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(7075937,7076001,7076002,8838545,10939898,7076397,7076398,7076399,7076400,7076401,11041170,11041206,11041207,11041208,11041209,11041210,11041211,11041212,11041213,11041214,11041215,11041216,11041217,11041218,11041219,11041220,11041221,11041222,11041223,11041224,8839145,10944340,7074203,7074204,7074205,7074206,7074207,7074208,7074209,7074210,7074211,7074212,7074213,7066240,7066241,7074296,10951196,10951227,11042465,8067831,8067943,7067548,11040245,11040246,11040247,11040248,11040249,11001254,11001255,11001256,11001257,11001258,11001259,11001260,7067585,8838232,8838233,8838236,8838237,7075914,8075292,8075297,8075305,10932054,8836207,8836371,8836372,8836373,10960609,10960610,10960611,10960612,10960613,10960614,10960615,10960616,10960617,10960618,10960619,10960965,10960966,10960967,10960968,10961099,10961100,10961101,10961102,10961103,10961104,10961105,10961106,8837047,10997795,10997796,10997797,10997798,10997799,10997800,10997801,10997802,10997803,10997804,10997805,10942754,11049302,7071460,10944865,10944866,10944867,10944868,10944869,10944870,10996260,3656280,11035965,11035966,11035967,11035968,11035969,11035970,11035971,11035972,11035973,11035974,11035975,11035976,11035977,11035978,11035979,11010126,11010127,11048373,11048374,11048375,11048376,11048377,11048378,10942162,10942163,3657276,11010436,11010437,11010438,11010439,11010440,11010441,11010442,11010443,11010444,11010445,11010446,11010447,11010448,7070848,10618182,10618183,10928804,10928805,10928806,10928807,10928808,10928809,10928810,11046109,11007852,10995157,10619874,11047551,11047552,11047553,11047554,11047555,11047556,11047557,10622054,10617066,11044740,11044741,11044742,10617171,10617198,10617332,10617456,10617464,10928002,10928003,10928004,11045212,11045213,11045214,10993349,10617737,10617746,10622924,10615179,10620253,10615281,10615284,10615349,10615350,10615353,10615354,10615356,8570311,10615435,10615462,10615463,10615464,10615467,10615468,10615469,10615470,10615473,10615549,10615581,10615709,10615723,10615724,10615725,10615726,10615727,10615728,10615729,10615730,10615731,10615732,10615733,10615734,10615735,10615736,10615737,10615738,10615739,10615740,10615741,10615742,10615743,10615744,10615745,10615746,10615747,10615748,10615749,10615750,10615751,10615752,10615753,10615754,10615755,10615756,10615757,10615758,10615759,10615760,10615761,10615762,10615763,10615764,10615765,10615766,10615767,10615768,10615769,10615770,10615771,10615772,10615773,10615774,10615775,10615776,10615777,10615778,10615779,10615780,10615781,10615782,10615783,10615784,10615785,10615786,10615787,10615788,10615789,10615790,10615791,10615792,10615793,10615794,10615795,10615796,10615797,10615798,10615799,10615800,10615801,10615802,10615803,10615804,10615805,10615807,10615808,10615809,10615810,10615811,10615812,10615813,10615814,10921973,10921974,10921975,10616655,9189444,9165549,10614355,9189711,7059886,10614502,10614538,10614563,10614633,10614765,10614766,10614767,10611830,10611831,10611891,10611892,8864754,8864788,6666285,6666286,6666287,10611980,10611982,10611984,10611986,10611987,10611988,10611991,10611992,10611993,10611994,10611998,10612005,10612006,10612074,10612075,10612076,10612125,10612223,10612224,10612234,10612235,10612236,10612254,10612255,10612256,10612257,10612291,10609348,10609350,10609351,10609352,10609357,10609358,10609359,10609362,10609363,10609364,10609367,10609376,10609377,10609378,10609385,10609386,10609389,10609400,10609724,10609772,10609782,10609835,10609836,10612987,10612988,10612989,10612990,10610000,10613034,10613056,10613057,10613058,10613060,10613061,10613062,10613063,10613066,10613075,10613078,10613142,10613143,10613145,10613152,10613153,10613154,10613155,10558305,10613156,10558306,10613158,10613162,10613163,10613166,10613168,10613169,10613170,10613171,10613172,10613174,10613175,10613176,10613177,10613178,10613179,10613180,10613191,10613192,10613197,10613198,10613201,10613208,10613209,10613210,10613214,10613215,10613220,10613221,10613225,10613232,10613233,10613234,10613251,10613254,10613258,10613259,10613260,10613265,10613266,7058776,7058777,7058778,7058779,7058780,10613292,10564458,10564459,10613316,10613317,10613334,10613335,10613343,10613364,9204784,9204785,9204786,9204787,9204788,9204789,9204790,9204791,9204792,9204793,9204794,9204795,9204796,10613565,9172951,9172952,9188997,9188998,9188999,10613676,10613677,10613695,10610696,10613696,10610697,10613722,10613736,10564989,10564990,10564991,10564992,10564993,10564994,10564995,10610868,9169300,9161399,9169527,9185538,9185539,9185540,9185541,7055731,7055733,9169779,4974643,4974644,4974645,10513714,4975292,4975293,7057163,7057244,10515087,10515088,10515089,10515090,10515091,10515092,10515093,7057446,10515094,10515095,10515096,10515097,9168341,8918061,9192512,8918335,10415664,10415667,7054942,9168799,9168863,9168864,9168876,9168920,9168954,7055264,9193253,9193254,9169270,7055444,9169289,9169290,8864841,6666466,6666472,9182543,9190644,9190645,9190646,8865260,4971639,4971640,4971641,4971642,6666802,9190954,6667132,6667166,6667167,8916862,8916863,6667270,6667271,6667272,6667273,6667274,6667275,6667349,6667365,6667366,6667367,6667368,6667369,6667370,10467952,10467953,10467954,10467955,10467956,10467957,10467958,10467959,10467960,10467961,10467962,10467963,10467964,10467965,10467966,10467967,10467968,10467969,10467970,10467971,10467972,10467973,10467974,10467975,10467976,10467977,10467978,10467979,10467980,10467981,10467982,10467983,10467984,10467985,10467986,10467987,10467988,10467989,10467990,10467991,10467992,10467993,10467994,10467995,10467996,10467997,10467998,10467999,10468000,10468001,10468002,10468003,10468004,10468005,10468006,10468007,10468008,10468009,10468010,10468011,10468012,10468013,10468014,10468015,10468016,10468017,10468018,10468019,10468020,10468021,10468022,10468023,10468024,10468025,10468026,10468027,10468028,10468029,10468030,10468031,10468032,10468033,10468034,10468035,10468036,10468037,10468038,10468039,10468040,10468041,10468042,10468043,10468044,10468045,10468046,10468047,10468048,10468049,10468050,10468051,10468052,10468053,10468054,10468055,10468056,10468057,10468058,10468059,10468060,10468061,10468062,10468063,10468064,10468065,10468066,10468067,10468068,10468069,10468070,10468071,10468072,10468073,10468074,10468075,10468076,10468077,10468078,10468079,10468080,10468081,10468082,10468083,10468084,10468085,10468086,10468087,10468088,10468089,10468090,10468091,10468092,10468093,10468094,10468095,10468096,10468097,10468098,10468099,10468100,9191524,10468101,10468102,10468103,10468104,10468105,10468106,10468107,10468108,10468109,10468110,10468111,10468112,10468113,10468114,10468115,10468116,10468117,10468118,10468119,10468120,6667599,6667600,6667601,6667602,6667604,6667605,8563544,6667662,6667663,6667683,6667684,6667685,8563608,6667858,6667862,6667877,6667878,6667891,6667892,6667894,6667895,6667896,6667897,6667898,6667899,6667900,6667901,9168022,9168023,9168024,6668107,6668108,6668109,6668156,9168167,9168168,6668177,6668178,10628786,10628787,10628788,10628789,10628790,10628791,10628792,10628793,10628794,10628795,10628796,10628797,10628798,10628799,10628800,10628801,10628802,10628803,10628804,10628805,10628806,10175911,10171161,10171175,10171176,10171180,10168689,10632205,10632206,10632207,10632208,10632309,10627713,10627714,10627715,10627716,10627717,10627718,10627719,10627720,10627721,10627722,10627723,10627740,10627751,10630023,10630024,10630025,10630026,10630027,10630028,10630029,10630030,10630031,10630032,10630033,10630034,10630035,10630036,10630037,10630038,10630039,10630040,10630041,10630042,10630043,10630044,10630045,10630046,10630047,10630048,10630049,10630050,10630051,10630052,10630053,10630054,10630055,10630056,10630057,10630058,10630059,10630060,10630061,10630062,10630063,10630064,10630065,10630066,10630067,10630068,10630069,10630070,10630071,10630072,10630073,10630074,10630075,10630076,10630077,10630078,10630079,10630080,10630081,10630082,10630083,10630084,10630085,10630086,10630087,10630088,10630089,10630090,10630091,10630092,10630093,10630094,10630095,10630096,10630097,10630098,10630099,10630100,10630101,10630102,10630103,10630104,10630105,10630106,10630107,10630108,10630109,10630110,10630111,10630112,10630113,10630114,10630115,10630116,10630117,10630118,10166675,10630654,10625860,10625869,10626447,10626449,10626452,10626453,10626454,10580113,10580233,10580234,10580235,10580728,10580729,10580730,10580731,10580732,10579490,10579491,10579492,10579493,10579494,10579495,10582505,10582506,10582507,10582508,10582509,10582510,10582511,10582512,10582513,10579735,10579736,10579737,10521594,10523658,10522152,10528866,10528867,10528872,10528873,10528874,10528875,10528876,10528879,10528880,10528881,10528882,10528883,10528887,10528888,10528889,10524893,10522903,10423621,10423627,10423994,10424008,10424014,10477143,10477144) 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'