left start: 0.0131 sec left end: 0.3056 sec listing start: 0.3163 sec listing end: 0.7098 sec END: 0.7101 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 = '73' or p2c.categories_id = '74' or p2c.categories_id = '75' or p2c.categories_id = '76' or p2c.categories_id = '77' or p2c.categories_id = '78' or p2c.categories_id = '79' or p2c.categories_id = '80' or p2c.categories_id = '81' or p2c.categories_id = '82' or p2c.categories_id = '83' or p2c.categories_id = '84' or p2c.categories_id = '85' or p2c.categories_id = '86' or p2c.categories_id = '87' or p2c.categories_id = '88' or p2c.categories_id = '89' or p2c.categories_id = '90' or p2c.categories_id = '91' or p2c.categories_id = '92' or p2c.categories_id = '93' or p2c.categories_id = '94' or p2c.categories_id = '95' or p2c.categories_id = '96' or p2c.categories_id = '97' or p2c.categories_id = '98' or p2c.categories_id = '99' or p2c.categories_id = '100' or p2c.categories_id = '101' or p2c.categories_id = '102' or p2c.categories_id = '103' or p2c.categories_id = '104' or p2c.categories_id = '105' or p2c.categories_id = '106' or p2c.categories_id = '107' or p2c.categories_id = '108' or p2c.categories_id = '109' or p2c.categories_id = '110' or p2c.categories_id = '111' or p2c.categories_id = '112' or p2c.categories_id = '113' or p2c.categories_id = '114' or p2c.categories_id = '115' or p2c.categories_id = '116' or p2c.categories_id = '117' or p2c.categories_id = '118' or p2c.categories_id = '119' or p2c.categories_id = '120' or p2c.categories_id = '121' or p2c.categories_id = '122' or p2c.categories_id = '123' or p2c.categories_id = '124' or p2c.categories_id = '125' or p2c.categories_id = '126' or p2c.categories_id = '127' or p2c.categories_id = '128' or p2c.categories_id = '129' or p2c.categories_id = '130' or p2c.categories_id = '131' or p2c.categories_id = '132' or p2c.categories_id = '133' or p2c.categories_id = '134' or p2c.categories_id = '135' or p2c.categories_id = '136' or p2c.categories_id = '137' or p2c.categories_id = '138' or p2c.categories_id = '139' or p2c.categories_id = '140' or p2c.categories_id = '141' or p2c.categories_id = '142' or p2c.categories_id = '143' or p2c.categories_id = '144' or p2c.categories_id = '145' or p2c.categories_id = '146' or p2c.categories_id = '147' or p2c.categories_id = '148' or p2c.categories_id = '149' or p2c.categories_id = '150' or p2c.categories_id = '151' or p2c.categories_id = '152' or p2c.categories_id = '153' or p2c.categories_id = '154' or p2c.categories_id = '155' or p2c.categories_id = '156' or p2c.categories_id = '157' or p2c.categories_id = '158' or p2c.categories_id = '159' or p2c.categories_id = '160' or p2c.categories_id = '161' or p2c.categories_id = '162' or p2c.categories_id = '163' or p2c.categories_id = '164' or p2c.categories_id = '165' or p2c.categories_id = '166' or p2c.categories_id = '167' or p2c.categories_id = '168' or p2c.categories_id = '169' or p2c.categories_id = '170' or p2c.categories_id = '171' or p2c.categories_id = '172' or p2c.categories_id = '173' or p2c.categories_id = '174' or p2c.categories_id = '175' or p2c.categories_id = '176' or p2c.categories_id = '177' or p2c.categories_id = '178' or p2c.categories_id = '179' or p2c.categories_id = '180' or p2c.categories_id = '181' or p2c.categories_id = '182' or p2c.categories_id = '183' or p2c.categories_id = '184' or p2c.categories_id = '185' or p2c.categories_id = '186' or p2c.categories_id = '187' or p2c.categories_id = '188' or p2c.categories_id = '189' ) group by products_id_group order by p.description