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(7067828,8068811,7067829,7067830,7075867,7075882,7075883,8068867,7075884,8068868,7075892,7075903,7067904,8068896,7075918,7075921,7075925,7076023,7076026,7076027,7076028,7076034,7076036,7076038,7076041,7076043,7076045,7076046,7076047,7076048,7076049,7076050,4970450,7068151,7068160,10943685,7068229,7068231,7068232,7068233,7068234,7068235,7068236,7068238,7068241,7076287,7076292,7076296,7076297,7068322,7068324,7068328,7068329,4970704,7068368,8569553,8569554,4970928,8569619,8569657,4971049,4971052,4971141,7065875,7065876,7065877,7065878,7065879,7065880,7065881,7065882,7065883,7065884,7065885,7065886,7065887,7065888,7065889,7065890,7065891,7065892,7065893,7065894,7065895,7065896,7065897,7065898,7065899,7065900,4968318,4968329,4968339,7074057,7074129,7074137,7066179,10437196,10437202,10437286,7074376,7074385,7074397,7074401,7074406,10437364,10437365,10437366,7074427,7074428,7074429,10437383,10437384,7074448,7074449,7074452,7074456,7074483,7074492,7074495,7074512,7074523,7074543,10437490,10437590,7066769,7066792,4969179,7074926,7075026,7075171,7075175,7075182,7075194,7075195,7075222,7075223,7075225,7067235,7075237,7075238,7075251,7067256,7075260,7075314,7075326,7067445,7067485,7067486,7067487,7067488,7067614,7067615,7067616,7067617,7067654,7067659,7075737,7075738,7075739,7067742,7075749,7075758,7067792,7067797,7067798,7067799,7071947,7071948,6000252,6000253,6000254,6000255,6000256,6000257,7072151,7072152,7064341,7064342,10931856,10931861,8075288,8075289,10931962,7064531,7064535,10932079,7064678,7064679,10932154,10932246,10932256,10932489,10932490,10932556,10932557,10932558,10932559,10932560,10932561,10932562,10932563,10932564,7065148,7065149,7065150,7065151,10932610,10932619,10932659,10932681,10932690,7065280,7065281,7065283,7065350,10932790,10932791,10932796,7065376,7065377,7065394,7065395,10932881,10932902,10932978,10933030,4967941,10933061,7065784,10942555,10942556,10942557,10942558,10942559,10942560,8860979,8861031,10943138,10943149,10943218,10943220,10943248,10943251,5999931,5999932,5999933,5999934,5999935,6000015,6000016,6000017,10940816,10944720,10944721,10944722,10944723,10944724,10940969,10941033,10941037,8072316,8072383,8072411,8072412,10945072,8072420,8072422,8072454,8072460,10941347,10941348,10941349,10941350,8072643,8072644,8072645,8072646,8072647,8072648,8072649,8072650,8072651,8072652,8072653,8072654,8072655,8072656,8072657,8072658,8072659,8072660,8072661,8072662,8072663,8072664,8072665,8072666,8072667,8072668,8072669,8072670,8072671,8072672,8072673,8072674,8072675,8072676,8072677,8072678,8072679,8072680,8072681,8072682,8072683,8072684,8072685,8072686,8072687,8072688,8072689,8072690,8072691,8072692,8072693,8072694,8072695,8072696,8072697,8072698,8072699,8072700,8072701,8072702,8072703,8072704,8072705,8072706,8072707,8072708,8072709,8072710,8072711,8072712,8072713,8072714,8072715,8072716,8072717,8072718,8072719,8072720,8072721,8072722,8072723,8072724,8072725,8072726,8072727,8072728,8072729,8072730,8072731,8072732,8072733,8072734,8072735,8072736,8072737,8072738,8072739,8072740,8072741,8072742,8072743,8072744,8072745,8072746,8072747,8072748,8072749,8072750,8072751,8072752,8072753,8072754,8072755,8072756,8072757,8072758,8072759,8072760,8072761,8072762,8072763,8072764,8072765,8072766,8072767,8072768,8072769,8072770,8072771,8072772,8072773,8072774,8072775,8072776,8072777,8072778,8072779,8072780,8072781,8072782,8072783,8072784,8072785,8072786,8072787,8072788,8072789,8072790,8072791,8072792,10941688,8072950,8072951,8072952,8072953,8072954,8072955,8072956,8072957,8072958,8072959,8072960,8072961,8072962,8072963,8072964,8072965,10941849,8860318,8860320,8860321,8860322,10942136,10942138,10942146,10942151,8860351,8860352,8860358,8860403,10942224,10942225,10942226,10942231,10942236,10942243,10942246,10942273,8073543,10942412,8860725,10623170,10623305,10623306,10623307,10623308,10623309,10623386,10623470,10623656,10623657,8070769,8070770,8071168,8071169,8071170,8071323,8071335,8071351,8071363,10624729,10624730,10922492,10922493,10621982,10622013,10927531,10922537,10622036,10922574,10927576,10927577,10927578,10922614,10622099,10622100,10622188,10622523,10622524,10622525,10622526,10622527,10622528,10622529,10622530,10622531,10928066,10928089,10928090,10928091,10622827,10622829,10619962,10619982,10920528,10920529,10620036,10620037,10620038,10620039,10620040,10620041,10620042,10620086,10920611,10920612,10920613,10920614,10920615,10920616,10620123,10620124,10620125,10620126,10620127,10620130,10620131,10620132,10620133,10620134,10620135,10620136,10620175,10920952,10920953,10620565,10921185,10921186,10921187,10921188,10921189,10921190,10926245,10926286,10926287,10926288,10926289,10921323,10921470,10921471,10921472,10921473,10921474,10921475,10921476,10921477,10921478,10921479,10921480,10921481,10921482,10921483,10921484,10921485,10921486,10921487,10921488,10921489,10921490,10921491,10921492,10921493,10921494,10921495,10921496,10921541,10921542,10921543,10921544,10921554,10921555,10921580,10921581,10921582,10921583,10921695,10921696,10921697,10921698,10921699,10921700,10921701,10921702,10921703,10921704,10921705,10921706,10921707,10921708,10921709,10921710,10921711,10921712,10921713,10921714,10921715,10921716,10921717,10921718,10921862,10921863,10921955,10922207,10927240,10927241,10922251,10922252,10922253,10922254,10922255,10922375,10922440,10922455,10565146,10559194,10565196,10559263,10559264,10559276,10559288,10614219,10559384,10559385,10559386,10614249,10614281,10614323,10614327,10614328,10614329,10559616,10559617,10559618,10559624,10559625,10614485,10614518,10614538,10614547,10614629,10614790,10614815,10614816,10614817,10614857,10566061,10566062,10563112,10563113,10563114,10563115,10563116,10563117,10563118,10563119,10563120,10563121,10563122,10563123,10563124,10563125,10563126,10563127,10563128,10563129,10563137,10563151,10612009,10563184,10563185,10563186,10612050,10563342,10612192,10563343,10563344,10563345,10563346,10563347,10563348,10563349,10563350,10563351,10563352,10563353,10563354,10563355,10612270,10612282,10612500,10612519,10612553,10612563,10612755,10612765,10612845,10612880,10612924,10612987,10612988,10612989,10613007,10613008,10613034,10613046,10613049,10613154,10613232,10613233,10613349,10558594,10558595,10564634,10564635,10558653,10564655,10564661,10564662,10564673,10564774,10564775,10564826,10564827,10613754,10513141,10511143,10511144,10511145,10511146,10511147,10511148,10513162,10513163,10513171,10513211,10513212,10513231,10513232,10511257,10513258,10511258,10513259,10511259,10511260,10513269,10513272,10513273,10513274,10511279,10511280,10513282,10513283,10513284,10513291,10517324,10511342,10511446,10511447,10511448,10511449,10511450,10511451,10511452,10511453,10511540,10511541,10511542,10511543,10511544,10511545,10511549,10513552,10517561,10517573,10517574,10517594,10517595,10511669,10511765,10511772,10513773,10513774,10513775,10513776,10513777,10513778,10513897,10513898,10513899,10513913,10513915,10513935,10513936,10513937,10513949,10513950,10514024,10514025,10514026,10514028,10512040,10512080,10512081,10512082,10512083,10512084,10512173,10512174,10512175,10514207,10514208,10514319,10514544,10512689,10512690,10512691,10512692,10512693,10512694,10512695,10512968,10513051,10513052,10513053,10513097,10513102,10416279,10416283,10417307,10417352,10417354,10419419,10419420,10417498,10416552,10416553,10416557,10416559,10416561,10416563,10416564,10419573,10419574,10419575,10419576,10419578,10419580,10419582,10419585,10419586,10419587,10419588,10419590,10419591,10416731,10416732,10419844,10419845,10419846,10419847,10419848,10419849,10419850,10416923,10416940,10416942,10416991,10420017,10420018,10417023,10417024,10417033,10417034,10417052,10420118,10418143,10420146,10417158,10417159,10417179,10417180,10417210,10467084,10467085,10467086,10465109,10467126,10467128,10467133,10467144,10467146,10467147,10467148,10467149,10467150,10467151,10467152,10467153,10467154,10467155,10467156,10467157,10467158,10467159,10467160,10471250,10467387,10467388,10467389,10467390,10467391,10467392,10467393,10467394,10467395,10467408,10467434,10467444,10467467,10467468,10467469,10467470,10467471,10467472,10467473,10467474,10467475,10467476,10467627,10467631,10465688,10465695,10465802,10465808,10465809,10465810,10465811,10465825,10465826,10465827,10465850,10465851,10465859,10465860,10465902,10465915,10463927,10463930,10469937,10470076,10470094,10466212,10466213,10466215,10466230,10466231,10466351,10466352,10466361,10466362,10466373,10466378,10466390,10466397,10466398,10466405,10466430,10466431,10466437,10466438,10470439,10470440,10466458,10470567,10470568,10470617,10470675) 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'