| |||||||||||||||||
|
Costumes
left end: 0.3542 sec
listing start: 0.3647 sec
listing end: 0.6337 sec
END: 0.6339 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 = '304' or p2c.categories_id = '305' or p2c.categories_id = '306' or p2c.categories_id = '307' or p2c.categories_id = '308' or p2c.categories_id = '309' or p2c.categories_id = '310' or p2c.categories_id = '311' or p2c.categories_id = '312' or p2c.categories_id = '313' or p2c.categories_id = '314' or p2c.categories_id = '315' or p2c.categories_id = '316' or p2c.categories_id = '317' or p2c.categories_id = '318' or p2c.categories_id = '319' or p2c.categories_id = '320' or p2c.categories_id = '321' or p2c.categories_id = '322' or p2c.categories_id = '323' or p2c.categories_id = '324' or p2c.categories_id = '325' or p2c.categories_id = '326' or p2c.categories_id = '327' or p2c.categories_id = '328' or p2c.categories_id = '329' or p2c.categories_id = '330' or p2c.categories_id = '331' or p2c.categories_id = '332' or p2c.categories_id = '333' or p2c.categories_id = '334' or p2c.categories_id = '335' or p2c.categories_id = '336' or p2c.categories_id = '337' or p2c.categories_id = '338' or p2c.categories_id = '339' or p2c.categories_id = '340' or p2c.categories_id = '341' or p2c.categories_id = '342' or p2c.categories_id = '343' or p2c.categories_id = '344' or p2c.categories_id = '345' or p2c.categories_id = '346' or p2c.categories_id = '347' or p2c.categories_id = '348' or p2c.categories_id = '349' or p2c.categories_id = '350' or p2c.categories_id = '351' or p2c.categories_id = '352' or p2c.categories_id = '353' or p2c.categories_id = '354' or p2c.categories_id = '355' or p2c.categories_id = '356' or p2c.categories_id = '357' or p2c.categories_id = '358' or p2c.categories_id = '359' or p2c.categories_id = '360' or p2c.categories_id = '361' or p2c.categories_id = '362' or p2c.categories_id = '363' or p2c.categories_id = '364' or p2c.categories_id = '365' or p2c.categories_id = '366' or p2c.categories_id = '367' or p2c.categories_id = '368' or p2c.categories_id = '369' or p2c.categories_id = '370' or p2c.categories_id = '371' or p2c.categories_id = '372' or p2c.categories_id = '373' or p2c.categories_id = '374' or p2c.categories_id = '375' or p2c.categories_id = '376' or p2c.categories_id = '377' or p2c.categories_id = '378' or p2c.categories_id = '379' or p2c.categories_id = '380' or p2c.categories_id = '381' or p2c.categories_id = '382' or p2c.categories_id = '383' or p2c.categories_id = '384' or p2c.categories_id = '385' or p2c.categories_id = '386' or p2c.categories_id = '387' ) group by products_id_group order by p.description