left start: 0.0135 sec
left end: 0.2009 sec
listing start: 0.2574 sec
listing end: 0.672 sec
END: 0.6723 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 = '498' or p2c.categories_id = '499' or p2c.categories_id = '500' or p2c.categories_id = '501' or p2c.categories_id = '502' or p2c.categories_id = '503' or p2c.categories_id = '504' or p2c.categories_id = '505' or p2c.categories_id = '506' or p2c.categories_id = '507' or p2c.categories_id = '508' or p2c.categories_id = '509' or p2c.categories_id = '510' or p2c.categories_id = '511' or p2c.categories_id = '512' or p2c.categories_id = '513' or p2c.categories_id = '514' or p2c.categories_id = '515' or p2c.categories_id = '516' or p2c.categories_id = '517' or p2c.categories_id = '518' or p2c.categories_id = '519' or p2c.categories_id = '520' or p2c.categories_id = '521' or p2c.categories_id = '522' or p2c.categories_id = '523' or p2c.categories_id = '524' or p2c.categories_id = '525' or p2c.categories_id = '526' or p2c.categories_id = '527' or p2c.categories_id = '528' or p2c.categories_id = '529' or p2c.categories_id = '530' or p2c.categories_id = '531' or p2c.categories_id = '532' or p2c.categories_id = '533' or p2c.categories_id = '534' or p2c.categories_id = '535' or p2c.categories_id = '536' or p2c.categories_id = '537' or p2c.categories_id = '538' or p2c.categories_id = '539' or p2c.categories_id = '540' or p2c.categories_id = '541' or p2c.categories_id = '542' or p2c.categories_id = '543' or p2c.categories_id = '544' or p2c.categories_id = '545' or p2c.categories_id = '546' or p2c.categories_id = '547' or p2c.categories_id = '548' or p2c.categories_id = '549' or p2c.categories_id = '550' or p2c.categories_id = '551' or p2c.categories_id = '552' or p2c.categories_id = '553' or p2c.categories_id = '554' or p2c.categories_id = '555' or p2c.categories_id = '556' or p2c.categories_id = '557' or p2c.categories_id = '558' or p2c.categories_id = '559' or p2c.categories_id = '560' or p2c.categories_id = '561' or p2c.categories_id = '562' or p2c.categories_id = '563' or p2c.categories_id = '564' or p2c.categories_id = '565' or p2c.categories_id = '566' or p2c.categories_id = '567' or p2c.categories_id = '568' or p2c.categories_id = '569' or p2c.categories_id = '570' or p2c.categories_id = '571' or p2c.categories_id = '572' or p2c.categories_id = '573' or p2c.categories_id = '574' or p2c.categories_id = '575' or p2c.categories_id = '576' or p2c.categories_id = '577' or p2c.categories_id = '578' or p2c.categories_id = '579' or p2c.categories_id = '580' or p2c.categories_id = '581' or p2c.categories_id = '582' or p2c.categories_id = '583' or p2c.categories_id = '584' or p2c.categories_id = '585' or p2c.categories_id = '586' or p2c.categories_id = '587' or p2c.categories_id = '588' or p2c.categories_id = '589' or p2c.categories_id = '590' or p2c.categories_id = '591' or p2c.categories_id = '592' or p2c.categories_id = '593' or p2c.categories_id = '594' or p2c.categories_id = '595' or p2c.categories_id = '596' or p2c.categories_id = '597' or p2c.categories_id = '598' or p2c.categories_id = '599' or p2c.categories_id = '600' or p2c.categories_id = '601' or p2c.categories_id = '602' or p2c.categories_id = '603' or p2c.categories_id = '604' or p2c.categories_id = '605' or p2c.categories_id = '606' or p2c.categories_id = '607' or p2c.categories_id = '608' or p2c.categories_id = '609' or p2c.categories_id = '610' or p2c.categories_id = '611' or p2c.categories_id = '612' or p2c.categories_id = '613' or p2c.categories_id = '614' or p2c.categories_id = '615' or p2c.categories_id = '616' or p2c.categories_id = '617' or p2c.categories_id = '618' or p2c.categories_id = '619' or p2c.categories_id = '620' or p2c.categories_id = '621' or p2c.categories_id = '622' or p2c.categories_id = '623' or p2c.categories_id = '624' or p2c.categories_id = '625' or p2c.categories_id = '626' or p2c.categories_id = '627' or p2c.categories_id = '628' or p2c.categories_id = '629' or p2c.categories_id = '630' or p2c.categories_id = '631' or p2c.categories_id = '632' or p2c.categories_id = '633' or p2c.categories_id = '634' or p2c.categories_id = '635' or p2c.categories_id = '636' or p2c.categories_id = '637' or p2c.categories_id = '638' or p2c.categories_id = '639' or p2c.categories_id = '640' or p2c.categories_id = '641' or p2c.categories_id = '642' or p2c.categories_id = '643' or p2c.categories_id = '644' or p2c.categories_id = '645' or p2c.categories_id = '646' or p2c.categories_id = '647' or p2c.categories_id = '648' or p2c.categories_id = '649' or p2c.categories_id = '650' or p2c.categories_id = '651' or p2c.categories_id = '652' or p2c.categories_id = '653' or p2c.categories_id = '654' or p2c.categories_id = '655' or p2c.categories_id = '656' or p2c.categories_id = '657' or p2c.categories_id = '658' or p2c.categories_id = '659' or p2c.categories_id = '660' or p2c.categories_id = '661' or p2c.categories_id = '662' or p2c.categories_id = '663' or p2c.categories_id = '664' or p2c.categories_id = '665' or p2c.categories_id = '666' or p2c.categories_id = '667' or p2c.categories_id = '668' or p2c.categories_id = '669' or p2c.categories_id = '670' or p2c.categories_id = '671' or p2c.categories_id = '672' or p2c.categories_id = '673' or p2c.categories_id = '674' or p2c.categories_id = '675' or p2c.categories_id = '676' or p2c.categories_id = '677' or p2c.categories_id = '678' or p2c.categories_id = '679' or p2c.categories_id = '680' or p2c.categories_id = '681' or p2c.categories_id = '682' or p2c.categories_id = '683' or p2c.categories_id = '684' or p2c.categories_id = '685' or p2c.categories_id = '686' or p2c.categories_id = '687' or p2c.categories_id = '688' or p2c.categories_id = '689' or p2c.categories_id = '690' or p2c.categories_id = '691' or p2c.categories_id = '692' or p2c.categories_id = '693' or p2c.categories_id = '694' or p2c.categories_id = '695' or p2c.categories_id = '696' or p2c.categories_id = '697' or p2c.categories_id = '698' or p2c.categories_id = '699' or p2c.categories_id = '700' or p2c.categories_id = '701' or p2c.categories_id = '702' or p2c.categories_id = '703' or p2c.categories_id = '704' or p2c.categories_id = '705' or p2c.categories_id = '706' or p2c.categories_id = '707' or p2c.categories_id = '708' or p2c.categories_id = '709' or p2c.categories_id = '710' or p2c.categories_id = '711' or p2c.categories_id = '712' or p2c.categories_id = '713' or p2c.categories_id = '714' or p2c.categories_id = '715' or p2c.categories_id = '716' or p2c.categories_id = '717' or p2c.categories_id = '718' or p2c.categories_id = '719' or p2c.categories_id = '720' or p2c.categories_id = '721' or p2c.categories_id = '722' or p2c.categories_id = '723' or p2c.categories_id = '724' or p2c.categories_id = '725' or p2c.categories_id = '726' or p2c.categories_id = '727' or p2c.categories_id = '728' or p2c.categories_id = '729' or p2c.categories_id = '730' or p2c.categories_id = '731' or p2c.categories_id = '732' or p2c.categories_id = '733' or p2c.categories_id = '734' or p2c.categories_id = '735' or p2c.categories_id = '736' or p2c.categories_id = '737' or p2c.categories_id = '738' or p2c.categories_id = '739' or p2c.categories_id = '740' or p2c.categories_id = '741' or p2c.categories_id = '742' or p2c.categories_id = '743' or p2c.categories_id = '744' or p2c.categories_id = '745' or p2c.categories_id = '746' or p2c.categories_id = '747' or p2c.categories_id = '748' or p2c.categories_id = '749' or p2c.categories_id = '750' or p2c.categories_id = '751' or p2c.categories_id = '752' or p2c.categories_id = '753' or p2c.categories_id = '754' or p2c.categories_id = '755' or p2c.categories_id = '756' or p2c.categories_id = '757' or p2c.categories_id = '758' or p2c.categories_id = '759' or p2c.categories_id = '760' or p2c.categories_id = '761' or p2c.categories_id = '762' or p2c.categories_id = '763' or p2c.categories_id = '764' or p2c.categories_id = '765' or p2c.categories_id = '766' or p2c.categories_id = '767' or p2c.categories_id = '768' or p2c.categories_id = '769' or p2c.categories_id = '770' or p2c.categories_id = '771' or p2c.categories_id = '772' or p2c.categories_id = '773' or p2c.categories_id = '774' or p2c.categories_id = '775' or p2c.categories_id = '776' or p2c.categories_id = '777' or p2c.categories_id = '778' or p2c.categories_id = '779' or p2c.categories_id = '780' or p2c.categories_id = '781' or p2c.categories_id = '782' or p2c.categories_id = '783' or p2c.categories_id = '784' or p2c.categories_id = '785' or p2c.categories_id = '786' or p2c.categories_id = '787' or p2c.categories_id = '788' or p2c.categories_id = '789' or p2c.categories_id = '790' or p2c.categories_id = '791' or p2c.categories_id = '792' or p2c.categories_id = '793' or p2c.categories_id = '794' or p2c.categories_id = '795' or p2c.categories_id = '796' or p2c.categories_id = '797' or p2c.categories_id = '798' or p2c.categories_id = '799' or p2c.categories_id = '800' or p2c.categories_id = '801' or p2c.categories_id = '802' or p2c.categories_id = '803' or p2c.categories_id = '804' or p2c.categories_id = '805' or p2c.categories_id = '806' or p2c.categories_id = '807' or p2c.categories_id = '808' or p2c.categories_id = '809' or p2c.categories_id = '810' or p2c.categories_id = '811' or p2c.categories_id = '812' or p2c.categories_id = '813' or p2c.categories_id = '814' or p2c.categories_id = '815' or p2c.categories_id = '816' or p2c.categories_id = '817' or p2c.categories_id = '818' or p2c.categories_id = '819' or p2c.categories_id = '820' or p2c.categories_id = '821' or p2c.categories_id = '822' or p2c.categories_id = '823' or p2c.categories_id = '824' or p2c.categories_id = '825' or p2c.categories_id = '826' or p2c.categories_id = '827' or p2c.categories_id = '828' or p2c.categories_id = '829' or p2c.categories_id = '830' or p2c.categories_id = '831' or p2c.categories_id = '832' or p2c.categories_id = '833' or p2c.categories_id = '834' or p2c.categories_id = '835' or p2c.categories_id = '836' or p2c.categories_id = '837' or p2c.categories_id = '838' or p2c.categories_id = '839' or p2c.categories_id = '840' or p2c.categories_id = '841' or p2c.categories_id = '842' or p2c.categories_id = '843' or p2c.categories_id = '844' or p2c.categories_id = '845' or p2c.categories_id = '846' or p2c.categories_id = '847' or p2c.categories_id = '848' or p2c.categories_id = '849' or p2c.categories_id = '850' or p2c.categories_id = '851' or p2c.categories_id = '852' or p2c.categories_id = '853' or p2c.categories_id = '854' or p2c.categories_id = '855' or p2c.categories_id = '856' or p2c.categories_id = '857' or p2c.categories_id = '858' or p2c.categories_id = '859' or p2c.categories_id = '860' or p2c.categories_id = '861' or p2c.categories_id = '862' or p2c.categories_id = '863' or p2c.categories_id = '864' or p2c.categories_id = '865' or p2c.categories_id = '866' or p2c.categories_id = '867' or p2c.categories_id = '868' or p2c.categories_id = '869' or p2c.categories_id = '870' or p2c.categories_id = '871' or p2c.categories_id = '872' or p2c.categories_id = '873' or p2c.categories_id = '874' or p2c.categories_id = '875' or p2c.categories_id = '876' or p2c.categories_id = '877' or p2c.categories_id = '878' or p2c.categories_id = '879' or p2c.categories_id = '880' or p2c.categories_id = '881' or p2c.categories_id = '882' or p2c.categories_id = '883' or p2c.categories_id = '884' or p2c.categories_id = '885' or p2c.categories_id = '886' or p2c.categories_id = '887' or p2c.categories_id = '888' or p2c.categories_id = '889' or p2c.categories_id = '890' or p2c.categories_id = '891' or p2c.categories_id = '892' or p2c.categories_id = '893' or p2c.categories_id = '894' or p2c.categories_id = '895' or p2c.categories_id = '896' or p2c.categories_id = '897' or p2c.categories_id = '898' or p2c.categories_id = '899' or p2c.categories_id = '900' or p2c.categories_id = '901' or p2c.categories_id = '902' or p2c.categories_id = '903' or p2c.categories_id = '904' or p2c.categories_id = '905' or p2c.categories_id = '906' or p2c.categories_id = '907' or p2c.categories_id = '908' or p2c.categories_id = '909' or p2c.categories_id = '910' or p2c.categories_id = '911' or p2c.categories_id = '912' or p2c.categories_id = '913' or p2c.categories_id = '914' or p2c.categories_id = '915' or p2c.categories_id = '916' or p2c.categories_id = '917' or p2c.categories_id = '918' or p2c.categories_id = '919' or p2c.categories_id = '920' or p2c.categories_id = '921' or p2c.categories_id = '922' or p2c.categories_id = '923' or p2c.categories_id = '924' or p2c.categories_id = '925' or p2c.categories_id = '926' or p2c.categories_id = '927' or p2c.categories_id = '928' or p2c.categories_id = '929' or p2c.categories_id = '930' or p2c.categories_id = '931' or p2c.categories_id = '932' or p2c.categories_id = '933' or p2c.categories_id = '934' or p2c.categories_id = '935' or p2c.categories_id = '936' or p2c.categories_id = '937' or p2c.categories_id = '938' or p2c.categories_id = '939' or p2c.categories_id = '940' or p2c.categories_id = '941' or p2c.categories_id = '942' or p2c.categories_id = '943' or p2c.categories_id = '944' or p2c.categories_id = '945' or p2c.categories_id = '946' or p2c.categories_id = '947' or p2c.categories_id = '948' or p2c.categories_id = '949' ) group by products_id_group order by p.description