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(8620686,10845605,10930242,10930264,8594610,8594611,8838631,8838675,10861487,9214938,9214939,8630955,10848631,8631069,8631070,10861817,10861818,10861819,10861820,10861821,10861824,10861825,8574723,10459119,10846302,10846303,8569587,8583157,10950371,9215409,10846530,7073832,10862174,10862193,9215638,10849374,10849376,10849377,10849378,10849379,10849380,10849381,10849382,7074095,10849383,10849384,10849385,10849386,10849387,10849388,8575286,10862541,10862542,10950911,9215948,9215963,9215978,10849623,10437339,10437340,10437341,10437342,10437343,10437344,8067467,10437345,8067468,10437346,10862726,7074445,10871774,7074491,7074497,7074509,7074520,7074542,8584014,8575788,10862907,10863094,10100051,10860248,10860250,10872345,8619928,10872397,10872431,10872432,10929532,8591556,3227788,11040076,10447512,3228123,10930052,7071832,7071833,7071834,7071835,7071836,7071837,7071838,7071839,7071841,7071842,7071843,7071844,7071845,7071846,7071847,7071848,7071849,7071850,7071851,7071852,7071853,7071854,7071855,10959553,8558865,8558898,8558921,6000259,8558925,8594666,8617871,7064065,7064066,10866400,3238532,11011816,8627790,10866462,11011881,8559189,7064249,8835793,7201606,11012107,11012108,10858724,8075331,8595141,10858795,10931965,10931966,10931967,7201773,10866886,8559602,4967056,4967057,4967058,4967059,4967060,10859074,8559745,10859184,8572086,8618767,8559881,8559882,8836445,8836446,8836447,8836448,8836449,8836450,8836451,8836452,8836453,8836454,8836455,10843742,10986789,8618989,8619134,8619190,8836853,7065392,8596082,8596083,8596084,10844221,7073539,10859897,10859898,10859899,10859900,10859901,10859902,10859903,10859904,10859905,10859906,10859907,10859908,10859909,10859910,10859911,10859912,10859913,3927233,10865159,10865162,8063983,11010619,10865234,3237366,10942725,10942729,10857503,7200486,10857556,10857560,10857562,10857564,8558230,8626943,3237834,3237932,4430243,4430244,4430245,4430246,4430247,4430248,11011348,6000078,10998485,6000086,6000089,3235277,3235293,8563617,4938659,3655726,3925506,8556473,3656273,10863911,11009314,10863988,8564513,3926230,8564553,8564554,8564562,3926265,3926267,3926268,8615797,11009751,7199325,8564803,8564817,11009896,11009916,11009929,8564980,8616198,3926757,3926787,8860348,3926953,8557533,8557537,8557539,8557540,8557541,8557542,8557543,8557544,8557545,8557546,8557547,8557548,8557549,8557550,8557551,8557552,8557553,8557554,8557555,8557556,8557557,8557558,8557559,8557561,8557562,8557563,10856908,8557568,8557569,8557570,8557571,8557572,8557573,8557574,8557575,8557576,8557577,8557578,10856932,10101789,10856995,7156368,7156369,3923227,10853139,3923308,10623062,10618215,3923486,10837883,10837914,10837954,10837955,10837969,3923618,3923621,10853532,10837998,10853533,10853534,10968013,10623492,11007206,11007207,11007733,10854397,10854398,10854399,8555078,10838954,8555199,8614103,3234693,11008237,10927476,10927477,8541360,8541361,8553061,3232542,8612007,10617377,8541747,8541748,3232661,8541762,10927921,8541778,10927922,10953999,10954000,10928015,10928016,10928018,10928024,10928025,3922902,3922969,3922970,3922971,8542131,8542137,8542139,8542140,11045338,10837539,10925483,10850248,10850260,10850277,10850285,8632739,8632741,8632742,8570113,10615341,10615342,10926025,10926026,10926030,10926031,10926058,10926076,10926084,10926092,10926108,10926126,10926140,10952130,10952131,10952132,10952133,10926189,10926190,10926191,10926192,8610379,8633196,10930510,10930512,10926248,10850902,10952247,8610484,8633300,8633301,8633302,8633303,8633304,8633305,8633306,8633307,9217316,10926322,10926323,10926324,10926325,10926326,10926327,10930729,3582182,8610652,10952445,10615988,3231265,3231266,3231288,10851176,3231309,9217559,9217665,10952653,10952654,10952655,10952656,10952657,10926709,10926715,10926716,10926743,10926744,10926745,10926746,10926747,10952840,10952841,10952842,8540802,3231952,10927199,10927204,8577767,8577789,8541243,10927434,8567885,8567893,10611095,10611096,10611098,9915723,9915760,10611242,10614354,9915944,9915976,8853661,8568429,9916166,10122236,8864617,8864618,8864663,8864697,9198193,8864722,9198204,10566084,10611948,9166286,9179374,9179384,7057573,8542628,9187504,8566008,9211513,9211514,10609238,8566151,10563533,10563544,3652968,8851695,9211890,9195891,9219888,8851796,8566590,10612883,8852118,9220338,9220339,10613041,3653679,7058648,9196803,9196804,8863363,8863365,8852761,9915238,9173042,8863584,8567740,10117554,9161536,10125750,10117775,10117794,10517523,10517524,10117929,10118046,9912083,9912084,9912103,9912105,10126098,9912118,9169914,9912129,9912131,9912132,10126124,10118151,8551338,6674347,6674348,3285870,9194292,3285955,10118564,9912623,9912717,9178694,9178712,8850564,8850594,9912978,9170941,8861557,9171039,9179076,9179101,9171125,9179174,9179179,9187292,9160401,9160402,9160403,10416476,4973437,10418541,10416642,10415664,10415665,10415666,10415669,10415670,10428207,10419766,10428320,10415879,10428360,9161042,10428499,10416180,10416181,9916514,8864980,9198569,8569153,9206710,3963039,8550014,9917162,9917163,10469707,10469708,10469709,10469786,10469787,6473536,8550423,8550539,10115611,10115612,10115613,10115614,10115615,8563317,10115616,10115617,10115618,10115619,10115620,10115621,10115622,10115623,10115624,10115625,10115626,10115627,10115628,10115629,10115630,10115631,10115633,9191463,10115663,10123716,6473866,976364,10123823,6473974,9175755,8550939,10124004,10124039,10462568,9200056,8917710,9176098,9176100,9168108,8917767,10893734,10893743,10893744,8593819,10879057,10628702,10628713,10628714,10884370,8594447,10175549,10175550,10175551,10175552,10175553,10175554,10175555,10175591,10175592,10175593,10910078,10910079,10890146,10890147,10875178,10910243,10885464,10885466,10885467,10912563,10912564,10912565,10912566,10912567,10912664,10877718,10153926,10153927,10153928,10153929,10153930,10153931,10153932,10158966,10877972,10164015,10164028,10888292,8593450,10176516,10630043,10630100,10176654,10176686,10176687,10176688,10176689,10905818,10161933,10161938,10167126,10167147,10167158,10167164,10911222,10891225,10891226,10911235,10911236,10891249,10911255,10187269,10911259,10891272,10891391,10891428,10891429,10891438,10911615,10911616,10911617,10911630,10911631,10162854,10187864,10912101,10877111,10877112,10877113,10912261,10912262,10912263,10892327,10892328,10892332,10907343,10907344,10907345,10907346,10907347,10907348,10907349,10907350,10907351,10907352,10907353,10907354,10945165,10907355,10945166,10907356,10907357,10907358,10907359,10907360,10907361,10907362,10907363,10907364,10907365,10907366,10907367,10907368,10907369,10907370,10907371,10907372,10907373,10907374,10907375,10907376,10907377,10907378,10907379,10907380,10907381,10907382,10907383,10907384,10907385,10907386,10907387,10907388,10907389,10907390,10907391,10907392,10907393,10907394,10892394,10907395,10907396,10907397,10912444,10912445,10912446,10912447,10912448,10912449,10892455,10892456,10892468,10643496,10643497,10643498,10643499,10643500,10643501,10652524,10652532,10652533,10602350,10608634,10647689,10603879,10604013,10591244,10567495,10604428,10604429,10604494,10521293,10547826,10547827,10547828,10546125,10546126,10546127,10546476,10524900,10524901,10528948,10528949,10528950,10520969,10531071,10510295,10510374,10423489,10423533,10423554,10507627,10507926,10423099,10409349,10483059,10407610,10407624,10407642,10409651,10407651,10413668,10411815,10411826,10411827,10411852,8562859,10486615,10486616,10408099,10496770,10410126,10410127,8563171,10408204,10414293,10414294,10414295,10414296,10414297,10492952,10414298,10414299,10414300,10414301,10414302,10414303,10414304,10414305,10492960,10414306,10414307,10414308,10414309,10492983,10492984,10489167,10489172,10489173,10489174,10493271,10493324,10493325,10476393,10472493,10472494,10406892,10406981,10406982,10406983,10406984,10406985,10406986,10406987,10406988,10406989,10406990,10406991,10406992,10406993,10406994) 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'