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(10250063,7067838,7067977,7076103,7068291,7068310,10211586,7068431,10198670,10198671,4970771,7065850,10212500,8837301,8837302,7066415,7066416,10437424,8837596,8837597,7074665,7066754,7066801,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,8835489,8068471,8835496,7067493,8835497,8068482,8068483,7075616,10249921,10249922,10249923,10249924,10249925,10249926,7075776,7067806,7072028,7072044,10234396,10234511,10234512,10195742,8564732,7064525,7072556,8564801,8564865,10248047,10248048,8565098,10196146,4967862,4967863,4967864,7065601,7065640,10235943,7071252,10943258,10943423,8970195,8970220,10257143,10283159,10944445,7068969,10218219,7068981,7068982,10218220,10218221,7068983,10218222,10218223,10218224,10218225,10218226,10218227,10218228,10218229,10218230,10218231,10218232,10218233,10218234,10218235,10218236,10218237,10218238,10218239,10218240,10218241,10218242,10218243,10218244,10218245,10218246,10218247,10218248,10218249,10218250,10218251,10218252,10218253,10218254,10218255,10218256,10218257,10218258,10218259,10218260,10218261,10218262,10218263,10218264,10218265,10218266,10218267,10218268,10218269,10218270,10218271,10218272,10218273,10218274,10218275,10218276,10218277,10218278,10218279,10218280,10218281,10218282,10218283,10218284,10218285,10218286,10218287,10218288,10218289,10218290,10218291,10218292,10218293,10218294,10218295,10218296,10218297,10940774,10940775,10218298,10218299,10940777,10218300,10218301,10940779,10218302,10218303,10940780,10940781,10218304,10218305,10218306,10218307,10218308,10218309,10218310,10218311,10218312,10218313,10218314,10218315,10218316,10218317,10218318,10218319,10218320,10218321,10218322,10218323,10218324,10218325,10218326,10218327,10218328,10218329,10218330,10218331,10218332,10218333,10218334,10218335,10218336,10218337,10218338,10218339,10218340,10218341,10218342,10218343,10218344,10218345,10231345,10218346,10218347,10218348,10218349,10218350,10218351,10218352,10218353,10218354,10218355,10218356,10218357,10218358,10218359,10218360,10218361,10218362,10218363,10218364,10218365,10218366,10218367,10218368,10218369,10218370,10218371,10218372,10218373,10218374,10218375,10218376,10218377,10218378,10218379,10218380,10218381,10218382,10218383,10218384,10218385,10218386,10218387,10218388,10218389,10218390,10218391,10218392,10218393,10218394,10218395,10218396,10218397,10218398,10218399,10218400,10218401,10218402,10218403,10218404,10218405,10218406,10218407,10218408,10218409,10218410,10218411,10218412,10218413,10218414,10218415,10218416,10218417,10218418,10218419,10218420,7069183,10218421,7069184,10218422,7069185,10218423,10218424,10218425,10218426,7069189,10218427,7069190,10218428,7069191,10218429,7069192,10218430,7069193,10218431,7069194,10218432,7069195,10218433,7069196,10218434,7069197,10218435,7069198,10218436,7069199,10218437,7069200,10218438,7069201,10218439,7069202,10218440,10218441,10218442,10218443,10218444,10218445,10218446,10218447,10218448,10218449,10218450,10218451,10218452,10218453,10218454,10218455,10218456,10218457,10218458,10218459,10218460,10218461,10218462,10218463,10218464,10218465,10218466,10218467,10218468,10218469,10218470,10218471,10218472,10218473,10218474,10218475,10218476,10218477,10218478,10218479,10218480,10218481,10218482,10218483,10218484,10218582,10218583,10218584,10218585,10218586,10218587,10218588,7069590,10245301,10245302,10622987,10190187,10623191,10623192,10623193,10623194,10623195,10623196,10623197,10204197,10204198,10204379,10282523,10282524,10282525,10282526,10204577,10204578,10204583,10204594,10204918,10619895,10619896,10619904,10617019,10617020,10280134,10617045,10617046,10189266,10189267,10189268,10189269,10189270,10189271,10189272,10189273,10189274,10189275,10189276,10189277,10189278,10189279,10189280,10189281,10189282,10189283,10617194,10617319,10215466,10215467,10280533,10617456,10228552,10228553,10228554,10228555,10215630,10215631,10215632,10228637,10215648,10215649,8569822,8569830,8569831,8569832,8569833,8569834,8569835,8569836,8569837,8569870,8569871,8569872,8569873,8569874,10615533,10926112,10926113,10926157,10615660,10615908,10615909,10616016,10616064,10621262,10621263,10621357,10621358,10621374,10227744,10227937,10227938,10227939,10565346,9197855,10614563,10559874,9179369,9171422,7057703,7057704,7057918,10612651,9180065,10612733,10612734,8862698,9172266,9172267,10612937,8862809,8862810,9172323,10613061,10613062,10613113,10558281,10558282,10558283,10558284,10558285,9196473,10558286,9196474,10558287,10613235,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,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,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,9167800,10466377,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,10183971,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,10589651,10589652,10589657,10589658,10589673,10589674,10583708,10583738,10583739,10583782,10583783,10583784,10583785,10583786,10583849,10583861,10589862,10589863,10583962,10584003,10584004,10584028,10587099,10587167,10587241,10584298,10584299,10584300,10584301,10584302,10584303,10584304,10584305,10584306,10584307,10584308,10584309,10584310,10584311,10584312,10584313,10584314,10584315,10584316,10587362,10584370,10572854,10570215,10570216,10585281,10573318,10582563,10585585,10585586,10585587,10585588,10585589,10585599,10585600,10585601,10585602,10585603,10585697,10585698,10585735,10585736,10585737,10585738,10585739,10585740,10585741,10585742,10585743,10585744,10585745,10585750,10585751,10585752,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'