QUERY: SELECT
p.products_id,
p.products_model,
p.label_ids,
p.main_category,
p.products_ean,
p.products_fsk18,
p.products_quantity,
p.products_quantity_min,
p.products_quantity_step,
p.products_price,
p.products_price_small_opt,
p.products_price_opt,
p.products_purchase_price,
p.small_opt_purchase_price,
p.count_small_opt_purchase_price,
p.count_opt_purchase_price,
p.opt_purchase_price,
p.postavshik,
p.suplier_catalog_id,
p.postavshik_comment,
p.name_catalog_id,
p.products_tax_class_id,
p.products_image,
p.products_vpe,
p.products_vpe_status,
p.products_vpe_value,
p.products_currency,
p.products_page_url,
p.video,
p.show_video,
pd.products_short_description,
p.rev_total,
p.rev_rating,
pd.products_name,
p.products_ordered,
pd.products_short_description,
s.status,
IF(s.status, s.specials_new_products_price, 0) as specials_new_products_price,
m.manufacturers_name,
m.manufacturers_id FROM products AS p
LEFT JOIN products_description AS pd ON (p.products_id = pd.products_id)
LEFT JOIN manufacturers AS m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN specials AS s on p.products_id = s.products_id
LEFT JOIN products_to_categories as p2c2 ON (p2c2.products_id=p.products_id)
LEFT JOIN categories as c ON (c.categories_id=p2c2.categories_id) WHERE p.products_status = 1 AND c.categories_status = 1 AND pd.language_id = '1' AND p.products_id IN(10845817,10930351,8594594,10845841,3228531,8838620,10861511,8838729,8630938,8630939,8630943,10861618,10861619,10861620,10861621,10861622,8621274,8838942,10448343,10448345,8621491,8621545,10950362,10950363,10950364,10950365,10950366,10950367,10950368,11041535,10933284,11041648,8621872,8621885,8621887,7066208,10847098,8622203,10951032,10951033,8575690,11042317,10862971,10863096,10964523,10437695,10437696,10460464,10460465,10460466,3227406,8560949,8560971,8560972,7075029,8560983,7075079,10872414,7075173,8561149,8561150,7067210,7067211,8837706,8561237,8561238,8561239,8620149,8620150,10962109,10962110,8620297,8620301,11040266,11040267,11040268,11040269,11040270,11040271,11040272,10962363,7075741,7075754,10873069,7075865,10873152,10873153,8558958,8065079,8065086,10103341,10103342,8594862,10960064,10866811,10866812,10866815,7072619,7072620,7072621,7072622,7072623,7072624,7201971,8595404,8595494,8628629,7073019,8560082,8836645,8619120,8560258,8560259,10859718,10859719,8560388,10859732,10104583,10859813,10859814,10859820,8837023,10859821,10859822,10859841,10859842,10867872,8596247,10844409,10860001,10860002,11013482,11013483,11013484,11013485,11013486,11013487,10933195,7073879,7073880,8616933,8910236,8910237,3927634,3927640,3927641,3927642,3927682,8910352,8626947,3927734,8617209,8617210,8617211,8617212,11049287,11037151,11037164,11049478,8910651,7200897,10857945,10102954,6000217,3655594,10863404,10863405,10995929,3235726,8556310,10840178,10840179,10840180,11035329,3656486,3656487,10840709,3236380,3656575,8072801,8072802,8072803,8072804,8072805,8072806,8072807,8072808,11022802,11022803,11022804,11022805,10864491,7199480,11022944,11022945,11022946,10101462,3926736,8073091,8557368,10856791,11048413,11048433,10101782,10101790,7070705,10865053,3927318,3233356,11019689,11019690,11019691,8612934,10967839,3233773,10968067,10968068,10968069,10968070,10968071,10968072,10968073,10968074,10968075,3233872,3233891,3234123,7157287,3924143,7157419,7157420,10838656,11046685,10619324,8555267,8555276,10619374,4938503,4938504,10855069,4938505,4938506,10855070,10855071,4938507,10855072,4938508,10855073,10855074,8541493,11005681,10852362,11044920,8541867,10927924,3232918,8578997,3923239,10615024,10920604,10920605,10990762,10990763,8632766,10925713,10848020,10615337,10920882,10920883,10920884,10920885,10926033,11043263,11043264,11043265,11043266,10926233,10926234,10848530,10848531,10921510,8610825,8610858,10931008,10921601,8540582,10952829,10952830,10952831,3231646,3231647,8633973,8633982,11044050,7155060,8611361,10852020,10852062,8577979,8577981,8577986,8577991,8634477,10616894,10927447,7027001,9189348,9165457,9213576,9205756,8864299,8864304,8864310,9173822,9173823,9173824,9173825,8568476,9214007,9166051,9214068,8864671,8864708,9187351,9211378,9187398,10119719,10119722,10119723,10119728,10119729,10557462,10557463,9171980,9196016,9196017,9196018,9196019,7018006,10613034,10613141,8852320,7018243,7026356,8852540,9188715,7026499,7018503,7026524,9204936,9189107,9915321,7026826,9189173,10117521,10428754,9169457,8592636,10517319,9161546,9193558,10125765,8849478,8849479,8849480,8849481,10125859,9912016,9912021,9912061,8849788,8849793,8849794,10513797,10513798,10513799,10513800,10513801,10513802,9209990,10513803,10513804,10513805,10513806,10513807,10513808,10513809,7023657,8849837,8849876,7023746,4974946,4974947,4974948,4974949,10118334,7023796,10118350,9186214,3285965,3286047,10556346,10556347,10556348,10556349,10556350,10556351,10556352,10556353,10556354,10556355,10556356,10556357,10556358,9913034,10518785,10518786,10518787,10518788,10518789,10518790,10518791,10518792,10518793,10518794,10518795,10518796,10518797,10518798,9187265,9187267,9187268,9187294,8918049,4973351,10116720,9184525,10415501,10415502,10415503,10415504,10415505,10416534,10416645,10419676,10419679,6673029,6673041,10417801,8848707,9911170,10416941,10416942,7055258,6681304,6681337,6681338,10125348,10117378,10428619,8568813,9206752,10471482,10471483,10471484,10471485,10471486,6666920,8854766,8854767,9207006,9207007,9207008,9207009,9207010,9175042,8550205,8916780,6667155,6667156,6667157,6667158,9175287,6665650,6665666,8855280,8563402,9207562,976393,976454,6667686,9207729,9199742,9199743,9199744,9199745,9167812,9207847,9207848,9207849,9207850,9175867,9175874,9175880,9175903,9175923,8551325,6668247,8917920,10159510,10159511,10159597,10888607,10893809,10159827,10159828,10159841,10884052,10904076,10909104,10909105,10904111,10909693,10170731,10170732,10155737,10155807,10155827,10155828,10155829,10879846,10629341,10629342,10879891,10879892,10879901,10879914,10171234,10171235,10171236,10156258,10156259,10156260,10156261,10156262,10156263,10156264,10890270,10890271,10890272,10890273,10890274,10910317,10885369,10905446,10905447,10183504,10168844,7001092,7001376,10893428,10885501,10900636,10905773,10905774,10161920,10171984,10172029,10177075,10162335,10162336,10187347,10187348,10162431,10162432,10162433,10172548,10187549,10631062,10631063,10631064,10631065,10631066,10631067,10187720,10187869,10187873,10187981,10631667,10631691,10626757,10626758,10626759,10626760,10892275,10892276,10892277,10892278,10631798,10163467,10601166,10586229,10586230,10586231,10586232,10586233,10586234,10586235,10586236,10586237,10586238,10586239,10602184,10586460,10586461,10586462,10586463,10586464,10602325,10589632,10589633,10583686,10583687,10583688,10583689,10583690,10583691,10583692,10583693,10598952,10598953,10650078,10650079,10647294,10650418,10650419,10650420,10650421,10650422,10644608,10644609,10644610,10644611,10644612,10644613,10644614,10644615,10644616,10644617,10653709,10653710,10653711,10606552,10653905,10581967,10606881,10654093,10606899,10606920,10606966,10606967,10606975,10606982,10606983,10654198,10582225,10582226,10582227,10582228,10582229,10582230,10582231,10651316,10604146,10648471,10648472,10648473,10601503,10607541,10607546,10588728,10645847,10645848,10645849,10645850,10601772,10547251,10547252,10525291,10525292,10543295,10543296,10521321,10521322,10547397,10547534,10547535,10547536,10547620,10547621,10547622,10537642,10537643,10537644,10537645,10530182,10530183,10530184,10530185,10534186,10530186,10534187,10530187,10530188,10530189,10530190,10534191,10530191,10530192,10530193,10534201,10534202,10528303,10528304,10528305,10546427,10546428,10538430,10538445,10548483,10548484,10548485,10548486,10548487,10548488,10548489,10548490,10548491,10548492,10548493,10548494,10548495,10548496,10548497,10548498,10548499,10548500,10548501,10552552,10552553,10552554,10552555,10552556,10552557,10552558,10552559,10552560,10552561,10552562,10552563,10552564,10552565,10552566,10552567,10552568,10552569,10552570,10552571,10552572,10552573,10552574,10552575,10552576,10552577,10552578,10552579,10552580,10552581,10552582,10552583,10552584,10552585,10552586,10552587,10552588,10552589,10552590,10552591,10552592,10552593,10552594,10552595,10552596,10552597,10552598,10552599,10552600,10552601,10552602,10552603,10552604,10552605,10552606,10552607,10552608,10552609,10552610,10552611,10552612,10552613,10552614,10552615,10552616,10552617,10552618,10552619,10552620,10552621,10552622,10552623,10552624,10552625,10552626,10552627,10552628,10552629,10552630,10552631,10552632,10552633,10552634,10552635,10552636,10552637,10552638,10552639,10552640,10552641,10552642,10552643,10552644,10552645,10552646,10552647,10552648,10552649,10552650,10552651,10552652,10522687,10522688,10530724,10530725,10538856,10538857,10522863,10538896,10538899,10538915,10546942,10546943,10546944,10546945,10533072,10423548,10505502,10505503,10505504,10505505,10505506,10505507,10505508,10505509,10505510,10508584,10423824,10423880,10423881,10510800,10510801,10477079,10477301,10492330,10492331,10411703,10492369,10492370,10496465,10496512,10496513,10496514,10481634,10414149,10414150,10414151,10414168,10414227,10414228,10414235,10414236,10414237,10414256,10414257,10410279,10410280,10410281,10410282,10410283,10410284,10412530,10476512,10476513,10472667,10472668,10472669,10472670) GROUP BY p.products_id ORDER BY CASE WHEN products_price = 0 THEN 99999999 WHEN products_price > 0 THEN products_price END asc ,p.products_specials desc
ERROR: Unknown column 'p.products_specials' in 'order clause'