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(10939535,10939536,10939545,10939546,10939547,4970233,4970245,4970246,4970247,4970250,4970252,10939632,4970255,10939678,4970324,10939718,4970418,4970424,10939810,10939811,10939813,10939819,10939820,10939831,10939837,10939848,10939850,10939851,10939861,4970493,4970500,4970512,4970513,4970514,4970515,4970516,4970517,4970518,4970519,10939904,10939908,10939912,10939922,10939926,4970568,4970609,4970616,4970628,4970638,4970646,4970657,4970659,10940042,10940044,10940045,4970666,4970667,10940063,4970700,4970713,4970715,4970717,4970719,4970720,4970738,4970742,4970757,4970767,10940233,10940234,10940256,10940305,4970956,4970981,10940369,10940380,10940381,10940400,10940402,4971026,4971040,4971041,4971060,10940459,4971096,4971098,10940524,10940529,4968185,8066923,8066939,4968236,8067049,8067070,8067145,8067193,4968461,4968462,4968463,8067204,8067205,8067332,4968615,4968629,8067362,4968640,4968641,4968646,8067391,8067392,4968666,8067446,4968724,4968725,4968726,4968727,4968728,4968786,8067522,8067523,8067524,4968807,8067556,4968845,8067583,4968861,8067638,4968910,4968912,4968913,4968914,8067730,4969032,4969033,4969034,4969035,8067769,4969036,4969037,4969038,4969039,4969040,4969041,4969042,4969043,4969044,4969045,4969046,4969047,4969048,4969049,4969050,8067799,8067804,8067815,10938492,10938495,10938496,4969127,4969128,10938522,10938524,10938530,10938546,4969192,10938588,10938592,10938601,10938609,10938625,4969252,10938637,4969258,10938667,10938679,10938682,4969312,10938726,10938729,10938730,10938740,10938802,4969437,4969438,10938832,10938833,10938846,10938847,10938856,10938858,10938886,10938904,10938905,10938957,10938958,10938966,4969599,4969609,4969610,4969615,10938996,10938997,10938998,10938999,10939000,10939001,4969626,10939040,4969721,10939104,4969759,10939139,10939155,10939156,10939189,4969832,10939272,10939275,10939287,10939301,10939338,10939340,10939364,10939373,10939378,10939379,4970023,4970026,4970027,10939408,10939420,4970062,10939444,8064894,8064916,8064976,8065016,8065026,8065073,8065177,8065222,8065233,8065234,8075040,8075041,8075042,8075043,8075044,8075045,8075058,8075059,8075060,8075061,8075062,8075063,8065296,8075086,8075087,8075088,8075089,8075090,8075091,8075105,8075106,8075107,8075108,8075109,8075110,8065391,8065392,8075214,8075215,8075216,8075217,8065454,8075257,8065488,8065537,8065538,8075333,8075334,8075335,8075336,8065616,8065707,8065722,8065725,8065737,8065738,8065789,8065790,8065791,8065793,4967112,4967113,4967114,4967117,4967118,4967119,4967120,4967122,4967124,4967128,4967129,4967130,4967132,4967136,4967139,4967143,8065944,4967242,8066016,8066053,8066054,8066055,8066056,8066060,8066063,8066131,8066146,8066172,4967463,8066286,8066287,8066288,8066289,8066290,8066291,8066292,8066293,8066294,8066295,8066296,8066297,8066298,8066299,8066300,8066301,8066302,8066303,8066304,8066305,4967629,4967741,8066575,4967843,8066576,8066577,8066578,8066579,8066580,4967885,4967886,4967887,4967894,4967900,4967901,4967904,4967905,8066659,8066660,4967928,8066661,8066662,4967929,4967930,8066663,8066664,8066665,8066666,8066667,8066668,8066669,8066670,8066671,8066672,8066673,8066674,8066675,8066676,8066677,8066678,8066679,4968032,4968033,4968034,4968048,4968049,4968050,4968051,4968052,4968053,4968054,4968055,4968056,4968057,4968058,4968059,4968061,4968062,4968064,4968065,4968066,4968072,4968073,4968122,4968124,4968125,4968126,4968131,4968133,4968134,4968135,8071670,8071671,8071672,8071673,8071674,8071675,8071676,8071677,8071678,8071679,8071680,8071681,8071682,8071683,8071684,8071685,8071686,8071687,8071688,8071689,8071690,8071691,8071692,8071693,8071694,8071695,8071696,8071697,8071698,8071699,8071700,8071701,8071702,8071703,8071704,8071705,8071706,8071707,8071708,8071709,8071710,8071711,8071712,8071713,8071714,8071715,8071716,8071717,8072650,8072653,8072654,8072655,8072656,8072657,8072670,8072675,8072695,8072703,8072704,8072705,8072706,8072707,8072710,8072725,8072730,8072750,8072770,8072775,8072955,8072998,8072999,8073055,8073061,8073471,8073478,8073534,8073535,8073536,8073538,8073539,8073540,8073541,8073543,8073544,8073558,8073559,8073560,8073561,8073562,8073575,8073576,8073577,8073578,8073579,8073580,8073605,8073606,8073607,8073608,8073609,8073610,8073611,8073624,8073625,8073626,8073627,8073628,8073629,10623052,10623082,10623083,10623084,10623098,10623166,10623171,10623183,10623232,10623254,10623255,10623309,10623320,10623388,10623408,10623492,10623502,10623507,10623580,10623656,10623661,10623748,10623785,10623833,10623834,10623835,10623836,10623837,10623838,10623839,10623840,10623841,10623842,10623843,10623844,10623845,10623888,10623899,10623900,10623920,10623921,10623956,10623957,10623958,10623964,10623998,10624034,10624035,10624049,10624050,10624051,10624054,10624055,10624079,10624173,10624177,10624182,10624223,10624294,10624396,10624479,10624480,10624481,10624482,10624483,10624623,10624624,10624625,10624626,10624695,10624729,10624730,10624841,10624857,10624858,10624859,10621975,10622013,10622036,10622128,10622129,10622130,10622131,10622135,10622137,10622138,10622139,10622236,10622397,10622450,10622537,10622588,10622605,10622606,10622616,10622620,10622622,10622623,10622653,10622721,10622788,10620037,10620040,10620121,10620137,10620222,10620223,10620229,10620230,10620231,10620232,10620233,10620294,10620295,10620296,10620310,10620311,10620312,10620313,10620426,10620480,10620481,10620482,10620483,10620513,10620522,10620523,10620524,10620525,10620526,10620527,10620528,10620529,10620530,10620531,10620532,10620533,10620534,10620535,10620536,10620540,10620556,10620559,10620560,10620723,10620731,10620732,10620734,10620736,10620739,10620740,10620741,10620835,10620836,10620838,10620845,10620852,10620853,10620858,10620872,10620873,10620897,10620934,10620935,10620936,10620945,10620991,10621060,10621063,10621064,10621110,10621111,10621112,10621115,10621176,10621177,10621178,10621179,10621180,10621182,10621185,10621186,10621218,10621219,10621220,10621284,10621285,10621286,10621287,10621440,10621441,10621442,10621443,10621453,10621454,10621455,10621550,10621551,10621580,10621581,10621582,10621585,10621587,10621588,10621589,10621590,10621591,10621592,10621593,10621594,10621853,10621863,10621864,10621865,10621866,10621914,10621915,10565271,10565272,10565273,10565274,10565275,10565276,10565277,10565278,10565279,10565280,10565281,10565335,10565336,10565337,10565614,10565615,10565616,10565617,10565618,10565619,10565620,10565621,10565622,10565623,10565624,10566061,10566083,10563323,10563324,10563328,10563329,10563330,10563331,10563559,10563560,10563561,10563562,10563563,10563587,10563605,10564428,10564433,10564442,10564443,10564482,10564483,10564484,10564485,10564486,10564487,10564537,10564538,10564539,10564540,10564541,10564542,10564543,10564544,10564545,10564546,10564547,10564548,10564555,10564582,10564583,10564631,10564634,10564635,10564649,10564684,10564686,10564749,10564750,10564751,10564808,10564809,10564810,10564994,10565094,10565099,10517293,10517411,10517870,10517872,10517875,10517881,10517884,10517885,10517886,10517887,10517889,10517890,10518030,10518144,10518148,10518412,10518413,10518683,10518772,10518906,10518908,10518911,10518991,10419221,10419222,10419272,10419274,10419275,10419276,10419278,10419279,10419280,10419281,10419282,10419284,10419293,10419294,10419339,10419340,10419341,10419370,10419404,10419462,10419509,10419510,10419522,10419523,10419535,10419539,10419540,10419544,10419545,10419546,10419547,10419548,10419549,10419550,10419557,10419560,10419578,10419685,10419686,10419703,10419712,10419786,10419790,10419792,10419798,10419819,10419820,10419828,10419829,10419831,10419844,10419845,10419846,10419847,10419848,10419849,10419850,10419861,10419882,10419884,10419885,10420013,10420017,10420031,10420064,10420109,10420118,10420127,10420152,10420169,10420170,10470949,10470991,10470992,10470995,10471018,10471025,10471026,10471249,10471399,10471400,10471401,10471402,10471403,10471404,10471405,10471406,10471407,10471568,10471569,10471571,10471575,10471581,10471582,10471583,10471591,10471607,10471635,10471674,10471675,10471676,10471677,10471678,10471679,10471680,10471704,10471720,10471735,10471750,10471787,10471800,10471801,10471802,10471803,10471804,10471805,10471806,10471807,10471808,10471809,10471810,10471811,10471812,10471813,10471814,10471815,10471816,10471817,10471818,10469913,10469920,10469921,10469987,10469988,10469989,10470049,10470052,10470053,10470054,10470055,10470056,10470089,10470095,10470113,10470114,10470134,10470227,10470267,10470268,10470304,10470305,10470306,10470307,10470382,10470727,10470733,10470770,10470776,10470777) 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'