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(4970677,4970682,3228944,3228957,3228979,3228981,8569559,3229017,3229018,3229045,3229066,3229158,7066011,7066012,8583490,7066030,10950685,10950692,10950737,7066229,8609570,8609572,10964615,3227405,3227406,3227536,3227543,3227544,8573309,7201273,8835551,7201313,8594794,8835704,8594935,3238792,7201622,8628036,8595083,8628270,8628339,8911776,8911785,8911790,8911791,8628381,7202028,8628475,8628476,8628477,7202078,7202080,8065816,7202121,7202166,7202315,5654563,5654564,5654565,7202477,7202478,7202479,7202480,7202481,7202482,7202483,7202500,7202501,5654636,7202548,7202549,5654637,5654640,3227196,7200191,3237370,3237371,8626623,8910058,8910077,7200622,8910458,7200695,7200724,8910582,8910583,7200780,8627258,8627260,7200931,10931197,10959615,8908004,7198355,7198356,8908215,8908216,8624884,8624885,8624903,8624904,8624974,8624975,8624976,8624977,8624978,8624979,8624980,8624981,8624982,8624983,8624984,8624985,7198677,7198694,7198697,8625135,8625136,8625137,8625140,7198766,7198776,8625447,8625450,8625451,8625452,8625474,8625475,8625476,8625477,7199213,8625696,8625697,8625698,8625699,8625700,8625701,7199389,7199473,8625937,8625938,8625939,7199540,7199541,10101453,10101454,10101469,10101478,10101493,8626015,8626016,8626017,8626018,8626019,8626020,11048387,11048388,11048389,11048407,7199896,7199911,7199928,7200017,3927180,7200080,7200096,7200097,7200099,7200102,7200147,7200153,7200171,7200179,8906005,8906006,3923455,3923463,3923532,3233597,10618321,10618330,10618331,10618385,10618386,10618387,10623491,10623492,7196795,7196796,7196797,8906636,8906637,8906651,10981287,8906721,8906722,7197233,3234854,3234856,7158093,7197799,3234986,7197860,7197863,7197890,8624301,8624302,8624303,8624304,8624305,8624306,8624307,8624308,8624309,8624314,8624315,8624316,8624317,8624522,8904993,8904994,11044654,8634621,8905092,10617123,10617124,8905232,8905315,8905316,8905317,8905318,8905320,8905337,8905377,10622526,8905567,8905584,10617804,8612652,8905953,10614980,8632742,8632748,10425484,10615266,10615390,3581861,3581871,3581874,3581878,8633182,10620565,8633198,3581936,10615604,10615615,10426008,10615692,10426195,10426199,10426233,10426257,10615952,10616007,10426365,8540538,10616089,10616098,10616099,8540608,10616248,10616249,10616250,10616251,10616287,10616353,10616354,10616410,10616450,10616469,10616471,10616474,8611285,8611308,10616512,8611322,10616548,10616551,10616601,10616604,10621660,10621661,10621662,8634282,10621664,10621665,8634316,10616699,10616700,8634321,10621711,10621714,10621715,7155300,10616834,10616840,10616887,10616901,10616911,10616955,11044616,11044617,10611018,10611076,10614079,8853247,8853248,8853249,8853252,10614097,10614106,10614107,10614108,10611124,10611156,10611184,10611185,10611186,10611187,10611188,10611191,10611203,10614222,10611226,10611230,10611236,10611243,8853430,8853431,8853432,8853433,8853434,10611286,10611287,10611288,10614316,10611324,10611353,10611354,10714178,10611371,10611410,8853633,10611498,8853688,8853692,8853693,8853694,8853698,10614578,10614579,10611693,8549451,10612162,10612324,10612326,10612332,10612335,10609400,10609401,7017443,7017444,7017449,7017450,7017455,7017456,7017461,7017462,7017467,7017468,7017473,7017474,7017479,7017480,7017485,7017486,10609500,7017491,7017492,7017497,7017498,7017503,7017504,7017509,7017510,10609526,10609561,10609587,10609652,10609697,10609700,10609701,10609702,10609715,10609716,10609732,10609733,10609734,10609735,8566602,10612822,10609888,10609889,10609890,10612926,10612963,10609988,6676578,10613056,10613057,10613058,10613075,10610108,10613203,10613205,10610252,10610271,10610399,10613425,10610772,10610780,10610781,10610791,10610878,10610937,10610938,10610939,10610940,10610956,10610957,10610958,10515113,10515114,7055477,6673517,10117535,7055534,9177369,10117584,10117620,10117690,10117704,10117713,989917,10117743,6673752,10117744,10117745,10117746,10117747,10117748,10117754,9169570,10117786,10117787,989978,10117788,989979,989981,10117840,10117955,10117967,10117968,10117969,9169846,10118048,10517681,10118069,9161895,9169936,10118155,10118176,10118199,7015658,7015659,7015676,7015677,10118231,6674241,10514075,10514091,10514092,10118495,10512118,10512119,10512120,10118526,10118528,10516171,10118556,10516172,10118561,10118564,10118613,10118625,990820,10118640,990838,7016197,10514371,10118921,10512559,8552164,991367,10514976,8565717,8565718,8565719,8565720,8565721,8565722,10515092,7013953,7013954,7013959,7013960,10417363,9168442,10416375,10416376,10416377,10416378,10416379,10416380,10416381,10416382,10416383,6672689,9168503,9168504,9168506,9168507,7014220,7014221,7014222,9168568,7014223,7014224,7014225,9168573,9168576,9168577,9168578,9168579,9168580,9168582,9168584,6672791,9168585,6672792,6672793,9168587,6672794,6672795,9168589,6672796,6672797,9168591,6672798,6672799,6672800,10116806,9168617,9168619,9168637,10419577,10419589,10419590,10416638,10415652,10415653,10419654,10415656,9168754,10415683,10415684,10415686,10415687,10415688,10415689,10415690,10418760,6673083,6673084,10415813,9168932,6673157,6673164,10415911,10415914,10417936,10417945,9169104,10420085,10420091,10420096,10420157,10117461,6673473,10420192,7055441,10117486,10470960,10470981,10470983,10470990,10463002,10471169,10123006,8549975,8549976,8549977,8550002,8550003,9167381,10468164,10468165,10468166,9167688,9167689,9167690,10468277,10468292,10468306,10464350,10464351,10464352,10464353,10468354,10464354,9167798,10466413,10468424,10468432,10468435,8551013,8551014,10468472,10462486,9167964,9168028,9168054,9168076,9168107,9168111,9168157,9168159,9168162,9168168,9168176,10462756,9168183,9168209,9168213,9168219,9168221,9168224,9168225,9168226,7013881,7013882,7013887,7013888,7013893,7013894,7013899,7013900,7013905,7013906,10470830,10470831,7013911,7013912,7013917,7013918,7013923,7013924,7013929,7013930,7013935,7013936,7013941,7013942,7013947,7013948,10184499,10883559,10883560,10883561,10888613,10888616,10898686,10898688,10883745,10888788,10883822,10883830,10883952,10883960,10883961,10888998,10889032,10889033,10889073,10884108,10889109,10889110,10889111,10884111,10889112,10889113,10889114,10889119,10889120,10889122,10889123,10889124,10889125,10889126,10889127,10884135,10889138,10889139,10889140,10889141,10889142,10889150,10889151,10889152,10889153,10889154,10889155,10889173,10889174,10889175,10889176,10889189,10889190,10889191,10889192,10889193,10889194,10889195,10884195,10889196,10889197,10889198,10884198,10889199,10889200,10889201,10889202,10889203,10889204,10889205,10889206,10889227,10889264,10889267,10889268,10884309,10889314,10884322,10884354,10884368,10884369,10884394,10884415,10884440,10884446,10884447,10884460,10884489,10889574,10889575,10889591,10884616,10884690,10884723,10884737,10884742,10889784,10889786,10884818,10884820,10884839,10884847,10889892,10889893,10884980,10890004,10890050,10885089,10890090,10890094,10885119,10885121,10885130,10885137,10885138,10885144,10890195,10890196,10890197,10890220,10890230,10890234,10890237,10890239,10890240,10890241,10885382,10885388,10885393,10885394,10885395,10882512,10887529,10882566,10877572,10882633,10882637,7000827,10882648,10882649,10882652,10882653,10887675,10887676,10882696,10882715,10887722,10882734,10882751,10882787,10882796,10627297,10627298,10882810,10882814,10882827,10882839,10882845,10882866,10882867,10882871,10882876,10882877,10882878,10887884,10883031,10883032,10883044,10883146,10883159,10883160,10883171,10883178,10883188,10627724,10627725,10627726,10627727,10888260,10888261,10883290,10888310,10883358,10883359,10883362,10883378,10883403,10883404,10885487,10885670,10885677,10885678,10885700,10625364,10885996,10162170,10162171,10162172,10876499,10886623,10886771,10886935,10886971,10897041,10897062,10887067,10887075,10887085,10887086,10887088,10882107,10887269,10887270,10882438,10882439,10882460,10882461,10882462,10882463,10598615,10647427,10591360,10591765,10591766,10591767,10591768,10591769,10591770,10591771,10591805,10579977,10527167,10529337,10529338,10529339,10529340,10528357,10528358,10538413,10546455,10546456,10546457,10546458,10546460,10546461,10546463,10546464,10546465,10522597,10420250,10420252,10420256,10420264,10505553,10505554,10507594,10507718,10507719,10507720,10507754,10507755,10507758,10507759,10507760,10507785,10422907,10507804,10422924,10507930,10507937,10423102,10423104,10407242,10407470,10407471,10409588,10407736,10407737,10409756,10409757,10409758,10409863,10409888,10409892,10409960,10409961,10410009,10410011,10410098,10410102,10410103,10410156,10410157,10491048,10410429,10410431,10410443,10497116,10497162,10497185,10497200,10497201,10489232,10411198,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'