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(8621120,8621121,8621122,8574502,3228908,3228986,3228996,3228997,3229001,3229049,8569710,8569711,8569712,8569713,8569714,8569715,8569716,10940432,10940434,8621696,8621697,8621698,8621699,8621700,8621701,7066087,10976973,10976974,10976975,10976976,10976977,10976978,10976979,10951085,10990267,11042276,8632327,8632328,7074860,8632548,8632549,8632550,8632551,8632552,8632553,8632554,8632555,8632556,8632557,8632558,11039777,11039778,11039779,11039780,11039781,11039782,11039783,11039784,11039785,11039786,11039787,11039788,11039789,11039790,11039791,11039818,11039819,11039820,11039821,11039822,11039823,11039824,11039825,11039826,11039827,11039828,11039829,11039830,8629991,7075390,7075391,8630262,10962452,10939397,7201225,7201233,8627809,8627815,7201424,8065184,8065185,7201609,7201610,7201611,7201612,7201613,7201614,7201615,7201616,7201617,7201618,8628169,8628170,7201781,10843410,10843412,8628386,8628387,8628389,8628390,8628397,10960465,8628435,10103958,8628493,8065844,7202133,7202196,7202197,7202216,7202217,10960682,7202296,7202297,7202298,10960824,10960825,10960837,7202525,7202526,7202695,7202696,7202697,7202701,7065457,7202702,8629109,8629111,8629114,7202755,8629165,8629166,11010826,11010827,11010828,8626845,10102355,10102358,7200485,10959087,10959088,10959092,7200672,7200673,7200674,7200675,7200676,7200677,7200678,7200716,7200721,7200726,10959189,7200784,7200785,8627268,8627281,8627305,8627309,8627473,8627474,8627475,8627476,8627486,8627499,8627500,8627501,8627502,8627503,8627504,8627505,8627514,8627517,10103013,8624669,8624670,8624671,8624672,8624673,8624674,8624675,8624676,8624685,8624686,8624687,8624689,7198308,10100209,7198325,7198327,7198338,8624788,7198392,7198719,7198770,11009411,8625457,8625481,8625482,8625504,8625527,8625528,8625572,8625580,8625581,8625586,8625587,8625598,7199530,7199531,7199532,7199533,7199534,7199535,7199536,7199537,7199538,7199539,7199540,7199541,7199542,10101491,10101493,8626243,8626244,10102026,10837728,7196303,7196304,7196305,7196306,7196307,7196308,8906121,7196309,7196310,7196311,7196312,7196313,8906126,7196314,7196315,7196316,7196317,7196318,7196319,7196320,7196321,7196322,7196323,7196324,7196325,7196326,7196327,7196328,7196329,7196330,7196331,7196332,7196333,7196334,7196335,7196336,7196337,7196338,7196339,7196340,7196341,7196342,7196343,10967891,7196462,7196463,7196464,7196465,7196466,7196467,7196468,7196469,10618304,8906340,7196532,7196533,7196534,7196535,7196536,7196537,7196538,7196539,7196540,7196541,8906482,7196997,7197019,7197020,7197021,8613620,8613643,10838801,10839008,7197621,8907435,8907463,7197663,7197664,7197741,7197742,7197743,10925124,7197913,8907806,8907856,11047512,11047513,10619864,10619865,10619866,8624495,8907909,8624499,8624500,10619885,10619886,10619889,8624510,8907923,8624515,8624563,7198167,7198175,7198176,10966724,10966725,10966726,10966727,10966728,10966729,10966730,10966731,10966732,10966733,10966734,10966735,11044914,8905354,8612210,3232886,8905782,8905921,8905924,11006582,11006585,11006591,11006592,11006593,11006594,11006595,11006596,10614962,10925483,10425353,10615032,10615033,10425471,10615140,10615141,10615142,10425482,10425484,10425485,10425487,10615202,10615230,10425571,10425911,10425933,10615615,10426021,10426151,10615820,10426196,10426293,10426294,10426295,10426296,10426297,10426298,10426299,10426300,10426301,10426302,10616048,10616049,10616060,8540599,8540634,8540635,8540637,10616193,8611276,8611299,8611302,8611303,10616635,10616636,10616637,8611470,8904798,10616879,10616890,10616891,10992594,10562225,10614106,10614107,10614108,10614146,10611162,10614207,10614210,10614289,10614297,10614304,9197862,10559702,10559744,10614624,10614632,6666004,10611764,10611823,9190254,6666255,9214258,9182270,10614950,10611981,10611989,7057518,7017285,7017286,7017313,7017314,10612327,10612346,7017355,7017356,7017357,7017358,10612601,10612602,10612603,10612604,10612654,10612733,10612734,10612735,10612736,10612767,10612797,10120371,10612841,10612842,8566708,8566709,10612884,10612945,10610006,9196381,10610233,8567072,8567073,10613305,10613342,10613380,10610396,10610676,10613744,9197141,7059324,10613902,7055534,6673661,10511278,10515280,10515281,10515282,10515290,10515291,6673684,10515292,10515293,10515294,10515295,10515296,10515297,10515298,10515299,10515300,10515301,10515302,10515303,6673696,10515304,10515335,9169539,7055722,7055724,10511421,10117895,10511537,10511538,9161732,9169775,9169824,10511663,9169944,10118207,10118208,9170063,6674278,6674279,6674325,10514036,10514090,10512180,10512181,10512182,10512183,10512184,10512185,10512186,10512187,10512188,10512189,10512190,10512206,10512207,10512208,10512209,9178414,10514229,10118613,10514230,10512243,10118627,10514275,10514279,10514287,10514288,9178495,9178496,9178497,10514340,10514341,10514342,10514363,10512368,10512369,10512370,10512371,10512372,10512373,10512374,10512375,10512376,10512377,10512378,7016251,7016252,10512517,10512518,10512519,10512520,10512521,10512522,10512523,10512524,10514591,10514592,10514593,10514609,10514610,10514619,10514620,10514621,10514622,10514623,10514624,10514625,10514670,10514791,10514792,10514793,10514803,10514805,10514806,10514807,9170999,10514830,10514831,991409,10514862,10514863,10514864,10514865,10514866,10514873,10514874,10514875,10514876,10514877,10514896,10515068,10515091,10515101,10515102,6672553,6672574,10415313,10415314,10417342,10417368,6672678,9168495,6672711,9168518,9168669,9208877,6673108,10419834,10419835,10419836,10418864,10418865,9169195,9169196,9169197,9169198,9169199,9169200,9169201,9169202,9169203,9169204,9169205,9169217,7055450,6673491,9166506,9166507,8549810,8550042,10463592,9175052,9199076,10123322,4972028,9175207,10469876,9167321,10465899,10463923,9167544,9175575,6671918,10466340,10468341,10466446,10468529,10462537,10116207,10116208,10116209,10116210,10116211,10116213,10116214,10116215,10116216,10116217,10116218,10116219,10116220,10116221,10116222,10116223,10462617,9168147,9168167,10888637,10888638,10888639,10888640,10888641,10888642,10889081,10889515,10884826,10874948,10885078,10885079,10885129,10885151,10885261,10885263,10885285,10885287,10885316,10887623,10882741,10882798,10882814,10882828,10627319,10882831,10887850,10158958,10158960,10158964,10158974,10158975,10887982,10883147,10883166,10883318,10883378,10883392,10883396,10883397,10883398,10885717,10885748,10171778,10186802,10186803,10161931,10885989,10885990,10187082,10187083,10886119,10886120,10886121,10896381,10626145,10886872,10886873,10886874,10886875,10886876,10167914,10167926,10167928,10167936,10167937,10167938,10167943,10167944,10167950,10167954,10167957,10167960,10167962,10167966,10167967,10167968,10167969,10167970,10167971,10167972,10167973,10167978,10167983,10167984,10167985,10167987,10167992,10168002,10168004,10168007,10168012,10168013,10168014,10168015,10168017,10168020,10897009,10897010,10168022,10168025,10168027,10168028,10897024,10897027,10168046,10168047,10897041,10168053,10897042,10168056,10168060,10168063,10887053,10168067,10168068,10897058,10168070,10897059,10897060,10168072,10897063,10168077,10168082,10168084,10897116,10897166,10887357,10626890,10626891,10626892,10626893,10601224,10598866,10581687,10581688,10581689,10581690,10581691,10581692,10581748,10581749,10581750,10581751,10581752,10581753,10581754,10581755,10581756,10581757,10581758,10581759,10521269,10521270,10543295,10543296,10527758,10544024,10522256,10522257,10522260,10548268,10548269,10548270,10528350,10522577,10522578,10522579,10548586,10524866,10522909,10539016,10527020,10421238,10507582,10507583,10507618,10507619,10507620,10507621,10507622,10507663,10507664,10507669,10507672,10507687,10507688,10507689,10507690,10507691,10507692,10507693,10507694,10507695,10507696,10507697,10507698,10507699,10507700,10507701,10507702,10507703,10507704,10507705,10507706,10507758,10507760,10507847,10507897,10507898,10507902,10507907,10507938,10508009,10508010,10508011,10508012,10508027,10409620,10477303,10407928,10408046,10408047,10408050,10408157,10494925,10494926,10494927,10494928,10410286,10410287,10410288,10410289,10410290,10410291,10410479,10410480,10408678,10408979,10411037,10411038,10411039,10411040,10411041,10411044,10411045,10411046,10411048,10411049,10411050,10411051,10411054,10411055,10411056,10411057,10411058,10411059,10411062,10411063,10411065,10411066,10411067,10411068,10411069,10411072,10409072,10411073,10409073,10411074,10409074,10411075,10409075,10411076,10409076,10411077,10411079,10411080,10411081,10409081,10411082,10409082,10409083,10411084,10409084,10411085,10409085,10409086,10411087,10409087,10409088,10411089,10409089,10411090,10409090,10411091,10409091,10409092,10409093,10409094,10409095) 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'