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(10943628,8574501,8574502,10989238,10989240,10989241,8569558,8583106,10989324,3229082,3229083,3229130,3229283,8575151,7065995,7066000,8583569,7066142,7074698,7074777,7074913,7074983,7074997,8573233,7201307,7201323,7201351,7201352,7201353,7201379,7201595,10960058,7201624,7201660,8911578,7064548,7201969,7201988,7201989,7202014,7202015,7202029,7202030,7202050,7202052,7202087,7202136,7202138,8911952,8911954,8911959,8911963,7202171,7202189,7202194,7202205,7202206,7202214,7202312,7202314,7202315,7202318,7202321,7202323,7202325,7202326,7202347,7202358,7202359,7202681,7202709,7202710,8910254,8910255,10102359,7200482,7200483,7200532,7200536,7200637,7200645,7200723,7200725,7200726,7200728,7200730,7200736,7200747,7200748,7200749,7200750,7200754,7200778,7200781,8910618,7200809,7200810,8910623,8910624,7200815,8910646,7200864,7200867,7200868,7200871,7200910,7200931,7200933,7200934,8064692,7201019,7201060,10100083,7198213,7198294,7198347,7198397,7198411,7198413,7198416,7198418,7198682,7198684,7198688,7198689,7198690,7198693,7198695,7198700,7198701,7198706,7198707,7198709,7198710,7198711,7198717,7198723,7198728,7198729,7198734,7198735,7198737,7198738,7198742,7198743,7198744,7198745,7198746,7198747,7198751,7198758,7198759,7198760,7198762,7198763,7198769,7198772,7199036,7199058,11048305,11048307,7200136,7200153,7200157,7196266,7196267,7196294,7196295,7196296,7196332,7196333,7196458,7196465,7196466,10618268,10618275,7196494,10618276,10618277,10618278,10618279,10618280,10618281,10618296,10618297,10618303,10618318,7196537,7196538,10618319,7196539,10618324,10618326,7196574,7196578,7196587,7196595,7196648,7196664,7196671,7196674,7196699,7196737,7196862,8906759,8906818,8906871,8906891,8906944,11046633,11046634,11046635,7197246,8070779,10838805,10838893,10838900,7197412,8907405,8907459,7197654,8907473,7197672,7197823,8907640,8907641,7197842,7198069,8907909,7198150,7198169,10427317,10617035,10617324,10953985,10953991,8612185,10622429,10954099,8905476,10954113,10954114,10954196,10954197,10954388,7196131,7196132,7196133,8905954,10614971,8609790,10614985,10614999,10425387,10425388,10425389,10425390,10425393,10425394,10425471,10615165,10615166,10425551,10425552,10425553,10425554,10425555,10615232,10425574,10425575,10425577,10425579,10425580,10425581,10425582,10425583,10425585,10425589,10425590,10620301,10615315,10615323,10951971,10615389,10615482,10615568,10615569,10425911,10426151,10615834,10615838,10615839,10615856,10615864,10615865,10426277,10426281,10426288,10426289,10426296,10426308,10615971,10615972,10426312,10426364,10616048,10616049,10426435,10426449,8540599,8540619,8904232,10616202,10616205,10616206,10616212,10616237,10616238,10616239,8904285,8904288,8904289,10616271,10616277,10616291,10616292,10616294,10616296,8904332,8904333,10616305,10616306,10616308,8904339,10616313,10616314,10616315,10616316,10616318,10616319,8904351,10616320,10616322,10616325,10616326,10616328,10616333,8904364,10616337,10616338,8904370,10616358,10616392,10616414,10616435,8611319,8611320,10616576,10992335,10992336,10427110,10616852,10616888,10616910,8904951,10614048,10614117,9165459,9165460,7059643,10614177,10714024,10614210,10611226,10614234,10614237,10714119,6669917,10614411,10614435,10611450,10611451,10611462,10611464,10611465,10611466,10611469,10611470,10611471,10611472,10611475,10611483,10611485,10611488,10611489,10611490,10611494,10611496,10611497,10611498,10611506,10611508,10611509,10611510,10559710,10559766,10611673,10611675,10611677,10614864,7057465,10611995,10612018,10609093,10612093,10609246,10609259,10612267,10609276,10609298,10612345,10612381,10609397,10609398,10609414,10609451,10609452,10612462,10612463,10612506,10612521,10612524,10612525,10612546,10609548,10612599,10609607,8862556,8862557,10609772,10609834,10120370,10612845,10612850,10612852,10612856,10609990,10610006,10610025,10610054,10613078,10613157,10613166,10613192,10610233,10610271,10610306,10610307,10610351,7058908,7058980,10613584,10613599,10613600,10613601,10613606,10610675,10613750,10613752,10610773,10610812,10610822,10610829,10610834,10610835,10610846,10610850,10610851,10610862,10610870,7055466,7055470,7055547,10117648,9169464,10117691,9169651,9161891,9161892,9161893,10118275,10118276,10118360,10118442,10118443,10118444,10118551,10118654,10118665,10419232,10419233,10416237,9168327,10416258,9168357,10417283,10417287,10419288,10417290,10418296,10418297,10418298,10418299,10418300,10418301,10416301,10418302,10418303,10418304,10415313,10415315,10415316,10418335,10416347,10418357,10416359,10418361,10419366,10418368,10419371,10419372,10416382,10418383,10419385,10416386,10419410,10419427,10418443,10417448,10418449,10418451,10416454,10415456,10415457,10416466,10416469,10416498,10416499,10416503,10418506,10416509,10416513,10416540,10416541,10415543,10415546,10415548,10417549,10415552,10415553,10415557,10415563,10419564,10419565,10417565,10419566,10415566,10419567,10416568,10415569,10419570,10418571,10415573,10416576,10416577,10416578,10416579,10416580,10415580,10417589,9168671,10417599,10417600,10415602,10419604,10419605,10419608,10415609,9168688,10417610,10416617,10417621,10419624,10419625,9168711,10415634,10416640,10416641,9168720,10415643,10417643,10415644,10415645,10416649,10415649,10417649,10416650,10415650,10416651,10416652,10416653,10416654,10415654,10416655,10419656,10419657,10416658,10417658,10416659,10416660,10415661,10416661,10416662,10419663,10417663,10417666,10416673,10416674,10418685,10418686,10418687,10415693,10418700,10417701,10416703,10415717,10417724,10415725,10417725,10418746,10415747,10415753,10415757,10417757,10417763,10417768,10416770,10416771,10416773,10419775,10419778,10417778,10416780,10416782,10417784,10416786,10415790,10416798,10419811,10416811,10416812,10416813,10418845,10418846,10418867,9168945,10418881,10418890,9168989,10418920,10418921,10418926,10418935,10418936,10415938,10418944,10417946,10417947,10417950,10418950,10418951,10417951,10418952,10417953,10417954,10416954,10417955,10416955,10417956,10416956,10417957,10417959,10417961,10417962,10417963,10418965,10418966,10418968,10418969,10417969,10418970,10417970,10418972,10418973,10417974,10417975,10418976,10417976,10417978,10417981,10417983,10417984,10417986,10417987,10417988,10418989,10417990,10418991,10417991,10417992,10417993,10417994,10417995,10418996,10417997,10417998,10417999,10418000,10418001,10418004,10418006,10418009,10418010,10418011,10418014,10418015,10418016,10418017,10418019,10417020,10418022,10418023,10419024,10418025,10418026,10419028,10418028,10416028,10419030,10418030,10418031,10418032,10419033,10418033,10418034,10416034,10419036,10418037,10419039,10419043,10418045,10417047,10419050,10419052,10419053,10417056,10417059,10418060,10417063,10417064,10419064,10419067,10418068,10417068,10419068,10419070,10419071,10419073,10418076,10418077,10418079,10419082,10419083,10418086,10419090,10419091,10419093,10419096,10117387,10117388,10416115,10419115,10416119,10419119,10419130,10419131,10419133,10419134,10419136,10419137,10419139,10419140,10419148,10418155,10419156,10117433,10117438,10419164,10419166,10419167,10419169,10419170,10419172,10419174,10419176,10419178,10416182,10416186,10416187,10419197,7055449,8549580,10471109,10471110,10471120,8549824,10469281,10469283,8549889,8549891,8549892,8550004,10467498,10467512,8550102,10469571,8550181,8550206,8550242,8550244,8550268,10470094,10470113,4972394,9167553,10464213,10470218,10464238,9167689,10470272,9167702,10470286,10470287,10470288,9167714,10470339,10470347,10470348,10470349,10470359,10470374,10470384,10470388,10470390,10470391,10470392,10470394,10470395,10470396,10470397,10470436,10470438,10470440,10470453,10470499,10470500,10470510,10470511,10470577,10470578,10116203,10116207,10116208,10116209,10116210,10116211,10116212,10116213,10116214,10116215,10116216,10116217,10470597,10116218,10116219,10116220,10470600,10116221,10470601,10116222,10116223,10116248,10470669,10468685,10468741,10468755,10468775,10468778,9168247,9168265,9168266,10468850,10883563,10883570,10883588,10883603,10883629,10883662,10883664,10888717,10888950,10883951,10884019,10884122,10889134,10889135,10889136,10889140,10889141,10889159,10889161,10889163,10889175,10889179,10889180,10889187,10884194,10889208,10889217,10889223,10884629,10884716,10884717,10879876,10879878,10879879,10879880,10879882,10879883,10885020,10885021,10875032,10885165,10885255,10885302,10885303,10885353,10882472,10882496,10882497,10631994,10632018,10882564,10877617,10632109,10632110,10882672,10882688,10882766,10882891,10883126,10883127,10883128,10883129,10883357,10883400,10161807,10162014,10162152,10162279,10876815,10876817,10167916,10167992,10877124,10877125,10877176,10877177,10882373,10877373,10882435,10598619,10580666,10529727,10534189,10423726,10477141,10477418,10477421,10477437) 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'