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(7076123,7076124,7076127,7076128,7076129,10198396,10198397,10237459,4970670,4970671,7068404,4970775,8569453,10198766,10198767,10198768,10198769,10198770,10198771,10250917,7065831,7065833,7065834,7065835,7065836,7065837,7065838,7065839,10251130,10251131,10251132,7065946,10238249,10238250,10238265,10238298,10238301,10238305,10238306,10238396,10238403,10238404,10238423,10238424,10251479,10251480,4968623,10238534,10238535,10238536,10238537,10238538,10238566,10238567,10238568,10238569,10238570,10238571,10238572,10238573,10238574,10238575,10238576,10238577,10238578,10238579,7066348,7074355,7074366,7074367,7074368,7074369,10225631,10437568,10238900,10212919,7066766,7066823,8067903,7067254,7075578,10249989,10249991,7071829,10247424,10247425,10234505,7064386,7064592,10234849,10234850,10234851,10234853,10234854,10234855,10195958,7064733,7064736,7064760,7064761,10235011,10235012,10235013,10235014,10235015,10235016,10235017,10235018,10235019,10235020,10235021,10235022,10235023,10235024,10235025,10235026,10235027,7064863,7064878,7064892,7064911,7064912,7064926,7064947,7064977,7064984,7064985,7064986,10196347,10196424,10196425,10196426,7073317,10932783,10932785,10235589,10932790,10932792,10932793,10932796,10932806,10932807,10932808,10932809,10932810,10222617,10235633,10235635,10932932,10248731,10248732,10248733,10248734,10932962,10932963,10932964,10932965,10932969,10932970,10932973,10932974,10932975,10235857,10222959,10196984,10942534,10942535,10942710,10942712,10942714,10942715,10942743,10942745,8860980,10942799,10942804,10942812,10942817,10233358,10233366,10233367,10233373,10233376,10233377,10233378,10942861,10942913,10942994,10943019,10943044,10233615,10943113,10943122,7071514,7071523,7071524,10943248,10233777,10943256,10233786,10943270,10943290,10943304,10943308,10218055,10944411,10231139,10231140,10231155,10940633,10231160,10231173,10231174,10231175,10231176,10231177,10231178,10231179,10940883,10231418,10944733,10940969,10940993,10940998,10941002,10941061,10941103,10941128,10941195,10941234,10941296,8859500,7069606,10941391,10941400,10941636,10941651,10941682,10941692,10941745,10941749,10941756,10941780,10941948,10941961,10941969,10941979,7070342,10942147,8860337,10942222,10942286,10942304,8860498,10942344,10942347,10942348,10942350,10942357,10942358,10942361,10942366,8073529,10229140,10190221,10623177,10190271,10229370,10229524,10229570,10229571,10229572,10229573,10229574,10229575,10229576,10229640,10229656,10623719,10623720,10623721,10623722,10230015,10191043,10230071,10204359,10624627,10624628,10624632,10624633,10204909,10619836,10204965,10619891,10619900,10619905,10619928,10922499,10922500,10922501,10922502,10922503,10922504,10922505,10922506,10922507,10922508,10922509,10922510,10922511,10922512,10922513,10922514,10228238,10228239,10228240,10228241,10228242,10228243,10228244,10228245,10228246,10228247,10189309,10189310,10189311,10189313,10617324,10617326,10617342,10617351,10617355,10617357,10617358,10617359,10617360,10622365,10617366,10617367,10617368,10617370,10617371,10617377,10617381,10617384,10922895,10617385,10617386,10617387,10617388,10617389,10922899,10922900,10617390,10617391,10617392,10617393,10617394,10617395,10617396,10617397,10617398,10617399,10617400,10617401,10617402,10617403,10617404,10617405,10617406,10617407,10617408,10617409,10617410,10617411,10617412,10617413,10617414,10617415,10617416,10617417,10617418,10617419,10617420,10617421,10617422,10617423,10617424,10617427,10922949,10617449,10617450,10928010,10928011,10617511,10928302,10928303,10614995,10620082,10620087,10620088,10620089,10620092,10620093,10620094,10615178,8570011,10620189,10620190,10620191,10620192,10620193,10620194,10620202,8570040,8570100,8570117,8570122,10615329,10615330,10615341,10615342,10200645,10200653,10200658,10239767,10239768,10620797,10930666,10615896,10930720,10615938,10615939,10616023,10616056,10201150,10201151,10616075,10926651,10926654,10931016,10616210,10616211,10616219,10616220,10616228,10616229,10616248,10616252,10616253,10616258,10616267,10616268,10188373,10616287,10616295,10616298,10616302,10616303,10616311,10240407,10616323,10616324,10616329,10616332,10616333,10616341,10616342,10616348,10616350,10616351,10616353,10616370,10616375,10616387,10616389,10616393,10616394,10616395,10616397,10616400,10616401,10616407,10616410,10616411,10616412,10616416,10616417,10616423,10616426,10616430,10616431,10616440,10616441,10616443,10616453,10616459,10227687,10227693,10922143,10616648,10922251,10922252,10922253,10922254,10922255,10927263,10927264,10922269,10922270,10922271,10922272,10922273,10922274,10922275,10922277,10201888,10922442,10922451,10565160,10565161,10565162,10565163,10565164,10565165,10565166,10565167,10565168,10565169,10614038,10614039,10614040,10614041,10614042,10614043,10614044,10614045,10614046,10614047,10614048,10614049,10614050,10614051,10614052,10614053,10614054,10614055,10614056,10614057,8864074,7059757,7059787,7059800,7059859,9173715,9173716,9173718,9173720,9173721,9173722,9173724,9173726,9173727,9173728,9173729,9173730,9173731,9173734,9173736,9173739,9173742,9173743,9173746,8864279,8864323,10614497,10614498,10559706,6665932,9173983,9174017,9174068,9174080,9174084,9166129,9174154,6666211,6666214,6666217,6666220,10612050,8862099,10612381,8862394,8862481,9180046,9172146,10612939,8862850,8862865,10613017,7058534,8862959,8862960,7058620,10613127,10613137,9172520,9172521,9172522,10613214,10613215,10561523,10561524,10561564,10561565,10561566,10561567,10561568,10561569,10613475,10564883,10613736,10613740,10613760,9173114,10613797,9173137,9173272,9169378,9169475,9161492,7055723,10515377,7055775,4974543,7055932,4974643,4974717,4974718,4974725,4974728,4974729,4974734,4974735,4974736,4974737,4974738,4974740,4974741,4974742,4974743,4974744,9161894,9161896,7056091,9169937,9169951,9169952,9169953,7056270,7056309,10513974,9162163,7056339,10516162,10518649,10518650,10518666,10518671,10518677,10518682,10518684,10518688,10518689,10518701,10518704,10512782,7057197,7057450,9176406,4973308,10416397,10416398,10416405,10416429,10419468,10419478,10419485,10419486,10419487,10419488,10419489,10419490,10419491,10419492,10419495,4973434,4973436,10419668,10419671,10419672,10418676,10419684,10418689,10418691,10418692,10418701,10418702,10418703,10418704,10419704,10419706,10418707,10419708,10419709,10419711,10419714,10419715,10419718,10419721,10419724,10419730,10419731,10419733,10419743,10419753,10419754,10419755,10419756,4973736,10418824,10418825,9168937,9168938,9168939,9168940,10418863,9168941,10419897,10419904,10419905,10419906,10419907,4973903,9169078,9169079,9169080,9169081,9169082,9169083,9169084,9169085,9169086,10420016,7055299,10419109,10417113,10417115,10417117,10417118,10417127,10417134,10417141,10417142,10417146,10417158,10417160,10419190,7055446,8864869,8864930,8864940,8864941,8864957,6666503,10471171,4971471,4971473,10467218,10467219,10467220,6666650,8865186,8865187,10469277,10469278,10469382,10469383,10469384,9166826,9166828,8916476,9166855,8916760,10465768,10465776,9167233,6667234,9167238,9167239,9175244,9175247,9175250,10467838,9175289,9175299,10463931,4972257,10468234,10468237,8917337,10466324,9175754,10466394,9175850,9175852,9175858,9175859,6667868,9175890,9168100,4972972,4972973,6668128,6668177,8917857,10466846,10466853,10627985,10627986,10159562,10628380,10628381,10628382,10628383,10155856,10627085,10627145,10632160,10632161,10632162,10632163,10632164,10632165,10163939,10158966,10627587,10627589,10627775,10161660,10630189,10630244,10630245,10630272,10162248,10162267,10162277,10167562,10631238,10631239,10631240,10626241,10631243,10631244,10626291,10631425,10631426,10631451,10631452,10631453,10631454,10626710,10626815,10163475,10568114,10568115,10568116,10568117,10568119,10568120,10568123,10568124,10568126,10568127,10568128,10580130,10568130,10580166,10580167,10580168,10580169,10580170,10580265,10580266,10580267,10580268,10580269,10580270,10580271,10580272,10568294,10568295,10568296,10568297,10568298,10568299,10568300,10568301,10568302,10568303,10568304,10568305,10568306,10568307,10568308,10568309,10568310,10568311,10568312,10568313,10568314,10568315,10521691,10521692,10521696,10522292,10522297,10522298,10522302,10522303,10522304,10522307,10522354,10522355,10522356,10522357,10522358,10522359,10522360,10522594,10522595,10520756,10520783,10524867,10524868,10522946,10422280,10422348,10420425,10420428,10420429,10420430,10420431,10420435,10421603,10420629,10420711,10423742,10423746,10423752,10423753,10423754,10420848,10420849,10420851,10420873,10420877,10420878,10420879,10420880,10420881,10420882,10420883,10421965,10423162,10477099,10477100,10477382,10477383,10473694,10478019,10478033,10474075,10474076,10474077,10474078,10474079,10474080,10474081,10474082,10474083,10474084,10474085,10474086,10474087,10474088,10474089,10476506,10476507) 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'