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(7075991,7076039,7076091,10943600,10943601,10943602,10943603,7076248,7076249,10939873,7076250,7076251,7076256,7076258,7076259,7076260,7076261,7076268,7076279,7076294,7068553,7068554,7068555,7068556,10940229,4970880,4970915,8569733,10944264,7068877,10933283,4968168,10933309,10933310,10933311,10933312,10933313,10933314,10933315,10933316,10933317,10933318,10933319,10933320,7073980,10933334,8067064,7074140,8067153,8067154,8067155,8067156,7074183,8067222,7074305,8067408,10437493,7066831,10437702,10437703,10437704,10437705,10437706,10437707,10437708,10437709,10437710,10437711,10437712,10437713,10437714,10437715,10437716,10437717,10437721,10938493,7066936,10961720,7075054,7075055,7075102,7075103,7075104,7075105,7075106,7075107,7075108,7075109,7075110,7075111,10961805,7075123,7075124,10961873,10961874,10961875,10961876,10961894,10961895,7075295,7075296,7075312,10938974,7075369,7067394,7075420,7075782,7075821,7075856,7075911,7072224,7072293,7064366,7064442,7064445,7072455,7072456,8075245,10960213,7064529,7064530,10960214,10960215,10960216,10960217,10960218,10960219,10960220,10960221,10960222,10960223,10960224,10960225,10960226,10960227,10960228,10960229,10960231,10960240,10960241,10960243,10960244,10960245,10960246,10960247,10960248,10960249,10960260,10960261,10960262,10960263,10960264,7072580,10960265,7072581,7072584,10960269,10960270,10960271,10960272,10960281,10960282,10960283,10960285,8065781,8065782,7072946,7072947,7072950,7072953,7072954,7072967,7072968,7072969,7072970,7072971,7072972,7072973,7072974,7072975,7072976,7072977,7072978,7072979,7072982,7072990,7072991,7072994,7073000,7073001,7073002,7073003,4967514,10961110,7073513,7073515,7073528,7073532,7073536,7073538,7073553,7073566,7065609,4967878,4967879,4967880,4967881,4967882,4967884,7073754,7065848,10933238,10933239,10942562,10942583,10942584,10942586,10942589,10942590,10942591,7070989,7070990,7070993,11049132,10958947,11049359,10943113,10943118,10943119,7071500,8064563,8064564,8064565,8064566,11049494,11049533,10943322,8064710,8064711,6000030,6000071,6000073,7071798,6000080,7071859,7071866,10959565,7069013,3655588,10944479,10944480,10944481,10944482,10940749,10940750,3655815,3655818,3655819,7069309,7069310,7069311,7069312,7069314,7069315,7069316,7069317,7069319,7069320,7069321,7069322,7069323,7069324,7069325,7069326,7069327,7069328,7069329,7069330,7069331,7069332,7069335,7069337,7069338,7069339,10944957,10944982,10944997,10941278,3656258,3656378,3656383,3656520,3656521,3656582,3656583,3656584,3656585,3656586,3656587,3656588,3656589,3656590,7070034,7070084,10941823,10941832,10941833,3656860,10941969,3656923,7070466,10942105,10942137,7070739,8073528,10942423,10618035,10918582,10623100,10918741,10918745,10623381,10919142,10618840,10618843,10919435,10919438,10919439,10919784,10919785,10919787,10919788,10919938,10919939,10619495,10619506,10624533,10624609,10624610,10624611,10619913,10624953,10624954,10624955,10624956,10624957,10624958,10624959,10624960,10616989,10616997,10617005,10617006,10617008,10617056,10617094,10617095,10617097,10622102,10622116,10622117,10622118,10622119,10622120,10622121,10622123,10917644,10917646,10917647,10917659,10617322,10622353,10917888,10622402,10928013,10918100,10928101,10918103,10918109,10954299,10954300,10954301,10954302,10954303,10617651,10622715,10622716,10622717,10622729,10918250,10918252,10918255,10918259,10928267,10928306,10928307,10928308,10928309,10928310,10928311,10928312,10928313,10928314,10918451,10918452,10918456,10918460,10918461,10920580,10620080,10925624,10925625,10925626,10925627,10925628,10925629,10925630,10925631,10925632,10925633,10925634,10925635,10925636,10920727,10920739,10615229,10925759,10925760,10925761,10925762,10925763,10925764,10925765,10925766,10925767,10925768,10925769,10925770,10925771,10925772,10925773,10925774,10925775,10925776,10925777,10925778,10925779,10925780,10925781,10925782,10925783,10925784,10925785,10925786,10925787,10925788,10925789,10925790,10925791,10925792,10925793,10925794,10925795,10925796,10925797,10925798,10925799,10925800,10925801,10925802,10925803,10925804,10925805,10925806,10925807,10925808,10925809,10925810,10615335,10926009,10926011,10926016,10926039,10926047,10615676,10926228,10926233,10926234,10926239,10926295,10620798,10926322,10926323,10926324,10926331,10926332,10926333,10921334,10921335,10921345,10921349,10921350,10921351,10921352,10921353,10921354,10921355,10921356,10921362,10921366,10921367,10921368,10921371,10921378,10921379,10921380,10921381,10921382,10921383,10921386,10921387,10620941,10620942,10620943,10620944,10620945,10620946,10620947,10620948,10921458,10620949,10620950,10620951,10620952,10620953,10620954,10620955,10620956,10620957,10620958,10926485,10926486,10926487,10616050,10616052,10921562,10921563,10926583,10926584,10926585,10926586,10926587,10916745,10916748,10921855,10921856,10921858,10921860,10921928,10921929,10616479,10616518,10616519,10616520,10917353,10917360,10917361,10917363,10611160,10614160,10614237,10614247,10614288,10614421,10611825,10611879,10611907,10612058,10609104,10609109,10609114,10609115,10609116,10557288,10612181,10557425,10609292,10609303,10612344,10557512,10612381,10557600,10557601,10557602,10557603,10557604,10557605,10557606,10557607,10557608,10557609,10557642,10609575,10609576,10609577,10612583,10612639,10612660,10612912,10612968,10612969,10610075,10610086,10610094,10610366,10610390,10610477,10613562,10610567,10613644,10610954,10555219,10555300,10555301,10555302,10555303,10555304,10555305,10555306,10555307,10555308,10555309,10555310,10555311,10555312,10555313,10555314,10555315,10555321,10555337,10555338,10555339,10555340,10555383,10555384,10555385,10555399,10555431,10555436,10555437,10555438,10555439,10555440,10555441,10555442,10555443,10555444,10555445,10555446,10555447,10555448,10555449,10555450,10555451,10555452,10555453,10555454,10555455,10555456,10555457,10555458,10555459,10555460,10555461,10555462,10555463,10555464,10555465,10555466,10555467,10555468,10555469,10555470,10555471,10555472,10555473,10555474,10555475,10555476,10555477,10555478,10555479,10555480,10555481,10555482,10555483,10555484,10555485,10555486,10555487,10555488,10555489,10555490,10555491,10555492,10555493,10555494,10555495,10555496,10555497,10555498,10555499,10555500,10555501,10555502,10555503,10555504,10555505,10555506,10555507,10555508,10555509,10555510,10555511,10555512,10555513,10555514,10555515,10555516,10555517,10555518,10555519,10555520,10555521,10555522,10555523,10555524,10555525,10555526,10555527,10555528,10555529,10555530,10555531,10555532,10555533,10555534,10555535,10555536,10555537,10555538,10555539,10555540,10555541,10555542,10555543,10555544,10555545,10555546,10555547,10555548,10555549,10555550,10555551,10555552,10555553,10555554,10555555,10555556,10555557,10555558,10555559,10555560,10555561,10555562,10555563,10555564,10555565,10555566,10555567,10555568,10555569,10555570,10555571,10555572,10555573,10555574,10555575,10555576,10555606,10555607,10555608,10555625,10555663,10555694,10555722,10555723,10555724,10555725,10555726,10555727,10555746,10555755,10555763,10555764,10555765,10555766,10555767,10555768,10555769,10555770,10555771,10555772,10555773,10555775,10555780,10555796,10555799,10555810,10555812,10555813,10555814,10555815,10555816,10555820,10555823,10555832,10555833,10555834,10555835,10555836,10555837,10555838,10555839,10555840,10555841,10555842,10555843,10555862,10555863,10555864,10555868,10555872,10555876,10555878,10555880,10555887,10555890,10555892,10555903,10555904,10555905,10555911,10555912,10555924,10555928,10555929,10555930,10512117,10512149,10512161,10512162,10512163,10512164,10512165,10512166,10556893,10556894,10418273,10418274,10416287,10417293,10417294,10417295,10419302,10418336,10417348,10417402,10417406,10417410,10417411,10417412,10417413,10417414,10417415,10417416,10417417,10417418,10417419,10417420,10417421,10417422,10417423,10416427,10419450,10419452,10418465,10415466,10419540,10419541,10419542,10419555,10419563,10419564,10419565,10419566,10419567,10416607,10416615,10416629,10416630,10416631,10416632,10416633,10416634,10416635,10416636,10415654,10415655,10415705,10419720,10417735,10417740,10419748,10419749,10419750,10418793,10417964,10420012,10420046,10417058,10417076,10417077,10418096,10417188,10417196,10416201,10416202,10417204,10470923,10469088,10469089,10469134,10469135,10471242,10467336,10467337,10467338,10467339,10467340,10467345,10467350,10467351,10467354,10467355,10467356,10467357,10463381,10463384,10463385,10463386,10463387,10463388,10463532,10470045,10464067,10464068,10464069,10464070,10464071,10464072,10464073,10464074,10464075,10464076,10464077,8563420,8563427,8563445,8563446,8563447,8563448,8563449,8563450,8563451,8563452,8563453,10468156,10464239,10464250,10464328,10470337,10470353,10470367,10464413,10468426,10470429,10470430,10470431,10470432) 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'