select p.products_id,
pd.products_name,
pd.products_description,
p.products_image,
p.products_tax_class_id,
IF(s.status, s.specials_new_products_price, p.products_price) as products_price
from products_description pd,
products p
left join specials s
on p.products_id = s.products_id
where p.products_id in (1600,7986,6145,6327,2627,3357,3838,7938,832,2773,5574,1374,6678,4516,6593,424,6318,4111,7271,736,6399,6841,724,3196,4652,5691,5699,7614,6426,6301,6409,7676,610,7388,2303,1263,7416,7595,7868,7403,3703,720,4178,7094,6760,3281,7444,4810,4324,7894,8061,5489,172,779,5654,3912,2621,4035,3435,1920,8303,3863,8228,6718,5660,1610,2707,6215,7878,376,5639,8338,4477,7762,6653,1031,6874,8135,32,4246,5197,4980,1471,3234,5954,7034,5957,7830,4388,4975,2289,3522,3995,2873,2363,5848,4898,5855,7033,5887,6932,6666,8246,1996,5396,2829,5651,397,5775,3385,6843,6532,3794,2633,5494,6094,208,4487,334,2361,6808,6850,3081,3724,3067,5894,2507,258,746,2493,1090,210,7448,2093,5856,1027,3474,4065,2369,1387,5387,4367,5813,523,6018,2595,1487,25,3543,8359,2882,3712,3523,646,7623,6877,5605,6763,152,5005,3953,2750,4600,1309,2136,5590,7511,6007,2171,4364)
and p.products_status = '1'
and p.products_id = pd.products_id
and pd.language_id = '4'
[TEP STOP]
2006 - MySQL server has gone away
select count(*) as total from sessions where sesskey = '2nrs48'
