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(3228508,8630760,8574526,4970719,4970720,3228942,4970757,10950296,8569704,8583432,8583434,7066004,7066022,7066024,7066100,8631857,10990262,8576024,10929241,3227408,8067910,8067911,8573231,11040000,11040001,11040002,11040003,11040004,11040005,10939040,10939041,10939042,10939139,10939155,10939156,8630195,8630428,10930107,10939535,10939536,7201202,7201226,7201229,7201231,7201234,7201337,7201338,7201532,7201539,7201578,8628310,7201959,8628411,8628417,8065842,8911946,8628595,8572159,8628805,7202654,7202682,8629356,8629417,8629558,7065919,7065920,7065927,7065928,8626611,7200214,8910048,8910049,8627050,8627075,7200722,7200931,7200935,8624652,8624656,8624658,8624766,8624767,8624768,8624769,8624770,8624771,8624772,8624773,8624774,8624775,8624776,7198428,7198429,7198430,7198432,7198433,7198434,7198435,7198451,7198476,7198567,7198573,7198677,7198694,7198700,7198706,7198727,7198757,10941602,7199270,7199271,7199472,7199816,7199821,7199863,8073547,7200134,10623324,10623418,3233941,8906608,8906609,8613583,7197132,7197139,7197142,7197152,7197155,7197162,7197208,10838770,10838772,7197267,7197268,10838942,7197446,7197504,7197505,8907418,8907458,7197810,7197811,3235068,3235105,7197939,10619886,8904995,8905006,10616980,10616982,8905015,8905022,8905034,8905064,10617034,8541521,8905067,8905068,10617204,8905267,10617460,10954226,10954227,8905608,8905612,8905627,10993336,8905732,8905770,10837492,10622772,8905859,10837561,8905895,8905980,10425350,10615014,10615040,10425573,10615258,10615287,10615391,10615425,8610374,10426215,8540519,8540521,10616040,10616197,10616226,10616332,8611382,10616690,8577911,8904792,10616790,10616794,10616795,8577968,8577998,8577999,8578000,10953529,8904913,8904933,10616940,10616941,8904986,8904990,9205324,10614006,10614007,10614008,10611008,10614027,10611052,10611064,10611370,10614452,10611459,10614472,10614493,10614538,10614554,10614618,10614712,10614821,10614833,10611850,10614852,10611856,10611863,10611971,10612009,10612070,10612071,10612072,10612077,10612172,10612173,10609354,10609387,10609431,10612501,10609550,10612552,10612554,10612566,10612567,10609592,10609607,10612625,10609637,10609654,10609663,10609669,10609670,10609671,10609672,10609686,10609689,10609690,10609691,10609692,10609693,10609694,10609695,10609696,10609706,10609712,10609722,10609745,10612747,10612748,10609772,10609778,10609782,10612844,10609857,10609887,10609891,10609892,10609898,10609912,10609913,10612939,10609962,10609963,10609965,10612979,10612980,10612986,10609986,10612987,10612988,10612989,10613023,10610099,10610111,10610118,10610119,10610121,10610134,10610141,10610142,10610143,10610144,10610145,10610146,10610147,10610160,10613230,10610274,10610304,10610323,10610374,10613630,9165153,9165154,9165155,10610844,10613853,9165202,10613896,10613897,10610903,10613928,10613929,10610942,10117498,10117499,6673514,6673515,10117513,10117534,10117538,7055534,9169393,9169414,9169468,9169469,9169470,9169498,9169506,6673769,9169563,7015360,7015361,10117931,10118283,8551409,6674326,8551419,8551550,8551596,8551599,10118507,10118543,8551770,8551849,10118827,8551999,8552132,8552159,8552161,8552168,8552204,10419252,10419266,10419267,10419268,10419269,10419273,10419276,10419278,10419279,10419280,10416288,10416290,10419293,10417293,10419294,10417294,10417295,10419296,10418308,10415328,10416336,10416337,10416338,10419352,10419368,6672662,10419390,10417395,10417397,10415416,10415418,10415424,10418426,10415427,9168508,10415438,10415439,10415444,10417453,10416458,10416459,10419470,10419476,10416477,10418477,10419482,10415487,10419491,10419492,10417509,10419527,10417534,10416543,10419544,10419561,10417566,10419569,6672856,10415580,10416610,10416611,6672906,10419631,10416639,10416651,10416656,10416658,10416659,10416660,9168740,10416673,10416674,10415674,10415676,10415677,10416688,10418696,10416698,10416699,10416700,10416701,10416702,10416703,6672992,10416709,6672993,10418709,10416710,10416711,10416712,10416713,10416714,10416715,10416716,10415716,10416717,10415718,10415719,10416720,10415722,10415724,10418732,10416737,10419777,10415782,10415783,10416802,10415805,10416810,10416817,10416821,10418824,6673117,10418836,10418862,9169014,10418937,10418938,6673237,10417966,10418969,10418970,9169055,10417996,6673283,6673284,6673285,10416042,10419054,10419061,10418068,10416076,10418076,10419095,10416113,6673399,6673400,10416118,10416133,10416134,10416135,10416136,10416137,10418142,10419148,10117425,10419150,9169232,9169255,10416183,9161274,10117479,10117480,10416210,10416216,10416217,10416218,8549500,8549516,8549540,10468981,10471008,10471009,10469066,10469067,6670730,8549751,10469343,8550050,10467534,10469540,10467555,10467561,10467572,10467578,8550158,10467591,8550174,10467606,10467681,10467685,10467736,10467745,10467762,10467768,10469947,10469975,10469976,10469977,10469997,10469998,10469999,10470000,10470033,10470034,10470035,10470053,10470054,10470055,10470056,9167680,9167724,10468307,9167743,9167744,9167745,9167764,9167765,9167766,9167777,9167850,8551009,8551010,8551011,9167858,8551017,9167863,9167872,10468579,10470776,10470777,10470778,10468827,10468828,10468829,10468832,10184510,10184511,10184512,10184520,10184545,10184556,10184571,10184574,10184575,10184585,10888577,10184593,10888595,10184608,10184635,10883676,10888684,10888703,10946710,10883948,10946760,10946762,10946771,10946772,10946836,10946882,10946886,10946912,10946914,10889131,10889161,10889239,10947054,10947055,10947068,10884324,10947142,10947146,10947150,10884374,10947208,10947277,10947318,10889542,10889547,10947377,10947393,10947402,10947410,10889621,10884699,10884820,10947646,10947653,10889869,10889870,10889871,10947772,10947790,10875004,10875007,10875008,10875010,10875013,10875014,10875027,10947840,10947856,10890046,10885064,10880084,10948054,10948119,10948131,10885332,10948168,10885380,10885381,10885382,10885385,10885386,10948197,10885387,10885388,10885389,10885391,10885414,10885416,10885417,10885418,10948254,10882477,10945291,10882505,10882538,10882540,10945360,10632040,10632041,10632042,10632043,10632044,10632045,10632046,10632047,10877557,10632048,10632049,10632050,10632051,10632052,10632053,10882563,10632054,10632055,10632056,10882572,10882582,10882619,10882644,10882648,10882649,10882650,10882651,10882652,10882653,10887654,10882654,10882655,10882656,10882657,10882658,10882659,10882660,10882661,10882662,10882663,10882673,10158686,10882687,10882709,10882722,10882724,10945560,10945564,10945565,10882760,10945581,10882774,10882775,10882776,10945592,10945594,10882786,10945597,10882787,10882803,10882805,10945616,10945630,10945634,10945639,10882890,10882891,10945714,10882907,10882930,10882961,10882962,10945786,10877994,10883001,10883002,10883023,10945838,10883037,10945850,10883045,10945864,10883120,10883170,10883171,10883175,10883178,10883179,10946005,10883198,10946009,10946017,10883211,10883217,10883218,10888273,10627776,10946102,10888309,10946120,10888338,10946153,10888367,10883381,10883382,10946204,10946211,10946213,10946219,10946243,10888433,10888442,10946264,10946273,10948323,10948378,10948383,10948389,10948402,10948404,10890632,10890634,10890636,10890650,10948488,10890682,10890687,10890694,10948505,10885698,10885699,10948522,10948529,10948548,10161813,10948613,10948626,10948633,10948634,10948636,10948647,10948679,10885893,10948712,10948738,10948752,10948790,10948791,10885993,10948816,10948818,10886054,10886066,10886081,10886082,10162097,10162168,10886206,10886207,10886208,10886209,10886210,10886311,10886312,10886313,10886314,10886362,10886422,10886450,10886527,10626099,10626102,10626103,10626104,10886664,10886665,10886666,10886769,10886770,10886771,10886772,10886773,10626278,10886827,10886828,10886829,10949757,10626445,10626476,10949800,10626483,10882000,10882001,10949864,10887125,10887353,10877359,10887390,10882398,10882407,10882408,10882410,10882411,10882414,10626906,10882440,10882451,10882453,10647337,10647338,10647350,10647351,10647553,10421497,10421498,10421499,10421502,10421503,10421504,10421543,10421544,10421546,10421547,10421549,10420863,10420866,10420868,10420870,10420878,10420879,10420880,10420881,10420882,10407591,10407604,10407633,10407642,10407644,10407692,10407696,10407726,10407731,10407732,10407819,10407820,10407821,10407970,10408021,10477683,10477684,10408119,10408122,10490878,10490936,10490937,10490976,10490978,10491001,10491003,10491004,10491030,10491038,10491062,10491067,10491071,10491072,10491073,10491078,10491101,10491105,10491107,10491108,10491113,10491129,10489182,10489216,10474255,10408674,10474362,10474380,10474381,10474384,10474403,10474420,10474422,10474430,10474438,10474452,10474453,10474454,10474456,10474487,10408834,10474497,10474504,10474505,10474555,10474569,10474598,10406982,10406985,10406987,10406988,10406989,10406990,10406991,10406992,10407085,10407100,10407116) 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'