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(7067838,10962572,10962573,7067977,7076103,7068291,7068310,10976041,7068431,4970771,10940472,10940473,10940499,10940500,10940501,10940502,10940506,7065850,7066415,7066416,10437424,10990348,7074665,11042429,7066754,11042484,7066801,10990485,10990486,10990487,7066938,7067001,8068013,8068014,8068015,8068016,8068017,7067188,7067189,7067190,7067388,8068386,8068387,8068388,8068389,8068390,8068391,8068392,8068393,8068394,8068395,8068396,8068397,8068444,8068445,8068446,8068447,8068448,8068471,7067493,8068482,8068483,7075616,7075776,7067806,7072028,7072044,10959860,10960175,7064525,7072556,8066264,8066265,8066266,8066267,8066411,8066412,8066413,8066414,8066415,8066416,8066417,8066418,8066419,8066439,8066440,8066459,8066460,8066461,8066462,8066463,8066464,8066473,8066474,8066492,8066493,8066494,8066495,4967862,4967863,4967864,7065601,7065640,11010656,10997874,7071252,10943258,10943423,8970195,8970220,10944445,7068969,7068981,7068982,11008667,7068983,11008668,10940774,10940775,10940777,10940779,10940780,10940781,7069183,7069184,7069185,7069189,7069190,7069191,7069192,7069193,7069194,7069195,7069196,7069197,7069198,7069199,7069200,7069201,7069202,7069590,10996311,3656359,10996421,10996422,3656837,3656914,10622987,10993548,10623191,10623192,10623193,10623194,10623195,10623196,10623197,10967787,10967788,10967955,10968162,10968428,10981712,10981713,10981714,10981715,10981716,10981717,10981718,10981719,10981720,10981721,10981722,10981723,10981724,10981725,10981726,10981727,10981728,10981729,10981730,10981731,10981732,10981733,10981734,10981735,10981736,10981737,10981738,10981739,10981740,10981741,10981742,10981743,10981744,10981745,10981746,10981747,10981748,10981749,10981750,10981751,10981752,10981753,10981754,10981755,10981756,10981757,10981758,10981759,10981760,10981761,10981762,10981763,10981764,10981765,10981766,10981767,10981768,10981769,10981770,10981771,10981772,10981773,10981774,10981775,10981776,10981777,10981778,10981779,10981780,10981781,10981782,10981783,10981784,10981785,10981786,10981787,10981788,10981789,10981790,10981791,10981792,10981793,10981794,10981795,10981796,10981797,10981798,10981799,10981800,10981801,10981802,10981803,10981804,10981805,10981806,10981807,10981808,10981809,10981810,10981811,10981812,10981813,10981814,10981815,10981816,10981817,10981818,10981819,10981820,10981821,10981822,10981823,10981824,10981825,10981826,10981827,10981828,10981829,10981830,10981831,10981832,10981833,10981834,10981835,10981836,10981837,10981838,10981839,10981840,10981841,10981842,10981843,10981844,10981845,10981846,10981847,10981848,10981849,10981850,10981851,10981852,10981853,10981854,10981855,10981856,10981857,10981858,10981859,10981860,10981861,10981862,10981863,10981864,10981865,10981866,10981867,10981868,10981869,10981870,10981871,10981872,10981873,10981874,10981875,10981876,10981877,10981878,10981879,10981880,10981881,10981882,10981883,10981884,10981885,10981886,10981887,10981888,10981889,10981890,10981891,10981892,10981893,10981894,10981895,10981896,10981897,10981898,10981899,10981900,10981901,10981902,10981903,10981904,10981905,10981906,10981907,10981908,10981909,10981910,10981911,10981912,10981913,10981914,10981915,10981916,10981917,10981918,10981919,10981920,10981921,10981922,10981923,10981924,10981925,10981926,10981927,10981928,10981929,10981930,10981931,10981932,10981933,10981934,10981935,10981936,10981937,10981938,10981939,10981940,10981941,10981942,10981943,10981944,10981945,10981946,10981947,10981948,10981949,10981950,10981951,10981952,10981953,10981954,10981955,10981956,10981957,10981958,10981959,10981960,10981961,10981962,10981963,10981964,10981965,10981966,10981967,10981968,10981969,10981970,10981971,10981972,10981973,10981974,10981975,10981976,10981977,10982072,10982073,10982074,10982075,10982076,10982077,10982078,10619895,10619896,10619904,10617019,10617020,10617045,10617046,10617194,10617319,11005963,11005964,10617456,10954281,8569822,8569830,8569831,8569832,8569833,8569834,8569835,8569836,8569837,8569870,8569871,8569872,8569873,8569874,10991004,10991005,10615533,10991086,10926112,10926113,10926157,10615660,10615908,10615909,10616016,10616064,10621262,10621263,10916774,10916775,10916776,10916777,10916778,10916779,10978888,10978889,10621357,10621358,10621374,10979047,10979048,10979049,10979060,10979061,11018190,10953472,10953473,10953474,10953475,10953476,10953477,10953478,10953479,10953480,10953481,10953482,10953483,10953484,10953485,10953486,10953487,10953488,10953489,10610970,10610972,10610973,10610974,10610979,10565346,9197855,10614563,10559874,10611933,9179369,9171422,7057703,7057704,10609270,7057918,10612651,9180065,10612733,10609733,10612734,8862698,10609882,9172266,9172267,10612937,8862809,8862810,9172323,10610054,10613061,10613062,10613113,10558281,10558282,10558283,10558284,10610134,10558285,9196473,10558286,9196474,10558287,10613235,10610356,8863326,8863327,8863328,8863329,8863330,9180842,9196865,8863442,8863472,8863473,8863474,8863475,8863476,8863477,8863478,8863479,8863480,8863481,8863491,8863492,8863502,8863503,8863513,8863514,8863516,10613741,9189196,9197272,10513233,10513234,10513235,10513236,10515311,10511427,4974579,10517552,10515676,10515677,9169872,10513895,9186102,10513992,4975081,10516059,10516060,10516061,10516062,10516063,10516064,10516065,2809142,2809143,7056923,7056924,9178932,9178933,9178934,9178935,7057125,10516830,10516831,10516832,10516833,10516834,10516835,10516836,9179058,9179059,9179060,9179061,9179062,9179063,9179064,9179091,9179092,9179093,9179094,9168341,9176362,9168489,8918221,8918222,8918223,8918227,10419599,9169007,9169088,9161200,9161201,9161202,9161203,9161204,9161205,9161206,9161207,9161208,9177282,9177283,9177284,9182405,10467240,8916405,10463363,10463364,10463365,10463366,10463367,9174880,9175061,9183160,10469770,4972106,4972107,4972108,4972109,4972110,4972111,4972112,4972122,10469852,9167296,9167297,9167298,10468035,10464046,10464047,10468059,10468071,10468072,10468107,9167658,10468240,6667693,6667694,6667695,8563600,8563601,10468281,10466343,10466344,10466345,10466346,10466347,10466348,10466349,10466350,10466351,10466352,10466353,10466354,10466355,10466356,10466357,10466358,10466359,10466360,10466361,10466362,10466363,10466364,10466365,10466366,10466367,10466368,10466369,10466370,10466371,10466372,10466373,10466374,10466375,10466376,10466377,9167800,10466378,10466379,10466380,10466381,10466382,10466383,10466384,10466385,10466386,10466387,10466388,10466389,10466390,10466391,10466392,10466393,10466394,10466395,10466396,10466397,10466398,10466399,10466400,10466401,6667879,10468520,9175944,9192059,9192062,9168104,9168202,9168204,10470803,9176298,10174499,10179606,10179607,10174871,10628580,10155366,10168679,10168680,10168681,10168682,10168683,10168684,10168695,10168696,10168697,10168698,10627290,10627292,10164092,10179150,10179151,10179152,10179153,10179154,10179155,10176656,10161662,10156709,10161868,10162126,10172391,10626138,10626139,10626302,10168321,10168322,10168323,10168324,10173337,10586444,10586445,10586512,10586519,10586528,10586529,10574558,10583708,10583738,10583739,10583782,10583783,10583784,10583785,10583786,10583849,10583861,10583962,10584003,10584004,10584028,10587099,10584298,10584299,10584300,10584301,10584302,10584303,10584304,10584305,10584306,10584307,10584308,10584309,10584310,10584311,10584312,10584313,10584314,10584315,10584316,10584370,10572854,10570215,10570216,10585281,10573318,10582563,10585585,10585586,10585587,10585588,10579795,10525277,10527278,10525278,10527279,10525279,10525280,10525281,10521323,10527351,10527352,10521362,10521363,10521364,10521365,10521366,10521367,10521368,10521369,10521370,10521371,10521372,10521373,10521374,10521375,10521376,10521377,10521378,10521379,10521380,10521381,10521382,10521383,10521384,10521385,10521386,10521387,10521388,10521389,10521390,10521391,10521392,10521393,10521394,10521395,10521396,10521397,10521398,10521399,10521400,10521401,10521668,10521669,10528106,10528108,10528177,10522324,10522399,10520463,10520464,10528485,10528486,10522598,10522621,10522622,10522625,10520760,10520770,10520780,10421240,10420245,10422461,10424479,10424509,10424510,10422526,10422527,10422529,10420550,10422553,10423734,10424742,10422794,10425045,10425046,10425053,10421104,10423160,10480944,10480945,10480946,10473074,10473088,10479630,10479631,10479632,10475647,10479654,10479655,10479656,10479657,10479658,10479659,10479671,10479703,10479704,10479724,10479895,10479896,10479931,10479932,10482092,10482093,10482095,10482118,10482120,10476503,10476504,10476505,10480846,10480847,10480848,10480849,10480850,10480851,10480852,10480853,10480854,10480855,10480856,10480857,10480858,10480859,10480860,10480861,10480862,10480863,10480864,10480865,10480866,10480867,10480868,10480869,10480870,10480871,10480872) 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'