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(7075856,7075866,7067871,7067872,7067873,7075881,7067889,7075890,7075894,7075917,7076001,7076002,7068159,7068161,7068162,7068163,7076175,7076246,7068275,7068299,7068301,7068302,7068313,7068314,7068316,7068319,7068320,7068325,7068337,7068341,7068342,7068367,7068605,7068606,10944272,4971140,4971148,7065863,7065864,7065865,7065866,7065867,7065868,7065869,7066173,7066241,10437197,10437198,10437199,4968615,10437237,4968648,4968649,7066346,10437295,7066368,10437331,7066386,10437352,10437403,10437423,10437424,4968848,10437597,10437598,7066782,7066783,7066815,7066986,7066987,7067231,7067232,7067236,7067474,7067475,7067482,7067483,7067484,7067641,8068730,8068731,8068732,8068733,8068734,8068735,8068736,8068737,8068738,8068739,8068740,8068741,8068742,8068743,8068744,8068745,8068746,8068747,8068748,8068749,8068750,8068751,8068752,8068753,8068754,8068755,8068756,8068757,8068758,8068759,8068760,8068761,8068762,8068763,8068764,8068765,8068766,8068767,8068768,8068769,8068770,8068771,8068772,7064025,10931608,8075034,8075035,8075036,8075037,8075038,8075039,8075040,8075041,8075042,8075043,8075044,8075045,8075046,8075047,8075048,8075049,8075050,8075051,8075052,8075053,8075054,8075055,8075056,8075057,8075058,8075059,8075060,8075061,8075062,8075063,8075064,8075065,8075066,8075067,8075068,8075069,8075070,8075071,8075072,8075073,8075074,8075075,8075076,8075077,8075078,8075079,8075080,8075081,8075082,8075083,8075084,8075085,8075086,8075087,8075088,8075089,8075090,8075091,8075092,8075093,8075094,8075095,8075096,8075097,8075098,8075099,8075100,8075101,8075102,8075103,8075104,8075105,8075106,8075107,8075108,8075109,8075110,8075111,8075112,8075113,8075114,8075115,8075116,8075117,8075118,8075119,8075120,8075121,8075122,8075123,8075124,8075125,8075126,8075127,8075128,8075129,8075130,8075131,8075132,8075133,8075134,8075135,8075136,8075137,8075138,8075139,8075140,8075141,8075142,8075143,8075144,8075145,8075146,8075147,8075148,8075149,8075150,8075151,8075152,8075153,7064300,8075154,8075155,8075156,8075157,8075158,8075159,8075160,8075161,8075162,8075163,8075164,8075165,8075166,8075167,8075168,8075169,8075170,8075171,8075172,8075173,8075174,8075175,8075176,8075177,8075178,8075179,8075180,8075181,8075182,8075183,8075184,8075185,8075186,8075187,8075188,8075189,8075190,7064336,7064337,8075191,8075192,7064338,8075193,8075194,8075195,8075196,8075197,8075198,8075199,8075200,8075201,8075202,8075203,10931788,8075204,8075205,8075206,8075207,8075208,8075209,8075210,8075211,8075212,8075213,8075223,8075224,10931855,10931900,7064526,10931992,10932164,10932288,10932319,10932320,10932321,10932372,10932593,10932594,10932609,10932658,10932662,10932666,10932667,10932668,10932669,10932670,7065438,10932880,10932886,10932900,10932901,10933015,10933029,10933144,10933145,10933146,10933147,10933148,10933152,10933153,10933181,10933182,10942784,8861151,8861152,8861153,8861316,10943137,10943146,10943155,10943158,8861402,10943258,10943284,8861480,10943321,10944341,10944342,10944343,10940572,10940573,10940574,10940575,10940576,10940577,10940696,10940697,10940698,10940699,10940700,10940701,10940702,10940703,10940704,10940705,10940706,10940707,10944530,10940815,10944644,10944696,10944762,10944905,10944906,10944937,10944938,10944939,10944940,8072315,8072385,8072428,10941345,10941346,8072511,8072778,8072779,8072780,8072781,8072782,8072935,8072936,8072937,8072938,8072939,8072940,8072941,8072942,8072943,8072944,8072945,8072946,8072947,8072948,8072949,10941825,10941832,10941841,8072996,10941871,8073036,8073037,10941939,8073088,10941950,10941952,10942120,10942121,10942135,10942160,10942161,8860356,8860357,8860358,8860359,10942223,10942235,8860480,10942313,10942411,10942432,10942452,10942453,10942472,10623185,10623186,10623187,10623188,10623189,10623190,10623191,10623192,10623193,10623194,10623195,10623196,10623197,10623377,10623465,10623494,10623788,8070981,8070982,8070994,8071164,8071165,8071166,8071167,8071322,8071334,8071340,8071350,8071362,10927479,10927487,10922491,10927495,10927496,10927497,10927498,10927573,10922597,10922599,10922615,10922619,10622409,10927930,10927931,10927956,10622518,10622519,10622520,10622521,10622542,10928155,10928156,10928157,10928306,10928307,10928308,10928309,10928310,10928311,10928312,10928313,10928314,10925527,10620085,10920739,10920843,10620342,10920903,10620419,10620420,10620421,10620422,10620423,10620424,10620425,10920945,10920946,10920947,10920948,10920949,10920950,10920951,10921172,10921173,10921174,10926184,10926185,10926205,10926239,10926244,10926251,10926252,10921316,10921331,10921332,10921333,10921334,10921335,10921336,10921337,10921338,10921339,10921340,10921341,10921342,10921343,10921344,10921345,10921346,10921347,10921348,10921349,10921350,10921351,10921352,10926353,10921353,10921354,10921355,10921356,10921357,10921358,10921359,10921360,10921361,10921362,10921363,10921364,10921365,10921366,10921367,10921368,10921369,10921370,10921371,10921372,10921373,10921374,10921375,10921376,10921377,10921378,10620862,10921379,10620863,10921380,10620864,10921381,10921452,10921453,10921454,10921545,10921546,10926787,10921851,10921852,10926885,10921925,10921926,10921927,10922099,10922210,10922211,10922212,10922213,10922214,10922215,10922216,10621745,10621746,10621747,10621748,10621749,10621750,10922376,10922429,10922470,10565152,10559233,10559291,10614453,10614454,10614558,10559709,10614573,10614578,10559790,10559791,10559792,10559793,10559794,10559795,10559796,10559797,10559798,10559799,10559800,10559801,10559802,10559803,10559804,10559805,10559806,10559807,10559808,10559809,10559810,10559811,10559812,10559813,10559814,10559815,10559816,10559817,10559818,10559819,10559820,10559821,10559822,10559823,10559824,10559825,10559826,10559827,10559828,10559829,10559830,10559831,10559832,10559833,10559834,10559835,10559836,10559837,10559838,10559839,10559840,10559841,10559842,10559843,10559844,10559845,10559846,10559847,10559848,10559849,10559850,10559851,10559852,10559853,10559854,10559855,10559856,10559857,10559858,10559859,10559860,10559861,10559862,10559863,10559864,10559865,10559866,10559867,10559868,10559869,10559870,10559871,10559872,10559873,10559874,10614862,10612005,10612006,10612162,10612166,10612167,10612168,10612169,10612258,10563556,10563557,10563558,10557600,10557601,10557602,10557603,10557604,10557605,10557606,10557607,10557608,10557609,10557633,10557634,10557635,10557636,10557637,10557638,10612488,10612489,10612491,10612492,10612498,10612535,10612573,10612679,10612684,10612694,10612907,10612912,10612913,10612914,10613045,10613047,10613048,10613050,10613051,10613052,10558281,10558282,10558283,10558284,10558285,10558286,10558287,10558322,10564632,10564633,10564672,10558684,10558685,10558686,10558687,10558688,10558689,10558690,10558691,10564831,10613785,10613786,10613804,10613805,10613806,10513143,10513160,10513161,10513170,10513185,10511199,10511204,10513256,10513257,10511374,10511409,10511410,10511411,10511412,10511413,10511414,10511415,10511427,10511428,10511429,10511430,10511431,10511432,10511433,10511434,10511435,10511436,10511448,10511449,10511450,10511451,10511452,10511453,10517636,10517637,10517638,10517639,10517640,10517641,10517642,10517643,10517644,10517645,10517646,10517647,10517648,10517649,10513766,10513767,10513768,10513769,10513770,10513771,10513772,10513895,10513896,10513914,10513934,10513980,10513992,10514020,10514523,10514527,10512667,10512903,10417306,10416354,10416355,10416407,10419418,10419480,10419481,10419482,10419483,10419484,10419684,10419723,10416726,10416727,10419740,10416769,10419811,10416935,10416936,10416937,10416938,10416939,10420012,10417188,10417196,10417204,10417209,10467224,10471245,10467407,10469945,10464078,10464079,10464080,10470093,10466402,10466403,10466404,10466405,10466406,10466407,10466408,10466409,10466410,10466411,10466412,10466413,10466414,10466415,10466416,10466417,10466418,10466419,10466420,10466421,10466422,10466423,10466424,10466425,10466426,10466427,10466428,10466429,10466430,10466431,10466432,10466433,10470433,10466434,10470434,10466435,10466436,10466437,10466438,10466439,10466440,10466441,10466442,10466443,10466444,10466445,10466446,10466447,10466448,10466449,10466450,10466451,10466452,10466453,10466454,10466455,10466456,10466457,10466458,10470560,10470561,10470575,10470576,10470577,10470578,10470579,10470580,10470581,10470582,10470583,10470584,10470585,10470586,10470587,10470588,10470589,10470590,10470591,10470592,10470593,10470594,10470595,10470596,10470597,10470598,10470599,10470600,10470601,10470602,10470603,10470604,10470605,10470606,10470607,10470608,10470609,10470610,10470611,10470612,10470613,10470614,10470615,10470616,10470617,10470618,10470619,10470620,10464807) 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'