left start: 0.0174 sec left end: 0.2043 sec listing start: 0.2177 sec listing end: 0.5286 sec END: 0.5287 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 = '443' or p2c.categories_id = '444' or p2c.categories_id = '445' or p2c.categories_id = '446' or p2c.categories_id = '447' or p2c.categories_id = '448' or p2c.categories_id = '449' or p2c.categories_id = '450' or p2c.categories_id = '451' or p2c.categories_id = '452' or p2c.categories_id = '453' or p2c.categories_id = '454' or p2c.categories_id = '455' or p2c.categories_id = '456' or p2c.categories_id = '457' or p2c.categories_id = '458' or p2c.categories_id = '459' or p2c.categories_id = '460' or p2c.categories_id = '461' or p2c.categories_id = '462' or p2c.categories_id = '463' or p2c.categories_id = '464' or p2c.categories_id = '465' or p2c.categories_id = '466' or p2c.categories_id = '467' or p2c.categories_id = '468' or p2c.categories_id = '469' or p2c.categories_id = '470' or p2c.categories_id = '471' or p2c.categories_id = '472' or p2c.categories_id = '473' or p2c.categories_id = '474' or p2c.categories_id = '475' or p2c.categories_id = '476' or p2c.categories_id = '477' or p2c.categories_id = '478' or p2c.categories_id = '479' or p2c.categories_id = '480' or p2c.categories_id = '481' or p2c.categories_id = '482' or p2c.categories_id = '483' or p2c.categories_id = '484' or p2c.categories_id = '485' or p2c.categories_id = '486' or p2c.categories_id = '487' or p2c.categories_id = '488' or p2c.categories_id = '489' or p2c.categories_id = '490' or p2c.categories_id = '491' or p2c.categories_id = '492' or p2c.categories_id = '493' or p2c.categories_id = '494' or p2c.categories_id = '495' or p2c.categories_id = '496' or p2c.categories_id = '497' ) group by products_id_group order by p.description