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(10861229,8630744,8630745,8630939,8630943,8631089,10873798,10950681,10950688,10862796,8629601,8629650,8629737,10860650,8630271,8630272,8630273,8630275,8630276,8630277,8630278,8630280,8630282,8630283,10861002,10861007,10861009,10861010,10861011,10861012,10861013,10861015,10861016,10861018,10861019,10861020,10861021,10861022,8630404,8630405,7201335,8627879,8595017,8595021,8595022,10866689,10866691,8595062,10858718,10858719,10858720,8911578,8911579,8911580,8911581,7202165,7202168,7202171,8628574,7202189,7202194,7202209,10859679,10859680,10859682,10859685,10859755,10859757,10859778,3237399,8910253,7200938,7201103,7201136,7201137,7201138,7201145,7201149,7201150,8624583,8624587,8624806,10855537,10855538,10855541,10855549,10855552,10855553,10855554,10855555,10855563,10855567,10855568,10855569,10855570,10855577,10855578,10855580,10855583,10855584,10855585,10855586,10855678,7198681,7198690,8625110,8625111,8625112,8625113,8625119,8625120,8625121,8625124,8625127,8625128,8625129,8625131,8625133,7198743,7198744,7198745,7198746,7198751,8625509,10856914,3233612,3923601,10853740,10853863,10853874,10853915,10853924,10853927,10853936,10853945,10853949,10853954,10853997,10854068,10854069,10854111,10854114,10854115,10854147,10854243,10854244,10838792,3235071,8624437,8624449,8905282,8905283,8905284,8905288,8612185,8905783,8905784,8905786,8905787,8579018,10615439,10615792,10426392,8634157,8634159,8634162,8634168,8634169,8634265,8634416,8634428,8634429,10611053,10611054,10614084,10614085,10614086,10614091,10614094,10614095,10614240,10614241,10611799,10612202,10612265,10609411,10609414,10609420,10609448,10609451,10609461,10609590,10609607,8852024,8852025,8852026,8852027,8852028,8852029,8852030,8852031,8852032,8852033,8852034,8852035,8852036,8852037,8852038,10610351,6673511,6673552,9911610,9911682,9911683,9911685,6673701,10117922,10117928,7015406,7015407,7015408,7015409,7015410,7015411,7015412,7015413,7015414,7015415,7015416,7015417,7015418,7015419,7015420,7015421,9911974,7015422,7015423,7015424,7015425,7015426,7015427,7015428,7015429,7015430,7015431,7015432,7015433,7015434,7015435,7015436,7015437,7015438,7015439,7015440,7015441,7015442,7015443,7015444,7015445,7015446,7015447,7015448,7015449,7015450,7015451,7015452,7015453,7015454,7015455,7015456,7015457,7015458,7015459,7015460,7015461,7015462,7015463,7015464,7015465,7015466,7015467,7015468,7015469,7015470,7015471,7015472,7015473,7015474,7015475,7015476,7015477,7015478,7015479,7015480,7015481,7015482,7015483,7015484,7015485,7015486,7015487,7015488,7015489,7015490,7015491,7015492,7015493,7015494,7015495,7015496,7015497,7015498,7015499,7015500,7015501,7015502,7015503,7015504,7015505,7015506,7015507,7015508,7015509,7015510,7015511,7015512,7015513,7015514,7015515,7015516,7015517,7015518,7015519,7015520,7015521,7015522,7015523,7015524,7015525,7015526,7015527,7015528,7015529,7015530,7015531,7015532,7015533,7015534,7015535,7015536,7015537,7015538,7015539,7015540,7015541,7015542,7015543,7015544,7015545,7015546,7015547,7015548,7015549,7015550,7015551,7015552,7015553,7015554,7015555,7015556,7015557,7015558,7015559,7015560,7015561,7015562,7015563,7015564,7015565,7015566,7015567,7015568,7015569,7015570,7015571,7015572,7015573,7015574,7015575,7015576,7015577,7015578,7015579,7015580,7015581,7015582,7015583,7015584,7015585,7015586,7015587,7015588,7015589,7015590,7015591,7015592,7015593,7015594,7015595,7015596,7015597,7015598,7015599,7015600,7015601,7015602,7015603,7015604,7015605,7015606,7015607,7015608,7015609,7015610,7015611,7015612,7015613,7015614,7015615,7015616,7015617,7015618,7015619,7015620,7015621,7015622,7015623,7015624,7015625,7015626,7015627,7015628,7015629,7015630,7015631,7015632,7015633,7015634,7015635,7015636,7015637,7015638,7015639,7015640,7015641,7015642,7015643,7015644,7015645,7015646,7015647,7015648,7015649,7015650,7015651,7015652,7015653,7015654,7015655,8850200,8850203,9912664,9912668,8850516,8552168,6672565,6672566,6672578,10416356,10416357,10416358,10416359,10416360,10416361,10416362,10416363,6672712,6672815,6672816,10419564,10419566,10415584,6672913,9168748,10418968,9169096,9169098,9169099,9169102,10416076,10416113,10416118,10469281,10469391,10469394,10469395,10467814,976421,9167692,9167693,9167749,9167970,10884178,10884379,10889498,10884976,10882472,10882480,10882557,10882559,10882564,10888335,10883444,10161784,10161848,10886884,10886885,10886886,10886887,10886888,10886898,10886905,10882447,10887459,10602160,10602175,10602738,10647297,10647630,10424427,10508603,10413260,10413261,10413262,10413453,10413499,10413500,10411580,10486249,10409754,10409761,10409784,10409785,10409793,10409794,10409795,10409796,10409797,10409798,10409823,10409911,10413917,10413918,10409920,10409922,10409923,10409925,10409981,10410001,10410005,10410007,10410008,10410009,10410011,10414103,10414104,10414109,10414110,10414112,10414117,10414192,10414194,10414203,10414206,10414211,10414214,10414217,10410694,10410695,10410696,10410697,10410698,10410699,10410700,10410701,10410702,10410703,10410704,10410705,10410706,10410707,10410708,10410709,10410710,10410711,10410712,10410713,10410714,10410715,10410716,10410717,10410718,10410719,10410720,10410721,10410722,10410723,10410724,10410725,10410726,10410727,10410729,10410730,10410731,10410732,10410733,10410734,10410735,10410736,10410737,10410738,10410739,10410740,10410741,10410742,10410743,10410744,10410745,10410746,10410747,10410748,10410749,10410750,10410751,10410752,10410753,10410754,10410755,10410838,10410854,10412855,10412856,10412857,10412858,10414869,10410869,10410875,10414876,10414883,10414884,10414895,10414935,10414941,10414980,10415031,10415032,10415033,10415034,10415035,10415036,10415037,10415038,10415039,10415040,10415041,10415042,10415043,10415044,10415045,10415046,10415047,10415048,10415049,10415050,10415051,10415052,10415053,10407112,10407118,10415169,10415179,10411182,10415198) 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'