Resultado Búsqueda

1053 -

select distinct m.manufacturers_id as id, m.manufacturers_name as name, CONCAT(m.manufacturers_name, ' (',manufacturers_products,')') as nombre_cantidad, m.manufacturer_grouper_id as grouper_id, mfd.filename as fileDeqName, m.url_amigable, m.manufacturers_image as imagen from manufacturers as m left join products p on p.manufacturers_id = m.manufacturers_id left join products_to_categories p2c on p.products_id = p2c.products_id left join specials s on s.products_id = p.products_id left join products_description pd on p.products_id = pd.products_id left join mods_product_groupers mpg on p.product_grouper_id = mpg.id left join mods_file_deqs mfd on m.manufacturers_id = mfd.parent_id AND mfd.class LIKE 'Manufacturer' AND mfd.field LIKE 'image' where manufacturers_products > 0 and p.is_rentable = 0 and products_price > 0 and p.products_status = 1 and p2c.categories_id is not null and m.manufacturers_status = 1 and p.is_rentable = 0 and p.products_price > 0 and p.products_status = 1 group by m.manufacturers_id order by m.manufacturers_name asc

[TEP STOP]

2006 -

select count(1) as total from sessions where sesskey = 'mmnq2ac4nb9r79g1a6nkbaf6ru'

[TEP STOP]