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(8627010,8627011,8627012,8627013,8627014,8627015,8627016,8627017,8627018,8627019,8627020,8627021,8627022,8627023,8627024,8627025,8627026,8627027,8627028,8627029,8627030,8627031,8627032,8627033,8627034,8627035,8627036,8627037,8627038,8627039,8627040,8627041,8627042,8627043,8627044,8627045,8627046,8627047,8627048,8627049,8627050,8627051,8627052,8627053,8627054,8627055,8627056,8627057,8627058,8627059,8627060,8627061,8627062,8627063,8627064,8627065,8627066,8627067,8627068,8627069,8627070,8627071,8627072,8627073,8627074,8627075,8627076,8627077,8627078,8627079,8627080,8627081,8627082,8627083,8627084,8627085,8627086,8627087,8627088,8627089,8627090,8627091,8627092,8627093,8627094,8627095,8627096,8627097,8627098,8627099,8627100,8627101,8627102,8627103,10842131,8627104,8627105,8627106,8627107,8627108,8627109,8627110,8627111,8627112,8627113,8627114,8627115,8627116,8627117,8627118,8627119,8627120,8627121,8627122,8627123,8627124,8627125,8627126,8627127,8627128,8627129,8627130,8627131,8627132,8627133,8627134,8627135,8627136,8627137,8627138,8627139,8627140,8627141,8627142,8627143,8627144,8627145,8627146,8627147,8627148,8627149,8627150,8627151,8627152,8627153,8627154,8627155,8627156,8627157,8627158,8627159,8627160,8627161,8627162,8627163,8627164,8627165,8627166,8627167,8627168,8627169,8627170,8627171,8627172,8627173,8627174,8627175,8627176,8627177,8627178,8627179,8627180,8627181,8627182,8627183,8627184,8627185,8627186,8627187,8627188,8627189,8627190,8627191,8627192,8627193,8627194,8627195,8627196,8627197,8627198,8627199,8627200,8627201,8627202,8627203,8627204,8627205,8627206,8627207,8627208,8627209,8627210,8627211,8627212,8627213,8627214,8627215,8627216,8627217,8627218,8627219,8627220,8627221,8627222,8627223,8627224,8627225,8627226,8627227,8627228,8627229,8627230,8627231,8627232,8627233,8627234,8627235,8627236,8627237,8627238,8627239,8627240,8627241,8627242,8627243,8627244,8627245,8627246,8627247,8627248,8627249,8627250,8627251,8627252,8627253,8627254,8627255,8627256,8627257,8627258,8627259,8627260,8627261,8627262,8627263,8627264,8627265,8627266,8627267,8627268,8627269,8627270,8627271,10102676,8627272,8627273,8627274,8627275,8627276,8627277,8627278,8627279,8627280,8627281,8627282,8627283,8627284,8627285,8627286,8627287,8627288,8627289,8627290,8627291,8627292,8627293,8627294,8627295,8627296,8627297,8627298,8627299,8627300,8627301,8627302,8627303,8627304,8627305,8627306,8627307,8627308,8627309,8627310,8627311,8627312,8627313,8627314,8627315,8627316,8627317,8627318,8627319,8627320,8627321,8627322,8627323,8627324,8627325,8627326,8627327,8627328,8627329,8627330,8627331,8627332,8627333,8627334,8627335,8627336,8627337,8627338,8627339,8627340,8627341,8627342,8627343,8627344,8627345,8627346,8627347,8627348,8627349,8627350,8627351,8627352,8627353,8627354,8627355,8627356,8627357,8627358,8627359,8627360,8627361,8627362,8627363,8627364,8627365,8627366,8627367,8627368,8627369,8627370,8627371,8627372,8627373,8627374,8627375,8627376,8627377,8627378,8627379,8627380,8627381,8627382,8627383,8627384,8627385,8627386,8627387,8627388,8627389,8627390,8627391,8627392,8627393,8627394,8627395,8627396,8627397,8627398,8627399,8627400,8627401,8627402,8627403,8627404,8627405,8627406,8627407,8627408,8627409,8627410,8627411,8627412,8627413,8627414,8627415,8627416,8627417,8627418,8627419,8627420,8627421,8627422,8627423,8627424,8627425,8627426,8627427,8627428,8627429,8627430,8627431,8627432,8627433,8627434,8627435,8627436,8627437,8627438,8627439,8627440,8627441,8627442,8627443,8627444,8627445,8627446,8627447,8627448,8627449,8627450,8627451,8627452,8627453,8627454,8627455,8627456,8627457,8627458,8627459,8627460,8627461,8627462,8627463,8627464,8627465,8627466,8627467,8627468,8627469,8627470,8627471,8627472,8627473,8627474,8627475,8627476,8627477,8627478,8627479,8627480,8627481,8627482,8627483,8627484,8627485,8627486,8627487,8627488,8627489,8627490,8627491,8627492,8627493,8627494,8627495,8627496,8627497,8627498,8627499,8627500,8627501,8627502,8627503,8627504,8627505,8627506,8627507,8627508,8627509,8627510,8627511,8627512,8627513,8627514,8627515,8627516,8627517,8627518,8627519,8627520,8627521,8627522,8627523,8627524,8627525,8627526,8627527,8627528,8627529,8627530,8627531,8627532,8627533,8627534,8627535,8627536,8627537,8627538,8627539,8627540,8627541,8627542,8627543,8627544,8627545,8627546,8627547,8627548,8627549,8627550,8627551,8627552,8627553,8627554,8627555,8627556,8627557,8627558,8627559,8627560,8627561,8627562,8627563,8627564,8627565,8627566,8627567,8627568,8627569,8627570,8627571,8627572,8627573,8627574,8627575,8627576,8627577,8627578,8627579,8627580,8627581,8627582,8627583,8627584,8627585,8627586,8627587,8627588,8627589,8627590,8627591,8627592,8627593,8627594,8627595,8627596,8627597,8627598,8627599,8627600,8627601,8627602,8627603,8627604,8627605,8627606,8627607,8627608,8627609,8627610,8627611,8627612,8627613,8627614,8627615,8627616,8627617,8627618,8627619,8627620,8627621,8627622,8627623,8627624,8627625,8627626,8627627,8627628,8627629,8627630,8627631,8627632,8627633,8627634,8627635,8627636,8627637,8627638,8627639,8627640,8627641,8627642,8627643,8627644,8627645,8627646,8627647,8627648,8627649,8627650,8627651,8627652,8627653,8627654,8627655,8627656,8627657,8627658,8627659,8627660,8627661,8627662,8627663,8627664,8627665,8627666,8627667,8627668,8627669,8627670,8627671,8627672,8627673,8627674,8627675,8627676,8627677,8627678,8627679,8627680,8627681,8627682,8627683,8627684,8627685,8627686,8627687,8627688,8627689,8627690,8627691,8627692,8627693,8627694,8627695,8627696,8627697,8627698,8627699,8627700,8627701,8627702,8627703,8627704,8627705,8627706,8627707,8627708,8627709,8627710,8627711,8627712,8627713,8627714,8627715,8627716,8627717,8627718,8627719,8627720,8627721,8627722,8627723,8627724,8627725,8627726,8627727,8627728,8627729,8627730,8627731,8627732,8627733,8627734,8627735,8627736,8627737,8627738,8627739,8627740,8627741,8627742,8627743,8627744,8627745,8627746,8627747,8627748,8627749,8627750,8627751,8627752,8627753,8627754,8627755,8627756,8627757,8627758,8627759,8627760,8627761,8627762,8627763,8627764,8627765,8627766,8627767,8627768,8627769,8627770,8627771,8627772,8627773,8627774,8627775,8627776,8627777,8627778,7201299,8627779,7201300,7201301,8627780,8627781,7201302,8627782,7201303,8627783,8627784,8627785,8627786,8627787,8627788,8627789,7201310,8627790,8627791,8627792,8627793,8595069,8628250,8628385,8628386,8628387,8628388,7073281,10101554,10839451,8624702,8624703,8624704,8624705,8624706,8624707,8908214,8908215,8908216,8625194,8625195,8625218,8625219,8625220,8625221,8625222,8625223,8625224,8625225,8625226,8625227,8625228,8625229,8625230,8625231,10073779,8625485,8625486,8625487,8625488,7069358,7069359,7069360,7069361,7069362,7069363,10284184,3234038,8540876,8634434,8634670,8634671,8634672,8541502,8541531,8541532,8634778,8634779,8634780,8634781,8634782,8634783,8634784,8634785,8634786,8634787,8634788,8634789,8634790,8634791,8634792,8634793,8634794,8634795,8634796,8634797,10283226,8631521,8631522,8631523,8631524,8631525,8631526,8631527,8631528,8631529,8631530,8631531,8631532,8631533,8631534,8631535,8631536,8631537,8583879,10622187,10622188,10622189,10099315,10099409,10099410,10099412,10099415,10099417,10615265,7202345,7202346,7202347,9794587,9794588,8572755,10099019,9220321,9220322,9212406,9212422,9212447,9169934,10118339,10118340,10118341,10118342,10558306,8542411,10564943,8542791,8542794,8550812,10513381,10513382,10513383,10513384,10513385,8551311,10517994,10517995,9168872,10125322,10125323,10514629,10117544,10117754,9193594,9190801,9190807,9190818,9206969,9206970,9206972,9206982,8550558,9196842,9173042,9213528,9166031,9182279,9182280,9182281,10628407,10628753,10678701,10671067,10162218,10658574,10626756,10626786,10598518,10580519,10598519,10580520,10598520,10580521,10650048,10650049,10650050,10650051,10650052,10650053,10650054,10650055,10650056,10650057,10590574,10590575,10590576,10524869,10524870,10524871,10524872,10524873,10524874,10524875,10524876,10524877,10524878,10524879,10524880,10524881,10524882,10524883,10524884,10524885,10524886,10524887,10524888,10524889,10524890,10524891,10524892) 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'