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(7067906,7067922,7067923,7075932,10198198,7076004,7076018,7076066,10224316,10224317,10224318,10224319,10224320,10224321,10224322,10224323,10224324,10224325,10224326,10224327,10224328,10224329,10224330,10224331,10224332,10224333,10224334,10224335,10224336,10224337,10224338,10224339,10224340,10224341,10224342,10224343,10224344,10224345,10224346,10224347,10224348,10224349,10224350,10224351,10224352,10224353,10224354,10224355,10224356,10224357,10224358,10224359,10224360,10224361,10224362,10224363,10224364,10224365,10224366,10224367,10224368,10224369,10224370,10224371,10224372,10224373,10224374,10224375,10224376,10224377,10224378,10224379,10224380,10224381,10224382,10224383,10224384,10224385,10224386,10224387,10224388,10224389,10224390,10224391,10224392,10224393,10224394,10224395,10224396,10224397,10224398,10224399,10224400,10224401,10224402,10224403,10224404,10224405,10224406,10224407,10224408,10224409,10224410,10224411,10224412,10224413,10224414,10224415,10224416,10224417,10224418,10224419,10224420,10224421,10224422,10224423,10224424,10224425,10224426,10224427,10224428,10224429,10224430,10224431,10224432,10224433,10224434,10224435,10224436,10224437,10224438,10224439,10224440,10224441,10224442,10224443,10224444,10224445,10224446,10224447,10224448,10224449,10224450,10224451,10224452,10224453,10224454,10224455,10224456,7068612,7068692,7068693,7068694,7068702,7068717,7068718,7068719,7073983,7073984,7073985,7073986,7073987,7073994,7073997,7073998,10199657,10225700,10225731,7074562,7074574,7074590,7074606,7074621,7074627,7074630,7074636,7066656,7066663,10437621,10437622,7074688,7074716,7074719,7074726,7074818,7074839,7074840,7074853,7074912,7074949,7074976,7074994,7074995,10197305,8068398,8068399,8068400,7075418,8068401,8068402,8068403,8068404,8068405,8068406,8068407,8068408,8068409,8068410,8068411,8068412,8068413,8068414,8068415,8068416,8068417,8068418,8068419,8068420,8068421,8068422,8068423,8068424,8068425,8068426,8068427,8068428,8068429,8068430,8068431,8068432,8068433,8068434,8068435,8068436,8068437,8068438,8068439,8068440,8068441,8068442,8068443,8068444,8068445,8068446,8068447,8068448,8068449,8068450,8068451,8068452,8068453,8068454,8068455,8068456,8068606,7067627,8068613,8068614,8068663,7067685,7067686,8068681,8068692,8068693,10197953,8068736,8068746,8068754,7067794,7071882,10195144,7072140,7072141,7072142,7072144,10221462,10221463,7072285,10208593,8075307,8075308,8075309,8075310,7072533,10221893,10221894,10932143,10209251,10209252,10209253,10222570,10209649,10222654,10196872,10222970,10222971,10222972,10222996,10222997,10222998,7070875,7070889,7070890,7070891,7070892,7070920,7070921,7070922,7070923,7070924,7070943,7070945,7070946,7070951,7070952,7070965,10220204,7070967,10220211,10220212,7070975,7070982,7070988,7070991,7070992,7071004,7071005,7071006,7071007,8860919,7071058,7071059,7071060,10942811,7071100,7071230,7071362,7071368,7071369,7071373,7071377,8861321,7071521,10943287,8861493,7071612,7071613,7071614,7071621,7071634,7071635,7071642,7071650,7071656,7071657,7071670,7071671,7071679,7071680,7071687,10940532,10205137,7068909,7068945,10940728,10940744,10940775,10940807,7069253,7069260,7069261,7069290,7069291,7069302,7069305,7069312,7069313,7069331,7069337,7069379,7069380,7069394,7069397,7069406,7069407,7069438,10941706,10941786,10941819,10941874,10941884,10941958,10941979,10941984,10942043,10206615,10206616,10206617,7070565,10942296,7070680,10942420,7070766,8860682,7070815,10923472,10923473,10923474,10923475,10618016,10923556,10923557,10923577,10923578,10923579,10923587,10923588,10923589,10923590,10923613,10923614,10623291,10623292,10623293,10623294,10623295,10618370,10623491,8071012,8071013,8071014,8071015,8071016,8071017,8071018,10619332,10619333,8071201,8071202,10925432,10925433,10925446,10925447,10925448,10925457,10621981,10621986,10621996,10622010,10622012,10622032,10622033,10622049,10622050,10622101,10622102,10622113,10622114,10622121,10622126,10622127,10617157,10922722,10922769,10922770,10922787,10922788,10922815,10922816,10922917,10922918,10922934,10922935,10922936,10189521,10922954,10922955,10922956,10922985,10927996,10927997,10927998,10927999,10928000,10928001,10215592,10215593,10215594,10215595,10215596,10215597,10215598,10215599,10215600,10923018,10215601,10928058,10923081,10928119,10928120,10923207,10923224,10923270,10923271,10923272,10923333,10923340,10923471,10615103,10615127,10615130,10615131,8570013,8570043,8570086,10615313,10615318,10615319,10615374,10615375,10615376,10615377,10615378,10620862,10615926,10930741,10621144,10926762,10926763,10621424,10621430,10621431,10621432,10621433,10621434,10621439,10621440,10621441,10621460,10621464,10621480,10621513,10621514,10621537,10621538,10621539,10621540,10621610,10621611,10621612,10621613,10621614,10621616,10621617,10621618,10621630,10621646,10621669,10621676,10621745,10559298,10559299,10559300,10559301,10559302,10559303,10559304,10559305,10559306,10559307,10559308,10559309,10559310,10559311,10559312,10559313,10559314,10559315,10559316,10559317,9165558,10614228,7059759,10614343,7059867,8864402,8864404,10559701,8864808,7057495,7057517,7057637,7057677,7057678,7057720,7057721,7057724,7057725,7057726,7057727,7057728,7057729,7057730,7057731,7057867,7057868,7058030,10557979,10561087,10561088,10561089,10561090,10561091,10561092,10561093,7058683,8863100,8863101,8863118,10558438,10558439,10558440,8863153,8863157,8863158,8863169,8863173,10613350,7058864,7058873,7058881,7058943,10613475,10613505,10613523,7059128,7059160,8863603,8863604,8863703,8863713,8863716,8863814,4974191,9161380,9161396,10511465,10511466,10511467,10511468,10511469,10511470,10511471,10511472,10511473,10511474,10511475,10511476,10511477,10511478,10511479,10511480,10511481,10511482,10511483,10511484,10511485,10511486,10511487,10511488,10511489,10511490,10511491,10511492,10511493,10511494,10511495,10511496,10511497,10511498,10511499,10511500,10511501,10511502,10511503,10511504,10511505,10511506,10511507,10511508,10511509,10511510,10511511,10511512,10511513,10511514,10511515,10511516,10511517,10511518,10511519,10511520,10511521,10511522,10511523,10511524,10511525,10511526,10511527,10511528,10511529,10511530,10511531,10511532,10511533,10511534,10511535,10511536,10511537,10511538,10511539,10511540,10511541,10511542,10511543,10511544,10511545,7055965,7055966,10513628,10513629,10515672,10515673,10515908,10515910,10515911,10515912,7056578,2809332,2809394,7056976,7057445,10419223,9160301,10419224,9160302,10419225,10419237,10419238,10419240,10419257,10419258,10417270,10417271,10419285,10419295,10419296,10419298,10419347,10417399,10417470,8918230,4973441,4973442,4973443,10419560,10419180,4971527,4971528,4971642,4971651,4972010,4972011,4972012,4972013,4972140,6667327,10467919,10467928,10467939,4972220,4972221,10467946,10469952,4972230,4972232,10467966,4972256,4972263,4972264,10467988,10468021,10468100,8917180,6667564,8917216,4972434,4972456,10468215,10468216,6667793,10627969,10628172,10628787,10628806,10628845,10628846,10628847,10628848,10628849,10627017,10627018,10627024,10627033,10627034,10627035,10627036,10632047,10632048,10632049,10632050,10632051,10632052,10632053,10632054,10632055,10632056,10627061,10632098,10632106,10632107,10627402,10627780,10627781,10627784,10627785,10627788,10627791,10627792,10627804,10627809,10627821,10627827,10627831,10627832,10627833,10627834,10627835,10627836,10627837,10627838,10627839,10627840,10627841,10627842,10627843,10627844,10627845,10627846,10627847,10627848,10627849,10627850,10627851,10627852,10627853,10627854,10627855,10627857,10627858,10627866,10627867,10627879,10627887,10627888,10627889,10627890,10627891,10627892,10627901,10627902,10627903,10627904,10627907,10627908,10627911,10627914,10627917,10627922,10627923,10627924,10627925,10627926,10627931,10627932,10630044,10630298,10630307,10630308,10630309,10630340,10630596,10630597,10630598,10630682,10630683,10630684,10630835,10630836,10630837,10630883,10625927,10630944,10630946,10630947,10626121,10626122,10626311,10626312,10626319,10626320,10626321,10626322,10626323,10626331,10631455,10574429,10574430,10574431,10574432,10574433,10571688,10574844,10574845,10568987,10575102,10521190,10523480,10523509,10523525,10523526,10523740,10523741,10523756,10523840,10521920,10524358,10524457,10524458,10524459,10524460,10524461,10524462,10524463,10524464,10524465,10524466,10524467,10524468,10524469,10524470,10524471,10524472,10524479,10524480,10524488,10524489,10524490,10524501,10524502,10524503,10524504,10524505,10524506,10524507,10524508,10524509,10524510,10524511,10524512,10524513,10524535,10524536,10524558,10420403,10420405,10420407,10421479,10421939,10421082,10421108,10421120,10421128,10421133,10422168,10422170,10422174,10422176,10422177,10421208) 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'