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(10939535,10939536,10939539,10939541,10939542,10939552,10939670,10939674,10940009,10940032,10940035,10940036,10940041,4970666,4970667,4970668,4970669,10940052,10940056,10940063,10940064,10940065,10940067,10940068,10940069,10940070,10940072,10940073,10940074,10940078,4970700,4970701,4970703,10940088,10940089,10940090,10940091,10940096,10940097,4970719,4970720,4970721,4970722,4970723,4970724,4970746,4970757,4970769,4970773,10940202,10940204,10940246,10940248,10940249,10940250,10940251,10940252,10940253,10940254,10940255,10940258,10940264,10940292,10940302,10940305,10940306,10940309,10940365,10940394,10940431,10940433,10940435,10940459,10940460,10938479,10938480,10938481,10938503,10938504,10938505,10938506,10938507,10938508,10938509,10938510,10938512,10938526,10938546,10938551,10938552,10938553,10938554,10938555,10938556,10938557,10938558,10938559,10938560,10938561,10938562,10938563,10938566,10938568,10938569,10938577,10938578,10938580,10938586,10938587,10938588,10938589,10938590,10938591,10938592,10938593,10938594,10938595,10938597,10938598,10938601,10938602,10938603,10938607,10938608,10938625,10938629,10938630,10938631,10938632,10938633,10938639,10938641,10938642,10938643,10938644,10938645,10938646,10938648,10938652,10938653,10938654,10938658,10938659,10938660,10938661,10938662,10938663,10938665,10938666,10938667,10938671,10938672,10938673,10938680,10938683,10938684,10938701,10938702,10938703,10938744,10938745,10938798,10938802,10938807,10938809,10938810,10938811,10938812,10938815,10938816,10938817,10938818,10938928,10938929,10938932,10938933,10938934,10938935,10938937,10938938,10938939,10938944,10938945,10938946,10938947,10938948,10938950,10938951,10938953,10938955,10938958,10938964,10938965,10938972,10938973,10938984,10938985,10939011,10939023,10939036,10939040,10939041,10939042,10939115,10939130,10939131,10939132,10939133,10939134,10939135,10939136,10939137,10939139,10939140,10939141,10939142,10939143,10939144,10939145,10939151,10939155,10939156,10939157,10939158,10939162,10939165,10939166,10939168,10939169,10939174,10939185,10939194,10939199,10939200,10939209,10939210,10939219,10939222,10939224,10939225,10939229,10939230,10939231,10939232,10939235,10939236,10939237,10939238,10939239,10939241,10939242,10939243,10939244,10939245,10939246,10939248,10939249,10939251,10939254,10939255,10939256,10939257,10939258,10939259,10939260,10939262,10939263,10939264,10939265,10939266,10939271,10939273,10939275,10939276,10939279,10939280,10939281,10939282,10939285,10939286,10939287,10939288,10939289,10939290,10939291,10939292,10939293,10939294,10939295,10939296,10939298,10939299,10939301,10939302,10939303,10939304,10939305,10939307,10939308,10939310,10939311,10939312,10939313,10939315,10939316,10939317,10939318,10939319,10939321,10939325,10939326,10939327,10939329,10939332,10939337,10939338,10939339,10939340,10939341,10939342,10939344,10939345,10939346,10939347,10939348,10939349,10939350,10939351,10939352,10939353,10939354,10939355,10939357,10939358,10939359,10939360,10939380,10939381,10939382,10939383,10939384,10939385,10939393,10939423,10939440,10939487,10939488,10939501,10939502,10939503,10939504,10939505,10939508,10939509,10939512,10939513,10939514,10939515,10939516,10939519,10939520,10939521,10939525,10939526,8065794,8065795,8065798,8065799,8065837,8065838,8065839,8065840,8065841,8065842,8970177,3656389,8073547,10623061,10623064,10623065,10623069,10623098,10623235,10623310,10623311,10623312,10623313,10623314,10623315,10623316,10623317,10623318,10623319,10623320,10623321,10623322,10623323,10623324,10623325,10623326,10623327,10623328,10623329,10623330,10623331,10623332,10623333,10623334,10623335,10623336,10623337,10623338,10623339,10623340,10623341,10623342,10623343,10623344,10623345,10623346,10623347,10623348,10623349,10623350,10623351,10623352,10623353,10623354,10623355,10623356,10623357,10623358,10623359,10623360,10623361,10623362,10623363,10623364,10623365,10623366,10623367,10623368,10623369,10623370,10623371,10623372,10623373,10623374,10623375,10623376,10623377,10623378,10623379,10623380,10623381,10623382,10623383,10623384,10623385,10623386,10623387,10623388,10623389,10623390,10623391,10623392,10623393,10623394,10623395,10623396,10623397,10623398,10623399,10623400,10623401,10623402,10623403,10623404,10623405,10623406,10623407,10623408,10623409,10623410,10623411,10623412,10623413,10623414,10623415,10623416,10623417,10623418,10623419,10623420,10623421,10623422,10623423,10623424,10623425,10623426,10623427,10623428,10623429,10623430,10623431,10623432,10623433,10623434,10623435,10623436,10623437,10623438,10623439,10623440,10623441,10623442,10623443,10623444,10623445,10623446,10623447,10623448,10623449,10623450,10623451,10623452,10623453,10623454,10623455,10623456,10623457,10623458,10623459,10623460,10623461,10623462,10623463,10623464,10623465,10623466,10623467,10623468,10623469,10623470,10623471,10623472,10623473,10623474,10623475,10623476,10623477,10623505,10623508,10623510,10623511,10623512,10623515,10623524,10623525,10623526,10623529,10623544,10623545,10623546,10623550,10623554,10623555,10623556,10623558,10623559,10623560,10623561,10623562,10623563,10623564,10623587,10623588,10623589,10623590,10623632,10623633,10623634,10624898,10624901,10624902,10624904,10624905,10624906,10624907,10624910,10624911,10624912,10624913,10624914,10624919,10621966,10621971,10621972,10621975,10622155,10622156,10622157,10622169,10622170,10622171,10622172,10622185,10622188,10622197,10622199,10622345,10622346,10622347,10622348,10622349,10622350,10622351,10622352,10622353,10622354,10622355,10622356,10622357,10622358,10622359,10622363,10622384,10622385,10622386,10622387,10622388,10622389,10622390,10622391,10622392,10622393,10622394,10622395,10622396,10622397,10622398,10622536,10622772,10622927,10620164,10620186,10620187,10620188,10620189,10620190,10620191,10620192,10620193,10620194,10620195,10620196,10620197,10620198,10620199,10620200,10620201,10620202,10620203,10620204,10620205,10620206,10620207,10620208,10620213,10620214,10620232,10620253,10620254,10620255,10620256,10620257,10620258,10620259,10620267,10620283,10620284,10620285,10620327,10620441,10620442,10620443,10620444,10620465,10620467,10620483,10620537,10620538,10620540,10620563,10620585,10620591,10620592,10620593,10620594,10620595,10620596,10620597,10620598,10620599,10620600,10620601,10620602,10620603,10620604,10620605,10620606,10620607,10620608,10620609,10620610,10620611,10620612,10620613,10620614,10620615,10620616,10620617,10620618,10620619,10620620,10620621,10620622,10620623,10620628,10620708,10620742,10620747,10620764,10620855,10620856,10620933,10620934,10620935,10620936,10620964,10620981,10620982,10621103,10621229,10621649,10621751,10621957,10621959,10621960,10611000,10611001,10611002,10611003,10611004,10611005,10565700,10565701,10565702,10565703,10565704,10565705,10565706,10563556,10563557,10563558,10564549,10564550,10564551,10564838,10564839,10419252,10419253,10419254,10419266,10419267,10419268,10419269,10419270,10419271,10419272,10419273,10419274,10419275,10419276,10419277,10419278,10419279,10419280,10419281,10419282,10419283,10419284,10419285,10419287,10419288,10419292,10419293,10419294,10419295,10419296,10419299,10419407,10419408,10419501,10419502,10419503,10419504,10419505,10419506,10419507,10419508,10419511,10419512,10419513,10419514,10419516,10419517,10419518,10419519,10419520,10419524,10419525,10419526,10419527,10419536,10419537,10471134,10471135,10471136,10471167,10469900,10469957,10469958,10469959,10469960,10469961,10469962,10469963,10469964,10469965,10469966,10469967,10469968,10469969,10469970,10469971,10469972,10469973,10469974,10469975,10469976,10469977,10469978,10469979,10469980,10469981,10469982,10469983,10469984,10469985,10469986,10469987,10469988,10469989,10469990,10469991,10469992,10469993,10469994,10469995,10469996,10469997,10469998,10469999,10470000,10470001,10470002,10470003,10470004,10470005,10470006,10470007,10470008,10470009,10470010,10470011,10470012,10470013,10470014,10470015,10470016,10470017,10470018,10470019,10470020,10470021,10470022,10470023,10470024,10470025,10470026,10470027,10470028,10470029,10470030,10470031,10470032,10470033,10470034,10470035,10470036,10470037,10470038,10470039,10470040,10470041,10470042,10470043,10470044,10470045,10470046,10470047,10470048,10470049,10470050,10470051,10470052,10470053,10470054,10470055,10470056,10470057,10470087,10470088,10470695,10470724,10470735,10470736,10470737,10470738,10470739,10470740,10470741,10470742,10470743,10470744,10470745,10470746,10470747,10470748,10470749,10470750,10470751,10470752,10470753,10470754,10470755,10470756,10470757,10470758,10470759,10470760,10470761,10470762,10470763,10470764,10470765,10470766,10470767,10470768,10470769,10470770,10470771,10470772,10470773,10470774,10470775,10470776,10470777,10470778,10470779,10470780,10470781,10470782,10470783,10470784,10470785,10470786,10470787,10470788,10470789,10470790,10470791,10470792,10470793,10470794,10470795,10470796,10470797,10470798) 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'