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(7067840,7067841,7067845,7067931,10943448,10943453,10943467,10943498,10943524,7068037,7068057,7068064,7068071,7068075,10943639,4970687,4970688,10943898,10943902,7068401,4970739,4970747,7068476,10944041,7068533,10944046,10944051,7068549,7068550,7068551,10944076,10944090,10944095,10944104,10944105,10944106,10944111,10944112,10944113,10944129,10944139,10944140,10944141,10944142,10944143,10944148,10944186,10944249,10944322,10944326,4968187,7065875,7065911,7065912,7065913,7065914,7065930,4968342,7066010,7066016,7066017,7066050,7066101,7066137,7066138,7066139,7066192,7066193,7066194,7066195,7066196,7066197,7066198,7066199,7066200,7066201,7066202,7066203,7066204,7066205,7066206,7066207,7066222,7066243,7066261,10437392,7066481,7066483,7066512,7066525,7066527,7066533,7066555,8067922,8067923,4969569,7067304,7067803,10931546,10931547,7064123,7064132,7064135,7064152,7064170,7064173,7064190,7064223,7064353,7064498,7064542,7064543,7064544,7064545,7064546,7064547,7064548,7064549,7064550,7064551,7064552,7064553,7065157,7065165,7065177,7065195,7065197,7065198,7065199,7065226,7065265,7065284,7065342,7065343,7065396,7065398,7065399,7065431,7065439,7065440,7065441,7065477,7065480,7065493,7065494,7065505,7065510,7065515,7065517,7065520,7065522,7065528,7065540,7065544,7065545,7065566,7065596,10933037,10933038,10933041,10933043,10933044,10933048,10933049,10933050,10933056,10933059,10933060,10933061,10933062,10933063,10933064,10933066,10933067,10933073,10933074,4967980,4967981,8860742,8860743,8860813,8860816,8860836,8860913,10942777,10944335,10944450,10940654,10940661,10940662,10940664,10940671,10940673,10940674,10940683,10944482,10944492,10944526,10944532,10944563,10944631,10940959,10940971,10940981,10941005,10941009,10941011,10941014,8859512,8859514,8859516,8859517,8859518,8859519,8859521,8859526,8859527,8859531,8859532,8859534,8859535,8859536,8859537,8859541,8859543,10941363,10941364,10941367,10941374,10941396,10941406,10941407,8859604,8859605,10941433,10941443,10941456,10941457,10941460,10941463,10941465,10941472,10941633,8860198,8860200,8860201,8860210,8860211,8860212,8860213,8860218,8860219,8860236,8860271,8860272,8860273,8860274,8860275,8860283,8860284,8860286,8860287,8860292,8860293,8860294,8860297,8860298,8860299,10942264,8073549,10623052,10623053,10623067,10623070,10623079,10623080,10623081,10623099,10623100,10623112,10623115,10623168,10623169,10623171,10623172,10623173,10623174,10623175,10623176,10623177,10623215,10623216,10623481,10623482,10623483,10623484,10623508,10623530,10623531,10623532,10623533,10623534,10623535,10623536,10623537,10623538,10623539,10623540,10623541,10623542,10623543,10623547,10623548,10623549,10623552,10623605,10623606,10624899,10624900,10624903,10624908,10624909,10624916,10621964,10621965,10621967,10621968,10621969,10621970,10621973,10621974,10622188,10622196,10620112,10620113,10620114,10620115,10620116,10620117,10620118,10620147,10620165,10620168,10620169,10620229,10620230,10620231,10620233,10620299,10620305,10620316,10620426,10620428,10620437,10620460,10620461,10620463,10620464,10620466,10620496,10620497,10620498,10620499,10620500,10620501,10620502,10620584,10620586,10620587,10620588,10620589,10620590,10620636,10620652,10620654,10620699,10620700,10620701,10620702,10620703,10620704,10620705,10620706,10620707,10620709,10620710,10620719,10620720,10620798,10620799,10620800,10620852,10620853,10620854,10620857,10620867,10620868,10620872,10620873,10620898,10620899,10620900,10620901,10620902,10620903,10620904,10620909,10620910,10620911,10620912,10620913,10620914,10620926,10620927,10620928,10620929,10620930,10620931,10620932,10620939,10620940,10620942,10620943,10620944,10620945,10620946,10620947,10620948,10620950,10620951,10620952,10620953,10620954,10620955,10620956,10620957,10620958,10620959,10620960,10620961,10620962,10620965,10620966,10620967,10620968,10620969,10620970,10620971,10620972,10620973,10620974,10620975,10620976,10620977,10620978,10620979,10620980,10621056,10621057,10621058,10621061,10621062,10621079,10621080,10621081,10621083,10621084,10621104,10621105,10621106,10621107,10621359,10921967,10921968,10621816,10621938,10621939,10621940,10621941,10621942,10621943,10621944,10621945,10621946,10621947,10621948,10621949,10621950,10621951,10621952,10621953,10621954,10621955,10621956,10614146,10614187,10614189,10614191,10614192,10614193,10614194,10614195,10614250,10614251,10614252,10614253,10614254,10614282,10614316,10614317,10614323,10614327,10614328,10614329,10614330,10614343,10614344,10614371,10614382,10614414,10614463,10614464,10614472,10614516,10614517,10614518,10614519,10614520,10614521,10614522,10614523,10614524,10614525,10614526,10614527,10614528,10614529,10614530,10614531,10614532,10614533,10614534,10614535,10614536,10614537,10614538,10614539,10614540,10614541,10614542,10614543,10614544,10614545,10614546,10614547,10614548,10614549,10614550,10614551,10614552,10614553,10614554,10614555,10614556,10614557,10614558,10614559,10614560,10614561,10614562,10614563,10614564,10614565,10614566,10614567,10614568,10614569,10614570,10614571,10614572,10614573,10614574,10614575,10614576,10614577,10614578,10614579,10614580,10614581,10614582,10614583,10614584,10614585,10614586,10614587,10614588,10614589,10614590,10614591,10614592,10614745,10614782,10614822,10614858,10614859,10614862,10614949,10612054,10612070,10612071,10612072,10612073,10612074,10612075,10612076,10612077,10612078,10612172,10612173,10612214,10612235,10612236,10612284,10612285,10612286,10612319,10612342,10612387,10612388,10612389,10612390,10612391,10612392,10612393,10612394,10612395,10612396,10612397,10612398,10612399,10612400,10612401,10612402,10612403,10612404,10612405,10612407,10612408,10612409,10612410,10612411,10612412,10612414,10612426,10612427,10612428,10612429,10612430,10612483,10612484,10612485,10612486,10612487,10612488,10612489,10612490,10612491,10612492,10612493,10612496,10612497,10612498,10612499,10612500,10612502,10612503,10612506,10612507,10612508,10612509,10612510,10612513,10612516,10612517,10612518,10612519,10612520,10612521,10612522,10612523,10612524,10612525,10612526,10612527,10612529,10612531,10612534,10612535,10612536,10612538,10612539,10612542,10612546,10612547,10612551,10612552,10612553,10612554,10612555,10612556,10612557,10612558,10612559,10612562,10612563,10612565,10612566,10612567,10612570,10612571,10612573,10612579,10612580,10612583,10612584,10612585,10612586,10612587,10612588,10612589,10612592,10612594,10612596,10612597,10612599,10612601,10612604,10612608,10612609,10612611,10612618,10612620,10612622,10612623,10612624,10612625,10612626,10612633,10612635,10612637,10612638,10612639,10612641,10612642,10612643,10612644,10612645,10612646,10612647,10612648,10612650,10612651,10612653,10612655,10612657,10612658,10612659,10612660,10612661,10612663,10612664,10612666,10612667,10612668,10612673,10612678,10612679,10612680,10612682,10612683,10612684,10612685,10612687,10612688,10612689,10612690,10612697,10612698,10612699,10612700,10612701,10612702,10612703,10612704,10612705,10612706,10612707,10612711,10612716,10612717,10612718,10612720,10612721,10612722,10612723,10612753,10612758,10612776,10612777,10612778,10612779,10612780,10612791,10612792,10612824,10612833,10612834,10612836,10612837,10612838,10612839,10612840,10612841,10612842,10612843,10612844,10612846,10612847,10612853,10612860,10612862,10612863,10612865,10612866,10612867,10612868,10612869,10612870,10612871,10612872,10612873,10612874,10612875,10612876,10612878,10612879,10612881,10612882,10612936,10612937,10612938,10612939,10612941,10612942,10612944,10612945,10612982,10613055,10613084,10613085,10613087,10613088,10613089,10613091,10613093,10613262,10613264,10613289,10613305,10613355,10613383,10613455,10613520,10613521,10613532,10613533,10613534,10613642,10613676,10613730,10613731,10613744,10613856,10613857,10419254,10419262,10419269,10419273,10419274,10419275,10419276,10419286,10419342,10416367,10416368,10419377,10416378,10416379,10416380,10419391,10419393,10419396,10416414,10416430,10416433,10416434,10419445,10416495,10416612,10416640,10416653,10416655,10416658,10416661,10416673,10416797,10416925,10416926,10416927,10416928,10416929,10416930,10420025,10420026,10420029,10471085,10471086,10469893,10470150,10470151,10470152,10470153,10470154,10470155,10470156,10470157,10470158,10470159,10470160,10470161,10470162,10470163,10470164,10470165,10470166,10470167,10470168,10470169,10470170,10470171,10470172,10470173,10470174,10470175,10470176,10470177,10470178,10470179,10470180,10470181,10470182,10470183,10470184,10470185,10470186,10470187,10470188,10464189,10470189,10464190,10470190,10464191,10470191,10464192,10470192,10464193,10470193,10464194,10470194,10464195,10470195,10464196,10470196,10464197,10470197,10464198,10470198,10464199,10470199,10464200,10470200,10464201,10470201,10464202,10470202,10464203,10470203,10464204,10470204,10470205) 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'