| |||||||||||||||||
|
Costumes
left end: 0.2089 sec
listing start: 0.2293 sec
listing end: 0.5816 sec
END: 0.5846 sec
select p.products_image1, p.description products_name , p.products_id, p.products_price,p.products_price_special, p.products_price final_price from products p , products_to_categories p2c where p.products_status = '1' and p.products_id = p2c.products_id and ( p2c.categories_id = '1192' or p2c.categories_id = '1193' or p2c.categories_id = '1194' or p2c.categories_id = '1195' or p2c.categories_id = '1196' or p2c.categories_id = '1197' or p2c.categories_id = '1198' or p2c.categories_id = '1199' or p2c.categories_id = '1200' or p2c.categories_id = '1201' or p2c.categories_id = '1202' or p2c.categories_id = '1203' or p2c.categories_id = '1204' or p2c.categories_id = '1205' or p2c.categories_id = '1206' or p2c.categories_id = '1207' or p2c.categories_id = '1208' or p2c.categories_id = '1209' or p2c.categories_id = '1210' or p2c.categories_id = '1211' or p2c.categories_id = '1212' or p2c.categories_id = '1213' or p2c.categories_id = '1214' or p2c.categories_id = '1215' or p2c.categories_id = '1216' or p2c.categories_id = '1217' or p2c.categories_id = '1218' or p2c.categories_id = '1219' or p2c.categories_id = '1220' or p2c.categories_id = '1221' or p2c.categories_id = '1222' or p2c.categories_id = '1223' or p2c.categories_id = '1224' or p2c.categories_id = '1225' or p2c.categories_id = '1226' or p2c.categories_id = '1227' or p2c.categories_id = '1228' or p2c.categories_id = '1229' or p2c.categories_id = '1230' or p2c.categories_id = '1231' or p2c.categories_id = '1232' or p2c.categories_id = '1233' or p2c.categories_id = '1234' or p2c.categories_id = '1235' or p2c.categories_id = '1236' or p2c.categories_id = '1237' or p2c.categories_id = '1238' or p2c.categories_id = '1239' or p2c.categories_id = '1240' or p2c.categories_id = '1241' or p2c.categories_id = '1242' or p2c.categories_id = '1243' or p2c.categories_id = '1244' or p2c.categories_id = '1245' or p2c.categories_id = '1246' or p2c.categories_id = '1247' or p2c.categories_id = '1248' or p2c.categories_id = '1249' or p2c.categories_id = '1250' ) group by products_id_group order by p.description