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(7067892,7067895,7067897,7067899,7067901,7067903,7075912,7075913,10943594,10943595,7068094,10943628,7076127,7076128,10198397,10237416,10237417,10237418,10237421,7068220,7068221,7068222,7068223,7068224,10237465,4970671,7068519,7068520,7068521,7068522,7068523,8569757,7065830,7065831,7065832,7065834,7065838,7065839,10238244,10238262,10238286,10238287,10238292,10238293,10238392,10238539,10238540,10238554,10238555,10238556,10238557,10238580,7066344,7066348,10199611,10199612,10225629,10225631,10238636,10238637,10238638,10238726,10200022,8067903,10223163,7067196,7067236,7067298,10210930,10210931,10210932,10210933,10210934,10210935,7067697,7075776,7075778,7072263,10234506,10234507,10234508,10234509,10234510,10221592,10931830,10234787,10234788,10234789,10234790,10234829,10234830,10195933,7064733,7064735,7064771,10209109,10209111,7064892,10196190,10196191,10196192,10196193,10222215,10196290,10222306,10196549,10196550,10196551,10196552,10196553,10196554,10196555,10196556,10196557,10196558,10196559,10196560,10196561,10196562,10196563,10196564,10196565,10196566,10196567,10196568,10196569,10235619,7071093,10233362,10233363,10233364,10233365,10233368,10233369,10233370,10233372,10233382,10233383,10233384,10233385,10233386,10194461,10194462,7071267,7071325,10233771,10233772,10233773,10233775,10233776,10233779,10943257,10233780,10233781,10233782,10233785,10943289,10943342,10220952,10220953,10220954,10233968,10220992,10220993,10220994,10220995,10220996,10220997,10220998,10220999,10221000,10221001,10221002,10221003,10221004,10221005,10221006,10231134,10231148,10231180,10231194,10231195,10231206,10231546,7069346,10941262,10232041,10941703,10941705,10941771,10941777,10941781,10941839,7070342,8860418,8860419,8860420,10942385,8073529,10229107,10229132,10229138,10229139,10229141,10229145,10229146,10229147,10229148,10229154,10229155,10229157,10229159,10229160,10229194,10229231,10928700,10928701,10618209,10229337,10229338,10229339,10229373,10229507,10229509,8070134,8070136,8070139,10229547,10229577,10229578,10229579,10229586,10229587,10229588,10229589,10229590,10229591,10229593,10623494,10623496,10623507,8070224,8070225,10229614,10229615,10229631,10229652,10229657,10229658,10229661,10190705,10190776,10623730,10229964,10230002,10230003,10230081,10230098,10204257,10230303,10204356,10619352,10624548,10204910,10619891,10619892,10619900,10189069,10927507,10927508,10617035,10189298,10622258,10622264,10622265,10622267,10622268,10617322,10617327,10617333,10617334,10617335,10617336,10617337,10617338,10617349,10617350,10617351,10617352,10617355,10617356,10617357,10617358,10617359,10617360,10622360,10617361,10617362,10617363,10617364,10617365,10617366,10617367,10617368,10617369,10617376,10922896,10617383,10617395,10622402,10622408,10189508,10189509,10189510,10189511,10189512,10189513,10617418,10617419,10617420,10617421,10617422,10617423,10617427,10622431,10617432,10617433,10622447,10617451,10617453,10617456,10928007,10617510,10622514,10622516,10622523,10622677,10622678,10622679,10622680,10622681,10617804,10189911,10190017,10190018,10213107,10213108,10213109,10213110,10213111,10213112,10213113,10213114,10213115,10213116,10213117,10213118,10213119,10213120,10615036,10615076,10620085,10213242,10620172,8570040,10615229,10620254,10620255,10620256,8570094,10620257,10620258,10620259,8570115,10620297,10620298,10620301,10620302,10620303,10615329,10615330,10615338,10615340,10615341,10615342,10615343,10615344,10200643,10200644,10200645,10200646,10200647,10200648,10200649,10200650,10200651,10200652,10200653,10200654,10200655,10200656,10200657,10200658,10200659,10200660,10200661,10620717,10620718,10930665,10930666,10930667,10615896,10930732,10620920,10620921,10620922,10620923,10616044,10616243,10616245,10616248,10616252,10616253,10616258,10188366,10188367,10188377,10188378,10188379,10188380,10188381,10188382,10188383,10188384,10188385,10616287,10188386,10616329,10616332,10616333,10616370,10616417,10227519,10227520,10227521,10616423,10227522,10227523,10227524,10616426,10227525,10227526,10227527,10227528,10227529,10188656,10188657,10188658,10188659,10188665,10616648,10616649,10927260,10613998,10613999,10614000,10614001,10614002,10614003,10614004,10614005,10614006,10614007,10614008,10614009,10614010,10614011,10614012,10614013,10614014,10614015,10614016,10614017,10614018,10614019,10614064,8863986,8864011,10614221,7059777,10559609,10614497,10614498,6665998,6666004,6666208,6666209,6666213,6666217,6666218,6666219,6666220,6666259,10611969,10611970,10612059,10612086,10612106,7057713,7057714,8862146,7057799,10612381,7058023,8862481,8862558,10557973,10557975,10557976,10612937,10612960,10612961,10558318,10558320,10613179,10613306,10613341,10613391,10613392,10613393,10613394,10561561,10561562,10613506,10613524,10613525,10613740,10613750,8863778,9161354,9161355,9161361,10515328,7055775,10513565,7055956,10515683,10515684,10515685,10515686,10515687,10515688,10515689,10515690,10515692,10515693,10515694,10515695,10515696,10515697,10515698,10515699,10515700,9161895,10515701,10515702,10515703,10515704,10515705,10515706,10515707,10515708,10515709,10515710,10515711,10513914,9162137,7056334,10518648,10518649,10518650,10518651,10518652,10518653,10518654,10518655,10518656,10518657,10518658,10518659,10518660,10518661,10518662,10518663,10518664,10518665,10518666,10518667,10518668,10518669,10518670,10518671,10518672,10518673,10518674,10518675,10518676,10518677,10518678,10518679,10518680,10518681,10518682,10518683,10518684,10518685,10518686,10518687,10518688,10518689,10518690,10518691,10518692,10518693,10518694,10518695,10518696,10518697,10518698,10518699,10518700,10518701,10518702,10518703,10518704,10518705,10518706,10518707,10518708,10516865,10516866,10516867,9160319,9160334,9160335,10419271,10416354,10416355,10416362,10416369,4973319,4973335,4973336,4973337,4973338,10416429,10417443,10417444,10419471,10419480,10419481,10419482,10419483,10419484,4973428,4973429,4973434,4973435,4973436,10419520,10419668,10419676,10419689,10419693,10419706,10419720,10419725,10419728,10419729,10419732,10419733,10419739,10419748,10419749,10419750,10418832,10418833,10418834,10419837,10419838,10419840,10418853,10418854,9160967,10419899,10419900,7055155,10419994,10419997,10419999,10420000,10420004,10420006,10420008,10420011,10417058,10417063,10417071,10417076,10417077,10417079,10417080,10417081,10417082,10417083,10417084,10417085,10417086,10417087,10417088,10417089,10417090,10417091,10417092,10417093,10417094,10417095,10417096,10417097,10417098,10417099,10417100,10417101,10417102,10417103,10417104,10417105,10417106,10417107,10417108,10419108,10417109,10417110,10417111,10419111,10417112,10417113,10417114,10417115,10417116,10417117,10417118,10417119,10417120,10417121,10417122,10417123,10417124,10417125,10417126,10417127,10417128,10417129,10417130,10417131,10417132,9161218,10417133,10417134,10417135,10417136,10417137,10417138,10417139,10417140,10417141,10417142,10417143,10417144,10417145,10417146,10417147,10417148,10417149,10417150,10417151,10417152,10417153,10417154,10417155,10417156,10417157,10417158,10417159,10417160,10419188,7055458,7055459,10467097,10467107,10467142,4971462,4971463,10467219,10467220,10467221,10469245,10469277,10469278,10469372,10469373,10469374,10469375,10469376,10469377,10469378,8916476,10467443,6666946,4971825,8916645,4971883,8916759,10465703,10465758,10465765,10465767,10465769,10465780,10467831,10465849,10465851,10465863,10465864,10467871,10465874,10463886,10463887,10463888,10465891,10463892,10465902,10465904,10465905,10463906,10465909,10467909,10467910,10467911,10467912,10463913,10467913,10467914,10467915,10465916,10463927,4972257,10464079,10464080,4972481,10466225,10466226,10466235,10466236,10466243,10468329,10466330,10466331,10466384,4972672,10466390,10466398,10466410,10466411,10466416,10466417,10466418,10466419,10466422,10466423,10466429,10466430,10466431,10466438,6667875,10466452,10466455,6668126,10466845,10628321,10628325,10628383,10159957,10628513,10628534,10155731,10156041,10156108,10627085,10632161,10632162,10632163,10632164,10632165,10632169,10627319,10153863,10627583,10627585,10627587,10630147,10630176,10630177,10630272,10626134,10626139,10626140,10626205,10626375,10626378,10626379,10631430,10631431,10631432,10631446,10631447,10631448,10631449,10626453,10626454,10631546,10626602,10626787,10626842,10631859,10158446,10568112,10568294,10568302,10568303,10567578,10567621,10522293,10522294,10522295,10522299,10522305,10522311,10522316,10522317,10522353,10522373,10524419,10522450,10522463,10522612,10522613,10420313,10420319,10420320,10420322,10420324,10420326,10421399,10421403,10421404,10421405,10421408,10421409,10421410,10420424,10420425,10420428,10420429,10420432,10420441,10420442,10421488,10422598,10421600,10421633,10421891,10421966,10421983,10423000,10423014,10423015,10423016,10423017,10423018,10423020,10421036,10421037,10423160,10477731,10477733,10477785,10476506,10476507,10472764) 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'