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(10963439,8569776,8569777,8569778,8569779,8569780,8569781,8569782,8569783,8569784,8569785,7068825,7068826,10940512,10940516,10940555,8067655,10437569,8067790,7074864,7074865,7074866,11001191,8068600,8068601,8068605,8068606,8068607,8068608,8068609,8068635,8068636,8068637,8068638,8068639,8068640,8068641,8068642,8068643,8068644,8068687,8068688,8068704,8068705,8068729,10974168,10974169,10974170,10932925,8066558,8066559,8066560,8066575,8066576,8066577,8066578,8066579,8066580,10932952,10932964,10932967,10932979,10932980,10932986,10933000,8066659,8066660,8066661,8066662,8066663,8066664,8066665,8066666,8066667,8066668,8066669,8066670,8066671,8066672,8066673,8066674,8066675,8066676,8066677,8066678,8066679,8066680,8066769,8066770,8066771,8066772,8066773,8066774,8066775,8066776,8066777,8066778,8066779,8066780,8066781,8066782,8066783,8066784,8066785,8066786,8066787,8066788,8066835,8066836,8066837,8066838,8066839,8066840,8066841,8066842,8066843,8066844,8066845,8066846,8066847,8066848,8066887,8066890,11048934,10942960,10942961,10942962,11049296,11049297,10940566,10940567,3655533,7069020,7069030,7069038,7069054,7069056,7069066,3656337,8072552,8072553,3656393,8072584,8072585,3656471,3656472,3656473,3656474,3656475,3656476,3656477,8072698,8072699,8072700,8072701,8072702,11048696,10980833,10980834,10980835,10980836,10980837,10980838,10980839,10980840,10980841,10980842,10980843,10980844,10980845,10980846,10980847,10980848,10980849,10980850,10980851,10980852,10980853,10980854,10980855,10980856,10980857,10980858,10980859,10980860,10980861,10980862,10980863,10980864,10980865,10980866,10980867,10980868,10980869,10980891,10980904,10980996,10980997,10980998,10980999,10981000,10981001,10981002,10981003,10981004,10981005,10981006,10981007,10981008,10981009,10981010,10981011,10981012,10981013,10981014,10981015,10981016,10981017,10981018,10981019,10981020,10981021,10981022,10981023,10981024,10981025,10981026,10981027,10981028,10981029,10981030,10981031,10981032,10981033,10981034,10981035,10981093,10981094,10981095,10981096,10981097,10981098,10981116,10981117,10981118,10981233,10981236,10924281,10924282,10924283,10924284,10924285,10924286,10924287,10924288,10924289,10924290,10924291,10924292,10924293,10924294,10924295,10924296,10924297,10924298,10924299,10924300,10924301,10924302,10924303,10924304,10924305,10924306,10618890,10619062,8071133,10979620,10979621,10979622,10979623,10979624,10979625,10979626,10979627,10979628,10979629,10979630,10979631,10979632,10979633,10979634,10979635,10979636,10979637,10979638,10979639,10979640,10979641,10979642,10979643,10979644,10979645,10979646,10979647,10979648,10979649,10979650,10979651,10979652,10979653,10979654,10979655,10979656,10979657,10979658,10979659,10979660,10979661,10979662,10979663,10979664,10979665,10979666,10979667,10979668,10979669,10979670,10979671,10979672,10979673,10979674,10979675,10979676,10979677,10979678,10979679,10979680,10979681,10979682,10979683,10979684,10979685,10979686,10979687,10979688,10979689,10979690,10979691,10979692,10979693,10979694,10617127,10979965,10979966,10979967,10954006,10980150,10980151,10980152,10980153,10980154,10980155,10980156,10980157,10980158,10980159,10980160,10980161,10980162,10980163,10980164,10980165,10980166,10980167,10980168,10980169,10980170,10980171,10980172,10980173,10980174,10980175,10980176,10980177,10980178,10980179,10980180,10980181,10980182,10980183,10980184,10980185,10980186,10980187,10980188,10980189,10980190,10980191,10980192,10980193,10980194,10980195,10980196,10980197,10980198,10980199,10980200,10980201,10980202,10980203,10980204,10980205,10980206,10980207,10980208,10980209,10980210,10980211,10980212,10980213,10980214,10980215,10980216,10980217,10980218,10980219,10980220,10980221,10980222,10980223,10980224,10980225,10980226,10980227,10980228,10980229,10980230,10980231,10980232,10980453,10980454,10980455,10980456,10980457,10980458,10980459,10980460,10980461,10980462,10980463,10980464,10980465,10991015,10930761,10930764,10615835,10616411,10616412,10616413,10621422,10621423,10621432,10621433,10621434,10621440,10621441,10621442,10621443,10621453,10621454,10621497,10621502,10621503,10621504,10979162,10979163,10979164,10979165,10979166,10979167,10979168,10621511,10979169,10621512,10979170,10979171,10979172,10979173,10979174,10979175,10979176,10979177,10979178,10979179,10979180,10979181,10979182,10979183,10979184,10979185,10979186,10621534,10621610,10621611,10621612,10621613,10621614,10621615,10621616,10621617,10621618,10621619,10992278,10992279,10992280,10992281,10992282,10992283,10992284,10992285,10621627,10992286,10621628,10992287,10992288,10621647,10979317,10979318,10979319,10979320,10979321,10979322,10979323,10979324,10979325,10621667,10979326,10979327,10979328,10979329,10979330,10979331,10979332,10979333,10979334,10979335,10979336,10979337,10979338,10979339,10979340,10979341,10979342,10979343,10979344,10979345,10979346,10979347,10979348,10979349,10979350,10979351,10621695,10621717,10979430,10979431,10979432,10979433,10979434,10979435,10979436,10979437,10979438,10979439,10979440,10979441,10979442,10979443,10979444,10979445,10979446,10979447,10979448,10979449,10922435,10979607,10979608,10979609,10979610,10979611,10979612,10979613,10979614,10979615,10979616,10621958,10979617,10979618,10979619,7059643,6665790,6665791,6665792,9173936,9174185,9179348,9179349,9179350,9179351,9179352,9179353,9179451,9179452,9179453,9179454,9179455,9179456,9179457,9179458,9179459,9179560,9179561,9179570,9179571,7057828,9179677,9179678,9179679,9179680,9179681,9179682,9179683,9179684,9179685,9179686,9179687,9179688,9179689,9179690,9179691,9179795,9179796,9179814,10613367,10613368,7058934,7058935,7058937,7059200,7059201,7059202,7059203,7059204,7059205,7059206,7059207,7059208,7059209,7059210,7059211,7059212,7059213,7059214,7059215,7059216,7059217,7059218,7059219,7059220,7059221,7059222,7059223,7059224,7059225,7059226,7059227,7059228,7059229,7059230,7059231,7059232,7059233,7059234,7059235,7059236,7059237,7059238,7059239,7059240,7059241,7059242,7059243,7059244,7059245,7059246,7059247,7059248,7059249,8863606,7059250,8863607,7059251,8863608,7059252,8863609,7059253,8863610,7059254,8863611,7059255,8863612,7059256,8863613,7059257,7059258,7059259,7059260,7059261,7059262,7059263,7059264,7059265,7059266,7059267,7059268,7059269,7059270,7059271,7059272,7059273,7059274,7059275,7059276,7059277,7059278,7059279,7059280,7059281,7059282,7059283,7059284,9161376,9161539,9161540,9161541,9161596,9161597,9161598,4974690,10513752,9178192,9178193,9178194,9178195,9178196,9178197,9178198,9178199,9178200,9178201,9178202,9178203,9178204,7056530,7056531,7056532,7056533,7056579,7056620,7056621,7056622,7056623,7056624,7056625,7056626,7056627,7056628,7056629,7056630,7056631,7056632,7056633,7056634,7056635,7056636,7056637,7056793,7056830,7056831,7056862,7056863,7056864,7056865,2809386,2809388,2809390,2809391,2809403,2809405,2809413,2809414,9179203,9179204,9179205,9179206,9179264,9179265,9179266,9179267,9179268,9179269,9179270,9179271,9179272,9179273,9179274,9179275,9179276,7054927,10415892,10415893,10415894,10415895,4971162,4971163,6666969,6666985,6666988,6666992,9175049,4972135,4972136,4972137,4972138,4972139,4972140,4972141,4972142,4972143,4972144,4972145,4972146,4972147,4972148,4972149,4972150,4972151,4972152,4972153,4972154,4972165,4972200,4972201,4972206,6667364,4972230,4972236,4972237,4972260,4972261,4972267,9175435,8917207,8917212,8917472,8917867,10628146,10628147,10169874,10628475,10163507,10163508,10163509,10163510,10163511,10163512,10627952,10630481,10167434,10167435,10167436,10167437,10167438,10167439,10167440,10167441,10167442,10167443,10630963,10630964,10630965,10630966,10630967,10630968,10630969,10630970,10630971,10630972,10630973,10630974,10630975,10630976,10162520,10525402,10525403,10523728,10523729,10523730,10523731,10523732,10523733,10523734,10523735,10523738,10523739,10523767,10523768,10523769,10523770,10523771,10523772,10523773,10523774,10523775,10523776,10523777,10523778,10523825,10523826,10523827,10523844,10523845,10420317,10420318,10423038,10423043,10423044,10422071,10422072,10422103,10421108,10421109,10421123,10421128,10421135,10475650,10473917,10473918,10473919,10473920,10473921,10473922,10473980,10473981,10479995,10479998,10480006,10480007,10480021,10480029,10480030,10480037,10480038,10480039,10474059,10480075,10480076,10480077,10480078,10480079,10480088,10480124,10480141,10480145,10480157,10480162,10480163,10480164,10480165,10480166,10480167,10480182,10480195,10480221,10480222,10480230,10480231,10480232,10480237,10480238,10480239,10480248,10480249,10480261,10480262,10480263,10480267,10480268,10480269,10480276) 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'