2006 - MySQL server has gone away
select products_price, pd.products_id, products_image, products_model, products_name, manufacturers_name, products_price, products_tax_class_id, products_quantity
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 c.parent_id = 6
group by p.products_id
order by RAND() limit 0, 10
[TEP STOP]
|