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(4970685,4970686,4970687,4970688,4970689,4970690,4970691,4970692,4970693,4970694,4970695,4970696,4970697,4970698,4970699,4970741,4970742,4968342,8067906,8067907,8067908,8067909,8067914,8067915,8067916,8067917,8067918,8067928,8067933,8067934,8067935,8067936,8067942,10623247,10623248,10623249,10623250,10623251,10623252,10623256,10623257,10623508,10925108,10925109,10925110,10925111,10925112,10925113,10925114,10925115,10925116,10925117,10925118,10925119,10925120,10925121,10925122,10925123,10925124,10925376,10925377,10925378,10925379,10925380,10925381,10925382,10925383,10925384,10925385,10925386,10925387,10925388,10925389,10925390,10925391,10925392,10925393,10925394,10925395,10925396,10925397,10925398,10925399,10925400,10925401,10925402,10925403,10925404,10925405,10925406,10925407,10925408,10925409,10925410,10925411,10925412,10925413,10925414,10925415,10925416,10925417,10925418,10925419,10925420,10925421,10925422,10925423,10925424,10925425,10925426,10925427,10925428,10925429,10925430,10925431,10925432,10925433,10925434,10925435,10925436,10925437,10925438,10925439,10925440,10925441,10925442,10925443,10925444,10925445,10925446,10925447,10925448,10925449,10925456,10925457,10925458,10925459,10925460,10925461,10925462,10925463,10925464,10925465,10925466,10925467,10925468,10925469,10925470,10925471,10925472,10925473,10925474,10925475,10925477,10925478,10923108,10923109,10923110,10923111,10923112,10923113,10923114,10923115,10923116,10923117,10923118,10923119,10923120,10923121,10923122,10923123,10923124,10923125,10923126,10923127,10923128,10923129,10923130,10923131,10923132,10923133,10923134,10923135,10923136,10923137,10923138,10923139,10923140,10923141,10923142,10923143,10923144,10923145,10923146,10923147,10923148,10923149,10923150,10923151,10923152,10923153,10923154,10923155,10923156,10923157,10923158,10923159,10923160,10923161,10923162,10923163,10923164,10923165,10923166,10923167,10923168,10923169,10923170,10923171,10923172,10923173,10923174,10923175,10923176,10923177,10923178,10923179,10923180,10923181,10923182,10923183,10923184,10923185,10923186,10923187,10923188,10923189,10923190,10923191,10923192,10923193,10923194,10923195,10923196,10923197,10923198,10923199,10923200,10923201,10923202,10923203,10923204,10923205,10923207,10923208,10923209,10923210,10923211,10923212,10923213,10923214,10923215,10923216,10923217,10923218,10923219,10923220,10923221,10923222,10923223,10923224,10923225,10923226,10923227,10923228,10923229,10923230,10923231,10923232,10923233,10923234,10923235,10923236,10923237,10923238,10923239,10923240,10923241,10923242,10923243,10923244,10923245,10923246,10923247,10923248,10923249,10923250,10923251,10923252,10923253,10923254,10923255,10923256,10923257,10923258,10923259,10923260,10923261,10923262,10923263,10923264,10923265,10923266,10923267,10923269,10923270,10923271,10923272,10923273,10923274,10923275,10923276,10923277,10923278,10923279,10923280,10923281,10923282,10923283,10923284,10923285,10923286,10923287,10923288,10923289,10923290,10923291,10923292,10923293,10923294,10923295,10923296,10923297,10923298,10923299,10923300,10923301,10923302,10923303,10923304,10923305,10923306,10923307,10923308,10923309,10923310,10923311,10923312,10923313,10923314,10923315,10923316,10923317,10923318,10923319,10923320,10923321,10923322,10923323,10923324,10923325,10923326,10923327,10923328,10923329,10923330,10923331,10923332,10923333,10923334,10923335,10923336,10923337,10923338,10923339,10923340,10923341,10923342,10923343,10923344,10923345,10923346,10923347,10923348,10923349,10923350,10923351,10923352,10923353,10923354,10923355,10923356,10923357,10923358,10923359,10923360,10923361,10923362,10923363,10923364,10923365,10923366,10923367,10923368,10923369,10923370,10923371,10923372,10923373,10923374,10923375,10923376,10923377,10923378,10923379,10923380,10923381,10923382,10923383,10923384,10923385,10620195,10620196,10620197,10620198,10620199,10621051,10621052,10565127,10614050,10565304,10565305,10565306,10565307,10565308,10565309,10565310,10565311,10565312,10565313,10565314,10565315,10565316,10565317,10565319,10614200,10614210,10614211,10614213,10614215,10614217,10614218,10614221,10614274,10614282,10614286,10614287,10614288,10614289,10614290,10614291,10614292,10614293,10614294,10614295,10614296,10614297,10614298,10614299,10614300,10614301,10614302,10614303,10614304,10614305,10614306,10614307,10614308,10614309,10614310,10614311,10614312,10614313,10614314,10614446,10614449,10614450,10614452,10614456,10565700,10565701,10565702,10565703,10565704,10565705,10565706,10614566,10614567,10614568,10614629,10614663,10614865,10614866,10614867,10614868,10614869,10614870,10614871,10614872,10614873,10614874,10614875,10614876,10614877,10614878,10614879,10614880,10614881,10614882,10614883,10614884,10614885,10614886,10614887,10614888,10614889,10614890,10614891,10614892,10614893,10614894,10614895,10614896,10614897,10614898,10614899,10614900,10614901,10614902,10614903,10614904,10614905,10614906,10614907,10614908,10614909,10614910,10614911,10614912,10614913,10614914,10614915,10614916,10614917,10614918,10614919,10614920,10614921,10614922,10614923,10614924,10614925,10614926,10614927,10614928,10614929,10614930,10614931,10614932,10614933,10566084,10614934,10614935,10614936,10614937,10614938,10614939,10614940,10614941,10614942,10614943,10614944,10614945,10614946,10614947,10614948,10614949,10614950,10614951,10614952,10614953,10614954,10614955,10614956,10614957,10614958,10614959,10614960,10614961,10612053,10612061,10612214,10612215,10612216,10612217,10612218,10612219,10612220,10612221,10612222,10612223,10612224,10612263,10612264,10612297,10612298,10612299,10612300,10612301,10612302,10612303,10612304,10612305,10612306,10612307,10612308,10612309,10612310,10612311,10612312,10612313,10612314,10612315,10612316,10612317,10612318,10612319,10612320,10612321,10612322,10612323,10612324,10612325,10612326,10612327,10612328,10612329,10612330,10612331,10612332,10612333,10612334,10612335,10612336,10612337,10612338,10612339,10612340,10612341,10612342,10612343,10612344,10612345,10612346,10612347,10612348,10612349,10612350,10612351,10612352,10612353,10612354,10612355,10612356,10612357,10612358,10612359,10612360,10612361,10612362,10612363,10612364,10612365,10612366,10612367,10612368,10612369,10612370,10612371,10612372,10612373,10612374,10612375,10612376,10612377,10612378,10612379,10612380,10612381,10612382,10612383,10612384,10612385,10612386,10612387,10612388,10612389,10612390,10612391,10612392,10612393,10612394,10612395,10612396,10612397,10612398,10612399,10612400,10612401,10612402,10612403,10612404,10612405,10612406,10612407,10612408,10612409,10612410,10612411,10612412,10612413,10612414,10612415,10612416,10612417,10612418,10612419,10612420,10612421,10612422,10612423,10612424,10612425,10612426,10612427,10612428,10612429,10612430,10612431,10612432,10612433,10612434,10612435,10612436,10612437,10612438,10612439,10612440,10612441,10612442,10612443,10612444,10612445,10612446,10612447,10612448,10612449,10612450,10612451,10612452,10612453,10612454,10612455,10612456,10612457,10612458,10612459,10612460,10612461,10612462,10612463,10612464,10612465,10612466,10612467,10612468,10612469,10612470,10612471,10612472,10612473,10612474,10612475,10612476,10612477,10612478,10612479,10612480,10612481,10612482,10612483,10612484,10612485,10612486,10612487,10612488,10612489,10612490,10612491,10612492,10612493,10612494,10612495,10612496,10612497,10612498,10612499,10612500,10612501,10612502,10612503,10612504,10612505,10612506,10612507,10612508,10612509,10612510,10612511,10612512,10612513,10612514,10612515,10612516,10612517,10612518,10612519,10612520,10612521,10612522,10612523,10612524,10612525,10612526,10612527,10612528,10612529,10612530,10612531,10612532,10612533,10612534,10612535,10612536,10612537,10612538,10612539,10612540,10612541,10612542,10612543,10612544,10612545,10612546,10612547,10612548,10612549,10612550,10612551,10612552,10612553,10612554,10612555,10612556,10612557,10612558,10612559,10612560,10612561,10612562,10612563,10612564,10612565,10612566,10612567,10612568,10612569,10612570,10612571,10612572,10612573,10612574,10612575,10612576,10612577,10612578,10612579,10612580,10612581,10612582,10612583,10612584,10612585,10612586,10612587,10612588,10612589,10612590,10612591,10612592,10612593,10612594,10612595,10612596,10612597,10517656,10517681,10419221,10419222,10419223,10419224,10419225,10419226,10419257,10419306,10419349,10419350,10419371,10419372,10419437,10419438,10419439,10419813,10419814,10419815,10419816,10419817,10419818,10419819,10419820,10419821,10419822,10419823,10419824,10419825,10419826,10419827,10419828,10419829,10419830,10419831,10419832,10419833,10419834,10419835,10419836,10419837,10419838,10419839,10419840,10419841,10419842,10419843,10419844,10419845,10419846,10419847,10419848,10419849,10419850,10471029,10471030,10471031,10471032,10471033,10471034,10471035,10471036,10471037,10471038,10471039,10469876,10469877,10469878,10469879,10469880,10470112,10470113,10470114,10470115) 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'