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(8068811,7067828,7067829,7067830,10939574,8068867,8068868,7067904,8068896,10939736,4970450,7068151,10939872,7068160,10943685,7068229,7068231,7068232,7068233,7068234,7068235,7068236,7068238,4970704,10940156,4970928,4971049,4971052,4971141,8066961,4968318,4968329,4968339,8067088,8067223,8067311,8067313,10437196,10437202,10437286,10437364,10437365,10437366,10437383,10437384,8067525,10437490,8067638,10437590,8067776,8067815,4969179,10939100,10939363,10939364,10939365,10939366,10939372,10939373,10939374,10939378,10939379,10939442,10931856,10931861,8075288,8075289,10931962,10932079,10932154,10932246,10932256,8065975,8065979,8066016,10932489,10932490,8066129,10932556,10932557,10932558,10932559,10932560,10932561,10932562,10932563,10932564,10932610,10932619,10932659,10932681,10932690,10932790,10932791,10932796,8066496,8066497,10932881,10932902,10932978,10933030,4967941,10933061,10942555,10942556,10942557,10942558,10942559,10942560,10943138,10943149,10943218,10943220,10943248,10943251,3655637,3655645,10940816,10940969,10941033,10941037,8072316,8072383,8072411,8072412,3656253,8072420,8072422,3656268,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,3656656,10941688,8072950,8072951,8072952,8072953,8072954,8072955,8072956,8072957,8072958,8072959,8072960,8072961,8072962,8072963,8072964,8072965,10941849,3656840,3656886,3656898,3656916,3656917,10942136,10942138,10942146,10942151,10942224,10942225,10942226,10942231,10942236,10942243,10942246,10942273,8073543,10942412,10918588,10918589,10918628,10623170,10918690,10918691,10918692,10918693,10623305,10623306,10623307,10623308,10623309,10623386,10623470,10919147,10919148,10919149,10919150,10919151,10919152,10919153,10623656,10623657,10919440,10919441,10919442,10919443,10919791,10919792,10919793,10919794,10919902,10624729,10624730,10920456,10920457,10920458,10920459,10920460,10920461,10920462,10920463,10920464,10920465,10920466,10920467,10920468,10920469,10920470,10920471,10621982,10922492,10922493,10622013,10922537,10622036,10922574,10622099,10622100,10922614,10917662,10917663,10917664,10917665,10917666,10917667,10917668,10917669,10917670,10917671,10917672,10917673,10917674,10917675,10917676,10917677,10622188,10917905,10917906,10917907,10917908,10917909,10622523,10622524,10622525,10622526,10622527,10622528,10622529,10622530,10622531,10918260,10918261,10918262,10622827,10622829,10920472,10619962,10920473,10920474,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,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,10916829,10916830,10916831,10916832,10916833,10916834,10916835,10916836,10916837,10916838,10916839,10916840,10916841,10916842,10916843,10916844,10916845,10916846,10916847,10916848,10916849,10916850,10916851,10916852,10916853,10916854,10916855,10916856,10916857,10916858,10916859,10916860,10916861,10916862,10921862,10916863,10921863,10916864,10916865,10916866,10916867,10916868,10916869,10916870,10916871,10916872,10916873,10916874,10916875,10916876,10921955,10922207,10922251,10922252,10922253,10922254,10922255,10917371,10917372,10922375,10922440,10922455,10610984,10610985,10565146,10565196,10614219,10614249,10611279,10614281,10614323,10614327,10614328,10614329,10614485,10614518,10614538,10614547,10614629,10614790,10611813,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,10609147,10609148,10609149,10609150,10609151,10609152,10609153,10609154,10609155,10609156,10609157,10609158,10609159,10609160,10609161,10609162,10609163,10609164,10609165,10609166,10609167,10609168,10609169,10609170,10609171,10609172,10609173,10609174,10609175,10609176,10609177,10609178,10609179,10609180,10609181,10609182,10609183,10609184,10609185,10609186,10609187,10609188,10609189,10609190,10609191,10612192,10563342,10609192,10563343,10609193,10563344,10609194,10563345,10609195,10563346,10609196,10563347,10609197,10563348,10609198,10563349,10609199,10563350,10609200,10563351,10609201,10563352,10609202,10563353,10609203,10563354,10609204,10563355,10612270,10612282,10609283,10609311,10609312,10609314,10609315,10609316,10609317,10609318,10609319,10609320,10609321,10609322,10609323,10609324,10609325,10609326,10612500,10612519,10612553,10612563,10609724,10612755,10612765,10612845,10612880,10612924,10609956,10612987,10612988,10612989,10610001,10610002,10610003,10610004,10610005,10613007,10613008,10613034,10613046,10613049,10610097,10613154,10613232,10613233,10610270,10613349,10610352,10610353,10610429,10610469,10564634,10564635,10610492,10610497,10564655,10564661,10564662,10564673,10564774,10564775,10564826,10564827,10613754,10610916,10511143,10511144,10511145,10511146,10511147,10511148,10555232,10511257,10511258,10511259,10511260,10511279,10511280,10517324,10511342,10511446,10511447,10511448,10511449,10511450,10511451,10511452,10511453,10511540,10511541,10511542,10511543,10511544,10511545,10511549,10517561,10517573,10517574,10517594,10517595,10511669,10555763,10555764,10511765,10555765,10555766,10555767,10555768,10511772,10555928,10555929,10512040,10512080,10512081,10512082,10512083,10512084,10512173,10512174,10512175,10556405,10556406,10556407,10556408,10556409,10556410,10556411,10556493,10556494,10556495,10556496,10556497,10512689,10512690,10512691,10512692,10512693,10512694,10512695,10512968,10513051,10513052,10513053,10513097,10513102,10415273,10415274,10416279,10416283,10415319,10415320,10415325,10415401,10419419,10419420,10416552,10416553,10416557,10416559,10416561,10416563,10416564,10419573,10419574,10419575,10419576,10419578,10419580,10419582,10419585,10419586,10419587,10419588,10419590,10419591,10415654,10415655,10416731,10416732,10415737,10415794,10415795,10415796,10415797,10415836,10419844,10419845,10419846,10419847,10419848,10419849,10419850,10415878,10416923,10416940,10416942,10415968,10415981,10416991,10420017,10420018,10417023,10417024,10417033,10417034,10417052,10416070,10416071,10416079,10416114,10416115,10416117,10420118,10416118,10416119,10420146,10417158,10417159,10417179,10417180,10417210,10463025,10463026,10463035,10463042,10465109,10471250,10463657,10463658,10463660,10465688,10465695,10463776,10463777,10463778,10463779,10463788,10463798,10463799,10465802,10463805,10463806,10465808,10465809,10465810,10465811,10465825,10465826,10465827,10463830,10465850,10465851,10465859,10465860,10463927,10463930,10469937,10470076,10470094,8563547,8563553,8563564,10462316,10462317,10462430,10462431,10470439,10462439,10470440,10462460,10462461,10462482,10462483,10462498,10462499,10462500,10462515,10462523,10462524,10462539,10462546,10470567,10470568,10462586,10470617,10462625,10470675,10462723,10462725) 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'