|
2006 - MySQL server has gone away
SELECT distinct
p.products_id,
p.products_group,
p.manufacturers_id,
m.manufacturers_name,
p.products_price,
p.products_tax_class_id,
p.products_model,
pd.products_name,
pd.products_description,
p.products_quantity,
p.products_download,
p.products_image,
p.products_weight
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 = '101'
AND c.categories_status = '1' AND mea_lighting_cat.in_lighting_cat = 1
AND (
mea_lighting_cat.language_id='0' OR
mea_lighting_cat.language_id='4'
)
GROUP BY p.products_id ORDER BY p.products_date_added DESC, p.products_id DESC
LIMIT 0, 6
[TEP STOP]
|
