2006 - MySQL server has gone away
SELECT DISTINCT(m.manufacturers_id) AS id, m.manufacturers_name AS name FROM products AS p
LEFT JOIN products_description AS pd
ON (p.products_id = pd.products_id and pd.language_id = '4')
LEFT JOIN manufacturers AS m
ON p.manufacturers_id = m.manufacturers_id
LEFT JOIN products_to_categories AS p2c
ON p.products_id = p2c.products_id
LEFT JOIN categories AS c
ON c.categories_id = p2c.categories_id
LEFT JOIN module_mea AS mea_lighting_cat
ON (mea_lighting_cat.products_id = p.products_id)
WHERE
p.products_status = '1'
AND pd.language_id = '4'
AND p2c.categories_id = '19'
AND c.categories_status = '1' ORDER BY m.manufacturers_name ASC
[TEP STOP]
