Get Them While They're Hot!

Currency:
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-0, MAX_DISPLAY_SEARCH_RESULTS' at line 1

select distinct p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_quantity, m.manufacturers_name, p.products_last_modified, p.products_date_added, p.products_date_available, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id , products_to_categories p2c where p.products_status > 0 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '2' and s.status = '1' and (p2c.categories_id = '306' or p2c.categories_id = '100201' or p2c.categories_id = '257' or p2c.categories_id = '100208' or p2c.categories_id = '3' or p2c.categories_id = '10' or p2c.categories_id = '15' or p2c.categories_id = '14' or p2c.categories_id = '11' or p2c.categories_id = '26' or p2c.categories_id = '27' or p2c.categories_id = '12' or p2c.categories_id = '46' or p2c.categories_id = '32' or p2c.categories_id = '48' or p2c.categories_id = '47' or p2c.categories_id = '49' or p2c.categories_id = '150' or p2c.categories_id = '162' or p2c.categories_id = '212' or p2c.categories_id = '214' or p2c.categories_id = '213' or p2c.categories_id = '274' or p2c.categories_id = '215' or p2c.categories_id = '216' or p2c.categories_id = '217' or p2c.categories_id = '275' or p2c.categories_id = '28' or p2c.categories_id = '42' or p2c.categories_id = '29' or p2c.categories_id = '30' or p2c.categories_id = '31' or p2c.categories_id = '43' or p2c.categories_id = '44' or p2c.categories_id = '45' or p2c.categories_id = '61' or p2c.categories_id = '67' or p2c.categories_id = '68' or p2c.categories_id = '69' or p2c.categories_id = '70' or p2c.categories_id = '62' or p2c.categories_id = '72' or p2c.categories_id = '73' or p2c.categories_id = '74' or p2c.categories_id = '75' or p2c.categories_id = '149' or p2c.categories_id = '63' or p2c.categories_id = '151' or p2c.categories_id = '152' or p2c.categories_id = '153' or p2c.categories_id = '34' or p2c.categories_id = '54' or p2c.categories_id = '55' or p2c.categories_id = '56' or p2c.categories_id = '57' or p2c.categories_id = '59' or p2c.categories_id = '58' 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 = '218' or p2c.categories_id = '219' or p2c.categories_id = '220' or p2c.categories_id = '64' 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 = '35' or p2c.categories_id = '154' or p2c.categories_id = '53' or p2c.categories_id = '60' or p2c.categories_id = '108' or p2c.categories_id = '65' 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 = '105' or p2c.categories_id = '107' or p2c.categories_id = '109' or p2c.categories_id = '33' or p2c.categories_id = '121' or p2c.categories_id = '160' or p2c.categories_id = '210' or p2c.categories_id = '100058' or p2c.categories_id = '100186' or p2c.categories_id = '100206' or p2c.categories_id = '100171' or p2c.categories_id = '100125' or p2c.categories_id = '100099' or p2c.categories_id = '100059' or p2c.categories_id = '100017' or p2c.categories_id = '301' or p2c.categories_id = '276' or p2c.categories_id = '255' or p2c.categories_id = '254' or p2c.categories_id = '253' or p2c.categories_id = '252' or p2c.categories_id = '251' or p2c.categories_id = '250' or p2c.categories_id = '256' or p2c.categories_id = '100030' or p2c.categories_id = '155' or p2c.categories_id = '124' or p2c.categories_id = '122' or p2c.categories_id = '135' or p2c.categories_id = '148' or p2c.categories_id = '123' or p2c.categories_id = '126' or p2c.categories_id = '147' or p2c.categories_id = '119' or p2c.categories_id = '137' or p2c.categories_id = '120' or p2c.categories_id = '66' or p2c.categories_id = '146' or p2c.categories_id = '110' or p2c.categories_id = '111' or p2c.categories_id = '113' or p2c.categories_id = '112' or p2c.categories_id = '114' or p2c.categories_id = '115' or p2c.categories_id = '116' or p2c.categories_id = '117' or p2c.categories_id = '221' or p2c.categories_id = '222' or p2c.categories_id = '100114' or p2c.categories_id = '100032' or p2c.categories_id = '100034' or p2c.categories_id = '100033' or p2c.categories_id = '100035' or p2c.categories_id = '100037' or p2c.categories_id = '127' or p2c.categories_id = '140' or p2c.categories_id = '157' or p2c.categories_id = '128' or p2c.categories_id = '130' or p2c.categories_id = '131' or p2c.categories_id = '132' or p2c.categories_id = '136' or p2c.categories_id = '241' or p2c.categories_id = '242' or p2c.categories_id = '243' or p2c.categories_id = '244' or p2c.categories_id = '133' or p2c.categories_id = '259' or p2c.categories_id = '262' or p2c.categories_id = '260' or p2c.categories_id = '261' or p2c.categories_id = '263' or p2c.categories_id = '265' or p2c.categories_id = '264' or p2c.categories_id = '266' or p2c.categories_id = '267' or p2c.categories_id = '277' or p2c.categories_id = '258' or p2c.categories_id = '134' or p2c.categories_id = '144' or p2c.categories_id = '100140' or p2c.categories_id = '100067' or p2c.categories_id = '100082' or p2c.categories_id = '100066' or p2c.categories_id = '100069' or p2c.categories_id = '100068' or p2c.categories_id = '100070' or p2c.categories_id = '145' or p2c.categories_id = '271' or p2c.categories_id = '268' or p2c.categories_id = '283' or p2c.categories_id = '284' or p2c.categories_id = '303' or p2c.categories_id = '294' or p2c.categories_id = '289' or p2c.categories_id = '285' or p2c.categories_id = '286' or p2c.categories_id = '287' or p2c.categories_id = '100047' or p2c.categories_id = '302' or p2c.categories_id = '288' or p2c.categories_id = '290' or p2c.categories_id = '291' or p2c.categories_id = '292' or p2c.categories_id = '293' or p2c.categories_id = '304' or p2c.categories_id = '305' or p2c.categories_id = '269' or p2c.categories_id = '270' or p2c.categories_id = '280' or p2c.categories_id = '281' or p2c.categories_id = '100192' or p2c.categories_id = '100178' or p2c.categories_id = '142' or p2c.categories_id = '156' or p2c.categories_id = '307' or p2c.categories_id = '30035' or p2c.categories_id = '30050' or p2c.categories_id = '30001' or p2c.categories_id = '30006' or p2c.categories_id = '30007' or p2c.categories_id = '30008' or p2c.categories_id = '30009' or p2c.categories_id = '30010' or p2c.categories_id = '30011' or p2c.categories_id = '30012' or p2c.categories_id = '30013' or p2c.categories_id = '30014' or p2c.categories_id = '30015' or p2c.categories_id = '30016' or p2c.categories_id = '30018' or p2c.categories_id = '30017' or p2c.categories_id = '30019' or p2c.categories_id = '30020' or p2c.categories_id = '30021' or p2c.categories_id = '30022' or p2c.categories_id = '30023' or p2c.categories_id = '30024' or p2c.categories_id = '30025' or p2c.categories_id = '30026' or p2c.categories_id = '30027' or p2c.categories_id = '30028' or p2c.categories_id = '30030' or p2c.categories_id = '30002' or p2c.categories_id = '30031' or p2c.categories_id = '30032' or p2c.categories_id = '30004' or p2c.categories_id = '30054' or p2c.categories_id = '50056' or p2c.categories_id = '50002' or p2c.categories_id = '50009' or p2c.categories_id = '50011' or p2c.categories_id = '50008' or p2c.categories_id = '50010' or p2c.categories_id = '100072' or p2c.categories_id = '50003' or p2c.categories_id = '50004' or p2c.categories_id = '50058' or p2c.categories_id = '100015' or p2c.categories_id = '50059' or p2c.categories_id = '50060' or p2c.categories_id = '50073' or p2c.categories_id = '100205' or p2c.categories_id = '100226' or p2c.categories_id = '100237' or p2c.categories_id = '100175' or p2c.categories_id = '100130' or p2c.categories_id = '100093' or p2c.categories_id = '100057' or p2c.categories_id = '100024' or p2c.categories_id = '50077' or p2c.categories_id = '50074' or p2c.categories_id = '50072' or p2c.categories_id = '50071' or p2c.categories_id = '50070' or p2c.categories_id = '50069' or p2c.categories_id = '50068' or p2c.categories_id = '50067' or p2c.categories_id = '50066' or p2c.categories_id = '50065' or p2c.categories_id = '50064' or p2c.categories_id = '50006' or p2c.categories_id = '50054' or p2c.categories_id = '50007' or p2c.categories_id = '50076' or p2c.categories_id = '100046' or p2c.categories_id = '50017' or p2c.categories_id = '50012' or p2c.categories_id = '50015' or p2c.categories_id = '50053' or p2c.categories_id = '50018' or p2c.categories_id = '50013' or p2c.categories_id = '50019' or p2c.categories_id = '50014' or p2c.categories_id = '50020' or p2c.categories_id = '50021' or p2c.categories_id = '50022' or p2c.categories_id = '50023' or p2c.categories_id = '50024' or p2c.categories_id = '50025' or p2c.categories_id = '50016' or p2c.categories_id = '50026' or p2c.categories_id = '50027' or p2c.categories_id = '50028' or p2c.categories_id = '50029' or p2c.categories_id = '50030' or p2c.categories_id = '50031' or p2c.categories_id = '50032' or p2c.categories_id = '50033' or p2c.categories_id = '50034' or p2c.categories_id = '50055' or p2c.categories_id = '50035' or p2c.categories_id = '50036' or p2c.categories_id = '50037' or p2c.categories_id = '50038' or p2c.categories_id = '50052' or p2c.categories_id = '50039' or p2c.categories_id = '50040' or p2c.categories_id = '50041' or p2c.categories_id = '50042' or p2c.categories_id = '50043' or p2c.categories_id = '50044' or p2c.categories_id = '50045' or p2c.categories_id = '50046' or p2c.categories_id = '50047' or p2c.categories_id = '50048' or p2c.categories_id = '50049' or p2c.categories_id = '50050' or p2c.categories_id = '50051' or p2c.categories_id = '100071' or p2c.categories_id = '100109' or p2c.categories_id = '50079' or p2c.categories_id = '80002' or p2c.categories_id = '80006' or p2c.categories_id = '80036' or p2c.categories_id = '80005' or p2c.categories_id = '80007' or p2c.categories_id = '80037' or p2c.categories_id = '80038' or p2c.categories_id = '80039' or p2c.categories_id = '80023' or p2c.categories_id = '80024' or p2c.categories_id = '80040' or p2c.categories_id = '100090' or p2c.categories_id = '80025' or p2c.categories_id = '80026' or p2c.categories_id = '80027' or p2c.categories_id = '80029' or p2c.categories_id = '80030' or p2c.categories_id = '80043' or p2c.categories_id = '80031' or p2c.categories_id = '80032' or p2c.categories_id = '80035' or p2c.categories_id = '80033' or p2c.categories_id = '80034' or p2c.categories_id = '80041' or p2c.categories_id = '80042' or p2c.categories_id = '80004' or p2c.categories_id = '138' or p2c.categories_id = '100233' or p2c.categories_id = '100234' or p2c.categories_id = '100236' or p2c.categories_id = '100235' or p2c.categories_id = '100229' or p2c.categories_id = '100230' or p2c.categories_id = '100232' or p2c.categories_id = '100231' or p2c.categories_id = '100120' or p2c.categories_id = '100122' or p2c.categories_id = '100156' or p2c.categories_id = '100173' or p2c.categories_id = '100121' or p2c.categories_id = '100181' or p2c.categories_id = '100191' or p2c.categories_id = '100216' or p2c.categories_id = '100193' or p2c.categories_id = '100134' or p2c.categories_id = '100135' or p2c.categories_id = '100169' or p2c.categories_id = '100136' or p2c.categories_id = '100217' or p2c.categories_id = '100062' or p2c.categories_id = '100064' or p2c.categories_id = '100157' or p2c.categories_id = '100146' or p2c.categories_id = '100228' or p2c.categories_id = '100244' or p2c.categories_id = '100063' or p2c.categories_id = '100101' or p2c.categories_id = '100133' or p2c.categories_id = '100180' or p2c.categories_id = '100209' or p2c.categories_id = '100132' or p2c.categories_id = '100212' or p2c.categories_id = '100043' or p2c.categories_id = '100044' or p2c.categories_id = '100150' or p2c.categories_id = '100147' or p2c.categories_id = '100240' or p2c.categories_id = '100220' or p2c.categories_id = '100200' or p2c.categories_id = '100163' or p2c.categories_id = '100117' or p2c.categories_id = '100088' or p2c.categories_id = '100052' or p2c.categories_id = '100045' or p2c.categories_id = '100183' or p2c.categories_id = '100215' or p2c.categories_id = '163' or p2c.categories_id = '100013' or p2c.categories_id = '175' or p2c.categories_id = '100143' or p2c.categories_id = '100159' or p2c.categories_id = '100199' or p2c.categories_id = '100221' or p2c.categories_id = '100238' or p2c.categories_id = '100116' or p2c.categories_id = '100086' or p2c.categories_id = '100050' or p2c.categories_id = '100021' or p2c.categories_id = '295' or p2c.categories_id = '279' or p2c.categories_id = '100144' or p2c.categories_id = '164' or p2c.categories_id = '165' or p2c.categories_id = '166' or p2c.categories_id = '168' or p2c.categories_id = '167' 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 = '100184' or p2c.categories_id = '100142' or p2c.categories_id = '100188' or p2c.categories_id = '207' or p2c.categories_id = '208' or p2c.categories_id = '100155' or p2c.categories_id = '100138' or p2c.categories_id = '100219' or p2c.categories_id = '100241' or p2c.categories_id = '100203' or p2c.categories_id = '100162' or p2c.categories_id = '100118' or p2c.categories_id = '100094' or p2c.categories_id = '100053' or p2c.categories_id = '100026' or p2c.categories_id = '297' or p2c.categories_id = '272' or p2c.categories_id = '209' or p2c.categories_id = '100079' or p2c.categories_id = '100078' or p2c.categories_id = '100077' or p2c.categories_id = '100076' or p2c.categories_id = '100075' or p2c.categories_id = '100074' or p2c.categories_id = '100073' or p2c.categories_id = '100189' or p2c.categories_id = '158' or p2c.categories_id = '159' or p2c.categories_id = '100014' or p2c.categories_id = '100148' or p2c.categories_id = '100223' or p2c.categories_id = '100239' or p2c.categories_id = '100202' or p2c.categories_id = '100165' or p2c.categories_id = '100119' or p2c.categories_id = '100092' or p2c.categories_id = '100054' or p2c.categories_id = '100029' or p2c.categories_id = '296' or p2c.categories_id = '273' or p2c.categories_id = '193' or p2c.categories_id = '192' or p2c.categories_id = '194' or p2c.categories_id = '195' 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 = '100149' or p2c.categories_id = '100172' or p2c.categories_id = '100185' or p2c.categories_id = '224' or p2c.categories_id = '225' or p2c.categories_id = '100065' or p2c.categories_id = '100187' or p2c.categories_id = '100210' or p2c.categories_id = '100196' or p2c.categories_id = '100197' or p2c.categories_id = '100091' or p2c.categories_id = '100224' or p2c.categories_id = '100243' or p2c.categories_id = '100102' or p2c.categories_id = '100103' or p2c.categories_id = '100154' or p2c.categories_id = '100179' or p2c.categories_id = '100211' or p2c.categories_id = '246' or p2c.categories_id = '247' or p2c.categories_id = '100019' or p2c.categories_id = '80001' or p2c.categories_id = '100227' or p2c.categories_id = '100242' or p2c.categories_id = '80010' or p2c.categories_id = '80011' or p2c.categories_id = '80008' or p2c.categories_id = '80009' or p2c.categories_id = '100194' or p2c.categories_id = '100174' or p2c.categories_id = '100127' or p2c.categories_id = '100087' or p2c.categories_id = '100051' or p2c.categories_id = '100023' or p2c.categories_id = '80022' or p2c.categories_id = '80021' or p2c.categories_id = '80016' or p2c.categories_id = '100126' or p2c.categories_id = '100158' or p2c.categories_id = '80017' or p2c.categories_id = '80018' or p2c.categories_id = '80019' or p2c.categories_id = '80012' or p2c.categories_id = '80013' or p2c.categories_id = '80014' or p2c.categories_id = '80015' or p2c.categories_id = '226' or p2c.categories_id = '227' or p2c.categories_id = '100018' or p2c.categories_id = '230' or p2c.categories_id = '50061' or p2c.categories_id = '100113' or p2c.categories_id = '100112' or p2c.categories_id = '100111' or p2c.categories_id = '100110' or p2c.categories_id = '50063' or p2c.categories_id = '50062' or p2c.categories_id = '50075' or p2c.categories_id = '50078' or p2c.categories_id = '100028' or p2c.categories_id = '100081' or p2c.categories_id = '100151' or p2c.categories_id = '100152' or p2c.categories_id = '100153' or p2c.categories_id = '100104' or p2c.categories_id = '100105' or p2c.categories_id = '100137' or p2c.categories_id = '100106' or p2c.categories_id = '100123' or p2c.categories_id = '100161' or p2c.categories_id = '100182' or p2c.categories_id = '298' or p2c.categories_id = '299' or p2c.categories_id = '100139' or p2c.categories_id = '300' or p2c.categories_id = '100022' or p2c.categories_id = '100055' or p2c.categories_id = '100089' or p2c.categories_id = '100131' or p2c.categories_id = '100160' or p2c.categories_id = '100190' or p2c.categories_id = '80045' or p2c.categories_id = '100145' or p2c.categories_id = '100095' or p2c.categories_id = '237' or p2c.categories_id = '238' or p2c.categories_id = '30036' or p2c.categories_id = '30045' or p2c.categories_id = '30048' or p2c.categories_id = '30053' or p2c.categories_id = '100025' or p2c.categories_id = '100056' or p2c.categories_id = '100096' or p2c.categories_id = '100124' or p2c.categories_id = '100195' or p2c.categories_id = '143' or p2c.categories_id = '161' or p2c.categories_id = '100042' or p2c.categories_id = '223' or p2c.categories_id = '100115' or p2c.categories_id = '100166' or p2c.categories_id = '100167' or p2c.categories_id = '100168' or p2c.categories_id = '0') order by s.specials_last_modified DESC limit -0, MAX_DISPLAY_SEARCH_RESULTS

[TEP STOP]