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(3228423,3228424,10861375,8838607,10930406,7068250,7076319,10870791,10848801,10848821,10848822,10848823,10848824,8569567,10848887,10848895,10963373,10963374,10963375,10963376,10963377,10848989,10848990,10849002,10849007,3229190,10849069,11041519,10963526,10963527,10963528,10963529,10963532,10963533,10963534,10963535,10963536,10963537,10963538,10963539,10963540,10963541,10874144,10963542,10963543,10963544,10963545,10963546,10963547,10963548,10963549,10963550,10963551,10963552,10963553,10963554,10963555,10963556,10963557,10963558,10963560,10963562,10963563,10963564,10963565,11041607,7065943,11041671,11041672,10871386,8632034,10862802,3229971,7066680,11042366,10847508,10863052,10863211,3227406,10869316,10869317,8619937,10872434,10961947,11039953,11039972,11039973,8620169,11001120,11001129,11001130,11001131,11040212,11040261,10939410,10962569,10870187,7075904,10866393,8835686,7201483,8627910,8627911,8627915,8627916,10843093,10973130,10843217,10858804,8836024,10999253,8559576,8559577,10858964,8559688,8559689,10999473,8559750,7202137,7202139,7202140,10843764,10843767,8628766,8628851,8628852,8628853,8628854,8628855,8628856,7202478,10104418,7202566,7065365,10859675,10932773,10867816,8629251,10841714,8616843,8616845,10857306,3927520,3927521,10997850,8558234,10959114,10865790,7071625,6000024,7200987,10943413,7201037,7201043,7201049,7201056,7201062,7201128,7201129,10863320,10863321,10855356,7198408,8624848,8624850,11034996,10863629,8625124,10855916,10855917,10855918,10855943,10855944,10864053,10864055,10856068,10864082,8625689,11009753,11009754,10941708,10840843,3656662,10941930,10941983,3236805,3236806,3236807,3236808,3236809,3236810,3236811,3236812,3236813,11048373,10841271,10864830,7070584,11010509,10928596,8612913,11045779,11045780,11045781,11045782,11045783,11045784,11045785,3923504,11019829,11045833,11045839,11045840,11045875,11045876,11045877,10837962,10618289,11045998,11045999,11046000,11046001,11046002,11046003,11046004,11046005,11046006,11046007,7196631,8906563,8906630,8554558,8906853,10618941,10618942,10618943,11046637,11046640,11046660,11046661,11046689,11046690,11046691,8613909,11046794,11046804,11046807,11046812,11046828,11046829,11046830,11046833,11046841,11046843,11046844,11046848,11046852,11046866,7197609,7197641,7197642,7197643,7197687,3234932,3234933,7197770,7197771,3234983,8907725,11047356,11047357,11047358,11047359,8555733,11044699,10617109,10992770,10992771,10992772,10992773,10992774,10992822,11044825,8905207,10992863,11044874,11044878,11044879,11044880,11044881,11044882,11044883,8541808,10993055,10993314,10993372,10993375,10993376,10993399,10993401,10993402,10622811,10622812,10853141,10951605,10615063,10615080,10915614,10915615,10620116,10847957,10964981,8633198,8633307,10965356,10615803,10991527,10426224,8633617,8904220,8904226,8904227,8540806,8540807,10616548,8541050,8541127,8541130,10427109,8541258,8904847,11044531,10992566,9189359,8567861,10611141,9213552,9213553,9221544,9213581,9213582,10614255,9213593,7019259,6669829,6669842,6669843,9213639,9213658,9189660,9213663,9213664,6669880,6669881,9213749,9213750,10614463,10614476,10559628,9213878,10122078,9916176,9189972,10122228,10122229,10122253,10122254,10122255,10611949,7057516,9187360,9187361,9187362,9187387,9187388,9211479,9211480,10612195,10612196,10612197,10612198,7057755,7057756,7057757,10609269,9211629,9211630,9211631,10609360,9171732,9171734,9179823,9179827,9179832,8851662,8851680,7058072,7058073,7058074,7058087,7017667,7017668,7017669,7017670,10609700,7058245,10612759,10612760,10612797,7058305,10609829,9196363,9212425,9212430,9196440,9212464,9212465,9188508,9188526,9188527,9188577,10613297,10613304,6676896,6676897,6676898,10610386,10610387,9172776,10610486,10610491,9172926,9204938,9204939,10613892,9189248,9177327,10125565,7023053,10125633,7023119,10517285,8849351,8849353,8849366,8849367,9185608,9185626,9185639,9185653,7055871,9911978,7015464,7015465,9185850,10126055,10126099,10126111,10126125,10126192,10126193,10517812,9186026,9186049,10118257,9912269,9186315,9186316,9186489,9186490,9186517,7024176,9186544,9912761,9186600,7024387,10118955,9186782,10516646,10516647,10516648,10516649,10516650,10119154,10119155,10119166,10119167,10119179,7024823,10517097,10517098,10517099,10517100,10517101,10517102,10517103,10517104,9168320,7021999,10416365,10419393,10419396,7014145,7014146,9168509,6680876,7022347,7014450,7014451,10428177,10428178,10428179,7022455,10416758,8848700,10416849,10416850,10416851,7022661,7014712,10418996,9193137,9193138,9193139,9193140,9193141,9193142,7022815,9193170,7022915,10125483,10125484,8864934,10122676,6670775,9916919,8854721,9199018,9199020,10123232,3963415,10467985,10468019,8917091,10468044,10468045,10468063,976337,10468141,10464216,10464217,8847468,8847485,8847486,8847508,8847522,8847523,8847524,8847525,8847526,8847527,10470294,9207761,9207762,9207763,9207764,8847626,9175802,8847641,8847642,8847643,8847644,8847645,8847646,9175837,8847674,9191859,8847698,8847699,8847700,8847701,8847702,8847703,8847704,8847705,8847706,6474216,7021581,8847753,8847946,8847947,7021795,9176261,10888580,10908618,10898683,10903831,10908890,10155690,10170915,10884971,10884972,10884973,10158700,10882702,10627323,10163871,10882893,10158989,10159007,10179254,10627790,10627792,10627793,10176636,10176648,10905987,10167015,10177046,10876039,10177062,10172069,10172107,10949012,10911223,10187299,10891386,10182466,10182467,10167533,10187579,10187580,10187581,10187597,10177766,10177896,10188262,10163279,10950146,10887445,10601145,10601164,10602051,10608597,10598806,10598807,10598926,10598939,10587006,10599006,10599007,10599008,10599009,10599010,10599040,10599058,10599059,10599060,10599061,10584093,10584094,10584095,10584096,10584097,10584098,10599162,10599163,10599236,10599237,10599238,10599239,10599301,10599302,10599309,10599332,10599333,10603510,10603513,10590827,10590828,10590829,10590830,10590831,10590832,10590833,10647983,10603835,10603836,10603837,10603838,10603839,10600210,10591446,10591447,10591448,10591464,10645595,10645596,10604409,10604412,10604421,10604456,10601495,10601496,10601499,10604521,10601527,10601528,10601529,10601530,10601531,10601532,10601533,10601534,10600684,10600685,10600686,10601551,10601561,10604580,10591745,10601645,10648859,10601650,10601651,10648863,10648864,10591826,10591827,10601680,10601681,10579836,10579837,10579838,10579839,10579840,10601692,10601693,10601694,10601695,10601701,10601712,10600985,10600986,10600987,10586027,10601947,10601109,10601110,10601111,10533122,10543154,10543155,10543156,10521263,10521324,10521325,10531344,10537454,10537455,10537456,10537457,10537458,10537459,10537460,10537461,10537462,10537463,10537464,10533503,10531530,10531531,10521576,10521577,10521578,10521579,10521580,10549650,10549651,10521844,10529973,10529976,10529977,10532004,10532151,10532152,10532153,10532154,10532155,10532156,10532157,10532158,10532159,10532160,10532161,10532162,10532163,10528191,10534270,10532315,10532316,10544372,10544373,10532410,10522515,10522516,10538522,10530602,10530603,10530604,10530605,10546638,10546639,10546640,10546641,10546642,10546643,10546644,10546645,10546646,10546647,10546648,10546649,10546650,10546651,10530653,10522728,10538742,10532844,10532845,10532846,10532847,10532848,10520855,10538942,10538943,10538962,10538963,10538964,10538965,10538966,10538967,10530986,10530987,10531020,10533103,10422430,10421520,10421521,10420525,10505445,10507499,10508543,10508555,10508556,10505594,10507597,10424732,10508685,10422860,10424867,10507844,10507845,10422024,10507923,10480883,10493887,10493888,10409350,10413358,10477088,10477089,10477090,10479268,10486305,10412070,10414105,10492953,10410537,10476304,10411048,10411049,10411050,10411051,10411052,10411053,10478727,10411199) 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'