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(7201606,10858724,10871774,8595141,10858795,7201773,8559602,10859074,8559745,10859184,8572086,8618767,8559881,8559882,8836445,8836446,8836447,8836448,8836449,8836450,8836451,8836452,8836453,8836454,8836455,10843742,10872345,10872397,10250827,8569587,10872431,10872432,8618989,8619134,8619190,7073832,8836853,8596082,8596083,8596084,10844221,10859897,10859898,10859899,10859900,10859901,10859902,10859903,10859904,10859905,10859906,10859907,10859908,10859909,10859910,10859911,7074095,10277334,10859912,10859913,10251354,10251445,10100051,10437339,10437340,10437341,10437342,10437343,10437344,10437345,10437346,10860248,10860250,7074445,10251689,10251690,7074491,7074497,7074509,7074520,7074542,8619928,10929532,8591556,3237834,10249157,3237932,10223245,10249319,4430243,4430244,4430245,4430246,4430247,4430248,10249335,10249349,8558865,8558898,8558921,10236686,8558925,8594666,8617871,3238532,8627790,8559189,10250015,8835793,7071832,7071833,7071834,7071835,7071836,7071837,7071838,7071839,7071841,7071842,7071843,7071844,7071845,7071846,7071847,7071848,7071849,7071850,7071851,7071852,7071853,7071854,7071855,10247102,6000259,8556473,7064065,7064066,10195454,7064249,8564513,3926230,8564553,8564554,8564562,3926265,3926267,3926268,10247624,8615797,8075331,10931965,10931966,10931967,7199325,8564803,8564817,4967056,4967057,4967058,4967059,4967060,8564980,8616198,3926757,3926787,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,10196390,10856995,3927233,7065392,3237366,10248710,7073539,10857503,7200486,10857556,10857560,10857562,10857564,8558230,8626943,10942725,10942729,3235277,3235293,10246600,10246601,8563617,4938659,3925506,6000078,6000086,6000089,10283215,3922902,3922969,3922970,3922971,8542131,8542137,8542139,8542140,10837539,7156368,7156369,3923227,10853139,3923308,3923486,10866400,10837883,10837914,10866462,10837954,10837955,10837969,3923618,3923621,10853532,10853533,10837998,10853534,10866886,8860348,10854397,10854398,10854399,8555078,10838954,8555199,8614103,3234693,10623062,10433072,10433073,10433074,10433075,8610379,8633196,10618215,10433182,10850902,10863911,8610484,8633300,8633301,8633302,8633303,8633304,8633305,8633306,8633307,9217316,10863988,3582182,10433383,8610652,3231265,3231266,3231288,10623492,10851176,3231309,9217559,9217665,10433594,10433595,10433596,10433597,10433598,8540802,3231952,8577767,8577789,10204437,8541243,8541360,8541361,10865159,10865162,10865234,8553061,3232542,8612007,8541747,8541748,3232661,8541762,8541778,10862726,8584014,8575788,10862907,10617377,10927921,10927922,10863094,10928015,10928016,10928018,10928024,10928025,10850248,10850260,10850277,10850285,8632739,8632741,8632742,10189906,10189907,10925483,3227788,10447512,8570113,3228123,10615341,10615342,10930052,8620686,10845605,10926025,10926026,10926030,10926031,10926058,10926076,10926084,10926092,10930242,10926108,10930264,10926126,10926140,10926189,10926190,10926191,10926192,10930510,10930512,8594610,8594611,10926248,8838631,10926322,10926323,10926324,10926325,10926326,10861487,10926327,8838675,9214938,9214939,10930729,8630955,10848631,10615988,8631069,8631070,10861817,10861818,10861819,10861820,10861821,10861824,10861825,8574723,10459119,10846302,10846303,10926709,10926715,10926716,10926743,10926744,10926745,10926746,10926747,8583157,10431324,9215409,10846530,10188529,10188530,10188531,10862174,10862193,9215638,10927199,10927204,10849374,10849376,10849377,10849378,10849379,10849380,10849381,10849382,10849383,10849384,10849385,10849386,10849387,10849388,8575286,10862541,10862542,10431847,9215948,10927434,9215963,9215978,10849623,10927476,10927477,8567885,8567893,9915723,9915760,10614354,9915944,9915976,8853661,8568429,9916166,10122236,8864617,8864618,8864663,8864697,9198193,8864722,9198204,10566084,9166286,9179374,9179384,7057573,8542628,9187504,8566008,9211513,9211514,8566151,10563533,10563544,3652968,8851695,8067467,8067468,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,8063983,9160401,9160402,9160403,10416476,4973437,10418541,10416642,10428207,10419766,10428320,10428360,9161042,10428499,9916514,8864980,3655726,9198569,8569153,9206710,3963039,8550014,9917162,9917163,3656273,10469707,10469708,10469709,10469786,10469787,6473536,8550423,8550539,10115611,10115612,10115613,10115614,10115615,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,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,10911259,10187269,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,10907355,10907356,10907357,10907358,10907359,10907360,10907361,10654676,10907362,10654677,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,10892394,10907394,10907395,10907396,10907397,10912444,10912445,10912446,10912447,10912448,10912449,10892455,10892456,10892468,10611095,10611096,10611098,10611242,10643496,10643497,10643498,10643499,10643500,10643501,10652524,10652532,10652533,10602350,10608634,10611948,10609238,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,10415664,10415665,10415666,10415669,10415670,10507627,10415879,10507926,10423099,10416180,10416181,10409349,10483059,10407610,10407624,10407642,10407651,10409651,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,8563317,10489167,10489172,10489173,10489174,10493271,10493324,10493325,10476393,10472493,10472494,10406892,10462568,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'