left start: 0.0436 sec
left end: 0.2344 sec
listing start: 0.4306 sec
listing end: 3.1584 sec
END: 3.1593 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 = '2' or 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 = '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 = '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 = '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' or p2c.categories_id = '216' or p2c.categories_id = '217' or p2c.categories_id = '218' or p2c.categories_id = '219' or p2c.categories_id = '220' or p2c.categories_id = '221' or p2c.categories_id = '222' or p2c.categories_id = '223' or p2c.categories_id = '224' or p2c.categories_id = '225' or p2c.categories_id = '226' or p2c.categories_id = '227' or p2c.categories_id = '228' or p2c.categories_id = '229' or p2c.categories_id = '230' or p2c.categories_id = '231' or p2c.categories_id = '232' or p2c.categories_id = '233' or p2c.categories_id = '234' or p2c.categories_id = '235' or p2c.categories_id = '236' or p2c.categories_id = '237' or p2c.categories_id = '238' or p2c.categories_id = '239' or p2c.categories_id = '240' or p2c.categories_id = '241' or p2c.categories_id = '242' or p2c.categories_id = '8223' or p2c.categories_id = '8224' or p2c.categories_id = '8225' or p2c.categories_id = '8226' or p2c.categories_id = '8227' or p2c.categories_id = '243' or p2c.categories_id = '244' or p2c.categories_id = '245' or p2c.categories_id = '246' or p2c.categories_id = '247' or p2c.categories_id = '248' or p2c.categories_id = '249' or p2c.categories_id = '250' or p2c.categories_id = '251' or p2c.categories_id = '252' or p2c.categories_id = '253' or p2c.categories_id = '254' or p2c.categories_id = '255' or p2c.categories_id = '256' or p2c.categories_id = '257' or p2c.categories_id = '258' or p2c.categories_id = '259' or p2c.categories_id = '260' or p2c.categories_id = '261' or p2c.categories_id = '262' ) group by products_id_group order by p.description