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(10447910,10447911,10447912,10447913,10447914,10447915,10447916,10447917,10447918,10447919,10447920,10447921,10447922,10447923,10963860,10963861,10437339,10437340,10437341,10437342,10437343,10437344,10437345,10437346,8575808,8575809,8575810,8575811,8575812,8575813,8575814,8575815,8575816,8575817,8575818,8575819,8575820,8575821,8575822,8575823,8575824,8575825,8575826,10103090,10103091,10103092,10103093,10103094,10103095,10931965,10931966,10931967,10931968,10931969,10931970,10931971,10931972,10931973,10931974,10931975,10931976,10931977,10931978,10931979,10931980,10931981,10931982,10931983,10931984,10931985,10931986,10931987,10931988,10931989,10931990,10931991,10931992,8836445,8836446,8836447,8836448,8836449,8836450,8836451,8836452,8836453,8836454,8836455,10997683,10997684,10997685,10997686,10997687,10997688,10997689,10997690,10997691,10997692,10997693,10997694,10997695,10997696,10997697,10997698,10997699,10997700,10997701,10997702,10997703,10997704,10997705,10997706,10997707,10997708,10997709,10997710,10997711,10997712,10997713,10997714,10997715,10997716,10997717,10997718,10997719,10997720,10997721,10997722,10997723,10997724,10997725,10997726,10997727,10997728,10997729,10997730,10997731,10997732,10997733,10997734,10997735,10997736,10997737,10997738,10997739,10997740,10997741,10997742,10997743,10997744,10997745,10997746,10997747,10997748,10997749,10997750,10997751,10997752,10997753,10997754,10997755,10997756,10997757,10997758,10997759,10997760,10997761,10997762,10997763,10997764,10997765,10997766,10997767,10997768,10997769,10997770,10997771,10997772,10997773,10997774,10997775,10997776,10997777,8910166,8910167,8910168,8910169,8910170,8910171,8910172,8910173,8910174,8910175,8910176,8910177,8910178,8910179,8910180,8910181,8910182,8910183,11049027,8910184,11049028,8910185,8910186,11049029,11049030,8910187,11049031,11049032,11049033,11049034,11049035,11049036,11049037,11049038,11049039,11049040,11049041,11049042,11049043,11049044,11049045,11049046,11049047,11049048,11049049,7071832,7071833,7071834,7071835,7071836,7071837,7071838,7071839,7071840,7071841,7071842,7071843,7071844,7071845,7071846,7071847,7071848,7071849,7071850,7071851,7071852,7071853,7071854,7071855,7071856,7071857,7071858,8615763,8615764,8615765,8615782,8615783,8615784,8615785,8615786,8615787,8615788,8615789,8615790,8615791,8615792,8615793,8615794,8615795,8615796,8615797,8615798,8615799,8615800,8615801,8615802,8615803,8615804,8615805,8615806,8615807,8615808,8615809,8615810,8615811,8615812,8615813,8615814,8615815,8615816,8615817,8615818,10942164,10942165,10942166,10942167,10942168,10942169,10942170,10942171,10942172,10942173,10942174,10942175,10942176,10942177,10942178,10942179,10942180,8070995,8070996,8070997,8070998,8070999,8071000,8071001,8071002,8071003,8071004,8071005,8071006,8071007,8071008,8071009,8071010,8570042,10951776,10951777,10714286,10714287,10714288,10714289,10714290,10714291,10714292,8864346,8864347,8864348,8864349,8864350,8864351,7057802,7057803,7057804,7057805,7057806,7057807,4973437,9190436,9190437,9190438,9190439,9190440,9190441,9190442,9190443,9190444,9190445,9190446,9190447,9190448,9190449,9190450,9190451,9190452,9190453,9190454,9190455,9190456,9190457,9190458,9190459,9190460,9190461,9190462,9190463,9190464,9190465,9190466,9190467,9190468,9190469,9190470,9190471,9190472,9190473,9190474,9190475,9190476,9190477,9190478,9190479,9190480,9190481,9190482,9190483,9190484,9190485,9190486,9190487,9190488,9190489,9190490,9190491,9190492,9190493,9190494,9190495,9190496,9190497,9190498,9190499,9190500,9190501,9190502,9190503,9190504,9190505,9190506,9190507,9190508,9190509,9190510,9190511,9190512,9190513,9190514,9190515,9190516,9190517,9190518,9190519,9190520,9190521,9190522,9190523,9190524,9190525,9190526,9190527,9190528,9190529,9190530,9190531,9190532,9190533,9190534,9190535,9190536,9190537,9190538,9190539,9190540,9190541,9190542,9190543,9190544,9190545,9190546,9190547,9190548,9190549,9190550,9190551,9190552,9190553,9190554,9190555,9190556,9190557,9190558,9190559,9190560,9190561,9190562,9190563,9190564,9190565,9190566,9190567,9190568,9190569,9190570,9190571,9190572,9190573,9190574,9190575,9190576,9190577,9190578,9190579,9190580,9190581,9190582,9190583,9190584,9190585,9190586,9190587,9190588,9190589,9190590,9190591,9190592,9190593,9190594,9190595,9190596,9190597,9190598,9190599,9190600,8917350,8917351,8917352,8917353,8917354,8917355,8917356,7001107,7001108,7001109,7001110,10173103,10173104,10173105,10173106,10173107,10173108,10540084,10540085,10540086,10540087,10540088,10540089,10540090,10540091,10540092,10540093,10540094,10540095,10540096,10540097,10540098,10540099,10540100,10540101,10540102,10540103,10540104,10540105,10540106,10540107,10540108,10540109,10540110,10540111,10540112,10540113,10540114,10540115,10540116,10540117,10540118,10540119,10540120,10540121,10540122,10540123,10540124,10540125,10540126,10540127,10540128,10540129,10540130,10540131,10540132,10540133,10540134,10540135,10540136,10540137,10540138,10540139,10540140,10540141,10540142,10540143,10540144,10540145,10540146,10540147,10540148,10540149,10540150,10540151,10540152,10540153,10540154,10540155,10540156,10540157,10540158,10540159,10540160,10540161,10540162,10540163,10540164,10540165,10540166,10540167,10540168,10540169,10540170,10540171,10540172,10540173,10540174,10540175,10540176,10540177,10540178,10540179,10540180,10540181,10540182,10540183,10540184,10540185,10540186,10540187,10540188,10540189,10540190,10540191,10540192,10540193,10540194,10540195,10540196,10540197,10540198,10540199,10540200,10540201,10540202,10540203,10540204,10540205,10540206,10540207,10540208,10540209,10540210,10540211,10540212,10540213,10540214,10540215,10540216,10540217,10540218,10540219,10540220,10540221,10540222,10540223,10540224,10540225,10540226,10540227,10540228,10540229,10540230,10540231,10540232,10540233,10540234,10540235,10540236,10540237,10540238,10540239,10540240,10540241,10540242,10540243,10540244,10540245,10540246,10540247,10540248,10540249,10540250,10540251,10540252,10540253,10540254,10540255,10540256,10540257,10540258,10540259,10540260,10540261,10540262,10540263,10540264,10540265,10540266,10540267,10540268,10540269,10540270,10540271,10540272,10540273,10540274,10540275,10540276,10540277,10540278,10540279,10540280,10540281,10540282,10540283,10540284,10540285,10540286,10540287,10540288,10540289,10540290,10540291,10540292,10540293,10540294,10540295,10540296,10540297,10540298,10540299,10540300,10540301,10540302,10540303,10540304,10540305,10540306,10540307,10540308,10540309,10540310,10540311,10540312,10540313,10540314,10540315,10540316,10540317,10540318,10540319,10540320,10540321,10540322,10540323,10540324,10540325,10540326,10540327,10540328,10540329,10540330,10540331,10540332,10540333,10540334,10540335,10540336,10540337,10540338,10540339,10540340,10540341,10540342,10540343,10540344,10540345,10540346,10540347,10540348,10540349,10540350,10540351,10540352,10540353,10540354,10540355,10540356,10540357,10540358,10540359,10540360,10540361,10540362,10540363,10540364,10540365,10540366,10540367,10540368,10540369,10540370,10540371,10540372,10540373,10540374,10540375,10540376,10540377,10540378,10540379,10540380,10540381,10540382,10540383,10540384,10540385,10540386,10540387,10540388,10540389,10540390,10540391,10540392,10540393,10540394,10540395,10540396,10540397,10540398,10540399,10540400,10540401,10540402,10540403,10540404,10540405,10540406,10540407,10540408,10540409,10540410,10540411,10540412,10540413,10540414,10540415,10540416,10540417,10540418,10540419,10540420,10540421,10540422,10540423,10540424,10540425,10540426,10540427,10540428,10540429,10540430,10540431,10540432,10540433,10540434,10540435,10540436,10540437,10540438,10540439,10540440,10540441,10540442,10540443,10540444,10540445,10540446,10540447,10540448,10540449,10540450,10540451,10540452,10540453,10540454,10540455,10540456,10540457,10540458,10540459,10540460,10540461,10540462,10540463,10540464,10540465,10540466,10540467,10540468,10540469,10540470,10540471,10540472,10540473,10540474,10540475,10540476,10540477,10540478,10540479,10540480,10540481,10540482,10540483,10540484,10540485,10540486,10540487,10540488,10422564,10422565,10422566,10422567,10422568,10422569,10422570,10422571,10422572,10422573,10422574,10422575,10422576,10422577,10422578,10422579,10422580,10422581,10422582,10422583,10422584,10489551,10489552,10489553,10489554,10489555,10489556,10489557,10489558,10489559,10489560,10489561,10489562,10489563,10489564,10489565,10489566,10489567,10489568,10489569,10489570,10489571,10489572,10472852,10472853,10472854,10472855,10472856,10472857,10472858,10472859,10472860,10472861,10472862,10472863,10472864,10472865,10472866,10472867,10472868,10472869,10472870) 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'