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(4970273,4970274,4970487,4970488,4970489,4970490,4970491,4970492,4970493,4970639,4970640,4970641,4970655,4970669,4970677,4970682,4970699,4970700,4970702,4970718,4970724,4970729,4970741,4970742,4970745,4970759,4970785,4970797,4970857,4970858,4970873,4970878,4970883,4970891,4970892,4970898,4970912,4970913,4970914,4970923,4970924,4970927,4970933,4970934,4970953,4970964,4970966,4970983,4970985,4970987,4970988,4970990,4970995,4971007,4971008,4971022,4971023,4971028,4971046,4971047,4971048,4971059,4971073,4971074,4971075,4971076,4971095,4971096,4971103,4971138,4971139,4971140,4971141,4971142,4971145,4971146,4971147,4968179,4968193,4968194,4968218,4968248,4968249,4968250,4968251,4968252,4968253,4968340,4968412,4968602,4968701,4968702,4968703,4968704,4968705,4968706,4968707,4968708,4968709,4968710,4968711,4968712,4968713,4968714,4968715,4968785,4968812,4968813,4968844,4968846,4968925,4968985,4968986,4968987,4968988,4969185,4969186,4969187,4969188,4969285,4969286,4969287,4969288,4969324,4969325,4969327,4969328,4969329,4969343,4969591,4969594,4969625,4969626,4969627,4969644,4969645,4969646,4969647,4969704,4969705,4969706,4969707,4969708,4969709,4969970,4969971,4969972,4969973,4969974,4969975,4969976,4969977,4969978,4970043,4970044,4970045,4970046,4970047,4970048,4970049,8074684,8074685,8074686,8074687,8074688,8074689,8074690,8074691,8074692,8074693,8074694,8074695,8074696,8074697,8074698,8074699,8074700,8074701,8074702,8074703,8074704,8074705,8074727,8074728,8074729,8074730,8074731,8074732,8074733,8074734,8074735,8074736,8074737,8074738,8074739,8074740,8074741,8074742,8074743,8074744,8074745,8074746,8074747,8074946,8074947,8074948,8074949,8074950,8074951,8074952,8074953,8074954,8074955,8074956,8074957,8074958,8074959,8074960,8074961,8074962,8074963,8074964,8074965,8074966,8074967,8074968,8074969,8074970,8074971,8074972,8074973,8074974,8074975,8074976,8074977,8074978,8074979,8074980,8074981,8074982,8074983,8074984,8074985,8074986,8074987,8074988,8074989,8074990,8074991,8074992,8074993,8074994,8074995,8074996,8074997,8074998,8074999,8075000,8075001,8075002,8075003,8075004,8075005,8075006,8075007,8075008,8075009,8075010,8075011,8075012,8075013,8075014,8075015,8075016,8075017,8075018,8075019,8075020,8075021,8075022,8075023,8075024,8075025,8075026,8075027,8075028,8075029,8075030,8075031,8075032,8075033,8075235,8075236,8075237,8075238,8075239,8075240,8075241,8075242,8075243,8075264,8075265,8075272,8075289,8075337,8075338,8075342,8075343,8075344,8075345,8075346,8075347,8075348,8075349,8075350,8075351,8075352,8075353,8075354,8075355,8075356,8075357,8075358,8075359,8075360,8075361,8075362,8075363,8075364,8075365,8075366,8075367,8075368,8075369,8075488,8075491,8075492,8075493,8075533,8075538,4967028,4967033,4967034,4967036,4967037,4967038,4967039,4967040,4967041,4967056,4967101,4967104,4967120,4967132,4967149,4967150,4967164,4967165,4967166,4967170,4967185,4967192,4967196,4967197,4967204,4967206,4967210,4967232,4967234,4967240,4967242,4967260,4967261,4967262,4967263,4967268,4967275,4967278,4967283,4967303,4967332,4967333,4967334,4967335,4967336,4967362,4967366,4967392,4967408,4967409,4967410,4967411,4967412,4967424,4967425,4967426,4967427,4967428,4967429,4967430,4967431,4967432,4967433,4967434,4967435,4967436,4967445,4967453,4967454,4967455,4967456,4967476,4967478,4967489,4967490,4967491,4967492,4967493,4967494,4967495,4967496,4967511,4967512,4967513,4967514,4967516,4967517,4967518,4967519,4967520,4967521,4967522,4967523,4967524,4967525,4967526,4967527,4967528,4967529,4967530,4967531,4967532,4967533,4967534,4967535,4967545,4967571,4967572,4967573,4967593,4967594,4967595,4967603,4967610,4967623,4967638,4967644,4967645,4967656,4967660,4967686,4967732,4967762,4967774,4967775,4967776,4967777,4967778,4967779,4967780,4967781,4967782,4967783,4967784,4967785,4967786,4967787,4967788,4967789,4967790,4967791,4967792,4967793,4967794,4967795,4967796,4967797,4967798,4967799,4967800,4967801,4967802,4967803,4967804,4967805,4967806,4967807,4967808,4967809,4967810,4967811,4967812,4967813,4967814,4967815,4967816,4967817,4967818,4967827,4967835,4967839,4967840,4967841,4967842,4967843,4967844,4967845,4967846,4967847,4967848,4967849,4967850,4967851,4967852,4967853,4967854,4967855,4967856,4967857,4967858,4967859,4967860,4967861,4967886,4967890,4967900,4967904,4967922,4967923,4967939,4967940,4967945,4967960,4967963,4967967,4967968,4967971,4967987,4967992,4967996,4968007,4968028,4968052,4968053,4968055,8073686,8073687,8073688,8073689,8073690,8073691,8073692,8073693,8073694,8073695,8073740,8073741,8073742,8073743,8073744,8073745,8073746,8073747,8073748,8073792,8073793,8073794,8073795,8073796,8073797,8073798,8073841,8073842,8073843,8073844,8073845,8073846,8073847,8073888,8073889,8073890,8073891,8073892,8073893,8073894,8073933,8073934,8073935,8073936,8073937,8073938,8073939,8073940,8073979,8073980,8073981,8073982,8073983,8073984,8073985,8074025,8074026,8074027,8074028,8074029,8074030,8072163,8072164,8072165,8072166,8072167,8072168,8072169,8072170,8072171,8072172,8072173,8072174,8072175,8072176,8072177,8072178,8072179,8072180,8072181,8072182,8072183,8072184,8072185,8072186,8072187,8072188,8072189,8072190,8072191,8072192,8072193,8072194,8072195,8072196,8072197,8072198,8072199,8072200,8072201,8072202,8072203,8072204,8072205,8072206,8072207,8072208,8072209,8072210,8072211,8072212,8072213,8072214,8072215,8072216,8072217,8072218,8072219,8072220,8072221,8072222,8072223,8072224,8072225,8072226,8072227,8072318,8072319,8072320,8072321,8072322,8072360,8072366,8072377,8072381,8072388,8072394,8072399,8072403,8072409,8072415,8072419,8072425,8072427,8072440,8072441,8072445,8072452,8072457,8072467,8072468,8072567,8072568,8072569,8072570,8072571,8072648,8072649,8072650,8072651,8072652,8072653,8072654,8072655,8072656,8072657,8072668,8072669,8072670,8072671,8072672,8072673,8072674,8072675,8072676,8072677,8072693,8072694,8072695,8072696,8072697,8072703,8072704,8072705,8072706,8072707,8072708,8072709,8072710,8072711,8072712,8072723,8072724,8072725,8072726,8072727,8072728,8072729,8072730,8072731,8072732,8072748,8072749,8072750,8072751,8072752,8072768,8072769,8072770,8072771,8072772,8072773,8072774,8072775,8072776,8072777,8072917,8072918,8072919,8072920,8072921,8072922,8072923,8072924,8072932,8072933,8072997,8073039,8073040,8073041,8073042,8073043,8073052,8073053,8073059,8073448,8073491,8073503,8073504,8073505,8073506,8073507,8073508,8073509,8073510,8073511,8073517,8073518,8073519,8073520,8073533,8073537,8073542,8073543,8073550,8073551,8073586,8073587,8073588,8073589,8073590,8073591,8073592,8073593,8073635,8073636,8073637,8073638,8073639,8073640,8073641,10622962,10622965,10622993,10622994,10622995,10623016,10623017,10623018,10623019,10623020,10623021,10623037,10623040,10623041,10623043,10623055,10623058,10623061,10623096,10623099,10623102,10623103,10623113,10623114,10623115,10623257,10623296,10623297,10623298,10623299,10623301,10623303,10623305,10623306,10623307,10623308,10623309,10623318,10623368,10623407,10623412,10623459,10623491,10623492,10623493,10623503,10623612,10623700,10623715,10623716,10623717,10623729,10623735,10623770,10623790,10623791,10623792,10623793,10623794,10623795,10623796,10623797,10623798,10623799,10623800,10623802,10623803,10623804,10623806,10623859,10623874,10623880,10623887,10623888,10623889,10623890,10623891,10623892,10623893,10623894,10623895,10623896,10623897,10623898,10623899,10623900,10623901,10623902,10623903,10623904,10623905,10623906,10623907,10623919,10623926,10623927,10624091,10624092,10624093,10624094,10624095,10624096,10624097,10624098,10624099,10624100,10624101,10624102,10624103,10624119,10624121,10624135,10624136,10624137,10624138,10624139,10624140,10624141,10624142,10624143,10624144,10624145,10624146,10624147,10624148,10624149,10624150,10624151,10624152,10624153,10624154,10624155,10624156,10624157,10624169,10624170,10624171,10624172,10624173,10624174,10624175,10624193,10624260,10624266,10624267,10624268,10624325,10624404,10624405,10624406,10624407,10624408,10624409,10624410,10624427,10624507,10624558,10624559,10624566,10624585,10624587,10624588,10624589,10624590,10624591,10624592,10624593,10624594,10624595,10624596,10624597,10624598,10624599,10624600) 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'