left start: 0.0137 sec
left end: 0.2913 sec
listing start: 0.3153 sec
listing end: 0.4893 sec
END: 0.4894 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 = '3' or p2c.categories_id = '4' or p2c.categories_id = '5' or p2c.categories_id = '6' or p2c.categories_id = '7' or p2c.categories_id = '8' or p2c.categories_id = '9' or p2c.categories_id = '10' or p2c.categories_id = '11' or p2c.categories_id = '12' or p2c.categories_id = '13' or p2c.categories_id = '14' or p2c.categories_id = '15' or p2c.categories_id = '16' or p2c.categories_id = '17' or p2c.categories_id = '18' or p2c.categories_id = '19' or p2c.categories_id = '20' or p2c.categories_id = '21' or p2c.categories_id = '22' or p2c.categories_id = '23' or p2c.categories_id = '24' or p2c.categories_id = '25' or p2c.categories_id = '26' or p2c.categories_id = '27' or p2c.categories_id = '28' or p2c.categories_id = '29' or p2c.categories_id = '30' or p2c.categories_id = '31' or p2c.categories_id = '32' or p2c.categories_id = '33' or p2c.categories_id = '34' or p2c.categories_id = '35' or p2c.categories_id = '36' or p2c.categories_id = '37' or p2c.categories_id = '38' or p2c.categories_id = '39' or p2c.categories_id = '40' or p2c.categories_id = '41' or p2c.categories_id = '42' or p2c.categories_id = '43' or p2c.categories_id = '44' or p2c.categories_id = '45' or p2c.categories_id = '46' or p2c.categories_id = '47' or p2c.categories_id = '48' or p2c.categories_id = '49' or p2c.categories_id = '50' or p2c.categories_id = '51' or p2c.categories_id = '52' or p2c.categories_id = '53' or p2c.categories_id = '54' or p2c.categories_id = '55' or p2c.categories_id = '56' or p2c.categories_id = '57' or p2c.categories_id = '58' or p2c.categories_id = '59' or p2c.categories_id = '60' or p2c.categories_id = '61' or p2c.categories_id = '62' or p2c.categories_id = '63' or p2c.categories_id = '64' or p2c.categories_id = '65' or p2c.categories_id = '66' or p2c.categories_id = '67' or p2c.categories_id = '68' or p2c.categories_id = '69' or p2c.categories_id = '70' or p2c.categories_id = '71' or p2c.categories_id = '72' or 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' or p2c.categories_id = '190' or p2c.categories_id = '191' or p2c.categories_id = '192' or p2c.categories_id = '193' or p2c.categories_id = '194' or p2c.categories_id = '195' or p2c.categories_id = '196' or p2c.categories_id = '197' or p2c.categories_id = '198' or p2c.categories_id = '199' or p2c.categories_id = '200' or p2c.categories_id = '201' or p2c.categories_id = '202' or p2c.categories_id = '203' or p2c.categories_id = '204' or p2c.categories_id = '205' or p2c.categories_id = '206' or p2c.categories_id = '207' or p2c.categories_id = '208' or p2c.categories_id = '209' or p2c.categories_id = '210' or p2c.categories_id = '211' or p2c.categories_id = '212' or p2c.categories_id = '213' or p2c.categories_id = '214' or p2c.categories_id = '215' ) group by products_id_group order by p.description