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(11014508,7075897,10943434,10943435,7067940,7067941,10873260,3228393,8838476,10845818,7076100,10930387,8594625,10943672,11014966,10870757,10448362,10870794,10448382,8569503,10873828,8621456,8621457,10459297,3229163,10874053,10459340,10459370,11041541,11041542,11015563,11015564,11015565,11015566,7073882,11041656,8067274,10849605,10849606,10849607,10849608,10849609,10849610,10849611,10849612,10849613,10849614,10849615,10849616,10849617,10849618,10849619,10849620,10849621,10849622,10847093,10847094,8622188,8622189,8622191,8622192,8622193,8622194,8622200,8622250,10862744,11016157,11016190,11016191,9216186,8575763,8575764,3230021,8584191,10938480,10938481,7066813,11013526,11013527,11013528,11013529,11013530,11013531,11013532,3227408,3227419,8619845,8629669,7075030,7075031,7075080,10872415,8837691,7067216,10938931,7067217,8573414,8573415,8561244,10939071,10962154,10929924,10962376,7067745,7067802,10998532,6000220,8594664,7064057,7064058,7064059,7064060,7064061,7064062,7064063,7064064,10931854,7072648,7072649,7072650,11012350,8595343,7201962,10843493,8595408,8595409,10859131,8065976,8065977,8065978,8065979,8065980,10999609,10999610,10999611,10999626,8628590,8628591,10843778,7073028,7073029,3899561,8619094,8560266,8560270,8560275,10104565,10104604,11013436,11013437,10933198,11010547,8063957,8063958,8063959,8063960,8063961,8063962,8063963,8063964,8063965,8063966,8063967,8063968,8063969,8063970,8063971,8063972,8063973,8063974,8063975,8063976,8063977,8063978,8063979,8063980,8063981,8063982,3927440,3927459,3927652,3927653,3927654,3927655,10943133,10943135,10998121,10998122,8834997,10959257,10857954,8617611,11011469,11011470,11011471,3238232,10957376,10957466,10957467,3656488,10856146,3236374,3236375,3236383,11022830,11022831,10864494,11023001,11023002,10942114,10942115,8860487,3927004,7070707,3927128,10101871,10101872,10101874,7156380,10954690,10954923,10954924,3923748,10968083,10968251,11033542,11033543,8554990,8070925,10619300,10619301,10619302,10619303,10619304,10619305,10619328,10619329,8907271,8907272,10919950,10919951,7197598,10995155,10922481,10852237,11044704,8611878,8611905,11006168,7156052,7156053,10837543,10964538,10964539,10964540,10964541,10964542,10964543,10964544,10964545,10964548,10920607,10920608,10920609,10425362,10425363,10425364,10425365,10425366,10425367,10425368,10425369,10425370,10425371,10425372,10425373,10925878,10920901,10615451,10926046,10926047,10926048,10926049,10926050,10926051,10926052,10930508,9217416,10930723,10952452,3582236,10921517,10965551,8610827,10426402,10931015,10952832,10952833,10952834,10952835,10952836,10952837,11044051,8611363,8611370,8552539,8552540,10922464,10927464,7027004,9915739,6669966,6669967,6669968,6669969,6669970,6669971,6669972,6669973,6669974,6669975,6669976,6669977,6669978,6669979,6669980,6669981,6669982,6669983,6669984,6669985,6669986,6669987,6669988,6669989,6669990,6669991,6669992,6669993,6669994,6669995,6669996,6669997,9173800,9173843,9173844,9173845,9173846,8864674,7019942,9211343,9211349,7025064,9211579,9219605,10119841,9211786,7057959,9171984,7018009,7018246,7026324,7026359,9188718,9188719,9164759,9164760,9164761,9164762,9164763,7026502,7018506,7026527,9188942,9915306,9189109,6677342,7026829,8567798,10660164,9161481,9161482,10117831,10125853,10125860,9185667,9185668,8849507,8849508,8592935,10513618,7023660,8551337,9912283,9912284,9912287,7023742,7023743,7023744,7023745,7023746,7023747,7023748,7023749,7023750,7023751,7023752,7023753,7023754,7023755,4974954,4974955,7023756,7023757,7023758,7023759,7023760,7023761,7023762,7023763,7023799,4975003,4975004,3285813,9912504,3285968,3286051,2809070,2809071,3651722,8850351,10556395,10556396,10556397,10556398,10556399,10556400,2809328,10518818,10518819,10518820,10518821,8565546,8565547,8565548,8565549,8565550,8565551,8565552,8565553,8565554,8565555,8565556,8565557,8565558,8565559,8565560,8565561,10119330,9179194,9179195,9179196,9179197,7022021,9160378,9160379,9160380,9160381,9160382,9160383,9160384,9160385,9160386,9160387,9160388,9160389,9160390,9160391,9160392,9160393,9160394,9160395,9160396,9160397,9160398,9160399,7022181,8918200,8918202,4973667,10417804,9209032,7022741,9201141,10125354,10125356,10125357,10125370,10465108,8865166,9190707,6670930,8549918,7020462,10123010,10123011,10123012,10123013,8916634,8854924,8916782,8916789,9191161,6679399,3963596,9191284,6679517,6665648,6665649,6665650,6665651,6665652,6665653,6665654,6665655,6665669,10115643,10115644,10115645,10115646,10115647,10115648,10115649,10115650,10115651,10115652,10115653,10115654,10115655,10115656,10115657,10115658,10115659,10115660,10115661,10115662,8917123,9207584,9207585,9207586,8917325,9199748,9199749,9199750,9199778,7021441,6474103,6474116,6474179,9167964,10462555,10462556,10462557,10462558,10462559,10462560,10462561,10462562,10462563,10462564,10462565,10462566,10462567,8917751,9176160,10159504,10159512,10159513,10159514,10159515,10888710,10159843,10888854,10169894,10909133,10909134,10909135,10909136,8594248,10884488,10884607,10909699,10909700,10894782,10894783,8069145,8069146,10155830,10155831,10629346,10629347,10879870,10629506,10629507,10629512,10875134,10875135,10875136,10875137,10875138,10875139,10875140,10875141,10875142,10875143,10875144,10875145,10875146,10875147,10875148,10875149,10875150,10875151,10875152,10875153,10875154,10875155,10875156,10875157,10875158,10875159,10875160,10875161,10875162,10875163,10875164,10875165,10875166,10875167,10875168,10875169,10875170,10875171,10875172,10875173,10875174,10875175,10875176,10875177,10915233,10915234,10915235,10905451,10183515,10183516,10183517,10912683,10912684,10912685,10912686,10912687,10168847,10882883,10153908,10153909,10153910,10153911,10153912,10153913,10153914,10153915,7001093,10153916,10153917,10153918,10153919,10153920,10153921,10153922,10153923,10153924,10153925,10164004,10893379,10893430,10171540,10905776,10161973,10172030,10172031,10172032,10172033,10172034,10187085,10162337,10162338,10177502,10177503,10881515,10172557,10172558,10172559,10172560,10172561,10172562,10172563,10172564,10172565,10172566,10177666,10177667,10631259,10631260,10631261,10187979,10187980,10631459,10187983,10187984,10187985,10187992,10187993,10882018,10892296,10892297,10892298,10892299,10892300,10892301,10892302,10892303,10892304,10892305,10892306,10892307,10892308,10892309,10631800,10892310,10631801,10631802,10631803,10631804,10631817,10631818,10631819,10945143,10945144,10945145,10945146,10945147,10945148,10945149,10945150,10945151,10945152,10945153,10945154,10945155,10945156,10945157,10945158,10945159,10945160,10945161,10945162,10945163,10945164,10173372,10173373,10173374,10173375,10173376,10173377,10173378,10173379,10173380,10173381,10173382,10173383,10163480,10605085,10605086,10602185,10602208,10602209,10605277,10643494,10643495,10602328,10602329,10602330,10602331,10602332,10602333,10602334,10602335,10602336,10602337,10602338,10602339,10602340,10602341,10602342,10602343,10602344,10602345,10602346,10602347,10602348,10602349,10598564,10583711,10583712,10583713,10583714,10583715,10583716,10583717,10583718,10583719,10583720,10644582,10644583,10644584,10644620,10644621,10644622,10644623,10584733,10584734,10584735,10584736,10654322,10654323,10651359,10651360,10648487,10651562,10648747,10645851,10645852,10645853,10645854,10652043,10543331,10529435,10529512,10529513,10529514,10529515,10529516,10537650,10537651,10545754,10545802,10534224,10538251,10534266,10548515,10548516,10548517,10548518,10548519,10548520,10522693,10522694,10522695,10544695,10522696,10522697,10520759,10552881,10552882,10552883,10552884,10552885,10552886,10552887,10552888,10552889,10552890,10552891,10552892,10552893,10552894,10552895,10552896,10552897,10552898,10552899,10552900,10552901,10552902,10552903,10552904,10552905,10552906,10552907,10552908,10552909,10552910,10422395,10422433,10424456,10505511,10505512,10505513,10505514,10505515,10505516,10505517,10505518,10498544,10505551,10509587,10409502,8562523,10413630,10492332,10407888,10481636,10481637,10481638,10495147,10495148,10495149,10412541,10489350,10489351,10476522,10476523,10407170,10407171,10407172,10407173,10407174,10407175,10407176,10407177,10407178,10407179,10407180,10407181,10407182) 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'