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(4970271,4970272,10943577,10943578,10943579,10943580,10943581,10943582,10198355,10198356,10198522,7068297,7068298,7076334,8569405,8569406,8569407,8569408,8569524,4970933,10933326,10199143,10199144,10199145,10199146,10199147,10199148,10199152,10199153,10199154,10199155,10199156,10199157,10199158,10199159,7074141,7074142,7074143,7074144,7074145,7074146,7074147,7074148,7074149,7074150,7074151,7074152,7074153,7074154,7074155,7074156,7074157,7074158,7074159,7074160,7074161,7074162,7074163,7074164,7074165,7074166,7074167,7074168,7074169,7074170,7074171,7074172,7074173,7074174,7074175,7074176,7074177,7074178,7074179,7074180,7074181,7074182,7074183,7074184,7074185,7074186,7074187,7074188,7074189,7074190,7074335,7074336,7066439,7066440,7074513,7074514,7074515,7074516,7074517,7074518,7074519,7074520,7074521,7074522,7074523,7074524,7074525,7074526,7074527,7074549,10437590,10437591,10437592,10437593,10437594,7066881,7066999,7075115,7075116,7075117,7075118,7067544,7067545,6000200,6000201,6000202,6000203,6000204,6000205,6000206,6000207,6000208,6000209,6000210,6000211,6000212,6000213,8074856,8074857,8074858,8074859,8074860,8074861,8074862,8074863,8074864,8074865,8074866,8074867,8074868,8074869,8074870,8074871,8074872,8074873,8074874,8074875,8074876,8074877,8074878,8074879,8074880,8074881,8074882,8074883,8074884,8074885,8074886,8074887,8074888,8074889,8074890,8074891,8074892,8074893,8074894,8074895,8074896,8074897,8074898,8074899,8074900,8074901,8074902,8074903,8074904,8074905,8074906,8074907,8074908,8074909,8074910,8074911,8074912,8074913,8074914,8074915,8074916,8074917,8074918,8074919,8074920,8074921,8074922,7072069,8074923,8074924,8074925,8074926,8074927,8074928,8074929,8074930,8074931,8074932,8074933,8074934,8074935,8074936,8074937,8074938,8074939,8074940,8074941,8074942,8074943,8074944,8074945,7072183,10195458,10195459,10195460,10195461,10195462,10195463,10195464,10195466,10195467,10195468,10195469,10195470,10195471,10195472,10195473,10195474,7072237,10195475,10195476,7064283,7064284,7064285,7064286,7064287,7064288,10932285,10932286,10932287,4967770,4967771,4967772,4967773,10933050,10933089,10933108,10933109,10933110,10933128,10933129,10933130,10933131,10933132,10933133,10933134,10933135,10933136,10933137,10933138,10933174,10933175,7070847,7070848,8861305,7071815,7071816,7071817,7071818,7069101,10944899,10944900,10944901,10944902,10944903,10944904,10944931,10944932,10944933,10944934,10944935,10944983,10944984,8859538,8859539,7069672,7070630,10623361,10623453,10922586,10922587,10922588,10922589,10922608,10922611,10922612,10922613,10922614,10617320,10622459,10928029,10928207,10928287,10928288,10928289,10928290,10928291,10928292,10928293,10622930,10622931,10620053,10620054,10615091,10620135,10620136,10920680,10920681,10620237,10615266,10925814,10925815,10925816,10615508,10615931,10921621,10921622,10921623,10921624,10921625,10921626,10921627,10921628,10921629,10921630,10921631,10921632,10921633,10921634,10921635,10921636,10921637,10921638,10921639,10921640,10921641,10921642,10921643,10921644,10921645,10921646,10921647,10921648,10921649,10921650,10921651,10921652,10921653,10921654,10921655,10921656,10921657,10921658,10921659,10921660,10921661,10921662,10921663,10921664,10921665,10921666,10921667,10921668,10921669,10921670,10921671,10921672,10921673,10921674,10921675,10921676,10921677,10921678,10921679,10921680,10921681,10921682,10921683,10921684,10921685,10921686,10921687,10921688,10921689,10921690,10921691,10921692,10921693,10921694,10921695,10921696,10921697,10921698,10921699,10921700,10921701,10921702,10921703,10921704,10921705,10921706,10921707,10921708,10921709,10921710,10921711,10921712,10921713,10921714,10921715,10921716,10921717,10921718,10921719,10921720,10921721,10921722,10921723,10921724,10921725,10921726,10921727,10921728,10921729,10921730,10921731,10921732,10921733,10921734,10921735,10921736,10921737,10921738,10921739,10921740,10921741,10921742,10921743,10921744,10921745,10921746,10921747,10921748,10921749,10921750,10921751,10921752,10921753,10921754,10921755,10921756,10921757,10921758,10921759,10921760,10921761,10921762,10921763,10921764,10921765,10921766,10921767,10921768,10921769,10921770,10921771,10921772,10921773,10921774,10921775,10921776,10921777,10921778,10921779,10921780,10921781,10921782,10921783,10921784,10921785,10921786,10921787,10921788,10921789,10921790,10921791,10921792,10921793,10921794,10921795,10921796,10921797,10921798,10921799,10921800,10921801,10921802,10921803,10921804,10921805,10921806,10921807,10921808,10921809,10921810,10921811,10921812,10921813,10921814,10921815,10921816,10921817,10921818,10921819,10921820,10921821,10921822,10921823,10921824,10921825,10921826,10921827,10921828,10921829,10921830,10921831,10921832,10921833,10921834,10921835,10921836,10921837,10921838,10921839,10921840,10921841,10921842,10921843,10921844,10921845,10921846,10921847,10921848,10921849,10921850,10921851,10921852,10921853,10921854,10921855,10921856,10921857,10921858,10921859,10921860,10921861,10921862,10921863,10921864,10921865,10921866,10921867,10921868,10921869,10921870,10921871,10921872,10921873,10921874,10921875,10921876,10921877,10921878,10921879,10921880,10921881,10921882,10921883,10921884,10921885,10921886,10921887,10921888,10921889,10921890,10921891,10921892,10921893,10921894,10921895,10921896,10921897,10921898,10921899,10921900,10921901,10921902,10921903,10921904,10921905,10921906,10921907,10921908,10921909,10921910,10921911,10921912,10921913,10921914,10921915,10921916,10921917,10921918,10921919,10921920,10921921,10921922,10921923,10921924,10921925,10921926,10921927,10921928,10921929,10921930,10921931,10921932,10921933,10921934,10921935,10921936,10921937,10921938,10921939,10921940,10921941,10921942,10921943,10921944,10921945,10921946,10921947,10921948,10921949,10921950,10921951,10921952,10921953,10921954,10921955,10922172,10922173,10922174,10922175,10616707,10616708,10616709,10616710,10616711,10616712,10621767,10565346,10614862,10612243,10612386,10563545,10612485,10612488,10612489,10612498,10612620,10612625,10612626,10612657,10612673,10612711,10612713,10612718,10612720,10612721,10612722,10612746,10612847,10612862,10612881,10558144,10558145,10558146,10558147,10558148,10558149,10558150,10558151,10558152,10558153,10558154,10558155,10558156,10558157,10558158,10558159,10558160,10558161,10558162,10558163,10558164,10558165,10558166,10558167,10558168,10558169,10558170,10558171,10558172,10558173,10558174,10558175,10558176,10558177,10558178,10558179,10558180,10558181,10558182,10558183,10558184,10558185,10558186,10558187,10558188,10558189,10558190,10558191,10558192,10558193,10558194,10558195,10558196,10558197,10558198,10558199,10558200,10613092,10613127,10558297,10558298,10558299,10558317,10558318,10558319,10558320,10564454,10558606,10558607,10558611,10613844,10513373,10513576,10513577,10513578,10513579,10513580,10513581,10513582,10513583,10513584,10513585,10513586,10513587,10513588,10513589,10513590,10513591,10513592,10513593,10513594,10513595,10513596,10513597,10513598,10513599,10513600,10513601,10513602,10513603,10513604,10513605,10513606,10513607,10513608,10513609,10513610,10513611,10513612,10513613,10513614,10513615,10513616,10513617,10513618,10515834,10515835,10515836,10513851,10513852,10513977,10513978,10513979,10516376,10516377,10516378,10516379,10516380,10516381,10516382,10516383,10516384,10516385,10516386,10516387,10516388,10516389,10516390,10516391,10516392,10516393,10516394,10516395,10516396,10516397,10516398,10516399,10516400,10516401,10516402,10516403,10516404,10516405,10516406,10516407,10516408,10516409,10516410,10516411,10516412,10516413,10516414,10516415,10516416,10516417,10516418,10516419,10516420,10516421,10516422,10516423,10516424,10516425,10516426,10516427,10516428,10516429,10516430,10516431,10516432,10516433,10516434,10516435,10516436,10516437,10516438,10516439,10516440,10516441,10516442,10516443,10516444,10516445,10516446,10516447,10516448,10516449,10516450,10516451,10516452,10516453,10516454,10516455,10516456,10516457,10516458,10516459,10516460,10516461,10516568,10516569,10516570,10516571,10516572,10516573,10516574,10516575,10417429,10417430,10417431,10417432,10417433,10417434,10417435,10417436,10417437,10417438,10417439,10417440,10417441,10417442,10418561,10418562,10418563,10418564,10418565,10418566,10418734,10418735,10418736,10418737,10418775,10419837,10419838,10420148,10469767,10469850,10467996,10468011,10468055,10468105,10468253,10468254,10468255,10468323,10468324,10468325,10468326,10468327,10468328,10468329,10468436,10466795,10466796,10466797,10466798,10466799,10466800,10466801,10466802,10466803,10466804,10466805,10466806,10466807,10466808,10466809,10466810,10466811,10466812,10466813,10466814,10466815,10466816,10466817,10466818,10466819,10466820,10466821,10466822,10466823,10466824,10466825) 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'