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(10939544,7075852,7075853,7075876,7075877,7075878,7075892,7067894,7067896,7067900,7067902,7067903,10943426,10943428,10962602,10943432,10943433,7067927,7067932,10943445,7075935,10943450,7075983,10988690,10943543,7068036,7068044,7068052,7068055,7068059,10943584,7068077,10943591,7068091,7076097,10943620,10943625,7068114,10943626,10939831,7076129,7076141,7068155,7068159,10943675,10943726,7068224,7076226,10943822,10943848,10943856,10943864,7068385,10943905,7068396,7068399,7068403,10943915,7068404,10989102,10943938,10943985,10944019,10940230,8569493,10944030,10944038,7068534,10944049,10944055,10944086,10944094,10944115,8569594,8569616,10944197,10944204,8569718,10944257,8569743,8569752,8569756,8569770,7068795,8569774,10944318,10933261,10933265,7073852,10933312,10963576,10963577,10963581,10963582,10963583,10963584,10963586,7073902,10963587,10963588,7073905,10963591,10963592,4968247,10963596,7073939,7073951,10933462,10933464,7074036,7074037,7074038,10963722,10963723,10933481,10933518,7074216,7074315,7074336,7074337,7074396,7074408,7074412,7074424,7066425,7066426,7074450,7066456,7066458,7066465,7074470,7074471,7074475,7066490,7074514,7074532,7066554,7074556,7066557,7066572,7066711,7066741,7066742,7074747,7074750,7066759,7066771,7066785,7074921,7074922,7074927,8067925,7074962,7066985,7075022,7067025,7067056,7067069,7075148,7067169,7075201,10987887,7075215,7067217,7075218,7075220,7075222,7075223,7075224,7075227,7075228,7075256,7067263,7075271,8068372,10962092,10962096,10962104,7075420,10962105,10962176,10962177,7067501,7067510,7067514,7075520,7067521,7067559,7075570,7075617,7075626,7067687,7075730,7075741,7075748,7075763,10988466,10975494,7071823,7071898,7071910,7071924,10985627,10985638,7071955,7072064,7064115,7064147,10931588,10931602,7064166,7064168,7064169,7064174,10985859,7064178,7064186,7064210,7064211,7064226,7064242,7064253,10931700,7064262,7064264,7072267,10985956,7064280,7064285,10931747,10931756,7072338,7072339,7072403,7072429,10960119,7064435,10960120,10960121,10986126,10931884,7064456,7072478,7072486,10960175,7064493,7064499,7064500,7064507,7064510,7064512,7064515,7064518,7064523,10986262,10932041,10932085,7064658,7072669,10960355,10960356,7064680,10960397,10960399,7064724,7064745,7064825,10986523,7064857,7064917,7064922,7072927,10986627,7064946,7064971,10932413,7064975,7064981,10986678,10986680,10932443,10932446,7065019,7065022,7065023,7065024,7065025,10960732,10960733,7065062,7065083,7065085,7073085,10932547,10932554,7065116,10932555,8066209,8066210,8066211,7065143,8066212,8066213,8066214,7065146,8066215,8066216,8066217,10932605,7065182,7073186,10960876,7065201,7065220,7065225,7065230,10960918,7065236,7065243,7065258,7073271,7065292,10932743,10932815,7073439,7065454,7065465,10987163,7073484,7065516,10961212,7073532,7065539,10933034,7065613,7065649,7065653,7065662,7073664,7073696,7065698,7065717,7065723,7065728,7073735,10933174,7073739,7065743,10974429,10987434,10987467,10933225,10987471,7073795,10933241,10933245,7073813,7065815,10958564,7071025,10958811,7071313,10943037,7071344,7071418,10959105,7071512,7071517,8064603,7071566,10985256,10943290,10985268,10943308,10985298,10985300,7071656,7071665,10985366,10985385,8970200,8970211,10985477,8064867,10944340,10944361,3655563,10944391,10944411,3655624,3655628,7068950,7068954,7068970,10944504,7068994,10944512,10944542,7069062,7069099,7069100,7069104,3655794,3655795,3655798,3655800,10944622,7069114,10944636,10944637,3655858,7069245,3655944,7069259,7069269,7069282,3655979,10944821,10944823,10944827,10944911,3656099,10944925,10944930,7069427,10944977,7069476,10944987,10944990,10944994,7069505,10945024,10945053,7069543,10945067,10945074,10945079,10945080,3656280,3656285,10957282,7069633,7069685,7069722,7069729,7069742,7069781,7069782,3656501,7069814,10983499,7069823,7069828,10970523,7069856,7069872,7069889,7069890,7069891,7069940,7069971,10957722,7070041,7070053,7070063,7070067,7070152,3656859,7070185,7070188,7070222,7070241,10983928,7070244,7070270,7070277,7070287,3656978,7070289,7070296,7070310,7070311,7070312,7070315,7070316,7070320,7070325,7070328,7070332,7070342,7070345,7070349,7070350,10942083,7070382,7070388,7070406,7070446,8860379,7070479,7070482,7070515,7070519,10958203,10958204,7070529,3657223,7070534,7070536,7070537,7070553,7070572,7070607,10971455,10971456,10971457,10954609,10967675,10967764,10618318,10618319,10618320,10618321,10618322,10618323,10618324,10618325,10618326,10955012,10955044,10955115,10968188,10968386,10968629,10968634,10966647,10966648,10966681,10966707,10966708,10979883,10966885,10966886,10966887,10966890,10966892,10966896,10954118,10617648,10967300,10954361,8569867,8569883,8569898,8569902,8569904,8569989,8570013,8570014,8570019,8570209,8570217,8570220,10615398,8570233,8570246,8570248,8570249,10620470,8570308,8570309,8570368,8570373,8570375,8570377,8570420,8570428,8570451,8570510,10930530,10930531,10930536,10965283,10930556,10930559,10930561,10930567,10930588,10930624,10930625,10930649,10930672,10930674,10930682,10930684,10930690,10978421,10930696,10930700,10930703,10930704,10930706,10978435,10930744,10930748,10930760,10930775,10930808,10930818,10930819,10930832,10930833,10930889,10930896,10930901,10930903,10930936,10930945,10930947,10930953,10930955,10930956,10930957,10930968,10930985,10930986,10930987,10931001,10931002,10916930,10916931,10916932,10916933,10916979,10916980,10916981,10916982,10916983,10916984,10916985,9165315,9165319,8863852,7059500,9165335,8863895,8863911,9165404,9165409,8863953,7059598,9165452,8864001,8864012,8864032,8864035,8864104,8864132,8864143,8864146,8864154,7059815,9165664,9165669,7059860,8864226,8864266,9165749,8864285,6665788,8864351,9165833,6665840,9165846,8864402,8864425,9165934,9165948,8864498,8864506,8864525,8864536,8864561,8864563,9166058,6666056,9166059,8864592,8864593,8864596,8864604,9166085,8864613,8864627,8864636,8864680,8864683,8864686,8864687,8864689,8864718,9166237,9166254,8864813,8864818,8861832,8861834,8861835,8861839,7057525,7057538,8861894,8861902,8861942,8861944,8861991,8861997,8861999,8862004,8862024,7057707,8862069,10609261,7057770,7057771,7057777,7057787,8862161,8862162,8862185,7057840,7057867,8862227,8862234,8862236,8862249,9163749,8862285,7057939,8862302,7057974,8862340,10612497,8862360,9163840,8862391,8862419,9163923,8862445,8862448,8862458,8862463,8862491,9163979,7058194,8862592,8862594,8862595,8862597,9164086,7058255,7058283,8862652,7058325,9164188,8862729,8862738,8862746,7058466,9164307,9164324,7058538,8862897,8862898,8862911,8862915,9164416,7058583,7058585,7058586,8862943,7058588,9164423,9164424,8863011,7058674,7058675,8863058,8863097,10610274,7058833,7058855,7058857,7058862,8863218,8863223,8863227,7058872,9164709,8863238,7058885,7058888,7058894,8863262,8863263,7058969,7058978,7058984,7058987,8863343,7058988,7058989,7059003,10558655,10558656,10558657,10558658,10558659,8863377,8863386,7059034,8863395,7059052,8863427,8863432,8863434,7059089,7059090,8863465,7059114,8863471,7059116,7059133,7059152,8863513,8863518,8863526,7059173,7059175,8863534,7059186,9165026,9165037,8863568,8863573,8863576,8863588,9165081,8863603,9165082,8863640,8863663,8863683,7059333,8863701,7059356,9165263,9161470,7055762,9161666,7055835,7055868,9161712,7055880,7055891,7055908,7055927,9161834,7056141,7056182,9162038,7056233,7056242,7056257,7056277,7056284,7056307,7056322,7056384,7056388,7056419,7056433,7056437,7056438,7056441,7056442,7056443,7056465,7056524,7056526,7056557,7056603,7056604,2809133,7056681,7056731,7056788,7056797,2809349,7056910,7056958,7056963,7057020,7057045,7057067,7057079,7057080,7057150,7057169,8861556,7057251,7057253,8861645,8861669,8861671,8861672,8861676,8861677,8861678,8861683,8861691,8861697,8861702,8861723,8861724,8861725,8861735,8861739,8861742,8861751,8861756,8861761,8861768,7057415,7057417,7057421,7057424,8918018,4973417,4973418,4973441,7054878,7054955,7054961,7055063,10418858,7055109,10418933,7055184,7055215,7055233,7055436,8864827,8865073,8865094,8865148,8865159,8865256,8563214,8563216,8563231,8563233,8563236,8563264,8563285,8563302,8563308,8563316,8563336,8563340,8563341,8563375,8563376,8563377,8563386,8563387,8563388,8563389,8563391,8563414,8563425,8563427,8563447,8563456,8563506,8563597,8563602,10155473,10155478,10155804,10155856,10156373,10156428,10571218,10571220,10571221,10571362,10571363,10569669,10571005) 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'