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(10939563,8068891,7076252,7076254,7076276,7076277,7068288,7068289,7076290,7076292,7076297,7068300,7076333,7076334,7076335,7068348,7068351,7068352,4970865,4970930,4970931,4970932,4970941,4970942,7068620,4970959,7068634,4970985,7068666,7068667,4971034,4971035,4971036,7068795,7068798,10976571,10976572,7074109,7074152,7074153,7074154,7074155,7074269,8067597,8067667,8067692,7066659,7066660,7066661,7066662,7066663,7066664,10437610,10990368,7074841,8067850,10961945,10987975,7067453,7067544,7067545,10985572,10985573,10985574,10985575,10985576,10985581,10985582,10972693,10972711,10972712,7064029,10972914,7064263,7064308,7072341,7072342,10986027,7072346,10999062,10986062,10986080,7072413,7072414,10973160,10973168,10973169,10973170,10973182,10973183,10986199,10986200,7072578,7072602,10973347,7072757,7072801,7072802,7072803,10986509,10986510,7072892,7072949,7072960,7073013,7073051,7073052,7073066,7073067,7073108,8066294,7065378,11000147,7070960,7070992,7071015,7071017,7071023,7071028,10942746,7071051,7071052,10942792,10942855,7071170,10942905,8861108,10942979,10942980,10972155,10985285,7071605,7071607,10985326,10943367,10943382,7071700,10972434,10985459,10985460,10985461,10985462,10985463,10985464,10985465,10985466,10985467,10985468,10985469,10985470,10985471,10985472,3655587,10969709,10940839,10940865,7069224,10969927,10969928,10969985,7069390,10970105,10970106,10970107,10970311,10970381,10970382,10970383,10970384,10970629,10970630,10941712,10941713,10941714,10941715,10941716,10941717,10941718,10941719,10941720,10941721,10941722,10970692,10941723,10941724,10970693,10970694,10941725,10941726,10970695,10941785,7070071,7070099,7070100,7070101,10996873,10996874,10996875,10970888,10970889,10941940,10970931,10941971,10942041,10942042,10942043,10971084,10971246,3657269,3657270,8073496,8073522,7070670,10971357,10971397,10971398,7070749,10942489,10923545,10923546,10618037,10618038,10923567,10618069,10618101,10618102,10618116,10923629,10618137,10618138,10918656,10923657,10923658,10923659,10923734,10923735,10923736,10923737,10923738,10923739,10923740,10923741,10993798,10923883,10923884,10923885,10923886,10993950,10993951,10993952,10993953,10993954,10993955,10993984,10993985,10993986,10993987,10993988,10993989,10993990,10993991,10993992,10993993,10993994,10993995,10993996,10993997,10993998,10993999,10994000,10994001,10994002,10994003,10994004,10923978,10923979,10924060,10924061,10924062,10924138,10924139,10924140,10924141,10924142,10924143,10924144,10924145,10924146,10924147,10924228,10924229,10919239,10919240,10919241,10919242,10919243,10924254,10924294,10924391,10924392,10924393,10924394,10924395,10924396,10924397,10924398,10924399,10924400,10924401,10924613,10924614,10924615,10924616,10924617,10924618,10924619,10924620,10924621,10924622,10968676,10968786,10968787,10968788,10968789,10968790,10968791,10968792,10968793,10968794,10968795,10924790,10924791,10924792,10924793,10924794,10924795,10924796,10924797,10924798,10924799,10924880,10924881,10924882,10924883,10924884,10924885,10924886,10924887,10924888,10924889,10924890,10924891,10924892,10981995,10981996,10925002,10925003,10925004,10925005,10925006,10925007,10925008,10925009,10969038,10969039,10969040,10969041,10969042,10969043,10969044,10969045,10969046,10969047,10969048,10969049,10969050,10925105,10925106,10925107,10925113,10925114,10925115,10925151,10925152,10925153,10925154,10925241,10925242,10925243,10925244,10925245,10925246,10925247,10925248,10925375,10917472,10616972,10992639,10922735,10922736,10922737,10992777,10992778,10992779,10922789,10922814,10922821,10922822,10922823,10922824,10922825,10922826,10922863,10922864,10922865,10922866,10622371,10992943,10992944,10992945,10993043,10993044,10993045,10928031,10918148,10918149,10918150,10923213,10918333,10918334,10617955,10925509,10920584,10920694,10990774,10990775,10920753,10920754,10925866,10920875,10615380,10620403,8570282,10615472,10921072,10921073,10921074,10921075,10965320,10965372,10965373,10921408,10921409,10965481,10921526,10991564,10991565,10991566,10921554,10921558,10921639,10991689,10991690,10991691,10991692,10991693,10991694,10991695,10991696,10991697,10991698,10991699,10991700,10991701,10991702,10921674,10991703,10991704,10991705,10991706,10991707,10991708,10991709,10991710,10991711,10991712,10991713,10991714,10991715,10991716,10991717,10991718,10991719,10991720,10991721,10991722,10991723,10991724,10991725,10991726,10991727,10991728,10991729,10991730,10991731,10991732,10991733,10991734,10991735,10991736,10991737,10991738,10991739,10991740,10991741,10991742,10991743,10991744,10991745,10621280,10978881,10921933,10921934,10921935,10921936,10921937,10922032,10953190,10992410,10992485,10917468,10917469,10917470,10917471,10565159,7059606,7059846,10611457,10611458,10611459,10562930,10562931,10562932,9171312,9171313,9171323,7057503,9171348,9171515,9171516,9171517,9171518,9171519,9171520,10557337,10557451,10557452,10557453,10557454,10557509,10609419,10557638,10557803,10557804,7058179,7058204,7058213,7058217,7058383,10609947,10613079,8863146,7058871,7058872,8863233,8863261,10610463,7059148,7059157,10610726,7059271,7059285,4974175,4974176,4974177,4974178,9169467,4974327,10555410,10555411,10555412,10555413,10555414,10555415,10555416,10555417,10555418,10555419,10555420,10555421,10555422,10555423,7055786,7055787,7055813,10513498,10513499,10513500,10513501,10513502,10513503,10513530,10513531,7055909,7055961,4974760,4974795,4974796,4974797,10555825,10555826,10555827,10555828,4974881,4974882,4974883,4974884,4974885,4974886,4974887,4974919,7056312,10556273,10556274,10556275,10556276,10556277,10556278,10556279,10556280,10556281,10556282,10556283,10556284,10556285,10556286,10556287,10556288,10556289,10556290,10556445,10556528,10556529,10556530,10556701,10556702,10556703,10556704,7057151,9170997,9170998,9170999,7057192,7057199,7057263,9171143,9171149,10516964,10557021,10557022,10557023,10557024,10557025,10557026,10557027,10557028,10557029,10557030,10557031,10557032,10557033,10557034,10557035,10557036,10557037,10557038,10557039,10557040,10557041,10557042,10557043,10557044,10557045,10557046,10557047,10557048,10557049,10557050,10557051,10557052,10557053,9171284,7057454,10417109,10463014,10463015,10463016,10463017,10463018,10463019,10463020,10463021,10463022,10463023,10463024,10463025,10463026,10463027,10463028,10463029,10463030,10463031,10463032,10463033,10463034,10463035,10463036,10463037,10463038,6666560,6666588,4971488,4971489,10471223,10471232,10471233,4971547,4971548,4971595,10467359,10471498,6666927,6666929,10468115,10470377,10470481,10470589,8917914,10164484,10628014,10628023,10628072,10164780,10164878,10164985,10165052,10165053,10165188,10165189,10165190,10165392,10165548,10165549,10165550,10165551,10165685,10165686,10165855,10165889,10165958,10165959,10629719,10629720,10629721,10629756,10629792,10629793,10629872,10629873,10166423,10627007,10627008,10627009,10627010,10627011,10627672,10627690,10164229,10164230,10164231,10164232,10164477,10164478,10164479,10164480,10164481,10164482,10164483,10630223,10630224,10630225,10630363,10630383,10630456,10630504,10630613,10630656,10630657,10162542,10631024,10631038,10631039,10631040,10162590,10626204,10626205,10631207,10631208,10162783,10162784,10162830,10626314,10162837,10626325,10626326,10626327,10626332,10577209,10577210,10577211,10577212,10571408,10571409,10571410,10577411,10571411,10577412,10577413,10577414,10577415,10577416,10577417,10577418,10577419,10577420,10577421,10577422,10577423,10577424,10577425,10577426,10577427,10577765,10574780,10574781,10571799,10571800,10571801,10571802,10571803,10577848,10577849,10577850,10578059,10578060,10578061,10578062,10578063,10578064,10575153,10572263,10572523,10572524,10572525,10572526,10572527,10572528,10572529,10572530,10572531,10572532,10572533,10572534,10575543,10575678,10575679,10576194,10576195,10570549,10570550,10576690,10576691,10576692,10576693,10576694,10576695,10576696,10576965,10576966,10571062,10571063,10571064,10571065,10571066,10571067,10571068,10571069,10571070,10577102,10577103,10525123,10523123,10523193,10523216,10523249,10523250,10523252,10523253,10523260,10521263,10521324,10521325,10525383,10525384,10525385,10523413,10523418,10523419,10523420,10523421,10523422,10523423,10523424,10523425,10523426,10523427,10523434,10523435,10523436,10523437,10523438,10523439,10523440,10522214,10524219,10524220,10524221,10524222,10524223,10524224,10524225,10524226,10524227,10524228,10524314,10524315,10524316,10522501,10522518,10520826,10520827,10520828,10524880,10522942,10522950,10522951,10522952,10525072,10525100,10525101,10421270,10421980,10421981,10421982,10421983,10421984,10422985,10422007,10422008,10422038,10422039,10422050,10422064,10422171,10477211,10477213,10479587,10479781,10477951,10478011,10478064,10478112,10478166,10478222,10478504,10478505,10478506,10478507,10478508,10478509) 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'