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(10939564,7067850,7067851,7067852,7067853,10939576,10939579,10939586,10939593,10939650,10943454,10943455,10943456,10943460,10943461,10943462,10943463,10943464,7067976,7067977,10943489,10939714,10939718,10939725,10939742,10939751,10939752,10939753,10939754,10939755,10943657,7068167,10939882,10939883,7068169,7068171,10939903,10939904,10939908,10939911,10939912,10939916,10939926,7068243,7068244,4970680,4970684,4970700,10940098,4970749,4970751,4970767,10940150,10940160,10944069,10944070,4970917,4971060,7068724,7068725,7068726,7068727,7068728,7068729,7068730,7068731,7068732,7068733,7068734,7068735,7068736,7068737,7068738,7068739,7068740,7068741,7068742,7068743,7068744,7068745,7068746,7068747,7068748,7068749,7068750,7068751,7068752,7068753,7068754,7068755,7068756,7068757,7068758,7065907,7065908,7065909,7065919,7065949,4968322,4968332,7066088,7066142,8067228,8067229,8067230,7066190,8067294,8067295,8067296,8067297,8067298,4968607,8067341,8067367,10437256,8067384,10437382,10437399,8067549,4968861,10437486,8067656,8067723,8067724,8067725,8067749,8067804,7066742,7066765,7066803,7066817,7066826,7066852,7066859,10938936,7067222,7067225,7067226,7067227,7067229,7067241,7067245,4969589,4969590,4969591,7067262,7067263,7067279,10939072,7067398,7067444,7067625,7067633,7067634,7067637,7067643,7067644,7067686,7067697,7067712,8068790,10931528,8065188,8065189,8065190,10931888,10931902,10932020,10932021,10932022,10932023,10932024,10932025,10932026,10932038,10932070,10932106,4967031,8065831,10932243,10932261,10932291,8065942,8065981,8065982,8065983,8065984,8065991,8066011,8066014,8066015,8066016,8066070,8066091,10932475,10932477,10932591,10932598,10932655,10932671,10932675,10932677,10932685,10932832,10932833,10932892,10933070,10933213,10942537,10942539,10942540,10942594,10942735,10942969,10943052,10943053,10943109,10943134,10943136,10943143,10943160,10943171,10943176,10943229,10943230,10943250,8970228,10931200,10931201,3655555,3655567,3655663,3655782,10940834,10940837,10940838,10940839,10940850,10940988,8072305,8072358,8072362,8072364,8072368,8072370,8072371,8072372,3656210,3656211,3656217,8072391,3656227,8072392,3656228,3656229,3656260,3656261,3656262,8072449,3656286,8072463,8072464,8072653,8072654,8072655,8072656,8072657,3656627,3656628,3656645,3656646,3656647,3656668,3656673,3656678,3656686,3656702,3656704,3656820,3656821,3656822,3656823,3656835,3656836,3656837,3656838,3656839,3656840,3656841,3656842,3656858,3656867,3656891,3656892,3656902,3656906,3656907,8073080,3656938,10942052,10942053,10942066,10942108,10942141,10942144,10942191,10942214,10942215,10942216,10942276,10942496,10918481,10918482,10918515,10918516,10918517,10918518,10918519,10918520,10918521,10918522,10918523,10918524,10623041,10623042,10923580,10918720,10918751,10918752,10918753,10918754,10918755,10918756,10918805,10918806,10918807,10918808,10918809,10918810,10918811,10918812,10918813,10918814,10918815,10918816,10918817,10623314,10923830,10923831,10923832,10623404,10623488,10924063,10623658,10919191,10919192,10919193,10919194,10924307,10924308,10924402,10924403,10924404,10924405,10924406,10924407,10924408,10924409,10924410,10924411,10924412,10924413,10924414,10924415,10924416,10924417,10924418,10924419,10924420,10924421,10924422,10924423,10924424,10924425,10924426,10924427,10924428,10924429,10919495,10919496,10919497,10919498,10919535,10919536,10919537,10919539,10924623,10924624,10924625,10924626,10924627,10924628,10924629,10924630,10924631,10924632,10924633,10924634,10924635,10924636,10924637,10924638,10924639,10924640,10924641,10924642,10924643,10919827,10919828,10919837,10919848,10919849,10919850,10919851,10920023,10920024,10920025,10920026,10920027,10920028,10920029,10920030,10925451,10622034,10922644,10922647,10922652,10922655,10922656,10922662,10922665,10922688,10917740,10917741,10917742,10917743,10917744,10917745,10917746,10917747,10917748,10917749,10917750,10917751,10622277,10622278,10622279,10622280,10622281,10622282,10622409,10622427,10622429,10622430,10917995,10917996,10917997,10918004,10918005,10918006,10923114,10918116,10923117,10923118,10923119,10923121,10923122,10923124,10923145,10923149,10923152,10923154,10923157,10923158,10923162,10923163,10923166,10923167,10923168,10923170,10923172,10923173,10923177,10923178,10923179,10923180,10923181,10923194,10923195,10923197,10923202,10923203,10918277,10918278,10918305,10918306,10918307,10622902,10923415,10923416,10923418,10923421,10622914,10622915,10622916,10923427,10923435,10923436,10923437,10923438,10923439,10619975,10620029,10620222,10620223,10920735,10920850,10920851,10620353,10620354,10620355,10920866,10920867,10920868,10920869,10920957,10920969,10920970,10920971,10921038,10921061,10620640,10620653,10921334,10921335,10921389,10921390,10921391,10921471,10921640,10921641,10921642,10921673,10921747,10921760,10921761,10921762,10921763,10921764,10921765,10921766,10921767,10921768,10921769,10921770,10921771,10921772,10921773,10921774,10921875,10921876,10921877,10921975,10922004,10917040,10917041,10917042,10917043,10917044,10922076,10922077,10917410,10917411,10917447,10917448,10922452,10922457,10610964,10610990,10565154,10611025,10611053,10611054,10611123,10611147,10611151,10611152,10611158,10565308,10611159,10565309,10611160,10565310,10611161,10565311,10611162,10611163,10611165,10565315,10611166,10565328,10611196,10614199,10614201,10614221,10614282,10614298,10611323,10611337,10611341,10611350,10611399,10614441,10614442,10614464,10614466,10614495,10614506,10614538,10614552,10614553,10614554,10614566,10614595,10565877,10614775,10611775,10614776,10611776,10611777,10614794,10611803,10611810,10611823,10566006,10614857,10614861,10611861,10611862,10566013,10611879,10566064,10566065,10611922,10611962,10611989,10612039,10612043,10612049,10612050,10612096,10609141,10563322,10563323,10612207,10612208,10612210,10612211,10612227,10612238,10612242,10609272,10609284,10609286,10609339,10609344,10609345,10563537,10563538,10563539,10612417,10563573,10563575,10563580,10563584,10563587,10563590,10563591,10563605,10612521,10612522,10612534,10609573,10612652,10609666,10609668,10612757,10609763,10563934,10563935,10612806,10612846,10612848,10609877,10609878,10609916,10609917,10609918,10612921,10612931,10612941,10612958,10609983,10609989,10609994,10610046,10564205,10613077,10610104,10610106,10564261,10564262,10564316,10613166,10564317,10564318,10564319,10564386,10564387,10564388,10610293,10613296,10610299,10613303,10564456,10564457,10613356,10613357,10613369,10613373,10613379,10613478,10564631,10613484,10613489,10613490,10613491,10610493,10564649,10610503,10564686,10613562,10564749,10564750,10564751,10564752,10564753,10564754,10564755,10564756,10564757,10613630,10613646,10564808,10564809,10610687,10610688,10610693,10610697,10610704,10564855,10610705,10610725,10613766,10613769,10610775,10610777,10610858,10610859,10610861,10610933,10610941,10610959,10555300,10555301,10555302,10555303,10555304,10517325,10517328,10511511,10511512,10511513,10511514,10511515,10511516,10511517,10511518,10517526,10517527,10511598,10511599,10511600,10511601,10511602,10511603,10511704,10511705,10511706,10511707,10511708,10511893,10555944,10555945,10555961,10512145,10512146,10512576,10512810,10512811,10512847,10512849,10512850,10512851,10518903,10518904,10518905,10518906,10518907,10518908,10518909,10518910,10518991,10513046,10513073,10513086,10513087,10513088,10416236,10419241,10416270,10415285,10415286,10415287,10419302,10419384,10416403,10416406,10416424,10416425,10416426,10416441,10416478,10416550,10416554,10416560,10419576,10415657,10415661,10415662,10415674,10415692,10415727,10415738,10416780,10416781,10416782,10415783,10419786,10419790,10416798,10415811,10419819,10419820,10416822,10416824,10415828,10416828,10416829,10416831,10416832,10416835,10416838,10416841,10416843,10416845,10416847,10416849,10416852,10416853,10416855,10415856,10415857,10415858,10416858,10416859,10416861,10416862,10416863,10416864,10416866,10416868,10416869,10416871,10416873,10416875,10416879,10415881,10416881,10416884,10416887,10416889,10416893,10416896,10415897,10415910,10415913,10415954,10416962,10416967,10415971,10416977,10416978,10416993,10416994,10416995,10417008,10417061,10420063,10420064,10417068,10420068,10416083,10416084,10417089,10417090,10420102,10420103,10420104,10420105,10420106,10420107,10417113,10417114,10417116,10417117,10417118,10416156,10416157,10463029,10471106,10471107,10471108,10471109,10471110,10471111,10471114,10471117,10471119,10471277,10471278,10471279,10471487,10471499,10471500,10465856,10469913,10469915,10469917,10469922,10469923,10469924,10469932,10469943,10469946,10469965,8563407,10470091,8563434,10470137,10470146,8563544,8563550,10470232,8563555,10470277,10470315,10470375,10470476,10470723,10470727,10470733,10462750,10462751,10462752,10462753,10462754,10462755,10462756,10462757) 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'