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(7201728,7201729,10873862,10873863,8628245,8559574,8628395,8628396,3899286,8628485,7202211,8569517,8628796,5654554,10859524,10859525,5654620,7202586,10872657,8596166,8596167,8596168,10859885,10859930,8629310,8629311,8629312,8629313,8629314,8629315,8629316,10929181,10199652,10860390,10860402,10437559,10212913,8629892,8629894,8629896,10860584,10860585,10860593,7200599,7200600,7200602,7200603,7200612,4430138,7200780,8910601,4430185,10857948,10857949,10857950,10857951,10857952,8627318,8627319,10857961,8627320,10857962,8627337,10858000,10858001,10858002,10858004,10858005,10871050,10858053,10858054,10858078,10858079,10858080,10858081,10858104,10858105,10858162,8627537,10858189,10858190,8627551,7201154,7201155,7201156,8627617,8627618,8627619,8627620,8627621,8627622,8627623,8627624,8627629,8627634,7201326,7201327,7201328,7201329,7201330,8627825,8627838,8627843,8627848,8627849,8627854,8627859,3235817,3235818,3235819,10840153,8625050,8625051,10195120,8625057,8625058,7198685,7198696,7198699,8908521,7198710,7198711,7198714,7198715,7198724,7198728,7198733,7198769,7198772,10856184,10869283,10869284,8909077,8909078,8909079,10840912,10273924,10273925,10273926,10273928,10273929,10273931,10273932,10273933,10273934,10273935,10196188,10196189,8626126,8565228,8565229,8565230,8565231,8565232,8565233,8565234,8565235,8565236,8565237,8626338,8626339,8626425,10932797,10932798,10932799,10932800,10932801,10932802,7065430,10857261,10857262,10857263,10857264,10857265,10857278,10857281,10857463,8626892,8626893,8626894,8626895,8626896,8626897,8626898,8626899,8626900,8626901,4968076,4968077,4968078,7200547,10857625,7197606,7197607,7197608,7197627,7197633,7197635,7197639,7197640,7197644,10867710,7197678,7197682,7197684,7197685,7197686,7197704,3234951,3234952,3234957,3234958,10194266,7197804,7197814,7197815,10868004,10855035,10855036,10855043,10855048,10855055,10855056,10855066,10285529,8624507,8624516,7198386,10194866,10194870,8624886,10194999,10195000,8624938,8624939,8624956,10855600,10855601,10855605,8635030,3922858,8612412,8612413,8612414,8905720,7196191,7196192,7196193,7196194,7196221,7196253,10853335,7196371,7196428,7196429,7196430,7196439,7196446,10866655,10866656,10866657,10853657,10866658,10866659,8554358,10866835,7196899,7196900,7196901,7196904,7196954,7196968,7196969,7197001,10838539,7197042,7197050,7197055,7197076,7197128,7197129,7197130,3234364,3234365,3924434,10838965,3234738,3234743,10850695,8633098,10863748,10850752,10863754,10863755,10863759,10863761,10850787,10425943,10425999,10426000,10426001,10426002,10426003,10426004,10426005,10426006,10426007,3231086,3582206,3582207,10851163,10851164,8540569,10426628,3231703,8633990,10624134,8611354,8611355,8634167,10619193,3232168,8634463,8552765,10852128,10852253,8634677,8634678,8634679,8634680,8634681,8634682,8634683,8634684,8634685,8634686,10852370,8905204,8905205,8905258,8905263,10619833,10619834,10619840,10852513,10852514,10619874,10619891,10619892,10619899,10619901,10619902,10865595,8631998,8632004,8632029,8632030,8632031,8632032,8632047,8632048,8632049,8632070,8632071,8632072,8632073,8632074,8632075,8632123,8632130,8632137,8632138,8632152,8632153,8632154,8632155,8632166,8632167,10622146,8632175,8632176,10849854,8632234,8632258,8632259,8632304,10617378,10617456,10617512,8632593,10432577,10425385,10425394,8632737,8632750,10425471,8632791,8632847,8632848,8632849,10425569,8632850,10425582,10425591,10860823,8630217,8630322,10615334,8630437,8630438,8630439,8630440,8620631,8630441,10848590,10848592,10848594,10848596,8574500,8574534,10861831,8631191,10861942,10616341,10616342,10616417,8631573,10431563,8583488,8583489,10849376,10849377,10849378,10849379,10849380,10849381,10849382,10849383,10849384,10849385,10849386,10849387,10922256,10922257,10922258,10922259,10922260,8631786,8631789,10849488,10849495,8631906,8631907,8631934,8631935,8631936,8631961,8631962,8631982,8631983,8631984,8863908,7059861,9173737,10614500,6665992,9166075,9166076,6666233,6666259,7019919,7019920,10611969,10612025,8851257,10120368,8852020,9172235,9172236,9172237,9196372,10613215,8852520,8852521,8852632,9172936,9172937,8852771,10428773,9161669,9161670,9161671,9161672,10517796,10517797,6674229,6674237,6674240,6674242,8849912,8849954,8849969,10118392,8850033,8850041,9912434,9912437,9912438,8850117,9912703,9912888,10518675,10518676,10518677,10518678,10518679,10518680,8552194,10417223,10417225,10419527,10419528,10419529,10419530,10419531,10419680,10419704,8848710,8848711,9169050,6673277,8064672,8064673,9193110,10117317,7055296,9209268,9169275,7055456,10417212,10417218,10417219,8549456,8568847,8568848,8568849,8568850,8568851,8568852,8568853,8568914,10467101,10467105,10467115,10467116,10467117,10467121,10467125,10467138,10467139,10467140,10467141,10467157,8549897,8854614,10467408,10467432,10467435,10467441,10467442,10467459,6665236,10465763,10465764,10465765,10465776,10465782,10465787,10465791,10465797,9175229,10465840,10465841,10465843,10465853,10465893,10463948,10463949,10464047,10466273,976476,10466305,10466306,10466307,10466311,10466312,9183739,10466320,10466328,10466354,10466363,10466368,10466382,10466383,10466387,10466388,10466389,10466845,10466846,10466850,10466854,9168281,10466859,10466861,10466862,10466863,10466864,10466865,10466866,10427672,10427673,10903627,10883966,10894377,10155598,10947830,10910024,10890113,10890118,10885212,10885213,10880233,10880234,10880235,10880236,10887476,10887557,10632161,10632162,10632311,10627319,10184010,10184011,10184012,10184013,10184014,10184015,10184016,10184017,10184018,10893351,8593387,10630030,10630240,10630241,10630242,10630243,10895781,10895782,10895783,10885959,10172196,10886346,10886347,10886348,10886349,10886350,10886351,10886352,10886353,10886354,10886355,10625935,10168039,10877211,10950079,10950080,10950081,10631915,10631919,10631920,10631922,10887461,10568128,10568129,10568130,10580255,10580256,10580257,10580258,10580259,10580260,10611250,10598670,10598671,10598672,10598673,10598674,10598675,10598676,10598677,10608551,10611571,10650037,10611831,10604032,10610044,10585351,10607635,10579795,10591802,10601700,10525330,10549689,10528106,10522617,10522839,10539036,10539037,10420435,10421488,10424489,10421489,10424490,10422597,10423616,10420652,10415675,10506825,10507956,10507957,10411281,10463005,10463011,10463012,10463013,10463034,10483044,10483045,10483046,10483047,10463047,10483048,10463048,10463056,10477105,10409501,10490324,10490325,10490326,10490327,10490328,10490329,10490330,10490331,10409676,10490332,10490333,10490334,10490335,10490336,10490337,10490338,10490339,10490340,10490341,10490342,10490343,10490344,10490345,10463435,10407954,10407955,10413980,10413981,10408005,10473697,10473698,10473699,10473700,10473701,10473702,10473703,10473704,10473705,10473706,10473707,10473708,10473709,10473710,10473711,10473712,10473713,10473714,10463734,10463735,10463736,10463737,10463742,10463743,10463744,10463747,10463754,10463767,10463770,10463792,10463810,10463816,10463818,10463821,10463822,10408189,10408190,10714524,8563204,10412238,10410249,10410250,10410257,10410268,10410269,10410276,10414281,10414325,10714736,10412535,10412536,10412537,10412538,10412539,10412548,10412549,10412586,10412587,10412588,10412590,10412591,10412631,10412632,10412657,10412658,10412659,10412683,10412684,10414693,10412733,10462406,10462409,10462410,10462411,10462412,10412760,10462416,10412761,10462419,10410766,10410767,10462425,10410771,10462427,10408776,10462440,10462442,10462443,10462449,10462450,10476462,10414830,10414840,10462505,10462518,10462525,10462526,10406872,10406874,10406876,10462532,10406878,10462533,10462616,10408978,10408979,10406982,10406983,10406984,10406985,10406986,10406987,10406988,10406989,10406990,10406991,10406992,10406993,10462730,10478856,10478857) 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'