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(7067893,7067894,7067896,7067900,10939617,7067902,7075913,7067938,10939677,10939694,10939700,10939736,10939772,10939796,10939822,7076123,10939907,10939908,7068213,7076239,7076287,7076292,7076294,7076296,10943842,4970675,4970685,4970731,4970732,4970734,4970738,7068403,10940293,8569647,4971081,10976455,7065830,7065832,7065835,7065837,7065838,7065839,10963637,4968339,10963826,10963832,10963837,10963842,10963847,10963865,10963879,7066265,4968622,4968624,4968625,7066348,10437560,8067757,10964441,10964442,10964443,10964444,10964445,10964446,10964448,10964449,10964450,10938792,7067102,7067134,10961933,7067425,7067445,7075498,10939465,10939467,7075779,7075783,7071829,6000112,6000113,10959561,10959565,10959568,7071911,7071983,7072074,7064168,7072259,10960066,10960067,7072467,8075333,8075334,8075335,8075336,10931961,10931962,10960308,7064733,7064735,8065807,7064760,7064761,7064856,7064863,7064892,7064911,7064926,7064947,7064977,7064983,7064985,7064986,7065004,7073317,7065352,7073403,10932966,10932967,10932968,7065750,10974473,10942598,10958628,10942666,10942671,10942692,10942693,10942734,10942735,10942737,10942793,10942913,10942992,10958979,10958980,10958987,10943018,10958988,10958989,10943026,10943045,10943048,10940578,10940580,3655603,3655604,10944518,10940783,10941161,10941163,10941226,10941477,10941589,7069926,10957648,10941688,10941691,10941700,10941701,10941703,10941717,10941718,10941726,10941754,10941756,10941758,10941759,10941760,10941764,10941768,10941778,10941779,10941781,10941839,10941849,10941929,3656933,3656988,10942106,10942123,10942205,10942210,10942213,10942218,10942219,10942228,10942229,8860419,8860420,7070567,10942325,10942343,10942346,10942367,10958353,10942390,10942395,10942401,10958381,10942435,10942448,10942455,7070757,7070761,10942477,10942489,8860684,10623092,10623093,10954694,10928700,10928701,10618196,10928735,10928736,10967835,10618320,10967936,10967937,8070196,8070198,10623508,10623736,10968421,10968455,10968456,10968458,10968459,10968460,10968461,10968463,10968464,10968572,10968573,10968574,8070947,8070948,8070949,8070950,8070951,8070952,8070953,8070954,8070955,8070956,8070957,8070958,8070959,10624414,10619833,10619834,10619901,10619902,10953508,10953512,10621982,10927576,10927577,10927578,10617123,10622154,10622269,10617323,10617324,10617333,10617336,10617339,10617340,10617341,10617342,10617344,10617346,10617354,10617362,10617366,10617378,10617379,10617380,10617383,10617385,10922896,10617386,10617387,10617388,10617389,10617390,10617391,10617392,10617393,10617394,10617395,10617396,10617397,10617398,10617399,10617409,10617420,10617424,10617425,10617426,10622428,10622430,10617434,10617435,10617436,10617439,10617440,10622441,10617444,10617445,10617452,10617453,10617456,10617458,10928008,10928009,10622508,10622523,10622533,10928301,10928303,10617793,10928326,10622828,10928353,10964582,10615075,10620086,8569935,10615179,10620183,8570016,10620208,10615229,10615248,8570093,8570099,8570114,8570120,8570134,10620310,10620311,10620312,10620313,10615471,10925981,10620711,10620712,10965296,10965299,10620796,10930665,10930666,10930667,10930733,10930734,10615933,10615950,10930777,10616006,10621038,10930851,10621041,10616044,10616058,10616059,10616076,10616077,10616426,10922251,10922254,10922255,10927261,10927262,10616911,10610963,10610964,10610967,10610984,10610985,10565155,10565158,10614020,10614021,10614022,10614023,10614024,10614025,10614026,10614027,10614028,10614029,10614030,10614031,10614032,10614033,10614034,10614035,10614036,10614037,8863914,8864010,8864011,7059680,10614186,10611197,7059722,7059723,10559384,10559385,10559386,10559392,7059786,7059790,10611365,10611416,6665751,10611428,10559609,10614475,10611483,10611496,10614496,10614499,10614501,10614503,10614504,10614505,10614518,10614519,10614552,10614553,10614554,10614565,10562767,10611649,8864631,10611833,10611834,6666207,10611969,10611970,8861845,10612013,10612106,10612107,8862008,10612201,10612268,10609287,10612292,10612293,10612295,10609355,10609369,10609379,10612381,8862394,8862480,8862481,8862762,10612916,10612937,10612938,10612942,10610005,10613017,10610056,10613057,10613058,10610060,10613066,10613096,10610097,10613135,10558317,10558318,10558319,10613191,10613192,10613342,10610347,10613369,10561523,10613406,10610429,10610449,10610473,10610474,10610479,10610480,10610481,10613501,10564666,10564669,10610641,10610642,10610643,10610644,10610645,10610646,10610647,10610648,10610649,10610650,10610651,10610652,10610653,10610654,10610655,10610656,10610657,10610658,10610659,10610660,10610661,10610662,10610663,10613721,10613736,10610739,10610775,10610881,10565037,10565038,10565039,10565040,8863771,10515282,10515341,10515342,10515422,4974522,10513552,10513564,10513565,10513622,10517809,10513915,10513974,10513975,10516160,10516161,10516163,4975237,10518648,10518650,10518651,10518652,10518654,10518655,10518656,10518657,10518658,10518659,10518660,10518661,10518662,10518663,10518664,10518667,10518669,10518670,10518672,10518674,10518675,10518676,10518677,10518678,10518679,10518680,10518681,10518683,10518685,10518686,10518687,10518690,10518691,10518692,10518694,10518695,10518696,10518697,10518698,10518699,10518700,10518702,10518703,10518704,10518705,10518706,10518707,10518708,10513077,10513078,4973162,10415251,10419306,10419349,10419350,10416358,4973308,10416405,10416431,10416432,10417445,4973425,10419500,10419503,10419509,10419510,10419514,10419520,10419522,10419523,10419530,10419532,10419533,10419534,10419535,10415575,10415576,10419673,10419674,10419676,10415679,10419679,10419680,10419683,10419684,10419685,10419686,10418691,10418692,10419693,10418701,10418702,10418703,10418704,10418707,10419712,10415729,10419734,10415737,10419737,10419743,10419744,10419745,10419746,10419747,10415794,10415795,10415796,10415797,4973746,10418820,10419828,10419829,10419830,10419831,10418841,10419841,10418842,10419842,10419843,10419844,10418845,10419845,10418846,10419846,10419847,10419848,10419849,10419850,10419996,10419998,10420001,10420002,10420003,10420005,10420007,10420010,10420012,10420013,10420017,10420018,10420043,10417057,10417074,10417078,10420087,10419110,10417111,10417112,10419113,10417156,10417157,10417158,10417159,10419169,10419170,10419171,10419177,10419188,10419189,10466955,10463005,10463011,10463025,10463026,10463035,10463042,10463043,10463046,10467099,10467109,10467116,10467117,10467118,10467126,10467128,10467133,10467144,10467150,10467151,10467153,10467154,10467157,10467160,10471172,10471174,10467218,4971644,10469379,10469380,10469381,10467408,10467428,10467434,10463434,10467444,10469618,10463657,10463658,10463660,10465688,10465695,10463736,10463744,10463753,10463764,10463767,10463770,10463773,10463776,10463777,10463778,10463779,10463784,10465785,10463788,10463790,10465791,10463792,10463793,10465797,10463798,10463799,10465802,10465803,10465804,10465805,10463805,10463806,10465808,10465809,10465810,10465811,10465812,10465813,10465825,10465826,10465827,10463830,10463833,10465850,10465851,10465853,10465858,10465859,10465860,10467865,10467866,10465869,10463876,10467876,10465881,10463898,10463899,10465900,10465902,10463907,10465907,10465915,10463927,8563250,10463930,8563252,8563299,4972257,8563359,8563360,10470089,10470090,10466208,10466212,10466213,10466215,10466222,10466230,10466231,10468234,10468235,4972568,10466312,10462316,10462317,10466326,10466332,10466333,10466343,10466344,10466346,10466348,10466351,10466352,10466353,10466361,10466362,10466373,10466378,10466390,10466397,10466398,10466405,10462408,10462412,10462413,10462414,10466430,10462430,10466431,10462431,10466434,10466435,10466437,10466438,10462439,10466441,10466443,10466447,10462452,10466458,10462460,10462461,10462482,10462483,10462498,10462499,10462500,10466501,10466502,10466503,10466504,4972789,10462515,10462517,10462523,10462524,10462525,10462526,10462530,10462531,10462537,10462539,10462546,10462586,10462616,10462620,10462625,10462628,10462629,10462723,10462725,10462728,10466847,10466852,10627986,10628379,10628524,10626963,10627141,10627319,10627582,10627586,10627588,10627665,10627707,10627708,10627726,10627727,10627793,10626130,10626143,10626144,10626230,10626238,10626244,10626258,10626291,10626292,10626293,10626448,10626749,10568113,10568114,10568118,10568121,10568122,10568124,10568125,10568129,10568130,10568294,10568295,10568296,10568297,10568298,10568299,10568300,10568301,10568302,10568303,10568304,10568305,10568306,10568307,10568308,10568309,10568310,10567579,10567580,10567581,10567582,10567583,10567584,10567585,10567586,10567587,10567588,10567589,10567622,10567623,10567624,10567625,10568110,10568111,10519308,10520755,10520756,10520782,10520793,10420316,10420318,10420321,10420325,10420427,10420428,10420429,10420430,10420436,10420443,10420444,10420445,10420710,10420765,10420766,10420767,10420848,10420873,10420922,10420923,10420981,10472756,10472757,10472758,10472759,10472760) 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'