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(10870248,10870266,10870295,7076081,7076083,10870393,10845931,8631040,10950683,8067150,8067151,8067152,8067157,8067158,10868537,8622404,7066668,7066669,10498080,8068481,8068490,10870003,10870008,10870009,10939410,10870145,7072176,7072178,7072180,7072273,7072274,7072275,10103463,10843177,10843181,10999277,10999278,10999291,10999292,10999293,10999294,10999295,10999296,10999297,10999298,10999299,10999300,10999310,10960685,7073169,10867548,10867549,11000129,11000130,8066485,8066486,10104818,4967996,11010628,7070944,11010641,11048927,10865386,10865387,10865400,7071594,7071596,7071597,7071603,7071604,7071610,7071611,7071612,7071613,7071615,10943302,10943304,10943306,10943308,10943309,10943324,10943388,10943407,7198323,7198325,7198327,7069369,7069370,7069372,10855669,10855673,7069389,10855678,10855679,10855682,10855683,10855684,10855685,10855693,10855701,10855702,10855710,10855711,10855712,10855718,10855719,10855722,10855723,10855724,10855725,10855730,10855733,10855734,10855736,10864082,10941708,10941869,10941889,8616108,8616110,10941983,7199779,10101759,10101761,7070655,7070657,7070658,7070659,7070661,7070663,7070664,7070667,7070719,7070721,7070722,7070723,7070726,8557856,3233432,3923443,11045812,11045813,11045814,10994517,10618941,10618942,10618943,11046660,11046661,11046690,11046691,7197486,7197489,7197490,7197498,7197501,7197504,7197507,7197508,7197511,7197519,7197522,7197528,7197531,7197532,7197536,7197537,7197542,11047049,10953676,10953677,10953678,10953679,10953680,3232499,3232500,3232501,10992774,3232645,8612090,10993314,10622661,10928237,10622829,10993518,11045608,11045609,11045610,11045611,11045612,11045613,11045614,10615444,8633213,10615597,10848337,10848338,10991337,10991338,10991339,10991340,10991343,10991344,10991345,10991346,10991347,10991354,10848501,10991527,8540597,8540735,8541126,10992566,3654735,9213582,9213663,9213664,9213696,9213697,9213698,9213699,9213750,9189820,9213822,9213823,9189823,9213824,9189824,10122078,9213935,8853822,8853823,8853824,8853825,10122228,10122253,10122254,10122255,9182288,9182289,10612193,9171531,9171532,9171533,9171534,9171535,7057717,10609269,10557529,10557530,8566538,10120282,10557977,9212190,9212343,10610403,10610406,10610407,10610409,10610410,10610412,10610414,9172787,10610909,6677470,9161374,9185376,9185377,9161378,9185379,9161379,9185380,9185381,9185382,9185383,9185386,9185390,9185391,9185392,9185393,9185398,9185399,9185400,9185401,9185402,9185407,9185408,9185409,9185410,9185413,9185415,9185416,9185417,9185418,9185421,9185422,9185423,9185424,9185425,9185426,9185429,9185430,9185431,9185435,10125633,9185436,9185437,9185438,9185439,9185440,9185441,9185442,9185443,9185455,9185456,9185457,9185458,9185459,9185460,9185461,9185462,9185463,9185464,9185465,9169465,9185473,9185474,9185475,7055871,9177805,9169822,9169867,10126111,10126150,9185954,10512115,10512116,10512117,9186315,6674531,7056497,7056498,7056499,7056500,8850192,8850199,8850200,8850203,8850205,8850208,8850211,8850214,8850215,9186489,9186506,9186545,10516646,10516647,10516648,10516649,10516650,10516651,10516652,10516653,10516663,10119149,10119150,10119151,10119152,10119153,10119154,10119155,10119156,10119162,10119163,10119164,10119165,10119166,10119167,10119168,10119169,10119170,10119171,10119172,10119174,10119175,10119176,10119177,10119178,10119179,9186982,10119180,10119181,10119182,9187013,9187048,9187049,9187065,9203127,10512969,4973179,4973180,4973181,4973182,4973183,4973184,4973185,4973186,4973187,4973188,4973189,10427897,10418685,10418686,10418700,10428177,10428178,10428179,10428180,10428181,10428182,10428183,10428184,10428185,10428186,10428187,10428188,10428189,9169033,9182323,9182324,9182325,9182326,9182330,9182331,9182332,9174752,10123161,10123175,10467842,10467843,10467844,10467847,10467849,10467852,10467853,10467855,10467856,10467860,10468391,10468482,10468483,10468495,9167986,6672213,9168075,10903474,10903475,10903476,10903481,10903482,10903484,10903485,10903486,10903487,10903488,10903489,10903490,10903494,10903495,10903496,10903497,10903498,10889067,10899902,10627012,10627013,10627014,10632170,10903432,10903433,10903434,10903435,10903436,10903437,10903438,10903439,10903441,10903442,10903443,10903444,10903445,10903446,10903447,10903448,10903449,10903450,10903451,10903452,10903453,10903454,10903455,10903456,10903460,10903461,10903462,10903463,10903464,10883464,10903465,10883465,10883467,10883469,10948484,10905971,10906056,10172068,10906057,10172069,10172070,10906093,10896382,10625920,10625921,10876875,10163279,10580158,10608101,10646637,10608513,10598939,10599006,10599007,10599290,10599339,10599367,10599368,10599384,10599385,10599939,10599940,10599941,10599942,10591149,10591150,10600436,10600437,10600438,10600439,10600440,10600573,10600574,10600575,10600576,10600577,10600578,10600579,10600684,10600685,10591725,10591745,10591746,10591749,10600824,10525121,10525122,10525124,10539174,10539175,10539176,10539177,10539178,10539179,10539180,10539181,10539182,10539183,10539186,10539187,10539188,10539189,10539190,10539191,10539192,10539193,10539194,10539200,10533210,10533211,10521258,10521260,10521261,10521263,10521264,10521269,10521270,10531344,10533369,10533462,10531527,10531528,10531529,10533586,10533587,10533588,10533589,10533627,10533628,10533629,10533630,10529735,10529736,10529737,10529738,10529739,10529740,10529741,10529742,10529743,10529744,10529745,10529746,10529747,10529748,10529755,10529756,10529757,10529759,10529760,10529761,10529762,10529763,10529765,10529766,10529767,10529768,10529769,10529770,10531773,10529780,10529781,10529782,10529783,10529784,10529785,10529786,10529787,10529788,10529789,10529793,10529794,10529824,10529825,10529826,10529827,10529828,10529829,10529830,10529831,10529832,10529976,10529977,10532004,10532410,10530478,10530479,10530480,10532519,10532520,10532521,10532522,10532523,10532524,10532525,10532526,10530655,10538742,10530986,10530987,10531020,10525083,10525084,10525085,10525086,10525087,10525088,10525089,10525090,10525091,10525092,10525093,10525094,10525095,10525096,10525097,10525098,10525099,10525105,10420324,10498366,10508603,10507761,10507900,10422054,10422089,10508019,10422139,10485907,10485908,8562382,8562510,10486240,10486242,10486274,10486305,10486338,10496836,10496842,10496845,10410826,10410830,10410835,10410837,10410838,10410839,10410840,10410849,10410850,10410860,10410867,10410868,10410869,10410874,10410875,10410878,10410879,10410880,10410881,10410887,10410890,10410891,10410895,10410896) 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'