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(10873267,10873268,10873269,10939718,10939719,10939720,10939721,10939722,10962698,8838574,8838575,8838576,8838577,8838578,8838579,8838580,11014907,8630949,8630952,11015042,11015043,8621491,8621492,3229161,3229162,3229169,11041568,11041569,11041570,11041571,11041572,11041573,11041574,11041575,7073893,11015746,11015747,11015748,11015749,11015750,11015751,11015752,8067172,10868591,8622179,10847123,10437329,10437330,10847153,10862692,10871778,10849871,11016325,11016326,11016327,11016328,11016329,11016330,10938511,10938512,8560787,8560937,8067978,8067979,8067980,8067981,8067982,10844777,3227444,7067050,10929374,10929375,10929376,7075232,7075233,7075234,7075235,7075236,7075237,7075238,7075239,7067240,7075240,7075241,7067241,7075242,7067242,7067243,7075243,7067244,7075244,7075245,7067245,7075246,7067246,7075247,7067247,7075248,7067248,7075249,7067249,7067250,7075250,7067251,7075251,7067252,7075252,7067253,7067254,7067255,7067256,7067257,7067258,7067259,7067260,7067261,7067262,7067263,7067264,7067265,7067266,7067267,11027099,11001184,8591768,8591769,10929892,10929938,10869999,10870068,7071825,8617786,8617787,8617788,8594686,8594687,7064102,3238530,3238531,10842944,3898891,10866707,10866708,8911533,8911534,8911535,8911536,4967162,4967163,4967164,4967165,4967166,8066153,8066154,11012844,11012845,10932644,5654539,10932645,10104357,8560280,8560281,8560282,8560283,8560284,8619258,8066561,10844271,7073561,10867887,10867888,10867889,10867890,10867891,10867892,8596249,8596250,8596251,8596284,10841780,11024148,8861388,10865782,8835014,8835015,8835016,8835017,8835018,8835019,8835020,8835021,8835022,8970222,11021563,11021564,11021565,10944609,7069590,10996290,10996295,10996299,10996300,10996305,3656631,3656632,3656633,3656634,3236462,3236463,3236464,3236465,3236466,3236467,3236468,3236469,3236470,3236471,3236472,3236473,3236474,3236475,3236476,3236477,3236478,3236479,3236480,3236481,3236482,3236483,3236484,3236485,3236486,3236487,3236488,3236489,3236490,3236491,10864422,10840996,11035951,8565006,10942068,10841136,10856803,10864838,10864839,8557524,10942309,8860562,10101882,8579051,8579052,8579053,8579054,8579055,8579056,8579057,7196387,7196388,3923933,3923934,8555001,8555002,8555003,8555004,3234584,10619348,10619349,10619350,10619351,8907287,8907288,8907289,8907290,8907291,8907292,10839299,11044602,11031991,7156026,7156027,8612454,8612455,8612456,8612457,8612458,8612459,8612460,8612461,11006473,11006474,11006475,11006476,11006477,11006478,11006479,11006480,11006481,11006482,11006483,11006484,11006485,11006486,11006487,11006488,11006489,11006490,11006491,11006492,11006493,11006494,11006495,11006496,11006497,11006498,11006499,10915496,10915497,10915498,10915499,10915500,10915501,10915519,10915520,10915521,10915522,10964563,10964564,10964565,10460452,10964566,10964567,10964568,10964569,10964570,10964571,10964572,10964573,10964574,10964575,10964576,8632542,10460532,8570035,8570036,10951701,10951702,10951703,10847871,10850463,3230672,3230673,3230674,3230675,3230676,3230677,3230678,3230679,3230680,3230681,3230682,3230683,3230684,3230685,3230686,3230687,3230688,3230689,3230690,3230691,3230692,3230693,3230694,3230695,3230696,3230697,3230698,3230699,3230700,3230701,10951968,10926094,10926095,10926096,10926097,10926098,10926099,10926100,10926101,10926102,10926103,10926104,10926105,10926106,10926107,11004172,10926342,3582131,10991607,10930970,10930971,3231663,10952948,10621425,10979202,10979203,8552575,8552576,10616887,9221407,10614247,8568141,6670091,10122088,9173934,9173935,9173938,9173939,9173940,9173941,9173942,9173943,9173944,9173945,9173946,9173947,10611777,3655478,9913528,9913529,10119910,9212097,10120482,8862832,8862833,8862834,8862835,8862836,8862837,8862838,8566936,8566937,9172441,10613144,10613145,10613146,10613147,10613148,10613149,8863317,9180878,9189013,6677247,7018801,7018802,7018803,7018804,7018805,7018806,7018807,7018808,8567656,7018809,7018810,7018811,7018812,7018813,7018814,7018815,7018816,7018817,7018818,7018819,7018820,7018821,7018822,7018823,7018824,7018825,7018826,7018827,7018828,7018829,7018830,7018831,7018832,7018833,7018834,7018835,7018836,7018837,7018838,7018839,7018840,7018841,7018842,7018843,7018844,7018845,7018846,7018847,7018848,7018849,7018850,7018851,7018852,7018853,8853024,7018854,8853025,7018855,8853026,7018856,7018857,7018858,7018859,7018860,7018861,7018862,7018863,7018864,7018865,7018866,7018867,7018868,7018869,7018870,7018871,7018872,7018873,7018874,7018875,7018876,7018877,7018878,7018879,7018880,7018881,7018882,7018883,7018884,7018885,7018886,7018887,7018888,7018889,7018890,7018891,7018892,7018893,7018894,7018895,7018896,7018897,7018898,7018899,7018900,7018901,7018902,6673552,4974268,9193563,8592731,9185674,10118062,9162056,9162057,4975073,4975074,7023903,7023904,7023905,7023906,7023907,7023908,7023909,7023910,7023911,7023912,7023913,7023914,7023915,9912469,7023916,9912470,7023917,7023918,7023919,7023920,7023921,7023922,7023923,7023924,7023925,7023926,7023927,7023928,7023929,7023930,7023931,7023932,7023933,7023934,7023935,7023936,7023937,7023938,7023939,7023940,7023941,7023942,7023943,7023944,7023945,7023946,7023947,7023948,7023949,7023950,7023951,7023952,6674603,4975269,3651733,7016180,9178913,8861577,8861578,10119337,10119338,10119339,10119340,10119341,10119342,10119343,10119344,10119345,10119346,10119347,10119348,10119349,10119350,10119351,10119352,10119353,10119354,10119355,10518977,10519001,4973203,4973204,4973205,8918049,8918050,9160514,10419577,10419578,10417733,6673030,10125375,10125376,10125377,10125378,10125379,10125380,10125381,10125382,10125383,10125384,10125385,10125386,10125387,10125388,10418160,10418161,10122504,8864870,8864871,8864872,8864873,8864874,8864875,6678672,6678673,6678674,6678675,6678676,6678677,6678678,6678679,6678680,6678681,6678682,6678683,6678684,6678685,6678686,6678863,4971699,6665146,6665147,6665148,9175236,9175251,3963588,3963589,4972159,4972160,6679524,10115544,6473668,6473669,6473670,6473671,6665660,6665661,8550641,8563455,9207622,9207623,9207624,9207625,9207626,9207627,9207667,9191735,9199769,9199770,9175885,9207935,9191960,6474284,9208056,7013847,7013848,10462772,10628173,10883975,10883976,10884590,10155843,10155844,10155845,10155846,10155847,10155848,10629362,10629363,10909935,10895047,10156211,10156212,10156213,10156214,10915253,10915254,10875324,10875325,10875326,10875327,10875328,10163506,10163513,10163514,10163515,10163516,10163517,10163518,10163519,10163520,10163521,10163522,10158717,10912715,10912716,10912717,10912718,10912719,7000909,10163783,10897921,10897922,10913362,10885564,10905680,10905692,10905693,10905694,10905695,10905701,10905702,10905703,10162030,10177556,10187559,10187560,10187561,10187562,10187563,10187564,10187565,10187566,10187567,10187568,10949413,10631264,10631265,10631266,10631267,10631268,10177810,10177811,10177812,10177813,10177814,10177827,10949764,10882020,10907224,10907225,10168292,10168293,10168294,10168295,10892373,10892374,10892375,10892376,10892377,10892378,10892379,10892380,10892381,10892382,10892383,10892384,10892385,10892386,10892387,10892388,10892389,10892390,10892391,10945271,10945272,10945273,10945274,10945275,10608035,10589558,10589559,10589560,10589561,10589562,10589563,10589564,10589565,10589566,10589567,10589568,10589569,10583813,10583814,10583815,10583816,10583817,10583818,10583819,10583820,10583821,10583822,10583823,10583824,10583825,10598869,10644930,10654040,10651393,10651394,10645864,10648893,10648894,10648895,10648896,10648897,10601050,10601051,10546084,10546182,10546183,10546184,10550368,10550369,10546414,10546416,10546418,10546419,10546424,10520786,10520787,10520788,10520789,10520790,10520791,10520792,10520793,10520794,10520795,10520796,10520797,10420574,10420575,10420576,10420577,10420578,10508604,10507698,10507699,10421930,10423963,10423964,10507938,10421089,10423102,10485919,10485920,10481002,10407371,10496057,10488099,10411715,10477387,10496806,10495178,10495179,10495180,10495181,10495182,10495183,10495184,10495185,10495186,10495187,10495188,10495189,10495190,10495191,10495192,10495193,10495194,10476577,10476578,10476579,10476580,10476581,10476582,10476583,10476584) 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'