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(7067842,10939596,10962566,10962568,10939737,10939738,10939739,10939740,10939741,10939742,7076128,10939911,7076313,7076342,7076349,7076350,4970714,10940343,10940345,10940352,10940353,10940411,10940423,7068716,4971054,7068719,4971055,10963403,10963404,4971056,4971057,4971058,7068738,8569722,10940494,10940495,10940496,10940497,10940498,10963519,8066937,8066960,8066961,8066975,10963668,7065998,7066224,7074250,7074251,7074252,7074253,7074254,7074255,7074256,7074257,7074258,7074259,7074260,7074261,10437208,7074262,7074263,7074264,7074265,7074266,7074290,7074291,7074292,7074293,10437315,10437316,10437317,10437318,10437319,10437320,10437321,7066564,7066565,7066566,7066567,7066568,7066569,8067739,8067776,7066802,7066843,7066846,7066850,7066851,7066857,7066859,7066861,7066877,7066878,7066885,7066886,7066889,7066895,7066896,7066898,10961900,10961901,10961902,10961907,10961922,10961923,10961924,10961926,10961927,10961930,10961931,10961934,10961948,10961951,10961952,10961953,7075278,7067278,7067279,7075328,7067392,7075421,7075422,7075424,7075427,8068461,8068476,7067698,7067809,7072167,7072168,7072169,7072170,7072171,10960013,7072536,7072537,7072538,7072539,10932190,10932191,10932192,10932193,10932194,10932196,10932219,8065917,8066203,8066204,7073163,7065339,7065365,8066455,8066456,8066457,8066478,8066479,8066480,8066490,4968121,8970185,10942659,7070952,7071000,7071003,7071005,7071008,7071011,7071014,8860918,8860919,8860920,7071025,7071031,7071036,7071038,10942756,7071042,10942757,7071047,10942770,7071061,7071062,7071063,7071068,7071222,7071224,7071226,7071230,7071361,7071362,7071368,7071369,7071370,7071371,7071374,7071375,7071376,7071377,7071378,7071379,7071380,7071397,10943137,10943217,8861410,8861411,8861549,7071664,10943415,7068818,7068882,10940684,10940685,10940686,10940687,10940689,10940690,10940691,10940692,10940696,10940697,10940698,10940699,10940700,10940701,10940702,10940703,10940704,10940705,10940706,10940707,7068996,7068997,7068998,7069004,10940724,10940725,10940728,10940729,10940730,10940746,10940757,10940763,10944607,10944608,7069189,7069190,7069191,7069192,7069193,7069194,7069195,7069196,7069197,7069198,7069199,7069200,7069201,7069202,7069203,7069204,7069205,7069206,7069207,7069208,7069209,7069210,7069211,7069212,7069213,7069214,7069215,7069216,7069217,7069218,7069219,7069234,7069239,7069259,7069306,7069309,7069310,7069311,7069312,7069314,7069315,7069316,7069317,7069418,10941328,10941329,10941352,10941353,10941354,10941355,10941356,3656630,3656654,3656655,3656656,3656669,3656670,3656671,10941789,7070075,3656816,3656817,10942004,10942029,10942033,8860433,8860436,8860499,8860519,8860520,8860521,7070639,8860565,8860678,8860680,7070789,10928512,10928578,10928610,10928618,10928626,10928650,10618146,10618158,10618159,10618204,10928813,10928814,10928815,10928816,10928817,10618334,10618335,10618336,10618337,10618338,10618347,10618348,10618666,10619016,10619017,10619202,10619358,10619854,10619872,10619874,10619951,10619952,10619953,10616971,10622015,10622016,10622017,10622018,10622019,10622020,10622021,10622022,10622023,10927551,10927554,10927555,10622057,10622059,10622061,10622062,10622063,10622064,10622065,10622066,10622074,10622075,10622076,10622088,10622089,10622093,10622095,10622127,10622263,10622364,10622379,10622406,10617452,10928064,10928065,10617573,10954232,10954233,8569861,8569862,8569863,8569864,8569865,8569866,8569876,10615163,10920691,10615219,10615220,10615225,10615227,10615228,10615352,10615476,10615477,10615501,8570395,10926081,10926082,10926083,10926084,10926085,10926086,10926087,10926171,10926206,10926207,10930643,10930644,10930645,10926354,10926355,10926356,10926357,10926358,10615960,10921557,10921558,10921559,10921595,10621110,10621111,10621112,10621137,10930973,10930976,10621368,10621369,10621370,10616472,10616491,10616492,10616493,10922025,10922026,10922027,10616519,10616520,10922042,10616542,10616543,10616544,10927057,10922100,10922101,10922102,10922103,10922104,10922105,10922106,10922107,10922109,10922110,10922111,10922112,10922113,10922114,10922115,10922116,10922120,10922121,10922122,10922123,10922124,10922125,10927200,10565146,10559248,10559249,10559250,10559251,10559331,10614210,10611227,10614317,10559702,10559706,10614564,10614566,10614568,10559722,10559723,10559724,10559725,10559726,10559730,10559731,10559732,10559733,10559734,10559735,10559736,10559737,10559738,10559743,10559744,10559753,10559754,10611685,10614733,10614734,10611900,10612025,10612206,10612259,10609303,10612380,10563564,10563565,10563566,10557610,10557611,10557612,10557613,10557666,10612546,10612650,10612727,10612728,10612729,10612848,8862855,8862856,8862857,8862858,8862859,8862860,8862861,8862862,10610008,10610009,10610010,10613017,8862927,10613092,10613097,10613098,10613099,10613100,10613101,10613102,10613103,10613104,10613105,10613106,10613107,10613108,10610109,10613109,10610110,10613110,10613111,10613112,10613113,10613114,10613115,10613116,10613117,10610233,10610272,10610285,10613306,10613318,10610471,10610484,10613586,8863462,8863463,8863464,8863465,8863466,8863467,8863468,8863496,10558954,10558955,10558956,10558957,10558958,10558959,10558960,10558961,10558962,10558963,10558964,10558965,10558966,10558967,10558968,10558969,10558970,10558971,8863706,8863707,8863708,8863709,10610872,10610928,10610954,10515137,10515138,10515160,10515161,10515162,10513234,10513235,10513236,10515312,10515313,10515326,10515328,10515329,10515330,10515331,10515332,10515333,10515334,10515336,10515337,10515437,10515438,10515439,10517552,10517621,10517669,10517672,10513918,10513919,10513920,10513921,10513922,10513923,10513924,10513925,10514025,10514026,10514042,10514049,10514050,10514051,10514052,10514053,10514054,10514055,10514056,10514062,10514063,10514064,10514065,10514066,10514067,10514068,10514069,10514070,10514071,10514072,10514073,4975125,4975126,10512180,10512181,10512182,10512183,10512184,10512185,10512186,10512187,10512188,10512189,10512190,10516194,10516195,10516196,10516197,10516198,10516199,10516200,10516201,10516202,10516203,10516204,10516205,10516206,10516207,10516506,10516507,10516508,10516509,10516510,10516511,10516512,10516513,10516514,10516515,10516516,10516517,10516518,10516526,10516527,10516528,10516529,10516530,10516531,10516532,10516533,10516534,10516535,10516536,10516537,10516538,10516539,10516540,10516541,10516542,10516543,10516544,10516545,10516546,10516547,10516548,10516549,10516550,10516551,10516552,10516553,10516554,10516555,10516556,10512576,10514616,10514617,10514618,10514619,10514620,10514621,10514622,10514623,10514624,10514625,10514632,10514633,10514634,10514635,10514645,10516655,10514656,10516656,10514657,10516657,10514658,10516658,10514659,10516659,10514660,10516660,10514661,10516661,10516662,10514666,10514670,10514783,10514791,10514792,10514793,10514805,10514806,10514807,10514830,10514831,10514862,10514863,10514864,10514865,10514866,10514896,10516908,10516928,10516936,10516937,10516938,10516939,10516940,10516941,10516942,10516943,10516944,10516945,10516946,10516947,10516948,10516949,10516950,10516951,10516952,10417222,10417223,10417224,10417225,10418264,4973257,10415333,10415339,10415340,10419460,10419461,10419462,10419464,10419465,10417554,10417556,10417558,10417560,10416600,10418668,10418669,10418671,10418672,10417812,10417821,10417822,10415838,10415839,10415840,10417840,10417841,10415845,10415846,10417857,10417858,10417875,10417876,10417892,10417893,10417910,10417911,10417922,10417926,10417927,10417931,10417932,10417935,10417939,10417941,10417944,10417212,10417213,10417215,10417216,10417218,10417220,10463008,10467114,10467131,10471210,10471211,10471212,10471213,10471219,4971647,10463431,10469532,10469534,10463655,4971955,10465688,10463792,10463793,10463794,10465819,10465820,10465821,4972104,4972118,4972119,4972120,4972121,10465878,10465879,10463895,10467953,10467957,10467967,10468139,10468142,10468144,10468145,10468146,4972427,4972428,4972430,4972434,4972435,10468159,4972448,4972451,4972452,4972455,4972456,10468182,10468184,10468190,10468191,10468194,10468200,10468204,10468206,10468208,10468211,10468213,8563536,10466214,10466215,10468219,10468220,10468222,10468223,10462315,10466324,10466366,10466367,10466368,10466426,10462443,10462502,10462503,10462504,10462505,10462598,4973065,4973066,10466857,10466858,10466859,10627980,10627981,10628084,10628085,10628316,10628828,10628941,10627283,10627285,10627409,10627594,10627724,10627725,10627726,10627727,10627740,10627749,10627751,10627886,10627931,10625151,10626331,10626445,10566126,10566127,10566128,10566670,10566671,10567317,10567465,10567466,10567467,10567468,10567628,10567629,10567630,10519792,10519793,10519794,10519795,10519796,10519797,10519798,10519799,10519800,10519801,10519802,10519803,10519804,10519805,10519806) 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'