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(8574484,4970673,4970680,3228965,3228966,8569559,3229028,3229047,3229048,3229049,3229050,3229051,3229052,3229053,3229186,3229187,8583437,7066007,7066008,8583486,7066017,8583494,7066135,7066165,7066260,8067930,8067941,8573612,10939417,7201202,7201211,7201213,7201215,7201216,10960174,8911585,8065820,8065827,8616856,10102355,10102356,10102358,10102359,8910598,10100291,8908230,8908231,8908232,8908233,8908234,8908235,8908236,8908237,8908238,8908239,8908240,8908241,8908242,8908243,8908244,8908245,8908246,8908247,8908248,8908249,8908250,8908251,8908252,8908253,8908254,8908255,8908256,8908257,8908258,8908259,8908260,8908261,8908262,8908263,8908264,8908265,8908266,8908267,8908268,8908269,8908270,8908271,8908272,8908273,8908274,8908275,10101503,10101504,10101505,10101555,11048369,11048370,8612892,10618177,10618178,10618179,10618180,10618181,10618277,10618279,10618280,10618281,10618329,10623700,8906858,8906911,8906913,10968547,10838790,10838816,10838817,10838895,10838905,8907418,8907419,8907420,8907421,8907711,8907718,8907719,8907855,8905100,8905101,8905102,8905103,8905104,8905105,8905106,8905107,8905108,8905109,8905110,8905111,10617135,10617145,10617146,10617158,10617169,10617170,10617171,10617172,10617221,10617223,8905294,8905297,8905298,8905328,8905393,8905394,8905401,8905402,8905403,8905404,8905405,8905406,8905407,8905408,8905409,8905410,8905411,8905412,8905413,8905414,8905415,8905424,8905425,8905427,10622434,10622462,10622526,8905649,8905677,8905842,8905941,10425349,10425360,10615037,10425394,10615202,10425570,10615353,10615469,10615472,10615509,10615544,10615581,10615724,10615751,10615754,10426246,10426269,10426274,10426275,10426276,10426277,10426278,10991658,10991659,10426341,10616050,10616052,10426402,10426445,10426628,8611313,8611321,8611341,10616548,8611398,8611453,10616694,10427108,10616783,10616859,10611053,10611054,10611177,10611178,10614282,10614284,10614285,10611318,10611319,10714137,10611338,10611339,10614355,7059861,10614376,10614427,10614444,10614446,10614556,10614558,10559766,10611696,10611720,10614739,10614749,10614753,10614766,10614767,10611821,10611823,10614857,10614858,10614859,10614861,10611972,10611973,10611982,10611992,10612008,10612010,10612042,10612069,10612106,10612107,10612125,10612131,10612132,10612133,10612135,10612136,10612137,10612171,10612172,10612173,10612174,10612175,10612176,10612179,10612189,10612191,10612192,10612193,10612202,10612203,10612221,10612222,10612223,10612224,10612229,10612230,10612234,10612235,10612236,10612239,10612240,10612241,10612246,10612252,10612253,10612254,10612255,10612256,10612257,10612263,10612265,10609271,10612272,10609273,10612276,10612277,10612278,10612280,10612281,10612282,10612286,10612291,10612294,10612345,10609385,10609392,10609393,10612483,10612484,10612485,10612486,10612487,10612488,10612489,10612490,10612491,10612492,10612493,10612496,10612497,10120032,10612498,10612499,10120033,10612501,10612505,10612506,10612513,10612516,10612517,10612518,10612519,10612520,10612521,10612522,10612523,10612524,10612525,10612526,10612527,10612528,10612529,10612530,10612532,10612535,10612539,10612542,10612546,10612547,10612551,10612552,10612553,10612554,10612556,10612557,10612558,10612562,10612565,10612566,10612567,10612568,10612570,10612571,10612573,10612583,10612584,10612585,10612586,10612587,10612588,10612589,10612592,10612596,10612597,10612599,10612601,10612604,10612608,10612609,10612611,10612618,10612619,10612623,10612625,10612626,10612637,10612639,10612640,10612641,10612644,10612645,10612647,10612648,10612651,10612655,10612657,10612660,10612663,10612664,10612666,10612667,10612668,10612673,10612675,8862536,10612678,10612679,10612680,10612682,10612683,10612684,10612685,10612688,10612689,10612690,10612697,10612698,10612699,10612700,10612701,10612702,10612703,10612704,10612705,10612706,10612707,10612711,10612713,10612715,10612717,10612718,10612720,10612721,10612722,10612723,10612753,10612757,10609772,10612791,10612792,10612821,10612822,10609828,10612833,10612834,10612836,10612837,10612838,10612841,10612842,10612843,10612844,10612846,10612850,10612852,10612853,10612856,10612862,10612863,10612865,10609865,10609866,10612866,10612867,10612868,10612869,10612870,10612871,10612872,10612873,10612874,10612875,10612876,10612877,10612878,10612879,10612881,10612886,10612888,10612898,10612914,10609972,10609994,10609999,10610002,10613094,10610097,10613136,10558292,10613172,10613179,10613198,10613209,10613228,10613232,10613233,10613234,10613238,10613254,10610282,10610302,10610303,10610304,10610305,10613358,10613359,10613360,10613362,10610362,10610363,10613363,10613364,10613365,10613366,10613367,10613368,10610417,10610462,10610463,10613476,10613503,10613695,10613698,10613699,10613719,10610836,10610838,10610862,10610866,10610867,7055490,7055500,9169336,9169468,9169534,10117735,10117737,10117738,10117739,10117740,7055722,10117788,9169637,10117907,10117908,10117909,10117910,10117911,10117912,10117913,10117918,10117921,10117922,10117923,10117924,10117925,10117928,10117929,10117933,10117938,9169748,9169801,7056001,10118042,10118177,10118199,10118255,10118272,10118281,7015776,7015777,7015778,7015779,7015780,7015781,7015782,7015783,7015784,7015785,7015786,7015787,7015788,7015789,7015790,7015791,7015792,7015793,7015794,7015795,7015796,7015797,7015798,7015799,7015800,7015801,7015802,7015803,7015804,7015805,7015806,7015807,7015808,7015809,7015810,7015811,7015812,7015813,7015814,7015815,10118385,10118404,10514102,10514103,7015978,7015979,7015980,7015981,7015982,7015983,7015984,7015985,10118529,7015986,7015987,7015988,7015989,7015990,7015991,7015992,7015993,7015994,7015995,7015996,7015997,10516919,10516920,10415230,10415231,9168331,10419255,10419257,10419258,10419259,9160337,10419260,9160350,9168395,9168399,10415323,9168403,9168414,9168415,9168416,9168417,9168421,10416344,9168422,9168423,9168424,9168425,9168447,9168448,9168449,9168450,9168451,9168452,9168456,9168458,9168462,10419394,10419395,10419396,9168481,9168487,10417474,10418493,10418495,10418496,10418497,10419564,10416647,9168729,10416652,10416653,10416654,10416657,10416678,10416706,10416718,7014452,7014453,7014454,7014455,7014478,7014479,7014480,7014481,7014482,7014483,7014498,7014499,7014506,7014507,10416801,10416803,10416807,10416808,10416810,10416811,10416812,10416813,10416814,10416816,10416818,10416820,9169018,9169019,10418968,10417026,10417027,10417029,10417030,10417031,10417034,10418048,9169182,9169183,9169184,10117436,9169270,7055445,10419210,8549927,10467467,10467468,10467469,10467470,10467471,8550055,8550119,8550165,8550185,8550221,9167265,10467879,9167534,9167540,10462332,10462338,10462339,10462340,10462341,10462342,10462343,10462346,10462347,10462348,9167772,9167773,10462392,10462393,10462394,9167832,9167833,10468447,10468448,10468450,10468452,10468453,10468454,10468455,10468456,10468457,10468458,10468473,10468474,10468475,10468476,10468477,10468478,10468479,10468480,10468481,10468482,10468483,10468484,10468485,10468486,10468487,10468488,10468489,10468490,10468491,10468492,10468493,10468494,10468495,10468496,10468497,10468506,10468507,10468519,10468521,10468522,9167955,9167956,10116158,9167968,9167974,10462569,10462571,10462572,10462574,10462575,10462576,9168199,10470783,9168281,10883670,10628322,10174930,10174931,10159945,10170104,10884260,10884261,10884446,10884836,10884881,10879881,10884882,10884883,10884884,10884885,10884887,10884914,10884926,10884946,10884947,10884948,10884949,10884950,10884951,10884952,10884953,10884954,10884955,10884956,10884957,10884958,10884959,10884960,10884961,10884962,10884963,10884964,10884965,10884966,10884968,10884971,10884972,10884973,10884976,10884977,10884981,10884982,10884983,10884999,10885002,10885005,10885021,10875021,10885022,10885025,10875028,10885033,10885039,10885041,10885061,10885064,10171140,10875193,10875194,10875195,10875237,10880303,10880304,10880305,10885354,10885460,10882540,10163718,10882908,10882913,10882914,10882944,10883067,10164088,10883143,10883161,10627773,10627776,10883301,10883302,10883303,10883332,10883333,10883334,10883335,10883336,10883337,10883338,10883339,10883340,10883341,10883342,10883343,10883344,10883345,10883346,10883347,10883348,10883349,10883350,10883351,10883352,10883353,10883354,10883355,10883356,10883357,10883425,10627930,10161683,10161685,10161709,10161711,10630191,10625214,10161841,10625372,10161928,10161969,10161972,10161974,10880977,10162048,10949008,10162236,10876482,10881557,10881567,10876588,10876634,10876689,10626439,10877125,10877126,10877127,10877176,10877177,10882295,10882398,10882432,10882433,10566135,10530689,10530690,10530691,10477204,10488268,10488269,10494360,10486535,10472504,10472505,10472506,10472507,10472508,10472509,10472510,10472511,10472512,10472513,10472534,10472535,10472555) 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'