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(8630581,8630582,8630583,8630584,8630585,8630586,8630587,8630588,8630589,8630590,8630591,8630592,8630593,8630594,8630595,8630596,8630597,8630598,8630599,8630600,8630601,8630602,8630603,8630604,8630605,8630606,8630607,8630608,8630609,8630610,8630611,8630612,8630613,8630614,8630615,8630616,8630617,8630618,8630619,8630620,8630621,8630622,8630623,8630624,8630632,8630633,8630634,8630635,8630636,8630637,8630638,8630639,8630640,8630641,8630642,8630643,8630647,8630649,8630650,8630651,8630652,8630653,8630654,8630657,8630658,8630659,8630660,8630661,8630662,8630663,8630664,8630665,8630666,8630667,8630668,8630669,8630670,8630671,8630672,8630673,8630674,8630675,8630676,8630677,8630678,8630679,8630680,8630681,8630682,8630683,8630684,8630685,8630686,8630687,8630688,8630689,8630690,8630691,8630698,8630699,8630700,8630701,8630702,8630703,8630704,8630710,8630711,8630712,8630713,8630714,8630715,8630716,8630717,8630718,8630719,8630720,8630721,8630722,8630723,8630724,8630725,8630726,8630727,8630728,8630729,8630730,8630731,8630732,8630733,8630734,8630735,8630736,8630737,8630738,8630739,8630740,8630741,8630742,8630744,8630745,8630747,8630748,8630749,8630750,8630751,8630752,8630753,8630754,8630755,8630756,8630757,8630758,8630759,8630760,8630765,8630766,8630767,8630768,8630769,8630770,8630771,8630772,8630773,8630774,8630775,8630776,8630777,8630778,8630779,8630780,8630781,8630782,8630783,8630786,8630787,8630789,8630791,8630792,8630793,8630794,8630795,8630796,8630797,8630798,8630799,8630800,8630801,8630802,8630803,8630804,8630805,8630806,8630807,8630810,8630811,8630812,8630813,8630814,8630815,8630816,8630818,8630820,8630821,8630823,8630825,8630827,8630829,8630831,8630832,8630833,8630834,8630835,8630836,8630837,8630838,8630839,8630840,8630843,8630845,8630847,8630849,8630852,8630853,8630854,8630855,8630856,8630857,8630858,8630859,8630860,8630861,8630862,8630863,8630864,8630865,8630866,8630870,8630872,8630873,8630874,8630875,8630876,8630877,8630878,8630879,8630880,8630881,8630882,8630883,8630884,8630885,8630886,8630887,8630890,8630892,8630893,8630894,8630895,8630896,8630897,8630898,8630899,8630900,8630901,8630902,8630903,8630904,8630905,8630906,8630907,8630908,8630912,8630918,8630936,8630943,8630958,8630959,8630960,8630963,8630964,8630965,8630966,8630967,8630970,8630971,8630972,8630973,8630974,8630976,8630977,8630983,8630987,8630988,8630989,8630990,8630991,8630993,8630994,8630995,8630996,8630997,8630998,8630999,8631001,8631002,8631003,8631004,8631005,8631007,8631009,8631010,8631011,8631012,8631013,8631027,8631028,8631029,8631030,8631031,8631032,8631033,8631034,8631035,8631036,8631037,8631038,8631039,8631040,8631041,8631042,8631043,8631044,8631045,8631046,8631047,8631048,8631049,8631050,8631051,8631052,8631053,8631054,8631055,8631056,8631057,8631058,8631059,8631060,8631061,8631062,8631063,8631064,8631065,8631066,8631067,8631068,8631069,8631070,8631071,8631072,8631073,8631074,8631075,8631076,8631077,8631080,8631081,8631082,8631083,8631084,8631085,8631086,8631087,8631088,8631089,8631090,8631091,8631092,8631093,8631094,8631095,8631096,8631097,8631098,8631099,8631100,8631103,8631104,8631105,8631106,8631107,8631108,8631109,8631110,8631111,8631112,8631113,8631114,8631115,8631116,8631117,8631118,8631119,8631120,8631121,8631122,8631125,8631126,8631127,8631128,8631129,8631130,8631131,8631132,8631133,8631134,8631136,8631137,8631139,8631140,8631141,8631142,8631143,8631144,8631145,8631147,8631172,8631173,8631174,8631175,8631176,8631177,8631178,8631179,8631180,8631181,8631182,8631183,8631185,8631186,8631187,8631188,8631189,8631190,8631191,8631192,8631194,8631195,8631196,8631197,8631198,8631199,8631200,8631201,8631202,8631203,8631204,8631205,8631206,8631207,8631208,8631209,8631210,8631211,8631212,8631213,8631214,8631215,8631216,8631217,8631218,8631219,8631220,8631221,8631222,8631223,8631224,8631225,8631226,8631227,8631228,8631229,8631230,8631231,8631232,8631233,8631234,8631235,8631236,8631237,8631238,8631239,8631240,8631241,8631242,8631243,8631244,8631245,8631246,8631247,8631249,8631251,8631252,8631255,8631256,8631257,8631258,8631259,8631260,8631261,8631262,8631263,8631264,8631265,8631266,8631267,8631268,8631269,8631270,8631271,8631272,8631273,8631274,8631276,8631298,8631299,8631300,8631301,8631302,8631303,8631304,8631305,8631306,8631307,8631308,8631309,8631310,8631311,8631312,8631313,8631314,8631315,8631316,8631317,8631318,8631319,8631320,8631321,8631322,8631323,8631324,8631325,8631326,8631327,8631328,8631329,8631330,8631331,8631332,8631333,8631334,8631335,8631336,8631337,8631338,8631339,8631340,8631341,8631342,8631343,8631344,8631345,8631346,8631347,8631382,8631383,8631384,8631385,8631386,8631387,8631388,8631389,8631390,8631391,8631392,8631393,8631394,8631395,8631396,8631397,8631398,8631399,8631401,8631402,8631403,8631404,8631413,8631414,8631415,8631416,8631417,8631418,8631419,8631422,8631423,8631424,8631425,8631428,8631429,8631430,8631431,8631432,8631433,8631434,8631435,8631437,8631438,8631439,8631440,8631441,8631442,8631443,8631450,8631451,8631458,8631459,8631460,8631461,8631466,8631467,8631468,8631469,8631471,8631472,8631473,8631474,8631475,8631476,8631477,8631478,8631479,8631480,8631481,8631482,8631483,8631484,8631485,8631486,8631487,8631488,8631489,8631490,8631491,8631492,8631493,8631494,8631495,8631496,8631497,8631498,8631499,8631500,8631501,8631502,8631503,8631504,8631505,8631506,8631507,8631508,8631509,8631510,8631511,8631512,8631513,8631514,8631515,8631516,8631517,8631518,8631519,8631521,8631522,8631526,8631527,8631528,8631529,8631530,8631531,8631532,8631533,8631534,8631535,8631536,8631537,8631560,8631561,8631562,8631563,8631564,8631565,8631566,8631567,8631568,8631569,8631570,8631571,8631572,8631573,8631574,8631575,8631576,8631578,8631579,8631580,8631581,8631582,8631585,8631586,8631587,8631588,8631589,8631590,8631591,8631592,8631593,8631594,8631595,8631596,8631597,8631598,8631599,8631600,8631601,8631602,8631603,8575733,8575734,8575735,8067927,8573316,10930095,7201377,8911629,7201959,7201974,7202257,7202285,7202585,7202683,7202684,9794578,9794579,9794580,9794588,9794592,9794594,8616849,7198678,7198679,7198688,7198690,7198695,7198696,7198697,7198698,7198700,7198701,7198702,7198703,7198704,7198710,7198711,7198712,7198713,7198714,7198716,7198717,7198718,7198721,7198722,7198725,7198726,7198730,7198731,7198736,7198744,7198745,7198747,7198750,7198752,7198760,7198763,7198764,7198765,7198766,7198768,7198769,7198770,7198772,7199006,7199508,10101491,7200030,3232382,10617118,3232913,3232914,3232915,8542254,10951828,10615363,10615598,10615727,10426204,8540418,8540596,8540633,10616210,10616211,10616219,10616220,10616228,10616229,10616243,10616245,10616248,10616252,10616253,10616254,10616258,10616265,10616267,10616268,10616287,10616295,10616298,10616302,10616303,10616311,10616323,10616324,10616329,10616332,10616333,10616341,10616342,10616348,10616350,10616351,10616353,10616370,10616375,10616387,10616389,10616393,10616394,10616395,10616397,10616400,10616401,10616404,10616407,10616410,10616411,10616412,10616416,10616417,10616423,10616426,10616430,10616431,10616440,10616441,10616443,10616453,10616454,10616459,10616644,10614054,10614057,10565319,10614220,10614376,10611655,10611782,10609285,10609355,10609971,9172407,10613133,10613342,10613513,10613514,10613527,10613531,10610666,10613858,10613859,10613860,10610901,9169318,6673534,6673535,6673536,6673537,6673538,6673540,6673541,6673542,6673543,6673544,6673546,6673549,6673550,6673563,7055541,7055546,9169428,9169453,6673685,6673688,6673692,7055722,9169586,9169748,10515609,10515610,10515611,10515612,10515613,10517681,6674175,6674249,6674256,6674276,6674278,6674280,6674281,10512852,6672592,10419370,6672802,6672896,6672897,6672898,6672899,6672900,6672901,9168804,6673105,6673140,6673141,9161147,6670727,10123006,9167554,9167779,10888524,10893984,10893985,10893986,10893987,10893988,10889019,10889020,10889021,10889226,10889449,10889997,10890007,10885074,10885166,10880304,10880305,10632012,7000826,10886057,10891654,10891655,10626299,10626300,10626301,10886818,10886878,10886910,10167992,10887052,10882359,10598535,10598867,10545324,10529398,10529399,10544310,10528350,10543041,10543042,10498367,10498499) 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'