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(10472344,10472345,10472346,10472347,10472348,10472349,10472350,10472351,10472352,10472353,10472354,10472355,10472356,10472357,10472358,10472359,10472360,10472361,10472362,10472363,10472364,10472365,10472366,10472367,10472368,10472369,10472370,10472371,10472372,10472373,10472374,10472375,10472376,10472377,10472378,10472379,10472380,10472381,10472382,10472383,10472384,10472385,10472386,10472387,10472388,10472389,10472390,10472391,10472392,10472393,10472394,10472395,10472396,10472397,10472398,10472399,10472400,10472401,10472402,10472403,10472404,10472405,10472406,10472407,10472408,10472409,10472410,10472411,10472412,10472413,10472414,10472415,10472416,10472417,10472418,10472419,10472420,10472421,10472422,10472423,10472424,10472425,10472426,10472427,10472428,10472429,10472430,10472431,10472432,10472433,10472434,10472435,10472436,10472437,10472438,10472439,10472440,10472441,10472442,10472443,10472444,10472445,10472446,10472447,10472448,10472449,10472450,10472451,10472452,10472453,10472454,10472455,10472456,10472457,10472458,10472459,10472460,10472461,10472462,10472463,10472464,10472465,10472466,10472467,10472468,10472469,10472470,10472471,10472472,10472473,10472474,10472475,10472476,10472477,10472478,10472479,10472480,10472481,10472482,10472483,10472484,10472485,10472486,10488880,10488881,10488882,10488883,10488884,10488885,10488886,10488887,10472205,10472206,10472207,10472208,10472209,10472210,10472211,10472212,10472213,10472214,10472215,10472216,10472217,10472218,10472219,10472220,10472221,10472222,10472223,10472224,10472225,10472226,10472227,10472228,10472229,10472230,10472231,10472232,10472233,10472234,10472235,10472236,10472237,10472238,10472239,10472240,10472241,10472242,10472243,10472244,10472245,10472246,10472247,10472248,10472249,10472250,10472251,10472252,10472253,10472254,10472255,10472256,10472257,10472258,10472259,10472260,10472261,10472262,10472263,10472264,10472265,10472266,10472267,10472268,10472269,10472270,10472271,10472272,10472273,10472274,10472275,10472276,10472277,10472278,10472279,10472280,10472281,10472282,10472283,10472284,10472285,10472286,10472287,10472288,10472289,10472290,10472291,10472292,10472293,10472294,10472295,10472296,10472297,10472298,10472299,10472300,10472301,10472302,10472303,10472304,10472305,10472306,10472307,10472308,10472309,10472310,10472311,10472312,10472313,10472314,10472315,10472316,10472317,10472318,10472319,10472320,10472321,10472322,10472323,10472324,10472325,10472326,10472327,10472328,10472329,10472330,10472331,10472332,10472333,10472334,10472335,10472336,10472337,10472338,10472339,10472340,10472341,10472342,10472343,10158025,10158026,10158027,10158028,10158029,10158030,10158031,10158032,10158033,10158034,10158035,10158036,10158037,10158038,10158039,10158040,10158041,10158042,10158043,10158044,10158045,10158046,10158047,10158048,10158049,10158050,10158051,10158052,10158053,10158054,10158055,10158056,10158057,8904702,8904703,10158058,10158059,8904704,8904705,10158060,8904706,10158061,10158062,8904707,8904708,10158063,10158064,8904709,10158065,8904710,10158066,8904711,10158067,10158068,10158069,10158070,10158071,10158072,10158073,10158074,10158075,10158076,10158077,10158078,10158079,10158080,10158081,10158082,10158083,10158084,10158085,10158086,10158087,10158088,10158089,10158090,10158091,10158092,10158093,10158094,10158095,10158096,10158097,10158098,10158099,10158100,10158101,10158102,10158103,10158104,10158105,10158106,10158107,10158108,10158109,10158110,10158111,10158112,10158113,10158114,10158115,10158116,10158117,10158118,10158119,10158120,10158121,10158122,10158123,10158124,10158125,10158126,10158127,10158128,10158129,10158130,10158131,10158132,10158133,10158134,10158135,10158136,10158137,10158138,10158139,10158140,10158141,10158142,10158143,10158144,10158145,10158146,10158147,10158148,10158149,10158150,10158151,10158152,10158153,10158154,10158155,10158156,10158157,10158158,10158159,10158160,10158161,10158162,10158163,10158164,10158165,10158166,10158167,10158168,10158169,10158170,10158171,10158172,10158173,10158174,10158175,10158176,10158177,10158178,10158179,10158180,10158181,10158182,10158183,10158184,10158185,10158186,10158187,10158188,10158189,10158190,10158191,10158192,10158193,10158194,10158195,10158196,10158197,10158198,10158199,10158200,10158201,10158202,10158203,10158204,10158205,10158206,10158207,10158208,10158209,10158210,10158211,10158212,10158213,10158214,10158215,10158216,10158217,10158218,10158219,10158220,10158221,10158222,10158223,10158224,10158225,10158226,10158227,10158228,10158229,10158230,10158231,10158232,10158233,10158234,10158235,10158236,10158237,10158238,10158239,10158240,10158241,10158242,10158243,10158244,10158245,10158246,10158247,10158248,10158249,10158250,10158251,10158252,10158253,10158254,10158255,10158256,10158257,10158258,10158259,10158260,10158261,10158262,10158263,10158264,10158265,10158266,10158267,10158268,10158269,10158270,10158271,10158272,10158273,10158274,10158275,10158276,10158277,10158278,10158279,10158280,10158281,10158282,10158283,10158284,10158285,10158286,10158287,10158288,10158289,10158290,10158291,10158292,10158293,10158294,10158295,10158296,10158297,10158298,10158299,10158300,10158301,10158302,10158303,10158304,10158305,10158306,10158307,10158308,10158309,10158310,10158311,10158312,10158313,10158314,10158315,10158316,10158317,10158318,10158319,10158320,10158321,10158322,10158323,10158324,10158325,10158326,10158327,10158328,10158329,10158330,10158331,10158332,10158333,10158334,10158335,10158336,10158337,10158338,10158339,10158340,10158341,10158342,10158343,10158344,10158345,10158346,10158347,10158348,10158349,10158350,10158351,10158352,10158353,10158354,10158355,10158356,10158357,10158358,10158359,10158360,10158361,10158362,10158363,10158364,10158365,10158366,10158367,10158368,10158369,10158370,10158371,10158372,10158373,10158374,10158375,10158376,10158377,10158378,10158379,10158380,10158381,10158382,10158383,10158384,10158385,10158386,10158387,10158388,10158389,10158390,10158391,10158392,10158393,10158394,10158395,10158396,10158397,10158398,10158399,10158400,10158401,10158402,10158403,10158404,10158405,10158406,10158407,10158408,10158409,10158410,10158411,10158412,10158413,10158414,10158415,10158416,10158417,10158418,10158419,10158420,10158421,10158422,10158423,10158424,10158425,10158426,10158427,10158428,10158429,10158430,10158431,10158432,10158433,10158434,10158435,10158436,10158437,10158438,10158439,10158440,10158441,10158442,10158443,10158444,10158445,10158446,10158447,10158448,10158449,10158450,10158451,10158452,10158453,10158454,10158455,10158456,10158457,10158458,10158459,10158460,10158461,10158462,10158463,10158464,10158465,10158466,10158467,10158468,10158469,10158470,10158471,10158472,10158473,10158474,10158475,10158476,10158477,10158478,10158479,10158480,10158481,10158482,10158483,10158484,10158485,10158486,10158487,10158488,10158489,10158490,10158491,10158492,10158493,10158494,10158495,10158496,10158497,10158498,10158499,10158500,10158501,10158502,10158503,10158504,10158505,10158506,10158507,10158508,10158509,10158510,10158511,10158512,10158513,10158514,10158515,10158516,10158517,10158518,10158519,10158520,10158521,10158522,10158523,10158524,10158525,10158526,10158527,10158528,10158529,10158530,10158531,10158532,10158533,10158534,10158535,10158536,10158537,8553483,8553484,8553485,8553486,8553487,8553488,8553489,8553490,8553491,8553492,8553493,8553494,8553495,8553496,8553497,8553498,8553499,8553500,8553501,8553502,8553503,8553504,8553505,8553506,8553507,8553508,8553509,7065041,7065042,7065043,7065044,7065045,7065046,7065047,7065048,7065049,7065050,7065051,7065052,7065053,7065054,7065055,7065056,7065057,7065058,7065059,7065060,7065061,7065062,7065063,7065064,7065065,7065066,7065067,7065068,7065069,7065070,7065071,7065072,7065073,7065074,7065075,7065076,7065077,7065078,7065079,7065080,7065081,7065082,7065083,7065084,7065085,7065086,7065087,7065088,7065089,7065090,7055159,7055160,7055161,7055162,7055163,7055164,7055165,7055166,7055167,7055168,7055169,7055170,7055171,7055172,7055173,7055174,7055175,7055176,7055177,7055178,7055179,7055180,7055181,7055182,7055183,7055184,7055185,7055186,7055187,7055188,7055189,7055190,7055191,7055192,3228310,3228311,3228312,3228313,3228314,3228315,3228316,3228317,3228318,3228319,3228320,3228321,3228322,3228323,3228324,3228325,3228326,3228327,3228328,3228329,3228330,3228331,3228332,3228333,3228334,3228335,3228336,3228337,3228338,3228339,3228340,3228341,3228342,3228343,3228344,3228345,3228346,3228347,3228348,3228349,3228350,3228351,3228352,3228353,3228354,3228355,3228356,3228357,3228358,3228359,3228360,3228361,3228362,3228363,3228364,3228365,3228366,3228367,3228368,3228369,3228370,3228371,3228372,3228373,3228374,3228375,3228376,3228377,3228378,3228379,3228380,3228381,3228382,3228383,3228384,3228385) 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'