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(10962666,10962668,10962669,10939609,10962675,10845986,10845987,10846015,8630938,8630939,8630943,8630948,7076360,10448300,10989177,8631176,8621401,7068748,7068749,7068772,7068786,7068794,8569851,8569852,8569853,8569854,8569855,8569856,8569857,8569858,8621718,8569859,11041641,11041642,8631857,8631858,10950936,8067324,8575611,7074736,3230163,3230179,3230180,3230181,9216568,8619775,3227391,3227392,3227400,10844743,8629693,8619915,8629748,10498038,10498039,10498060,8620148,8620336,8068459,8068460,8630286,8630287,8630311,8630312,8630436,8630443,8630469,10939458,7201203,7201204,8627823,8627862,10843007,10843008,11037975,10843057,10843116,8628052,8628053,8628346,8628353,8836217,8628424,8628463,7202126,7202127,7202131,7202136,7202138,7202161,7202196,7202197,7202205,7202206,7072984,7202248,7202249,7202250,7202251,7073021,7073022,8628786,8628787,8628788,8628789,8628802,8595839,5654554,8595877,8836766,8066452,8066453,8066454,8066472,8629242,8629301,3227097,11048945,8626779,8626780,8617017,8626894,8910449,8910450,8910451,10943153,10943154,7071652,8617597,8617598,8617599,10985497,10985498,10985499,8910894,7201107,7068937,8624585,7068991,8615105,8615106,8615107,8615109,8615137,3925918,3926008,3926083,3236291,8625584,8625585,8625597,8564805,8564865,10840935,10941820,10941828,10941834,10941861,10941877,10941886,8909339,8909340,8626094,10841265,10841266,8909590,8909591,11048567,8626336,8626337,8626338,8626339,8626340,8909790,3927164,10942441,10942483,10942484,7070879,8909953,8909954,7070902,7070903,7070904,7070934,7070935,10622993,10622994,10622995,10622997,10622998,10622999,3233411,3233412,10623057,10918617,3923486,3923488,3923489,11045802,8906205,11045833,3923546,11045838,3923547,3923619,3923620,3923621,10928813,10928814,10928815,10928816,10928817,8906390,10918960,11007320,7196903,7196904,7196905,7196906,7196907,7196908,7196909,7196910,7196911,7196912,7196913,8613775,8613776,8613777,8613790,8613791,8907057,8907058,8907095,10619176,10919855,10919856,10919857,7197616,7197655,7197693,7197720,7197731,7197732,7197733,11047277,3235078,8624361,10619874,11044631,10992636,11044667,10992705,10992719,10992756,10992757,10992758,10992784,10992785,8612015,8612025,10992904,10992905,10992906,10992999,11045025,11045028,11045029,10622425,10993085,10993086,10922938,10993087,10922939,10922940,10922941,10922942,10993181,10993202,10993260,10993304,8542204,11006480,11006527,10622939,10622940,3230390,8570019,10920603,8632766,10920677,8632786,10620212,10615236,10920780,10991123,8576644,8633191,10425934,10425935,10425936,10425937,10425938,10425939,10425940,10425941,10425942,10425943,8576814,10921281,8633461,8633477,10991542,10991543,10991561,10921606,10926771,10926772,10926773,10926774,10926775,10621363,10621364,10621365,10621366,10621373,10992046,10992047,10992109,10992110,8634105,8634126,8634127,8634130,8634134,8634135,8634138,8634144,8634145,8634148,8634149,8634159,8634160,8634162,8634165,8634166,8634168,8634169,8634367,8634369,8634372,8634373,8634374,8634381,8634382,8634383,8634384,8634392,8634393,8634394,8634396,8634397,8634398,8634399,8634400,10992463,10992464,10992465,10992466,10992467,8634440,8634441,8634446,10992595,10992596,10992607,10992608,10992609,10992610,10992611,10992618,10992619,10559340,10714183,10122188,10122220,10122221,10122222,9214034,10122244,10122245,10122246,10614786,8853950,10122322,10614808,10614809,10614810,7057477,7057478,7057479,9203326,9203327,9203328,9203329,9203330,7057498,7057500,10612105,9195453,9195454,9203524,9203525,9187824,8851764,8851765,9211945,9203954,9203955,9212049,9212051,9188131,9204143,9196206,10120444,10120445,10120446,10120447,9188261,9204276,9204277,10612993,10613023,9212381,9212382,9212383,9212384,9172470,9172475,9172511,10613201,10613233,8852440,10610282,10610289,8852496,10558537,10558538,10558539,8567244,8567245,8567246,8567247,8567248,7058930,9196861,8863457,8863458,8863459,8863460,8863461,8852784,8852785,8852787,8852788,8852790,8852792,8852795,8852798,8852800,8852802,8852906,8852907,8852910,8852911,8852914,8852915,10564995,9173227,9185357,9193617,9177639,8849616,8849778,8849785,8849786,9185981,10126180,10126181,10126182,10515812,10515813,10515844,10515845,10515846,10515847,10515848,10515849,10515850,10515851,10515852,10515853,10515854,10515855,10515856,10515857,10515858,10515859,10515860,10515861,10515862,10515863,10515864,10515865,10515866,10515867,10515868,10515897,9186084,10515898,10515899,10515900,10515901,10515902,10513916,10515960,10515961,10515962,10515963,9186165,9186166,9186194,10516014,10516015,10516016,10516017,10516018,10516019,10516020,10516021,10516022,10516023,10516024,10516025,10516026,10516027,10516028,10516029,9202295,9186382,9186395,9186479,9186560,9186614,9194644,9186672,9186677,9186744,9186829,9186830,9194914,9203109,9203147,9195147,9195148,9195149,10517004,10517005,10517024,9187263,10515104,10416277,10418323,10418326,10415377,6680776,8848410,9200748,10419908,10419909,10419910,10419911,10419912,10419913,10419914,10419915,10419916,10419918,10419919,10419920,10419922,9169002,10419924,10419926,10419927,10419928,10419929,10419930,10419931,10419932,10419933,10419934,10419935,10419939,10419940,10419941,10419943,10419945,10419946,10419947,10419948,10419949,10419950,10415961,9209105,8849107,6678514,10122760,3962914,3962917,3962921,3962923,9190642,6666961,6666963,6666964,6666965,10469754,10469755,10465796,10465797,10465798,10465799,10123419,10465800,10465801,10465802,10465803,10465804,10465805,10465806,10465807,10465808,10465809,10465810,10465811,10465812,10465813,10465814,10465815,10465816,10465817,10465818,10465819,10465820,10465821,10465822,10465823,10465824,10465825,10465826,10465827,10465828,10465829,10465830,10465831,10465832,10469833,10465833,10465834,10469834,10465835,10469835,10465836,10465837,10465838,10465839,10465840,10465841,10465842,10465843,10465844,10465845,10465846,10465847,10465848,10465849,10465850,10465851,10465852,10465853,10465854,10465855,6667326,10468006,10468025,10468050,10468065,10468109,8847399,8917290,10470407,9207841,9207842,9207843,9175843,10470529,8847800,10124480,10124481,10893506,10893507,10893508,10893511,10893630,10893631,10628151,10903692,10628240,10628241,10174771,8593825,8593826,10179968,10179994,10884074,10180213,10904522,10884598,10180625,10180626,10180627,10180628,10180629,8069023,10904740,8069125,8069126,8069127,8069128,8069129,10899885,10899886,10180981,10905114,10181253,10890322,10890323,10890325,10890327,10890328,10183484,10631993,10631995,10631996,10631997,10631998,10631999,10632000,10632003,10632004,10632005,10632008,10632009,10632015,10632019,10632020,10632021,10632022,10632023,10632025,10632026,10632028,10168656,10168657,10168658,10168659,10168660,10627144,10632172,10632173,10632174,10632175,10632176,10632177,10632178,10632179,10632180,10632181,10632182,10632183,10632184,10632185,10897757,10897758,10897759,10897760,10897761,10897762,10897763,10888199,10903403,10181521,10630065,10181972,10181973,10181974,10182068,10182069,10182070,10630653,10162193,10172207,10182235,10891301,10891302,10891303,10182390,10177422,10891446,10891449,10182491,10182492,10949303,10949304,10949305,10949306,10949307,10949308,10182651,10182823,10182824,10182947,10182948,10631457,10183004,10626547,10183085,10183157,10188303,10183337,10183396,10183481,10586595,10649671,10649672,10649677,10574824,10652957,10652958,10574964,10574965,10575465,10575696,10575697,10575698,10576004,10648234,10591539,10591540,10591541,10591542,10591543,10591544,10591545,10591546,10576563,10576564,10576565,10576566,10576567,10576568,10576569,10576570,10576571,10576572,10576573,10576574,10576575,10531557,10531558,10531574,10531575,10531576,10531577,10531578,10531598,10531599,10531600,10531601,10531602,10531603,10531604,10531605,10531606,10531632,10531633,10531641,10531642,10539717,10531718,10531816,10531817,10531881,10529889,10529890,10531969,10536099,10536100,10536101,10536102,10530294,10530295,10530296,10530297,10532348,10530380,10536423,10536424,10536425,10536426,10522597,10532663,10534681,10530711,10530712,10530782,10530798,10524820,10524821,10530841,10530842,10530843,10530844,10530845,10530846,10530847,10530848,10530849,10530850,10530851,10530888,10526938,10526939,10547089,10420222,10420223,10420224,10420228,10420230,10420231,10420233,10420236,10420238,10420239,10420240,10420433,10424931,10424936,10424944,10424945,10424957,10424959,10424963,10424972,10424973,10424976,10424984,10424986,10421055,10424063,10422108,10422146,10485990,10485991,10494036,10488184,10488199,10479275,10479320,10479321,10409877,10409878,10409882,10409883,10409884,10479906,10479907,10479908,10481976,10408640,10408641,10408642,10493416,10407050,10407051,10409068,10409069,10493764) 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'