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(7075957,8068878,8068887,8068894,7076065,7076144,7068146,7076157,7068162,7068239,7068273,7068274,7068275,7068276,7068282,7068312,7068313,7068314,7068316,7068317,7068318,7068325,7068335,10939965,7068342,10939991,4970667,4970668,10940181,10940198,7068708,7068759,7068765,7068766,8569750,8569792,8569793,8569798,8569799,7068832,8569813,7068843,7068844,7068845,4971061,4971062,8569822,7068849,8569888,8066918,7065974,7074084,7074140,7074176,8067216,8067519,7074608,7074638,7074646,7074647,8067626,8067627,8067636,7074667,8067648,7074672,8067652,7074680,8067658,7074689,7066704,8067685,8067686,8067687,8067695,7074721,7074722,7074727,7074731,8067709,8067710,8067711,7074735,7074752,10437614,10437615,10437616,7074765,7074769,7074775,7074795,7074805,7074816,7074819,7074836,7074846,7074855,7074865,7074867,7074868,7074869,7074880,7074886,10437744,7074902,7074921,7075012,7075013,8067964,8067965,8067966,8067967,8067981,8067982,8067988,8067989,8067990,8068016,8068017,8068041,8068063,8068064,8068066,8068106,8068107,8068108,8068125,8068126,8068127,8068128,8068129,8068130,8068166,8068167,8068168,8068169,8068170,8068171,8068172,8068204,8068205,8068206,8068207,8068208,8068209,8068210,8068247,8068248,8068249,8068250,8068251,8068252,8068265,8068280,8068281,8068300,8068301,8068329,8068330,8068331,8068332,8068333,8068334,8068353,8068354,8068355,8068356,8068357,8068358,8068359,8068360,8068395,8068396,8068397,8068406,8068419,8068425,8068426,8068427,8068428,8068447,10939179,10939180,8068448,8068520,8068521,8068522,8068523,8068554,8068555,8068556,8068557,8068558,8068591,8068592,8068593,8068594,8068595,8068596,8068601,8068610,8068615,8068630,8068631,8068643,8068650,8068665,8068675,8068678,8068679,8068684,8068703,8068704,8068705,8068708,8068717,8068718,8068719,8068721,8068740,8068741,8068742,8068752,8068765,8068766,7072113,7072302,7072321,7072322,7072323,7072329,7072362,7072363,7072374,7072387,7064400,7072401,7072403,7072404,7072405,7072427,7072511,7072637,7072640,7072680,7072681,7064713,7072731,7072776,8065796,7072831,7072924,8066002,7073187,8066193,8066194,8066195,8066228,8066229,8066230,8066231,8066232,8066247,8066248,8066279,8066317,8066353,8066368,8066377,8066378,8066379,8066394,8066395,8066396,8066397,8066398,8066399,10932774,7065432,7065433,7065438,8066417,8066418,8066419,8066420,8066439,8066440,8066555,8066556,8066563,8066582,8066603,8066604,8066605,8066618,8066619,8066620,8066655,8066676,8066739,8066741,8066742,8066766,8066783,8066808,8066809,8066810,8066811,8066812,8066813,8066814,10933192,8066829,8066830,8066831,4968079,4968080,8066845,8066846,8066859,8066860,8066879,8066882,8066889,8066896,8066907,8066909,8066910,7071079,11049012,10942750,10942751,10942752,10942753,10942794,10942813,7071200,10942824,7071213,10942934,10942936,10942972,10942973,10942974,10942976,10942977,10942978,10942983,10942984,10942998,10942999,10943000,10943001,10943002,10943009,10943011,10943012,10943013,10943014,11049329,11049331,11049335,11049342,11049343,11049350,10943080,10943095,10943096,10943098,8064693,7071727,6000164,6000165,6000166,6000167,6000168,6000169,7068961,7068969,7068970,7069016,7069024,7069031,7069036,7069057,7069058,7069060,7069073,7069074,3655676,3655677,10940752,7069229,7069280,7069281,7069317,7069461,10944942,10944943,3656453,3656463,3656479,3656596,10942156,10942324,7070772,11048691,10923502,10923503,10923504,10923505,10923506,10618003,10923515,10923536,10923537,10918558,10918559,10618066,10928601,10923603,10918619,10923620,10923621,10918677,10918681,10923784,10923785,10923786,10923787,10923788,10923789,10923790,10923791,10923792,10923793,10923794,10923795,10923796,10923797,10623307,10623352,10623446,10923997,10923998,10923999,10924000,10924001,10924002,10924003,10924004,10919062,10919063,10919064,10924188,10924189,10924190,10924191,10924192,10924193,10924194,10924195,10924196,10924197,10924198,10924199,10924259,10924260,10919368,10919369,10919370,10924513,10924514,10924515,10924516,10924517,10924518,10924519,10924520,10924521,10924522,10924523,10924524,10924525,10924701,10924702,10924703,10924704,10924705,10924706,10924707,10924708,10924709,10924710,10924711,10924712,10924713,10924714,10919715,10924715,10919716,10924716,10919717,10924717,10919718,10924718,10919719,10919928,10925030,10925031,10925032,10925033,10925100,10925104,10925164,10925175,10925198,10925199,10925200,10920299,10920300,10920301,10920302,10920303,10920304,10920305,10925319,10925320,10925321,10925322,10925323,10925324,10925325,10925326,10925327,10925409,10925410,10925411,10925412,10925413,10925414,10925449,10925450,10624953,10925471,10621977,10621978,10622099,10622100,10922637,10922677,10922678,10922679,10922680,10922681,10922687,10922688,10922689,10922690,10922691,10922713,10917792,10917793,10917794,10917795,10917796,10922893,10922894,10922896,10922930,10922933,10917973,10922974,10922975,10922976,10922977,10617499,10923009,10923010,10923011,10923012,10617516,10923045,10923046,10923047,10923048,10923049,10923050,10923051,10923052,10923053,10923054,10923055,10923056,10923057,10918075,10918076,10918077,10918078,10923078,10923079,10923082,10923105,10923132,10923133,10923134,10923135,10923202,10923203,10928211,10923249,10923250,10923251,10923252,10923253,10923254,10923255,10923256,10923257,10923258,10923307,10923308,10923349,10923350,10923351,10923352,10923369,10923370,10918417,10923442,10923443,10923444,10923462,10923463,10923464,10923465,10925472,10925473,10920524,10920808,10920809,10920810,10920811,10620302,10920817,10920818,10920819,10920820,10620321,10620322,10620323,10620324,10620325,10620326,10925996,10925997,10925998,10615489,10925999,10926000,10921009,10615570,10921294,10921298,10916421,10916422,10921596,10921597,10921598,10921599,10921600,10921601,10921602,10921603,10921604,10921605,10921606,10921607,10921608,10921609,10921610,10921611,10921612,10921613,10921614,10921615,10921616,10921617,10921618,10921619,10921620,10621123,10621152,10621156,10621157,10621158,10621162,10621244,10621245,10621246,10621263,10621298,10621299,10621302,10621337,10621338,10621339,10621344,10616372,10616373,10616374,10616375,10616376,10616377,10616378,10616379,10616380,10616381,10616382,10616383,10616384,10616385,10616386,10621386,10616387,10621387,10616388,10621388,10616389,10616390,10616391,10616392,10616393,10616394,10616395,10616396,10616397,10616398,10616399,10616400,10616401,10616402,10616403,10616404,10616405,10616406,10616407,10616408,10616409,10616410,10616411,10616412,10616413,10616414,10616415,10616416,10616417,10616418,10616419,10616420,10621420,10616421,10616422,10621425,10621427,10621452,10921966,10621458,10616462,10621462,10621477,10621478,10621489,10621490,10621499,10621570,10621576,10621577,10621578,10621579,10621580,10621585,10621633,10621635,10621638,10621643,10621648,10621663,10621664,10621665,10621670,10621681,10621682,10621686,10621691,10621697,10621700,10616701,10621701,10621702,10621703,10621712,10927232,10927233,10927234,10621730,10621734,10927255,10621750,10917277,10917278,10917299,10616790,10614235,10614402,10611572,10611573,10611574,10611575,10611576,10611577,10611578,10611579,10611580,10611581,10611582,10611583,10611584,10611585,10611586,10611587,10611588,10611589,10611590,10611591,10611592,10611593,10611594,10611595,10611596,10611597,10611598,10611599,10611600,10611601,10611602,10611603,10611604,10611605,10611606,10611607,10611608,10611609,10611610,10611611,10611612,10611613,10611614,10611678,10562887,10562888,10562889,10562890,10562962,10562963,10562964,10609285,10557615,10609935,10609936,10610014,10610094,10558600,10613589,10613610,10610658,10610674,10610695,10610739,10610740,10613772,10515819,10555869,10555870,10555871,10556089,10556090,10556093,10512560,10417143,10469493,10470023,8563377,8563380,10470133,10466206,10466207,10466208,10466209,10466210,10466211,10466212,10466213,10466214,10466215,10466216,10466217,10466218,10466219,10466220,10466221,10466222,10466223,10466224,10466225,10466226,10466227,10466228,10466229,10466230,10466231,10466232,10466233,10466234,10466235,10466236,10466237,10466238,10466239,10466240,10466241,10466242,10466243,10466278,10466279,10466280,10466281,10470292,10470330,10466402,10466403,10466404,10466405,10466406,10466407,10466408,10466409,10466410,10470410,10466411,10466412,10470412,10466413,10466414,10466415,10466416,10466417,10466418,10466419,10466420,10466421,10466422,10466423,10466424,10466425,10466426,10466427,10466428,10466429,10466430,10466431,10466432,10466433,10466434,10466435,10466436,10466437,10466438,10466439,10466440,10466441,10466442,10466443,10466444,10466445,10466446,10466447,10466448,10466449,10466450,10466451,10466452,10466453,10466454,10466455,10466456,10466457,10466458,10470533,10470672) 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'