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(8068842,10943619,10943620,10943621,10943622,10943623,10943624,10943625,10943626,10943627,4970700,4970763,4970765,4970766,10944080,10944081,10944082,10944083,4971143,4968321,4968322,4968323,4968324,4968325,4968326,4968327,4968328,4968329,4968330,4968331,4968332,4968333,4968334,4968335,4968336,4968337,4968338,4968339,4968341,10437208,10437265,4968849,4968859,4968860,4969177,8067859,8067968,8067969,8067970,8067971,8067972,8067973,8067974,8067975,8067976,8067977,8068032,8068033,8068034,8068035,8068036,8068037,8068038,8068039,8068065,8068086,8068087,8068088,8068089,8068090,8068091,8068092,8068093,8068094,8068095,8068096,8068173,8068174,8068175,8068176,8068177,8068178,8068179,8068180,8068181,8068182,8068183,8068184,8068185,8068186,8068187,8068188,8068189,4969619,8068266,4969620,8068267,8068268,4969621,4969622,8068269,4969623,8068270,4969624,8068271,8068302,8068335,8068336,8068337,8068338,8068339,8068340,8068341,8068342,8068343,8068344,8068345,8068346,8068347,8068348,8068407,8068408,8068409,8068410,8068411,8068412,8068413,8068414,8068415,8068416,8068417,8068418,8068452,8068458,8068459,8068460,8068468,8068530,8068531,8068532,8068533,8068534,8068535,8068536,8068537,8068538,8068539,8068718,8068719,10932089,10932206,10932220,10932798,10932828,10932841,10932842,10932843,10932844,10932845,10932846,10932847,10932848,10932849,10932850,4968029,10942630,10942633,10942825,10943158,10943250,10943253,10943254,10943315,10943325,10943327,10943404,10943408,10943415,10940532,10940561,8072723,8072724,8072725,8072726,8072727,10941787,10941792,10941808,10941826,10941828,10941832,10941834,10941885,10941895,10941999,10942020,10942099,10623065,10623185,10623186,10623187,10623188,10623189,10623190,10623191,10623192,10623193,10623194,10623195,10623196,10623197,10623328,10623422,10925111,10925112,10925113,10925114,10925115,10925116,10925117,10925118,10925119,10925120,10925121,10925122,10925123,10922472,10922473,10621979,10621980,10922693,10922694,10622404,10622405,10622406,10622407,10923108,10923109,10923115,10923123,10923150,10923160,10923184,10622677,10622678,10622679,10923190,10622680,10923191,10923204,10622714,10923225,10923226,10923228,10923229,10923231,10923234,10923235,10923236,10923237,10622727,10923238,10923239,10923241,10923242,10923245,10923247,10923249,10923251,10923254,10923255,10923258,10923259,10923263,10923264,10923266,10923269,10923271,10923290,10923292,10923294,10923295,10923296,10923321,10923323,10923324,10923326,10923329,10923330,10923331,10923340,10923341,10923343,10923344,10923347,10923348,10923351,10923352,10923355,10923356,10923367,10923380,10923381,10923383,10923384,10622919,10619985,10619986,10620012,10620013,10620046,10620065,10620106,10920692,10920693,10920694,10920695,10920696,10920697,10920698,10920699,10920700,10920701,10920702,10920703,10920704,10920705,10920706,10920707,10920708,10920709,10920710,10920711,10920712,10920713,10920714,10920715,10920716,10920717,10920718,10920719,10920720,10920721,10920722,10920723,10920724,10920725,10920726,10920727,10920728,10920729,10920730,10920731,10920732,10920733,10920734,10920735,10920736,10920737,10920738,10620235,10620236,10620271,10620323,10620324,10620328,10620329,10620379,10620380,10620381,10620382,10620383,10620384,10620385,10620386,10620387,10620388,10620414,10620487,10921034,10921035,10921036,10921037,10921038,10921039,10921040,10921041,10921042,10921043,10921044,10921045,10921046,10921047,10921048,10921049,10921050,10921051,10921052,10921053,10921054,10921055,10921056,10921057,10921058,10921059,10921060,10921061,10921062,10921063,10921064,10921065,10921066,10921067,10921068,10921069,10921070,10921071,10921072,10921073,10921074,10921075,10921076,10921077,10921078,10921079,10921080,10921081,10921082,10921083,10921084,10921085,10921086,10921087,10921088,10921089,10921090,10921091,10921092,10921093,10921094,10921095,10921096,10921097,10921098,10921099,10921100,10921101,10921102,10921103,10921104,10921105,10921106,10921107,10921108,10921109,10921110,10921111,10921112,10921113,10921114,10921115,10921116,10921117,10921118,10921119,10921120,10921121,10921122,10921123,10921124,10921125,10921126,10921127,10921128,10921129,10921130,10921131,10921132,10921133,10921134,10921135,10921136,10921137,10921138,10921139,10921140,10921141,10921142,10921143,10921144,10921145,10921146,10921147,10921148,10921149,10921150,10921151,10921152,10921153,10921154,10921155,10921156,10921157,10921158,10921159,10921160,10921161,10921162,10921163,10921164,10921165,10921166,10921167,10921168,10921169,10921170,10921171,10921172,10921173,10921174,10921175,10921176,10921177,10921178,10921179,10921180,10921181,10921182,10921183,10921184,10921185,10921186,10921187,10921188,10921189,10921190,10921191,10921192,10921193,10921194,10921195,10921196,10921197,10921198,10921199,10921525,10921526,10921527,10921528,10921529,10921530,10921531,10921532,10921533,10621077,10621078,10921595,10921605,10921606,10921611,10621122,10621123,10621153,10621154,10621247,10621248,10621249,10621250,10621251,10621269,10621294,10621295,10621310,10621311,10621312,10621313,10621314,10621315,10621341,10621342,10621363,10621364,10621365,10621366,10621367,10621373,10621389,10621390,10621391,10621392,10621393,10621394,10621395,10621396,10922072,10621572,10621573,10621574,10621583,10621637,10621638,10621668,10621669,10621670,10621718,10621719,10621720,10621721,10922293,10922294,10922308,10922309,10922310,10922464,10922465,10922466,10922467,10922468,10922469,10922470,10922471,10565189,10565225,10565318,10565338,10565339,10565340,10565341,10565342,10614228,10614271,10614451,10565648,10614518,10614538,10614567,10614568,10614729,10565885,10565886,10565887,10565888,10565889,10565890,10565891,10565892,10565927,10614781,10614782,10614783,10614784,10565937,10565938,10614804,10614805,10565957,10565958,10565959,10565963,10565964,10565965,10565966,10565967,10565968,10565969,10565970,10565971,10565972,10565973,10565974,10565975,10565976,10565977,10565978,10566007,10614858,10566008,10614859,10566016,10566017,10566018,10566019,10566020,10566021,10566022,10566023,10566039,10566064,10566065,10612026,10612091,10612092,10612189,10612342,10612408,10612409,10612410,10563568,10612521,10612522,10612523,10612559,10612562,10612624,10563923,10563924,10563925,10563926,10563927,10563928,10563929,10563930,10563931,10563932,10563933,10563934,10563935,10563936,10563937,10563938,10563939,10563940,10563941,10563942,10563943,10563944,10563945,10563946,10563947,10563948,10563949,10563950,10612800,10563951,10563952,10563953,10563954,10563955,10563956,10563957,10563958,10563959,10563960,10563961,10563962,10563963,10563964,10563965,10563966,10563967,10563968,10563969,10563970,10563971,10563972,10563973,10563974,10563975,10563976,10563977,10563978,10563979,10563980,10563981,10563982,10563983,10563984,10563985,10563986,10563987,10563988,10563989,10563990,10563991,10563992,10563993,10563994,10612845,10563995,10563996,10563997,10563998,10563999,10564000,10564001,10564002,10564003,10564004,10564005,10564006,10564007,10564008,10564009,10564010,10564011,10564012,10564013,10564014,10564015,10564016,10564017,10564018,10564019,10564020,10564021,10564022,10564023,10564024,10564025,10564026,10612877,10564027,10612878,10564028,10564029,10564030,10564031,10564032,10564033,10564034,10564035,10564036,10564037,10564038,10564039,10564040,10564041,10564042,10564043,10564044,10564045,10564046,10564047,10564048,10564049,10564050,10564051,10564052,10564053,10564054,10564055,10564056,10564057,10564058,10564059,10564060,10564061,10564062,10564063,10564064,10564065,10564066,10612917,10564067,10564068,10564069,10564070,10564071,10564072,10564073,10564074,10564075,10564076,10564077,10564078,10564079,10564080,10564081,10564082,10564083,10564084,10564085,10564086,10564087,10564088,10564089,10564090,10564091,10564092,10564093,10564094,10564095,10564096,10564097,10564098,10564099,10564100,10564101,10564102,10564103,10564104,10564105,10564106,10564107,10564108,10564109,10564110,10564111,10564112,10564113,10564114,10564115,10564116,10564117,10564118,10564119,10564120,10564121,10564122,10564123,10612997,10613005,10613018,10613066,10613175,10613176,10613191,10613192,10613232,10613233,10613234,10613385,10613555,10613666,10613667,10613670,10613741,10613745,10613757,10613758,10613772,10511184,10511185,10511204,10511205,10511206,10511207,10511208,10511234,10511235,10511236,10511237,10511238,10511267,10517267,10511268,10517268,10511269,10517269,10517317,10517318,10517325,10517326,10517327,10517552,10517614,10517615,10517616,10517654,10517655,10517673,10517674,10517675,10517682,10517683,10517684,10419404,10419405,10419438,10419439,10419564,10419565,10419940,10420002,10420125,10420160,10420161,10420178,10420179,10420187,10420193,10420206,10420210,10420213,10471537,10471541,10470345,10470346,10470347,10470348,10470349,10470350,10470351,10470352,10470353,10470354,10470355,10470647,10470648,10470804) 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'