|
2006 - MySQL server has gone away
select count(distinct p.products_id) as total FROM products p
LEFT JOIN products_description pd on pd.products_id = p.products_id and pd.language_id = '4'
LEFT JOIN manufacturers m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN products_to_categories ptc ON (p.products_id = ptc.products_id)
LEFT JOIN categories c ON (ptc.categories_id = c.categories_id)
LEFT JOIN categories_description cd ON (c.categories_id = cd.categories_id and cd.language_id = '4')
WHERE p.products_status = '1'
AND m.manufacturers_id = 15
[TEP STOP]
| 
