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(7201712,7201713,7201714,7201715,7201716,7201717,7201718,7201719,7201720,7201721,7201722,7201723,7201724,7201725,7201726,8595234,8628261,8628263,4970767,9794588,7066180,7066267,8629468,8629469,8629470,3227391,3227392,3238520,8594793,8625209,8625269,8625270,8625271,8625272,8625285,8625286,8625287,8625288,8625289,8625290,8625291,8625298,8625299,8625300,8625301,8625303,8625304,8625305,8625306,8625307,8625308,8625309,8625310,8625311,8625312,8625313,8625314,8625315,8625316,8625317,8625323,8625324,8625325,8625326,8625327,8625328,8625329,8625331,8625334,8625335,8625336,8625337,8625338,8625339,8625340,8625342,8625343,8625344,8625352,8625353,8625354,8625355,8625356,8625357,8625358,8625359,8625360,8625363,8625365,8625367,8625370,7199173,7199272,7199400,7199468,7199469,10195965,10195966,7199559,7199560,7199561,7199562,7199563,7199564,8910077,8626801,8626802,8626803,8626804,7200469,8834751,8834752,8834762,8834763,8905981,8905982,8905983,8905984,8905985,8905986,8905987,8905988,8905989,8905990,8905991,8905992,8905993,8905994,8905995,8905996,8905997,8905998,8905999,8906000,8906001,8906002,8906003,8612892,3923618,3923619,3923620,3923621,7196647,7196648,7196649,7196650,7196651,7196652,7196653,7196654,7196655,7196656,7196657,7196658,7196659,7196660,7196661,7196662,7196663,7196664,7196665,7196666,7196667,7196668,7196669,7196670,7196671,7196672,7196673,7196674,7196675,7196676,7196677,7196678,7196679,7196680,7196681,7196682,7196683,7196684,7196685,7196686,7196687,7196688,7196689,7196690,7196691,7196692,7196693,7196694,7196695,7196696,7196697,7196698,7196699,7196700,7196701,7196702,7196703,7196704,7196705,7196706,7196707,7196708,7196709,7196710,7196711,7196712,7196713,7196714,7196715,7196716,7196717,7196718,7196719,7196720,7196721,7196722,7196723,7196724,7196725,7196726,7196727,7196728,7196729,7196730,7196731,7196732,7196733,7196734,7196735,7196736,7196737,7196738,7196739,7196740,7196741,7196742,7196743,7196744,7196745,7196746,7196747,7196748,7196749,7196750,7196751,7196752,7196753,7196754,7196755,7196756,7196757,7196758,7196759,7196760,7196761,7196762,7196763,7196764,7196765,7196766,7196767,7196768,7196769,7196770,7196771,7196772,7196773,7196774,7196775,7196776,7196777,7196778,8860432,10838905,10838906,7197420,7197421,7197422,7197423,7197424,7197425,7197426,7197427,7197428,7197429,7197430,7197431,7197432,7197433,7197434,7197435,7197436,7197437,7197438,7197439,7197440,7197441,7197442,7197443,7197444,7197445,7197446,7197447,7197448,7197449,7197450,7197451,7197452,7197453,10190312,10190313,10190314,10190315,10190316,10190317,10190318,8633275,8633276,8633277,10426218,10426219,10426220,10426221,10426222,10426223,10426224,10426225,10426226,10426227,8540517,10426407,8070780,8070782,8904519,8904520,8904521,8904522,8904523,8904524,8904525,8904526,8904527,8904528,8904529,8904530,8904531,8904532,8904533,8904534,8904535,8904536,8904537,8904538,8904539,8904540,8904541,8904542,8904543,8904544,8904545,8904546,8904547,8904548,8904549,8904550,8904551,8904552,8904553,8904554,8904555,8904556,8904557,8904558,8904559,8904560,7155303,8634728,10617031,10617048,10617049,10617050,10617114,10617135,10617136,10617137,10617145,10617146,10617148,10617149,10617155,10617156,10617157,10617158,10617159,10617164,8609572,8609573,10189897,10189898,10189927,10425610,10930096,10615442,10615443,10615444,10615445,10615446,10615447,10615448,10615449,10615450,10615451,10615452,10615453,10615454,10615455,10615456,10615457,10615458,10615459,10615460,10615461,10615462,10615463,10615464,10615465,10615466,10615467,10615468,10615469,10615470,10615483,10615524,10615556,8630627,8630628,8630632,8630635,8630636,8630637,8630638,8630639,8630640,8630641,8630642,8630643,8630649,8630650,8630651,8630652,8630653,8630654,8630655,8630656,8630657,8630766,8630767,8630768,8630769,8630770,8630771,8630772,8630773,8630774,8630775,8630776,8630779,8630780,8630781,8630782,8630783,10615950,10615952,10615953,10615954,10615955,10615956,10615957,3229126,3229127,3229128,3229129,3229130,3229131,3229132,3229133,3229134,3229281,3229282,3229283,3229284,3229285,3229302,8583495,8631716,10616704,10614078,10614079,10614085,10614086,10614089,8851248,8851355,10612267,8851448,10612821,10612822,8852024,8852025,8852026,8852027,8852028,8852029,8852030,8852031,8852032,8852033,8852034,8852035,8852036,8852037,8852038,8566727,8566728,8566729,10612916,10612976,10613084,8852311,8852312,8852343,8852344,8852345,8852346,8852347,8852348,8852349,8852350,8852351,8852352,8852353,8852354,8852355,8852356,8852357,8852358,8852359,8852360,8852361,8852362,8852363,8852364,8852365,8852366,8852367,8852368,8852369,8852370,8852371,8852523,9169505,9169506,9169507,9169508,9169509,9169510,9169511,9169512,9169513,9169514,9169515,9169516,9169517,8849371,6673769,8849412,8849413,8849414,8849415,8849416,8849417,8849522,8849715,8849716,8849717,8849718,8849719,8849720,8849721,8849722,8849723,8849724,6674149,6674150,6674151,8849782,8849783,9161959,9161960,9161961,9161962,8849907,8849908,8849909,10118386,10118387,10118388,10118389,8850032,10118482,8850122,8850123,8850124,10118546,10118678,9168327,10417347,10417348,10417349,10417350,10417351,10417352,10417353,10417354,10417355,10417356,10417357,10417358,10417359,10417360,10417361,10417362,10417363,10417364,10417365,10417366,10417367,10417368,10417369,10417370,10417371,10417372,10417373,10417374,10417375,10417376,10417377,10417378,10417379,10417380,10417381,10417382,10417383,10417384,10417385,10417386,10417387,10417388,10417389,10417390,10417391,10417392,10417393,10417394,10417395,10417396,10417397,10417398,10417399,10417400,10417401,10417402,10417403,10417404,10417405,10417406,10417407,10417408,10417409,10417410,10417411,10417412,10417413,10417414,10417415,10417416,10417417,10417418,10417419,10417420,10417421,10417422,10417423,10416468,9169300,10468892,10468893,10468894,10468895,10468896,10468897,10468898,8550013,8550014,8550170,8550171,8550177,8550178,8550179,8550180,8550254,10470062,10470063,10470064,10470065,10470066,10470067,10470068,10470069,10470070,10470071,10470072,10470073,10470074,10470075,10470076,10470077,10470078,10470079,10470080,10470081,10470082,10464229,10464230,10464231,10464232,10464233,10464234,10464235,10464236,10464237,10464238,10464239,10464240,10464241,10464242,10464243,10464244,10464245,10464246,10464247,10464248,10464249,10464250,10464251,10464252,10464253,10464254,10464255,10464256,10464257,10464258,10464259,10464260,10464261,10464262,10464263,10464264,10464265,10464266,10464267,10464268,10464269,10464270,10464271,10464272,10464273,10464274,10464275,10464276,10464277,10464278,10464279,10464280,10464281,10464282,10464283,10464284,10464285,10464286,10464287,10464288,10464289,10464290,10464291,10464292,10464293,10464294,10464295,10464296,10464297,10464298,10464299,10464300,10464301,10464302,10464303,10464304,10464305,10464306,10464307,10464308,10464309,10464310,10464311,10464312,10464313,10464314,10464315,10464316,10464317,10464318,10464319,10464320,10464321,10464322,9167973,10116250,10470631,10888479,10888480,10888481,10888482,10888483,10888484,10888485,10888486,10888487,10888488,10888489,10888490,10888491,10888492,10888493,10888494,10888495,10888496,10888497,10888498,10888499,10888500,10888501,10888502,10888503,10888504,10888505,10888506,10888507,10888508,10888509,10888510,10888511,10888512,10888513,10888514,10888515,10888516,10888517,10888518,10888519,10888520,10888521,10884503,10899931,10890020,10890029,10885079,10885168,10885169,10885170,10885377,10877538,10877539,10877540,10877541,10877542,10877543,10877544,10877545,10877546,10877547,10877548,10877549,10877550,10877551,10877552,10877553,10877554,10877555,10877556,10877557,10877558,10877559,10877560,10877561,10877562,10877563,10877564,10877565,10877566,10877567,10887606,10627295,10627296,10627297,10627299,10627300,10627302,10627306,10627310,10627311,10627314,10627315,10882890,10887947,10887948,10887971,10883304,10888453,10888454,10888455,10888456,10627939,10888457,10888458,10888459,10888460,10888461,10888462,10888463,10888464,10888465,10888466,10888467,10888468,10888469,10888470,10888471,10888472,10888473,10888474,10888475,10888476,10888477,10888478,10885955,10172743,10877102,10877125,10877126,10877127,10882372,10647640,10647641,10541716,10507605,10507721,10507902,10507996,10508002,10508009,10508010,10508011,10508012,10409617,10477685,10477686,10408173,10408174,10408175,10408176,10408177,10408178,10410666,10472558,10472559,10472560,10472561,10472562,10411039,10411049,10411057,10411067,10411075,10411080,10411090,10411101,10411106) 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'