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(7075939,4970410,4970411,4970412,4970413,4970414,4970415,4970416,4970417,4970418,4970419,4970420,4970421,4970422,4970423,4970424,4970425,7076370,3228807,3228808,3228809,3228810,3228811,3228863,11041137,10989202,10989203,10989204,8621496,8621509,8621538,8621557,10846513,10846514,10944211,10944212,10944213,10944214,11041558,11041562,11041563,11041664,8622106,8622107,7074276,7074279,8622116,8622117,7074292,10847101,10847102,8622283,8622284,10868783,10868784,10871806,10862843,10849851,10460411,7074847,8632497,8632500,8632502,10951558,10929218,10929219,10929220,7066955,8573188,8837599,7075121,8573330,7075221,7075255,7075274,8561227,8561229,10961990,10961991,10961992,10961993,10961994,10961995,10961996,10961997,10961998,10961999,10962000,7067326,3227765,7067374,7067376,11040079,7075547,10872835,10962351,10939340,10939341,10939342,10939343,8630403,8630449,8630452,8630454,8630455,7064070,10959861,10959862,10959863,10959864,10959865,10959866,10959867,10959868,8835732,8594932,10931765,10858825,8075288,10960243,10960244,10960245,10960246,10960247,10960248,8065697,8065698,8618556,8065699,8065700,8065701,8065702,8065703,8065704,8065705,8065706,8065707,8065708,3899266,8628477,8618692,7202271,8560138,8619029,7202518,10859615,10104475,8560297,8560298,10104489,8596070,7065448,10859772,10859774,5654828,5654829,7073507,7065550,7065551,8629219,7065599,10932976,10932977,8560576,7065636,3227173,3227174,3227175,8629427,8837304,10929168,11049787,11049788,11049789,11049790,11036767,3237519,10865393,8834696,8834697,8834698,8834719,3927659,10865622,10865623,8626984,8626985,8626986,8626991,8558311,7200627,7200628,7200630,7200631,7200679,7200703,7200704,7200705,7200718,11037226,11037227,8627326,7071889,7071896,10103046,8624773,8624776,10995822,10995827,10995828,10100296,8615015,7069220,7069221,7069222,7069223,7069224,8556332,7069645,3926116,3926124,8615609,8615632,8615641,10864156,10864159,8564637,8564638,10101112,3656555,3656637,3656649,3656651,11009787,11009788,11009789,11009790,11009791,11009792,11009793,7199398,7199399,10101285,3236578,10101311,3656839,7199530,7199536,3236710,10841182,10841192,11048355,10942135,10101687,10967667,7196265,7196273,7196308,8554009,8554010,8554011,7196324,7196344,7196345,7196346,7196347,7196348,7196349,7196350,7196351,7196352,7196353,7196354,7196355,10837937,7196466,8554206,8554207,8554227,8554228,8554230,7196542,7196543,11045991,8554256,8554259,8554261,10623379,3233864,3233865,3233866,3233926,8554594,8554595,8554748,10838569,3924224,8613921,8613922,8613923,8613924,10838962,10838963,10982065,10982066,10982067,10982068,10982069,10982070,10982071,10982072,10982073,10982074,10982075,10982076,10982077,10982078,10982079,10982080,10982081,10982082,10982083,10982084,10982085,10982086,10982087,10982088,10982089,10982090,10982091,10982092,10982093,10982094,10982095,10982096,10982097,10982098,10982099,10982100,10982101,10839216,8555533,8624370,8624371,8624372,8624373,10616971,10616972,10922515,8611916,11005837,11005838,10622187,11005966,11005967,10617318,11006021,10837204,10622522,8612560,10853029,8542343,7156467,7156470,7156475,8632602,10615232,10615340,10615341,10615342,10951979,9217007,10850677,10850678,10850682,10952125,10926082,10926085,9217222,9217223,9217224,10926108,9217225,9217226,10926109,9217227,10926116,10926117,10926146,10926148,10926156,10926159,10926197,10952308,10952309,11043406,10926284,10426120,10426121,10952456,10952544,9217737,10426505,10426506,8610977,10916781,10916782,10916783,10916784,10916785,10916786,10916787,10916788,10916789,10916790,10916791,10926899,10926900,10926901,10616464,8577653,10616503,10616512,11018202,10922267,10922268,10922292,8904846,3232238,9915633,9915635,10614263,6665768,6665769,6665770,9181883,10714439,9198059,9198060,9198061,9198071,9198072,9198073,9198074,9198075,9198076,9171414,10563385,10563386,10563387,10563388,10563389,10563390,10563391,10563392,8542780,8566159,8862340,8862341,9914026,8862342,8862343,8862344,8566493,8566494,8566495,8566496,3653259,8851884,10609749,9196155,9196156,9196157,7058419,8862811,9196340,10120585,9172389,10120586,10120587,6676623,9914674,9914675,9180837,9180838,9180839,9180840,9180841,9180842,9180843,9180844,9180845,9180846,9180847,9180848,9196867,10613744,9189182,9205259,9205265,7015067,7015074,9201439,10513767,10513768,8849940,2809278,7056976,7056977,7056978,7056979,7056980,7056981,7056982,7056983,7056984,8552117,7056985,7056986,7056987,7056988,7056989,7056990,7056991,7056992,7056993,7056994,7056995,7056996,9203029,9203030,10119315,10119316,10416407,8918224,7014384,7014385,10418693,10116984,10418851,10418852,10125384,10125423,10125424,10125427,10125442,10125445,10125448,9911493,9911494,9911495,8864871,8864880,8864902,10466963,10466964,10466965,10466966,10466967,10466968,8864919,8864931,8864938,10122625,10122639,8864968,8864972,8864976,8864977,9166716,9166717,9166718,9166719,9166720,9166721,9166722,9166723,9166724,8569338,10471557,6666998,9917294,8854971,9207216,8855146,10469945,6473733,9207628,9207630,9207634,9207655,9207657,8550816,9207661,9207754,9207801,9207822,6667855,9175889,9207949,10116197,10470725,10464807,6672436,6672437,6672438,6672439,6672440,10174513,10888543,10888544,10179610,10174872,10174873,10174874,10888883,10174926,8594118,10175209,10175230,10175404,10175405,10175406,10175407,10175408,10899402,10175608,10175723,10175724,10909944,10910010,10910011,10910012,10910013,10161342,10161343,10161344,10161345,10161346,10161347,10161348,10161349,10161350,10161351,10161352,10161353,10161354,10161355,10161356,10161357,10161358,10161359,10161360,10161361,10161362,10161363,10161364,10161365,10161366,10161367,10161368,10161369,10161370,10161371,7000814,10168663,10184019,10184020,10184064,10184065,7001359,7001390,10883308,10883309,10883310,10883311,10913456,10174476,10156663,10905797,10905798,10948819,10948820,10948821,10948822,10948823,10948824,10948825,10948826,10948827,10948828,10948829,10948830,10911045,10911046,10911047,10177237,10177238,10177239,10891343,10881386,10881387,10881388,10881389,10881390,10881391,10881392,10881393,10187569,10187570,10187581,10911579,10911580,10911581,10626099,10172747,10631251,10631277,10162848,10162849,10162850,10631332,10876873,10876874,10631446,10631447,10892009,10892010,10892011,10892012,10892013,10892014,10892152,10892153,10892154,10892155,10626724,10626725,10907237,10877306,10626819,10950152,10950153,10608379,10608380,10646934,10646935,10646936,10646937,10646938,10646939,10599320,10599321,10599323,10599325,10599327,10599328,10599329,10599330,10599332,10653459,10653460,10653461,10647984,10570027,10570028,10588254,10582453,10582454,10591806,10648890,10648891,10648892,10601849,10524270,10524271,10524272,10524273,10524274,10524275,10524276,10524277,10524278,10524279,10524280,10524281,10524282,10524283,10524284,10524285,10524286,10524287,10546288,10524288,10524289,10546289,10546290,10546291,10546292,10546293,10522396,10538417,10544672,10544673,10544674,10544675,10527025,10509276,10508554,10508555,10508556,10507628,10508708,10508776,10508802,10508803,10508804,10508805,10421200,10489932,10489933,10480943,10480944,10480945,10480946,10480947,10480948,10480949,10480950,10480951,10480952,10407360,10413373,10488130,10490368,10490369,10490370,10407938,10407939,10407943,10414052,10481822,10480553,10480554,8562176) 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'