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(8630581,8630582,8630583,8630584,8630585,8630586,8630587,8630588,8630589,8630590,8630591,8630592,8630593,8630594,8630595,8630596,8630597,8630598,8630599,8630600,8630601,8630602,8630603,8630604,8630605,8630606,8630607,8630608,8630609,8630610,8630611,8630612,8630613,8630614,8630615,8630616,8630617,8630618,8630619,8630620,8630621,8630622,8630623,8630624,8630632,8630633,8630634,8630635,8630636,8630637,8630638,8630639,8630640,8630641,8630642,8630643,8630647,8630649,8630650,8630651,8630652,8630653,8630654,8630657,8630658,8630659,8630660,8630661,8630662,8630663,8630664,8630665,8630666,8630667,8630668,8630669,8630670,8630671,8630672,8630673,8630674,8630675,8630676,8630677,8630678,8630679,8630680,8630681,8630682,8630683,8630684,8630685,8630686,8630687,8630688,8630689,8630690,8630691,8630698,8630699,8630700,8630701,8630702,8630703,8630704,8630710,8630711,8630712,8630713,8630714,8630715,8630716,8630717,8630718,8630719,8630720,8630721,8630722,8630723,8630724,8630725,8630726,8630727,8630728,8630729,8630730,8630731,8630732,8630733,8630734,8630735,8630736,8630737,8630738,8630739,8630740,8630741,8630742,8630744,8630745,8630747,8630748,8630749,8630750,8630751,8630752,8630753,8630754,8630755,8630756,8630757,8630758,8630759,8630760,8630765,8630766,8630767,8630768,8630769,8630770,8630771,8630772,8630773,8630774,8630775,8630776,8630777,8630778,8630779,8630780,8630781,8630782,8630783,8630786,8630787,8630789,8630791,8630792,8630793,8630794,3228956,3228957,3228958,3229106,3229107,3229108,3229109,3229110,3229130,3229131,3229285,8583487,8583488,8583489,7066266,8573309,8573310,8573311,8573312,8573316,8573335,8573336,8573337,10930095,10842809,7201335,7201336,7201354,7201366,7201367,7201368,7201377,7201426,7201427,7201431,7201432,7201453,7072286,7201610,7201612,7201614,7201624,7201730,7201761,7201762,7201847,7201848,7201849,7201850,7201861,7201889,10960336,7201901,7201902,7201959,7201974,7202079,7202082,7202087,7202089,7202090,7202092,7202095,7202096,7202133,7202165,7202168,7202171,7202209,7202210,7202211,7202212,7202213,7202214,7202257,7202265,7202266,7202285,7202347,7202439,5654644,5654649,7202585,5654682,5654683,9794594,3227094,3227207,3237391,3237392,3237396,7200602,8910444,8910445,8910446,8910447,8910448,8910449,8910450,8910451,8910452,8910600,8910601,8910602,8910603,10100083,7198397,7198408,7198409,7198410,7198411,7198412,7198413,7198414,7198415,7198416,7198417,7198418,7198419,8615017,7198457,7198458,7198459,7198460,7198461,7198462,7198463,7198464,7198465,7198682,7198687,7198709,7198722,7198723,7198726,7198728,7198733,7198760,7199130,7199392,7199394,7199395,7199396,7199397,7199398,7199399,7199401,7199402,7199403,7199405,7199409,7199410,7199411,7199414,7199415,7199417,7199449,7199480,7199545,7199739,7199740,7199741,7199742,7199743,11048454,11048460,11048461,11048462,7200091,7200111,7196333,7196458,7196465,7196466,7196531,7196539,11046633,11046634,11046635,8907067,7197433,3234660,3234661,3234729,7197602,7197851,3235067,7197903,7197911,10617035,8541668,8905237,10617428,10617429,10617430,10617431,10617432,10617433,10617434,10617435,10617453,10617454,3232910,10617573,8542165,8905844,10615025,10615026,10615036,10620200,10620201,10620202,10615222,10615229,10615248,10615258,10615329,10615330,10615334,10615338,10615339,10615340,10615341,10615342,10615343,10615344,10615363,10930631,10615710,10615726,10615728,10616016,10426382,10426383,10426384,10426385,10426386,8540618,8540619,10426628,10616416,10616644,10427106,10613971,10614048,10611250,10614257,10614260,10614261,10614262,10614263,10614264,6669828,10614376,10611377,10611381,10611393,10611396,10611406,10611407,10611408,10611426,10611432,10611457,10611462,10611464,10611469,10611498,10611521,10611526,10611539,10611544,10611551,10611555,10611563,10611578,10611583,10611586,10614593,10611611,10611640,10611643,10611658,10611660,10611856,10614857,10611891,10611892,10611906,10611907,10611908,10611909,10611910,10611911,10611912,10611913,10611914,10611915,10611916,10611917,10611918,10611919,10611920,10611921,10611922,10611923,10611924,10611925,10611926,10611927,10611928,10611929,10611930,10611931,10611932,10611933,10611934,10611935,10611936,10611937,10611938,10611939,10611940,10611941,10611944,10611945,10611946,10611947,10611948,10611949,10611950,10611951,10611952,10611953,8549450,10611983,10611995,10611996,10611997,10612062,10612063,10612064,10612086,10612191,10612192,10612194,10612201,10609285,10609287,10609313,8862558,10557973,10557975,10557976,10609834,10612909,10612916,10612931,10613025,10610044,10613127,10613157,10613192,10613235,10610351,10613372,10613513,10613514,10610666,10613732,10613733,10613750,10610901,10610917,10610918,10610919,6673527,6673528,6673529,6673530,6673531,6673532,6673534,6673535,6673536,6673537,6673538,6673540,6673541,6673542,6673543,6673544,6673546,6673549,6673550,6673552,6673563,7055541,7055546,6673636,9169453,9169472,9169473,6673738,6673803,9169822,9169956,9169957,9169958,9169959,9169960,9169961,9169962,9169963,9169964,6674175,6674186,10118214,6674229,6674230,6674232,6674233,6674237,6674238,6674240,6674241,6674242,6674243,6674249,6674256,6674276,6674278,6674280,6674281,6674329,10118342,10118357,10118358,10118364,10118365,10118366,10118367,10118368,10118369,10118370,10118371,10118372,10118373,10118374,10118375,9168359,10416284,6672592,10416364,10416365,10416366,10416367,10416368,10416369,10415370,10419370,10415373,10415374,10415375,10415376,10416383,10416384,10416385,10416386,10416387,10416397,10416398,10416400,10416405,10416411,10416414,10416429,10416430,10416431,10416432,10416433,10416434,10416435,6672725,10416443,10416481,10419497,10419498,6672829,6672830,6672831,6672832,6672833,6672862,6672863,6672864,6672865,6672866,6672867,6672868,10415585,6672869,10415586,6672870,6672871,6672872,6672873,6672874,6672875,6672876,6672877,6672885,6672886,6672887,6672888,6672890,6672896,6672897,6672898,6672899,6672900,6672901,9168721,10416648,10416671,10416672,9168796,10416718,10416719,6673017,6673019,6673020,6673021,6673022,6673023,6673024,6673025,6673035,6673036,6673051,6673067,6673085,6673086,6673088,6673089,10416806,10416807,10416808,10416809,10416810,10416826,6673122,6673123,6673124,6673125,6673126,6673127,6673174,6673196,6673267,6673271,6673272,6673273,6673277,6673278,6673279,6673281,6673282,6673287,6673288,6673289,6673293,6673297,6673299,6673300,6673301,6673304,6673308,6673310,10417053,10417054,10417055,10417056,10417057,10417058,10417059,10417060,10417061,10417062,10417063,10417064,10417065,10417066,10417067,10417068,10417069,10417070,10417071,10417072,10417073,10417074,10417075,10417076,10417077,10417078,10417079,10417080,10417081,10417082,10417083,10417084,10417085,10417086,10417087,10417088,10417089,10417090,10417091,10417092,10417093,10417094,10417095,10417096,10417097,10417098,10417099,10417100,10417101,10417102,10417103,10417104,10417105,10417106,10417107,10417108,10419108,10417109,10419109,10417110,10419110,10417111,10419111,10417112,10419112,10417113,10419113,10417114,10419114,10417115,10417116,10417117,10417118,10417119,10417120,10417121,10417122,10417123,10417124,10417125,10417126,10417127,10417128,10417129,10417130,10417131,10417132,10417133,10417134,10417135,10417136,10417137,10417138,10417139,10417140,10417141,10417142,10417143,10417144,10417145,10417146,10417147,10417148,10417149,10417150,10417151,10417152,10417153,10417154,10417155,10417156,10417157,10417158,10417159,10417160,10117478,6670727,10471175,8550097,8550155,8550156,10469949,10469950,10468410,10468411,10468412,10468413,10468414,10468415,10468416,10468417,10468418,10468419,10468420,10470721,10470722,10888524,10883563,10883568,10888637,10888638,10888639,10888640,10888641,10888642,10893984,10893985,10893986,10893987,10893988,10884483,10889585,10884652,10884653,10889699,10889707,10884787,10884788,10884793,10889997,10890006,10890008,10885165,10890165,10890166,10890167,10890169,10890170,10890171,10885313,10631994,10632010,10632011,10632012,10632013,10632014,10632018,10627321,10887930,10887931,10888032,10888067,10883069,10888339,10883358,10883359,10888362,10883378,10888381,10888382,10883396,10883397,10883402,10883412,10883414,10883421,10886057,10886058,10886059,10886060,10886061,10886062,10886063,10886064,10886065,10162091,10162201,10162249,10626145,10187807,10626299,10626300,10626301,10167992,10877124,10887132,10882353,10882354,10882359,10598616,10598617,10598618,10644403,10647479,10647704,10590996,10545324,10521871,10521872,10521873,10544310,10498250,10498251,10498252,10421543,10407370,10408164,10408656,10406960,10406962,10406965) 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'