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(10939598,4970273,4970274,4970276,4970281,4970285,4970287,4970290,4970301,4970302,4970303,4970304,4970305,4970306,4970307,4970308,4970309,4970310,4970311,4970312,4970314,4970315,4970316,4970317,4970318,4970321,4970323,4970324,4970325,4970331,4970332,4970335,4970336,4970337,4970338,4970340,4970350,4970357,4970361,4970362,4970363,4970366,4970367,4970368,4970369,4970373,4970381,4970383,4970384,4970385,4970386,4970391,4970398,4970399,10940033,4970669,4970699,10940112,10940114,4970754,4970755,4970792,4970912,4970966,10944180,10944188,10944189,10944190,10944191,10944192,10944193,10944200,10944204,10944205,10944207,10944208,10944210,8066928,8066929,8066930,8067041,8067103,8067104,8067196,4968699,4968700,8067471,8067495,4968843,8067774,8067893,8067894,8067895,8067901,8067910,8067911,8067912,10938655,10938656,10938657,10938898,10938899,8068481,8068529,10939287,10939289,10939293,10939294,10939295,10939296,10939297,10939298,10939299,10939300,10939301,10939302,10939307,10939308,10939312,10939313,10939314,10939319,10939325,10939326,10939327,10939328,10939329,10939330,10939332,10939335,10939337,10939338,10939339,10939484,8068793,8065518,8065519,8065520,8065521,8065522,10931893,8065523,10931894,8065536,8065537,8065538,8065539,8065540,8065541,8065542,8065543,8065544,8065545,8065546,8065547,8065548,8065549,8065550,8065551,8065552,8065553,8065554,8065555,8065556,8065557,8065558,8065559,8065560,8065561,8065562,8065563,8065564,8065565,8065566,8065567,8065569,8065570,8065571,8065572,8065573,8065575,8065576,8065580,8065581,8065582,8065583,8065584,8065585,8065586,8065587,8065590,8065591,8065592,8065593,8065594,8065595,8065596,8065599,8065600,8065601,8065603,8065604,8065608,8065609,8065611,8065616,8065617,8065618,8065622,8065623,8065628,8065631,8065634,8065635,8065636,8065638,8065644,8065645,8065646,8065647,8065649,8065650,8065651,8065652,8065653,8065654,8065655,8065656,8065657,8065658,8065659,8065660,8065661,8065662,8065665,8065667,8065668,8065670,8065671,8065672,8065673,8065674,8065675,8065677,8065681,8065682,8065683,8065684,8065685,8065686,8065691,8065815,8065831,10932803,10932819,10932820,10932821,10932823,10932826,8066486,8066510,4967774,4967775,4967776,4967777,4967778,4967779,4967780,4967781,4967782,4967783,4967784,4967785,4967786,4967787,4967788,4967789,4967790,4967791,4967792,4967793,4967794,4967795,4967796,4967797,4967798,4967799,4967800,4967801,4967802,4967803,4967804,4967805,4967806,4967807,4967808,4967809,4967810,4967811,4967812,4967813,4967814,4967815,4967816,4967817,4967818,10932957,10932958,10933051,10933052,10933220,11049776,11049777,11049778,11049779,11049780,11049781,11049782,11049784,10942773,10943109,8064491,8064492,8064493,8064494,8064495,8064496,8064497,8064498,8064499,8064500,8064501,8064502,8064503,8064504,8064505,8064506,8064507,8064508,8064509,8064510,8064511,8064512,8064513,8064514,8064515,8064516,8064692,10943421,8970224,10940620,10940621,10940622,10940623,10940624,10940625,10940626,10940627,10940628,10940629,10940630,10940631,10940632,10940633,10940634,10940635,10940636,10940637,10940638,10940639,10940640,10940641,10940642,10940643,10940644,10940645,10940646,10940647,10940648,10940649,10940650,10940651,10940652,10940653,10940654,10940655,10940656,10940657,10940658,10940659,10940660,10940661,10940665,10940666,10940709,10940712,10941121,10941122,10941123,10941124,10941125,10941126,8072318,8072319,8072320,8072321,8072322,10941268,10941269,3656701,10942010,11049615,11049616,11049617,11049618,11049771,11049775,10918562,10918564,10918565,10918566,10918567,10918568,10918684,10918711,10918712,10918726,10919092,10919093,10919094,10623806,10919377,10919378,10919379,10919380,10919398,10919399,10919401,10919402,10624135,10624136,10624137,10624138,10624139,10624140,10624141,10624142,10624143,10624144,10624145,10624146,10624147,10624148,10624149,10624150,10624151,10624152,10624153,10624154,10624155,10624156,10624157,10624158,10624159,10919729,10919732,10919733,10919747,10919749,10919750,10919751,10919752,10919753,10919754,10919883,10919884,10919885,10919886,10624404,10624405,10624406,10624407,10624408,10624409,10624410,10624427,10624582,10624583,10624584,10624585,10624586,10920328,10920363,10920364,10624883,10624884,10624959,10917473,10922487,10922489,10917591,10917592,10917593,10917594,10917597,10917598,10917599,10917600,10917601,10917602,10917603,10917604,10917605,10917606,10917607,10622173,10622174,10622175,10622176,10622177,10622178,10622251,10917818,10917819,10917820,10917821,10917822,10917823,10917838,10917839,10917840,10917841,10918088,10918229,10622916,10918426,10622920,10918434,10918435,10920526,10920527,10915624,10915625,10620164,10620168,10620169,10920683,10920716,10620213,10620268,10620269,10920825,10920826,10920830,10920831,10620364,10620406,10920934,10620484,10620485,10620486,10620487,10620488,10620489,10620490,10620491,10620492,10620493,10620494,10620495,10620496,10620497,10620498,10620499,10620500,10620501,10620502,10620503,10620504,10921015,10620505,10921016,10620506,10620507,10620508,10620509,10921142,10921143,10921144,10921145,10921155,10620669,10620699,10620700,10620701,10620702,10620703,10620704,10620705,10620706,10620707,10620708,10620709,10620710,10620711,10620712,10921302,10921447,10921448,10916467,10916468,10916469,10916470,10916471,10916472,10916473,10916474,10916475,10916476,10916477,10916478,10921536,10921537,10916549,10916550,10916551,10916552,10916553,10916554,10916555,10916556,10921659,10921692,10921693,10921694,10921817,10921824,10921825,10921826,10921827,10921828,10921829,10921830,10921831,10921832,10921922,10921949,10921952,10921953,10621627,10621628,10621629,10621630,10621631,10621632,10621633,10621634,10621635,10621636,10621637,10621638,10621639,10621640,10621641,10621642,10621643,10621644,10621645,10621646,10621647,10621648,10922188,10922189,10621817,10621818,10621819,10621820,10621821,10621822,10621823,10621824,10621825,10621826,10621827,10621828,10621829,10621830,10621831,10621832,10621833,10621834,10621835,10621836,10621837,10621838,10621839,10621840,10621841,10621842,10621843,10621844,10621845,10621846,10621847,10621848,10621849,10621850,10621851,10621852,10621853,10621854,10621855,10621856,10621857,10621858,10621859,10621860,10621861,10621862,10621863,10621864,10621865,10621866,10621867,10621868,10621869,10621870,10621871,10621872,10621873,10621874,10621875,10621876,10621877,10621878,10621879,10621880,10621881,10621882,10621883,10621884,10621885,10621886,10621887,10621888,10621889,10621890,10621891,10621892,10621893,10621894,10621895,10621896,10621897,10621898,10621899,10621900,10621901,10621902,10621903,10621904,10621905,10621906,10621907,10621908,10621909,10621910,10621911,10621912,10621913,10621914,10621915,10621916,10621917,10621918,10621919,10621920,10621921,10621922,10621923,10621924,10621925,10621926,10621927,10621928,10621929,10621930,10621931,10621932,10621933,10621934,10621935,10621936,10621937,10621938,10621939,10621940,10621948,10565158,10611026,10611027,10611028,10611029,10611032,10611033,10611034,10611050,10611051,10611097,10611114,10611365,10611717,10611718,10611751,10611752,10611753,10609056,10563280,10563281,10609239,10563519,10563520,10609379,10563983,10563988,10563989,10563991,10563994,10609846,10609852,10564011,10564012,10609871,10609873,10564028,10564029,10564030,10564031,10564032,10609883,10564033,10609884,10564034,10609885,10564035,10564036,10564037,10564038,10564040,10564041,10564044,10564045,10564046,10564047,10564048,10564052,10564053,10564054,10564055,10564056,10564057,10564058,10564059,10564060,10609914,10564069,10564073,10564080,10564106,10564107,10564108,10564110,10564111,10564112,10564113,10564114,10564115,10564116,10564117,10610105,10610106,10610183,10610184,10610185,10610186,10610187,10610188,10610210,10610212,10610231,10610245,10610246,10610539,10610558,10610633,10610704,10610705,10610742,10610743,10610744,10610745,10555690,10555691,10555692,10555709,10555710,10555711,10555712,10517812,10517815,10517816,10517817,10517818,10517819,10556169,10556170,10556172,10556393,10556475,10556477,10556611,10556612,10556879,10556880,10556881,10556882,10556969,10556970,10519079,10519080,10519081,10415383,10415483,10471187,10471203,10471204,10471239,10463256,10463257,10463258,10463259,10463260,10463261,10463262,10463263,10463264,10463265,10463266,10463267,10463268,10463269,10463270,10463271,10463272,10463273,10463274,10463275,10463276,10463277,10463278,10463279,10463280,10463281,10463282,10463283,10463284,10463285,10463286,10463287,10463288,10463289,10463290,10463291,10463292,10463293,10463294,10463295,10463296,10463297,10463298,10463299,10463300,10471502,10471503,10471505,10471556,10469897,10469898,10469899,10470029,10470030,10470031,10470032,10470107,8563527,8563528,10470223,10462709,10462710,10470854) 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'