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(8630696,8630702,8630716,8630717,8630940,8630941,8630942,8630944,8630960,8630967,8630976,8631008,8631009,8631010,8631011,8631012,8631013,8631040,8631056,8631062,8631067,8631197,8631213,8631214,8631220,8631231,8631232,8631233,8631234,8631235,8631236,8631237,8631238,8631239,8631240,8631241,8631242,8631243,8631244,8631245,8631246,8631247,3229029,3229187,3229190,8631539,8631551,8631554,8631555,8631665,8631751,8631754,8631791,7066237,8632194,8632433,8632434,8632436,8632540,8632558,8629729,8629905,8629972,8629973,8629977,8629981,8629982,8630001,8630012,8630017,8630021,8630022,8630027,8630029,8630030,8630140,8630141,8630145,8630146,8630154,8630203,8630295,8630400,8630405,8630443,8630444,8630445,8630446,7201218,7201219,7201274,8627724,8627725,8627727,8627728,8594727,8594728,7201390,8627902,7201502,8627903,8627906,8627910,8627911,8627915,8627916,8627917,8627919,8627922,8627930,8627933,7201581,7201582,8627997,8627998,8628021,8628022,8628023,8628442,8911923,8911924,8911925,7202136,7202138,8628621,8628622,8628650,7202257,8628670,8628691,8628699,8628700,8628718,8628719,8628724,8628725,8628726,8628727,8628743,8628750,8628813,8628889,8628890,8628995,8629003,8629017,8629018,8629019,8629020,8629021,8629022,8629023,8629024,8629035,8629036,8629037,8629038,8629044,8629045,8629046,8629047,8629048,8629049,8629050,8629051,8629137,8629138,8629139,8629167,8629168,8629169,8629170,8629171,8629172,8629173,8629178,8629179,8629180,8629181,8629182,8629183,8629184,8629186,8629187,8629231,8629251,8629253,8629265,8629267,8629284,8629367,8629368,8629374,8629375,8629381,8629443,8629448,8629466,8629519,8626596,8626770,8626841,7200486,7200489,7200525,8626941,8626958,8626964,8627061,7200726,4430160,8910662,8627347,8627361,8627364,8627383,7201036,7201037,7201039,7201045,7201051,7201088,7201098,7201129,8624588,8624787,7198466,8625042,7198708,8625123,8625124,8625125,7198725,8625126,7199024,8625488,8625689,8625744,8625745,8625746,8625747,8625748,8625749,8625750,8625751,8625752,8625753,7199427,7199637,8626054,7199660,7199674,7199675,7199676,7199677,7199678,7199722,7199723,7199724,7199779,7199780,7199781,8626219,11048475,11048476,8626229,8626230,8626231,7200030,7200103,8626514,7196236,7196239,3923414,10623063,3923504,7196368,7196409,7196410,3923567,7196425,7196426,3923577,10618292,7196555,8906566,8906583,8906584,8906618,8906630,10623605,10623606,7196925,7196990,7196992,7196993,7197014,7197023,7197024,7197025,7197026,7197027,7197028,8906858,7197061,10838796,7197290,10838797,10838802,10838913,7197484,7197501,7197530,7197532,7197633,7197635,7197639,7197668,7197671,7197672,7197682,7197825,7197955,7198007,7198040,7198043,7198045,7198071,7198072,8624493,7198176,8634673,8634674,8634675,8634676,8634677,8634678,8634679,8634680,8634681,8634682,8634683,8634684,8634685,8634686,10617068,10617101,8634726,10617108,10617124,10617134,10617137,10617169,10617170,10617220,8634880,10622363,8635011,8635012,8635013,10615063,8632698,8632755,8632758,8632759,8632763,10615317,8633015,8633016,8633017,8633018,8633051,8633153,10615536,10615556,8633201,8633213,10615598,8633223,8633226,8633231,8633242,10615647,8633332,10615739,8633459,10615863,10426257,10615923,10615931,10615944,10615945,10615953,10615957,10615979,10615980,8633601,8633602,8633603,10615985,8633617,10616023,10426369,10426386,10426425,10426428,10616090,8633710,8633711,8633712,8633713,8633714,8633715,8633716,8633717,8633718,8633719,8633720,8633721,8633722,8633723,8633902,8633903,8633904,8633905,8633906,8633907,8633908,8633909,8633910,8633911,8633912,8633913,8633914,8633915,8633916,8633917,8633918,8633919,8611332,8634157,10616548,8634269,8634294,10616686,8634317,8634321,8634345,8634346,8634347,8634348,8634349,8634350,10616804,8634470,8634519,8634520,8634521,8634522,8634523,8634524,8634529,8634530,8634531,8634532,10614086,10614089,10614183,10614184,6669818,6669819,6669820,6669821,6669822,6669823,6669824,6669825,6669826,6669827,6669828,6669832,6669833,6669834,6669835,6669836,6669837,6669838,6669839,6669840,6669841,6669842,6669843,6669844,6669845,6669846,6669847,6669848,6669849,6669850,6669851,6669852,6669853,6669854,6669855,6669856,6669857,6669858,6669859,6669860,6669861,6669862,6669863,6669864,6669865,6669866,6669867,6669868,6669869,6669870,6669871,6669872,6669873,6669874,6669875,6669876,6669877,6669878,6669879,6669880,10611338,6669881,6669882,6669883,6669884,6669885,6669886,6669887,6669888,6669889,6669890,6669891,6669892,6669893,6669894,6669895,6669896,6669897,6669898,6669899,6669900,6669901,6669902,6669965,10614463,10614464,10614476,10614485,10614488,10614490,10614492,10614537,10614572,10614592,10614713,10611750,10611879,10612054,10612193,7017207,7017208,7017209,7017210,7017211,7017212,7017213,7017214,7017215,7017216,7017217,7017218,7017219,7017220,7017221,7017222,7017223,7017224,7017225,7017226,7017227,7017228,7017229,7017230,8851420,10612272,10612328,10612342,10609360,10612428,10609470,10609471,10612483,10612484,10612534,10612535,10612542,10612583,10612584,7017607,7017608,7017609,7017610,10612624,10612635,10612638,10612639,10612643,10612664,7017659,7017660,7017667,7017668,7017669,7017670,7017671,7017672,8851853,8851856,8851859,7017707,10612717,7017708,7017709,7017710,10612723,10612724,10612725,10612730,10612731,10612732,10612733,10612734,10612735,10612736,10612738,10612740,7017731,7017732,7017733,7017734,10612756,10612757,10612761,10612762,10612763,10612764,10612765,10612766,7017759,10612769,7017760,7017761,10612771,7017762,7017771,10612781,7017772,10612782,7017773,10612783,7017774,10612784,10612785,10612786,10612787,10612797,10612800,10612803,10612805,10612806,7017805,7017806,7017807,10609829,10609830,10612840,10612866,10612870,10612882,10612897,10612898,10612910,10612911,7017914,7017915,10612936,10609980,10609981,8852156,8852157,10610039,10610046,10610048,10610132,10610259,10613293,10613294,10613295,10613296,10613297,10613298,10613299,10613300,10613301,10613302,10613303,10613304,10613356,10613357,10613365,8852528,10613367,8852530,10613368,8852531,8852532,8852533,10610371,8852534,8852535,10610414,9204792,10610466,10610468,10610486,10610671,10613679,10610909,10117569,10117570,9169429,6673737,10117871,9169689,7015438,7015439,7015440,7015441,7015464,7015465,9169817,7015484,7015485,7015526,7015527,7015540,7015541,7015568,7015569,7015570,7015571,7015584,7015585,7015594,7015595,8849782,7015616,7015617,7015632,7015633,6674194,6674216,8849909,6674315,10118497,8850184,8850185,8850186,8850192,8850193,8850199,8850200,8850202,8850203,8850205,8850211,7016040,7016041,7016042,7016043,7016074,7016075,7016076,7016077,7016078,7016079,7016100,7016101,7016102,7016103,7016118,7016119,7016130,7016131,7016142,7016143,7016162,7016163,9171075,8851096,10416228,7013971,9168318,7013972,8848158,10418313,9168458,10419382,10419394,10419395,10415445,10418481,10419493,10419494,10415518,10415523,6672810,6672811,10415537,10416593,10416594,10416595,10416596,10416597,10416598,10416599,10416600,10416601,10416602,10416603,10416604,10416605,10416606,10416607,10416608,10418686,10418687,7014434,7014435,7014450,7014451,10418730,10418731,7014466,7014467,7014476,7014477,7014482,7014483,10418754,10418755,7014488,7014489,10418781,7014514,7014515,7014516,7014517,7014534,7014535,7014536,7014537,9169033,10418996,10419020,10419021,10419022,9169102,10419060,10419156,10419178,9161281,9169287,10117492,10467104,10471125,8550093,8550094,8550095,10469570,8916774,8847486,8847487,8847493,8847496,8847500,8847501,8847505,8847516,8847521,8847526,8847528,8847534,8847538,8847541,8847542,8847543,8847553,8847556,8847557,8847558,8847561,8847566,8847573,8847579,8847584,8847592,8847598,8847603,8847613,8847618,9167981,9168072,10470686,10470687,8848104,10888580,10888582,10888831,10888886,10888888,10888985,10888995,10889028,10889068,10884416,10889418,10889419,10889420,10884625,10884646,10889673,10889674,10889675,10889703,10884798,10885462,10627019,10877551,10882893,10888032,10888093,10883137,10883464,10883469,10885519,10885520,10885876,10161960,10949012,10876487,10886895,10886901,10886905,10886906,10887052,10631884,10887443,10887450,10887453,10586579,10586580,10602647,10590495,10585350,10601418,10601436,10601496,10601502,10601510,10601527,10601535,10601559,10528350,10507617,10507619,10507620,10507621,10507902,10508002,10409235,10409236,10409346,10409347,10407736,10407737,10486556,10407949,10410322,10410798,10410799) 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'