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(7068373,10940101,11041171,11041191,11041192,10976317,10976318,10940330,7068724,7068757,10940404,10940412,10940420,10940421,7068801,10940425,10940429,8569786,8569787,8569794,8569795,7068821,8569801,7068831,7068835,7068850,7068851,7068852,7068858,7068865,7068874,7068875,10963638,10963639,7074284,7074290,10951248,10951252,10951261,10977321,10977322,10977323,10977324,10951266,10977360,10977433,10977461,10977462,10977479,10977487,10977493,10977534,7075135,10961906,10961908,7075499,10988309,10988342,10962467,10962468,10962469,10962470,10962471,10962472,10962473,10972647,10972648,10999092,10973098,10973099,7072450,11012288,11012407,4967031,10932187,10960624,10960625,10960626,10960627,10960628,10960629,10960630,10960631,10960632,10960633,10960634,10960635,10960636,10960637,10960638,10960639,10960640,10960641,10960642,10960643,10960644,10960645,10960646,10960647,10960648,10960649,10960653,10960654,10960655,10960656,10960657,10960695,11012703,11012795,8066197,8066198,8066199,8066200,8066206,7065339,11000107,11013244,11013363,11013399,11013401,11013423,10971742,10971879,10971880,10971881,10972005,10972036,10972195,10959203,10959204,11011396,7069310,10970237,10970243,3656278,10970524,10941693,10983766,10983924,11036013,11036014,11036015,11036016,11036017,11036018,11036019,11036020,11036021,11036022,11036023,11036080,11036081,11036082,11036083,11036084,11036085,11036086,10971464,10971474,8073525,10971482,10971483,10971484,10971485,11010506,11010609,11045759,11045765,11045766,11045767,11045771,11045772,11045773,11045774,11045775,11045776,11045777,11045778,11045779,11045780,11045781,11045782,11045783,11045784,11045786,11045787,10618162,11045823,11045824,11045825,11045826,11045827,11045828,11045833,11045835,11045836,11045838,11045839,11045841,11045847,11045850,11045851,11045852,10968057,11046647,11046662,11046663,11046664,11046665,10968669,10968670,11046695,11046696,11046697,11046698,11046699,11046700,11046701,11046702,11046703,11046721,11046723,11046724,11046729,11046730,11046794,11046796,11046822,11046825,10619193,11008165,11008169,11008170,11047218,11047289,11047353,11047354,11034375,11034376,11034377,11034378,11034379,11034380,11034381,11044746,11044773,11044774,11044870,10922949,10617509,10977634,11042640,11042641,10977697,10977698,10977699,10977749,10977754,10977785,10977788,10977823,10977824,10977825,10977826,10977835,10977880,10977881,10977895,10977896,10977899,10920753,10977923,10977976,10977980,10920843,10977997,10977999,10978009,10978023,10620401,10978136,10978142,10978285,10978286,10978287,10978288,10978289,10978290,10978330,10978331,10978332,10978333,10978334,10978392,10921248,10921250,10921251,10921252,10978401,10921253,10978402,10978403,10978404,10978408,10978409,10978410,10978411,10978412,10978413,10978414,10978415,10978416,10978425,10978426,10978427,10978428,10978429,10978430,10978431,10978449,10978450,10978451,10978452,10930728,10978461,10978463,10978464,10978472,10978475,10978476,10921328,10921329,10978479,10978480,10978481,10978490,10978491,10978498,10978501,10978502,10978506,10978507,10978517,10978531,10978532,10978533,10978538,10978539,10978540,10978541,10978542,10978543,10978554,10978555,10978565,10978594,10921497,10978654,10978658,10978696,10978698,10978699,10978700,10978701,10978733,10978766,10978767,10978768,10978772,10621117,10621125,10978791,10621138,10978801,10978805,10621147,10978806,10621155,10621160,10621162,10565196,10611157,10565429,7059796,7059844,9165725,10611418,10611424,10611426,10611442,10611445,9166007,9206083,9206084,10611898,10612034,9187456,9187457,10557665,9172213,9172262,9188272,9204360,9204361,9172467,10610235,10610237,10613300,10610484,9172881,9172882,9172883,9172964,10610724,10517253,10515296,7055722,7055724,9177642,9177650,9177651,9177663,9177664,10517551,10515608,9177950,9193959,9177963,9177972,9177989,9170041,7056223,9170060,9170062,9170065,9178069,9178070,9178103,9178107,9178110,9178111,9178112,9178115,9178144,7056398,7056402,9178241,9178242,9178243,7056411,7056413,7056417,7056421,9178257,9170258,9178258,9170259,9170260,9170261,9170262,9178265,9178266,7056437,7056438,7056452,7056454,9178289,7056455,7056456,9178292,7056459,7056461,7056468,7056472,9170311,9178318,9170322,9170323,9170324,9170326,9178337,9178352,9178353,9178368,9178374,9178375,9178376,9178377,9178378,9178379,9178380,9178381,9178382,9178383,9178384,9178385,9178386,9178387,9178388,9178389,9178390,9178391,9178397,9178402,9178403,9178404,9178405,9178406,9170407,9178407,9178408,9178409,9170411,9170415,9170416,9170417,9170418,9178432,9178439,9178440,9178441,9178442,9178443,9178444,9178445,9178450,9178467,9178468,9178477,9178478,9178479,9178480,9178490,9178491,9178492,9178493,9178502,9178503,9178504,9178505,9178514,9178515,9178516,9178517,9178531,9178532,9178534,9178536,9178537,9178538,9178541,9178546,9178547,9178548,9178551,9178555,9178557,9178558,9178565,9178574,9178575,9178593,9178596,9178667,9178670,9178671,9178679,9178696,9178702,9178709,9178720,9178734,9178760,10514592,9178784,9178791,10514609,10514610,9178798,9178806,9178841,9178852,9178853,9178854,7057083,10514794,10514833,10514835,10514836,9171077,10514892,10516932,10516933,10516934,10516935,9192354,9176388,10416346,10415460,9192574,9192616,10419568,7054861,10416629,9168718,10419679,10419682,10418689,10419720,9176910,10419994,7055261,9193124,10420056,10418149,10418150,10420166,6666604,9174669,9174747,9174748,9174749,9198999,9175012,4971943,4971964,4971968,4971969,4971970,4971971,4971972,9175139,9175140,4972006,4972007,4972008,4972014,4972015,4972016,4972017,10463743,4972021,4972022,4972023,4972024,4972028,4972029,4972030,10465766,9191265,8917191,9167662,10466310,10462348,10462417,10462421,10462425,10462456,10462457,10462517,10462518,10462519,10462536,10462538,9168281,9200282,10628109,10628110,10628111,10165888,10171283,10629787,10629788,10629789,10629790,10629791,10632040,10632041,10632042,10632043,10632044,10632045,10632046,10632047,10632048,10632049,10632050,10632051,10632052,10632053,10632054,10632055,10632056,10627279,10627281,10627282,10627283,10627285,10627289,10627290,10166568,10166569,10630067,10625239,10625240,10167068,10167114,10182191,10182192,10182193,10182298,10182301,10167327,10167337,10167637,10167648,10167649,10162655,10167677,10167678,10167681,10162687,10162689,10162690,10167693,10162710,10167717,10162731,10182772,10182779,10182780,10162795,10162797,10162799,10162815,10162820,10162827,10162828,10162839,10167866,10167867,10167868,10167869,10167870,10182876,10167880,10167881,10167882,10167883,10167884,10167885,10167914,10167915,10182919,10167919,10182920,10167920,10167921,10167922,10167923,10167924,10167925,10167926,10167927,10167928,10167929,10167930,10167931,10167932,10167933,10167934,10167937,10167938,10167939,10167940,10167941,10167963,10167975,10167976,10167977,10167978,10167979,10167980,10167981,10167982,10167983,10167984,10167985,10167986,10168008,10168014,10168030,10168031,10168032,10168033,10168037,10168049,10168050,10168064,10168074,10168077,10168078,10168079,10168083,10168085,10168087,10168097,10168098,10168106,10163114,10183131,10168136,10168143,10168144,10168190,10168198,10168199,10168200,10183207,10168207,10183208,10168208,10168209,10168210,10183302,10183306,10586453,10586481,10577810,10577827,10577828,10577829,10577832,10578004,10578005,10578006,10578007,10578008,10578009,10578010,10578011,10578012,10578033,10578034,10578035,10569100,10569101,10569102,10569103,10569104,10569105,10581105,10569106,10569107,10569158,10569159,10569161,10578339,10578340,10578439,10578440,10578441,10578442,10578443,10569490,10569555,10569578,10579580,10579581,10567655,10579690,10579691,10579692,10576954,10521184,10531252,10531253,10531254,10531255,10531256,10531257,10531258,10531259,10531260,10531261,10531262,10531263,10531264,10531265,10531266,10531267,10531268,10531269,10531270,10521286,10521287,10521288,10521289,10525365,10525377,10525378,10525379,10531381,10531382,10531383,10529506,10529507,10529508,10529509,10529510,10523671,10523697,10523700,10523701,10529889,10529890,10529898,10529907,10529916,10529918,10529919,10529920,10532015,10532174,10532175,10522504,10522521,10522523,10522526,10522609,10522674,10522675,10522676,10522677,10522678,10522679,10532714,10520901,10520904,10520905,10520909,10530964,10530981,10531004,10531010,10531011,10531012,10531015,10531047,10533084,10533085,10533086,10533087,10533088,10421765,10421766,10424768,10421775,10479183,10479186,10479187,10479222,10479223,10479224,10479247,10479279,10479345,10479346,10479356,10479357,10479358,10479359,10479365,10479369,10479370,10479371,10479372,10479432,10479446,10479469,10479472,10479473,10479474,10479477,10479478,10479479,10479542,10479543,10479544,10479551,10479552,10479559,10479582,10481589,10481596,10481599,10481601,10481605,10481607,10481608) 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'