1053 - Server shutdown in progress
select pd.products_info,pd.products_name, p.products_id, p.products_weight,p.products_image, p.manufacturers_id,m.manufacturers_name, p.products_price, p.products_tax_class_id,
IF(s.status='1', s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status='1', s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id, products_to_categories p2c , products_to_subthemes p2s where p.products_status2 = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.products_id = p2s.products_id and pd.site_id=(IF((select max(site_id) from products_description where products_id=pd.products_id)=2 ,2,0 )) and pd.language_id = '4' and p2c.categories_id = '336' and p2s.subtheme_id='105' order by products_sort desc, pd.products_name
[TEP STOP]