select p.products_id, p.products_model, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, p.manufacturers_id, p.org_manufacturers_id,
p.products_eta, m.manufacturers_name, m2.manufacturers_name as org_manufacturers_name from products p left join manufacturers m on (p.manufacturers_id = m.manufacturers_id) left join manufacturers m2 on (p.org_manufacturers_id = m2.manufacturers_id), products_description pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '2' and ( upper( p.products_image ) NOT LIKE '%NO-IMAGE%' AND upper( p.products_image ) NOT LIKE '%NO_IMAGE%'
AND upper( p.products_image ) NOT LIKE '%NO-PICTURE%' AND upper( p.products_image ) NOT LIKE '%NO_PICTURE%'
AND length( p.products_image ) > 0 )
order by p.products_date_added DESC, pd.products_name limit 17710, 10
[TEP STOP]
2006 - MySQL server has gone away
select count(*) as total from sessions where sesskey = 'bsfdk8cl44jm6655j0881hp5vd'