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(11001797,11001798,11001799,11001803,11015023,11015038,10989072,11002167,11002168,11002437,11002573,11002574,11015587,11015588,11015656,11015657,11015658,11002729,7066144,7066145,8067252,7074302,11003004,8067312,8067313,7074374,11003094,11016120,11016217,11016239,11016240,11016241,11016259,11016260,11016261,11003329,11003462,11003463,10938484,11016619,11013621,11013622,11013623,7066982,10961701,10961702,10961703,10961704,11013711,11013712,11013732,11013733,11013735,10961739,10961740,11013781,10961789,10961790,10961809,10961838,10961858,11013904,11013905,11014380,11014381,11014382,7071973,7072215,10960065,10931829,11012216,11012308,11012349,11012462,10999490,10999491,10999492,10999493,10999494,10999495,10999497,10999498,10932161,11012505,11012551,11012552,11012559,8065959,8065976,11012688,11012689,11012690,11012691,8066014,10986750,10986751,10986752,10986753,10986754,10986755,10986756,11012771,11012868,11012869,11012870,11000014,11013029,11013032,11013042,11013174,11013175,10961204,11013339,11013340,11013355,10961373,11013393,11013394,11013402,11013430,11013435,10961439,10961440,10961441,10961442,10961443,10961444,10961445,10961472,10961473,11013518,11013519,11013520,11013521,11013522,11013523,11013524,11013525,4968060,10961557,10961558,10961559,10961560,10961561,10961562,10961592,10961593,10961599,10961600,8063951,8063952,10942762,10997836,7071265,7071266,10958955,10958956,7071361,11049303,10959090,10959091,10959188,6000125,10940709,10996187,10996286,10996343,10996569,10996570,10996571,10997042,10958381,10997395,10997419,11006647,11006648,11006685,11006724,11006728,11006765,11006766,11006767,11006841,11006849,11006866,10623494,11007316,10623731,10623732,10623733,10623734,10623735,10623736,10623737,10623738,10623739,10994546,10994547,10994548,10994549,10994760,10994789,10994807,11007812,11007839,8070909,8070910,11007864,11007869,11007876,11007877,10619300,10619301,10619302,10619334,10624550,10624551,8071307,8071308,8071309,8071310,8071311,8071312,8071313,8071314,8071315,8071316,8071317,8071318,8071319,8071320,8071321,8071322,8071323,8071324,8071337,10995307,10995308,10995309,10995310,10927480,11005670,11005676,10622033,10622049,10622050,11005712,11005733,11005847,11005848,10622271,10622272,10622273,10622274,10622276,11005991,11006007,11006110,11006114,11006130,11006141,11006142,11006143,11006166,11006264,11006370,11006412,11006413,11006414,10993544,11006574,11006577,11006578,11006604,11006611,10615083,10920606,10615103,10920629,10920630,10920631,10920632,10615127,10615130,10615131,10920683,10620238,10620330,10620331,11004000,11004001,11004002,11004003,11004004,11004005,11004006,11004007,11004008,10615355,11004030,11004042,11004043,10615447,11004113,11004131,11004164,11004165,11004169,8570486,11004231,11004232,11004277,11004278,11004462,11004504,11004512,11004648,11004649,10991682,10991686,11004710,11004711,11004739,10991750,10991751,10991752,10991756,10991790,10952818,10616216,10616217,10616218,10616219,10616220,10922073,8863877,10611067,10611379,10611382,10611389,10611390,10611391,10611393,10611394,10611396,10611400,10611407,10611409,10611411,10611412,10611413,10611414,10611420,10611422,10611425,10611426,10611427,10611428,10611429,10611430,10611433,10611434,10611435,10611436,10611437,10611442,10611444,10611445,10611446,10611447,10611449,10611450,9173789,10611455,10611463,10611473,10611476,10611477,10611479,10611480,10611484,10611486,10611491,10611507,10611508,10611515,10611525,10614527,10611528,10611532,10611536,10611542,10611546,10611550,10611554,8864413,10611559,10611567,10611572,10611574,10611581,10611584,10611585,10611588,10611596,10611597,10611598,10611600,10611604,10611617,10611618,10611619,10611635,10611636,10611637,10611638,10565796,10565797,10565798,10565799,10565800,10565801,10565802,10565803,10565804,10565805,10565806,10565807,10565808,10565809,10565810,10565811,10565812,10565813,10565814,10565815,10565816,10565817,10565818,10565819,10565820,10611670,10565821,10611676,10565944,10565945,10565946,10565947,10565948,10612422,10557660,10557661,10557662,7058096,10612655,10612684,10612821,10612822,10610048,10610078,10613097,10613137,8863359,10610668,9173016,10610696,9161361,9161476,9161504,10515504,10515505,10517506,9169698,10515526,10515527,10515528,10515529,10515530,10515531,10515532,10515533,4974660,4974661,4974662,4974663,7056138,10513985,10512118,10512119,10512120,9160377,10417315,9168407,10416534,8918334,10415681,10415682,9160764,10418807,10418808,9160887,10418910,10418050,10418051,10418052,10417212,10466955,10463011,10463023,10463024,10463025,10463026,10463027,10463028,10463029,10463031,10463034,10463035,10463042,10463043,10463044,10463045,10463046,10463050,10463051,10463052,10463054,10463055,10463056,10463057,10463058,10463059,10463060,4971353,10467102,10467108,10467109,10467110,10467116,10467118,10467122,10467125,10467126,10467127,10467128,10467132,10467134,10467135,10467136,10467143,10467144,10467145,10467146,10467148,10467151,10467152,10467153,10467154,10467157,10463392,10463393,10463394,10463395,10463396,10463397,10463398,10463402,10463430,10463431,10467433,10463434,10467434,10463435,10467437,10467438,10467440,10467458,10467459,10471504,10463595,10463649,10463651,10463652,10463653,10463655,10463656,10463658,10463660,10463661,10463670,10463674,10465683,10465684,10465687,10465688,10465691,10465692,10465695,10465706,10465709,10463731,4972007,4972009,10463741,4972017,4972018,4972019,4972020,10463745,10463746,4972023,10463748,10463749,10463750,10463751,10463752,4972028,10463753,4972029,10463755,10463756,10463758,10463759,10465760,10463763,10463764,10463765,10463766,10463767,10463768,10463771,10465772,10465773,10463774,10465774,10463775,10465775,10465778,10465779,10463780,10465782,10463783,10465783,10463784,10463785,10463786,10465786,10463787,10465787,10463789,10465791,10463792,10465792,10463793,10465793,10463798,10465798,10463799,10465800,10465801,10465802,10465803,10465804,10463805,10465806,10465807,10465810,10465811,10465812,10465813,10465824,10463825,10465825,10463826,10463828,10465830,10465831,10463832,10463833,10465845,10465846,10465848,10465854,10465860,10465865,10465866,10465872,10465873,10463876,10465876,10463877,10465877,10465878,10465879,10463881,10463883,10465883,10463885,10465887,10463888,10465888,10463889,10465889,10465892,10463893,10465893,10463894,10465894,10463895,10465895,10465896,10463901,10465901,10463905,10463908,10465908,10463909,10463910,10465910,10465911,10465912,10465913,10463915,10465915,10463916,10463917,10465917,10463918,10463919,10463920,10463924,10463925,10463929,8917096,10464040,10464041,10464042,10464043,10464044,10464045,10464052,10466207,10466209,10466211,10466214,10466215,10466219,10466220,10466227,10466228,10466229,10466230,10466238,10466242,10468253,10468257,10462298,10466304,10462313,10462314,10466314,10466315,10462316,10466316,10462317,10466317,10466318,10466320,10466321,10466322,10466323,10462324,10466325,10466326,10468328,10466328,10466332,10466333,10466336,10466338,10466339,10466344,10466345,10466346,10466349,10466350,10466351,10466352,10466353,10466359,10466360,10466361,10466362,10466369,10466371,10466376,10466377,10466392,10466393,10466397,10466399,10466400,10466401,10466403,10466404,10466405,10462407,10462409,10462411,10462412,10466412,10462413,10462414,10466415,10462417,10466418,10466419,10462420,10466421,10462421,10466423,10462423,10466424,10466425,10466426,10462427,10466428,10462428,10462430,10462431,10466432,10466433,10466434,10462434,10466435,10462435,9167859,10466436,9167860,10462438,10466439,10462439,10466440,10466441,10462441,10466444,10462444,10462445,10462447,10466448,10462448,10466449,10462450,10462451,10462452,10462455,10462456,10466457,10462457,10466458,10462459,10462460,10462461,10462462,10462463,10462473,10462476,10462477,10462480,10468481,10462481,10462483,10462484,10462488,10462491,10462492,10462493,10462494,10462496,10462497,10462498,10462500,10462501,10462502,10462504,10462505,10462507,10462512,10462513,10462514,10462517,10462518,10462521,10462522,10462523,10462524,10462525,10462526,10462528,10462529,10462530,10462531,10462533,10462538,10462539,10462543,10462545,10462546,10462582,10462583,10462585,10462586,10462590,10462592,10462595,10462596,10462597,10462598,10462603,10462604,10462605,10462607,10462609,10462610,10462611,10462612,8917683,10462613,10462614,10462615,10462619,10462621,10462625,10462629,10462630,10462723,10462724,10462725,8917819,9168242,9168243,9168244,9168245,9168246,10466851,10466855,9168281,10466860,10628387,10628388,10628389,10166287,10158705,10632310,10627343,10153892,10153893,10627542,10627543,10627713,10630041,10630044,10630045,10630047,10630048,10630049,10630050,10630051,10630052,10630053,10630054,10630149,10630150,10630151,10630152,10630153,10630154,10161967,10162099,10162119,10162250,10631412,10631413,10626590,10163482,10567368,10567369,10567370,10567717,10520738,10520739,10520758,10522839,10422273,10421605,10422749,10422750,10421967,10421968,10478231) 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'