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(11001532,11001533,10939603,11001668,11002071,11002072,10989160,11002292,11002293,11002294,11002295,11002296,11002494,11002495,10976516,11002650,11002828,8067215,7074253,11002943,11003042,7066619,11003389,10961779,10961780,10961781,10961831,10987951,7067699,11001452,11001453,10972738,10972874,10972956,10973130,7072773,7072922,8066037,10961329,10961404,10961405,10961406,7071208,10959004,10959005,7071724,7071786,10969716,10970037,10970038,10970333,10970424,10970425,10970782,10970783,10941843,10997112,10997113,10997114,10997115,10971185,10997236,10997237,10997328,10918551,10918552,10919021,10919022,10919024,10919025,10919026,10919326,10919349,10919350,10994600,10994601,10994717,10919693,10919694,10994837,10968837,10994838,10919946,10919947,10919948,10919949,10919950,10919951,10919952,10919953,10919954,10919955,10919956,10919957,10919958,10919959,10919960,10919961,10919962,10919963,10919964,10919965,10919966,10919967,10919968,10919969,10919970,10919971,10919972,10919973,10919974,10919975,10919976,10919977,10919978,10919979,10919980,10919981,10919982,10919983,10919984,10919985,10919986,10919987,10919988,10919989,10919990,10919991,10919992,10919993,10919994,10919995,10919996,10919997,10919998,10919999,10920000,10920001,10920002,10920003,10920004,10920005,10920006,10920007,10920008,10920009,10920010,10920011,10920012,10920013,10920014,10920015,10920016,10920017,10920018,10920019,10920020,10920021,10920022,10920023,10920024,10920025,10920026,10920027,10920028,10920029,10920030,10920031,10920032,10920033,10920034,10920035,10920036,10920037,10920038,10920039,10920040,10920041,10920042,10920043,10920044,10920045,10920046,10920047,10920048,10920049,10920050,10920051,10920052,10920053,10920054,10920055,10920056,10920057,10920058,10920059,10920060,10920061,10920062,10920063,10920064,10920065,10920066,10920067,10920068,10920069,10920070,10920071,10920072,10920073,10920074,10920075,10920076,10920077,10920078,10920079,10920080,10920081,10920082,10920083,10920084,10920085,10920086,10920087,10920088,10920089,10920090,10920091,10920092,10920093,10920094,10920095,10920096,10920097,10920098,10920099,10920100,10920101,10920102,10920103,10920104,10920105,10920106,10920107,10920108,10920109,10920110,10920111,10920112,10920113,10920114,10920115,10920116,10920117,10920118,10920119,10920120,10920121,10920122,10920123,10920124,10920125,10920126,10920127,10920128,10920129,10920130,10920131,10920132,10920133,10920134,10920135,10920136,10920137,10920138,10920139,10920140,10920141,10920142,10920143,10920144,10920145,10920146,10920147,10920148,10920149,10920150,10920151,10920152,10920153,10920154,10920155,10920156,10920157,10920158,10920159,10920160,10920161,10920162,10920163,10920164,10920165,10920166,10920167,10920168,10920169,10920170,10920171,10920172,10920173,10920174,10920175,10920176,10920177,10920178,10920179,10920180,10920181,10920182,10920183,10920184,10920185,10920186,10920187,10920188,10920189,10920190,10920191,10920192,10920193,10920194,10920195,10920196,10920197,10920198,10920199,10920200,10920201,10920202,10920203,10920204,10920205,10920206,10920207,10920208,10920209,10920210,10920211,10920212,10920213,10920214,10920215,10920216,10920217,10920218,10920219,10920220,10920221,10920222,10920223,10920224,10920225,10920226,10920227,10920228,10920229,10920230,10920231,10920232,10920233,10920234,10920235,10920236,10920237,10920238,10920239,10920240,10920241,10920242,10920243,10920244,10920245,10920246,10920247,10920248,10920249,10920250,10920251,10920252,10920253,10920254,10920255,10920256,10920257,10920258,10920259,10920260,10920261,10920262,10920263,10920264,10920265,10920266,10920267,10920268,10920269,10920270,10920271,10920272,10920273,10920274,10920275,10920276,10920277,10920278,10920279,10920280,10920281,10920282,10920283,10920284,10920285,10920286,10920287,10920288,10920289,10920290,10920291,10920292,10920293,10920294,10920295,10920296,10920297,10920298,10920299,10920300,10920301,10920302,10920303,10920304,10920305,10920306,10920307,10920308,10920309,10920310,10920311,10920312,10920313,10920314,10920315,10920316,10920317,10920318,10920319,10920320,10920321,10920322,10920323,10920324,10920325,10920326,10920327,10920328,10920329,10920330,10920331,10920332,10920333,10920334,10920335,10920336,10920337,10920338,10920339,10920340,10920341,10920342,10920343,10920344,10920345,10920346,10920347,10920348,10920349,10920350,10920351,10920352,10920353,10920354,10920355,10920356,10920357,10920358,10920359,10920360,10920361,10920362,10920363,10920364,10969393,10920365,10920366,10969394,10969395,10920367,10920368,10920369,10920370,10920371,10920372,10920373,10920374,10920375,10920376,10920377,10920378,10920379,10920380,10920381,10920382,10920383,10920384,10920385,10920386,10920387,10920388,10920389,10920390,10920391,10920392,10920393,10920394,10920395,10920396,10920397,10920398,10920399,10920400,10920401,10920402,10920403,10920404,10920405,10920406,10920407,10920408,10920409,10920410,10920411,10920412,10920413,10920414,10920415,10920416,10920417,10920418,10920419,10920420,10920421,10920422,10920423,10920424,10920425,10920426,10920427,10920428,10920429,10920430,10920431,10920432,10920433,10920434,10920435,10920436,10920437,10920438,10920439,10920440,10920441,10920442,10920443,10920444,10920445,10920446,10920447,10920448,10920449,10920450,10920451,10920452,10920453,10920454,10920455,10920456,10920457,10920458,10920459,10920460,10920461,10920462,10920463,10920464,10920465,10920466,10920467,10920468,10920469,10920470,10920471,10918061,10918201,10918202,10918203,10918403,10918404,10920472,10920473,10920474,10920475,10920476,10920477,10920478,10920479,10920480,10920481,10920482,10920483,10920484,10920485,10920486,10920487,10920488,10920489,10920490,10920491,10920492,10920493,10920494,10920495,10920496,10920497,10920498,10920499,10920500,10920501,10920502,10920503,10920504,10920505,10920506,10920507,10920508,10920509,10920510,10920511,10920512,10920513,10920514,10920515,10920516,10920517,10920518,10920604,10920605,10920709,8570074,10920792,10920793,10920883,10921122,10921123,10921124,10921125,10921126,10921288,10921289,10921290,10921291,10921355,10620864,10921486,10921651,10921681,10921682,10921786,10921940,10921941,10614230,10557148,10557149,10557150,10557498,7058295,10610879,4974399,4974400,4974401,4974402,4974403,4974404,4974405,4974406,4974407,4974408,4974409,4974410,4974411,4974412,4974413,4974414,4974415,4974416,4974417,4974418,4974419,4974420,4974421,4974422,4974423,4974424,4974425,4974426,4974427,4974428,4974429,4974430,4974431,4974432,4974433,4974434,4974435,4974436,4974437,4974438,4974439,4974440,4974441,4974442,4974443,4974444,4974445,4974446,4974447,4974448,7055762,4974449,4974450,4974451,4974452,4974453,4974454,4974455,4974456,4974457,4974458,4974459,4974460,4974461,4974462,4974463,4974464,4974465,4974466,4974467,4974468,4974469,4974470,4974471,4974472,4974473,4974474,4974475,4974476,4974477,4974478,4974479,4974480,4974481,4974482,4974483,4974484,4974485,4974486,4974487,4974488,4974489,4974490,4974491,4974492,4974493,4974494,4974495,4974496,4974497,4974498,4974499,4974500,4974501,4974502,4974503,4974504,4974505,4974506,4974507,4974508,4974509,4974510,4974511,4974512,4974513,4974514,4974515,4974516,4974517,4974518,4974519,4974520,4974521,4974522,4974523,4974524,4974525,4974526,4974527,4974528,4974529,4974530,4974531,4974532,4974533,4974534,4974535,4974536,4974537,4974538,4974539,4974540,4974541,4974542,4974543,4974544,4974545,4974546,4974547,4974548,4974549,4974550,4974551,4974552,4974553,4974554,4974555,4974556,4974557,4974558,4974559,4974560,4974561,4974562,4974563,4974564,4974565,4974566,4974567,4974568,4974569,4974570,4974571,4974572,4974573,4974574,4974575,4974576,4974577,4974578,4974579,4974580,4974581,4974582,4974583,4974584,4974585,4974586,4974587,4974588,4974589,4974590,4974591,4974592,4974593,4974594,4974595,4974596,4974597,4974598,4974599,4974600,4974601,10555604,10555605,10555606,10555607,10555608,10555649,10515732,10515733,10515734,7056316,7056317,10556360,10556361,10556362,10556363,10556469,10556787,10556788,10556789,10556790,10556791,10556792,10556793,10556794,10556795,10556796,10556797,10556798,10556799,10556800,10556801,10556802,10556803,10556804,10556805,9171290,10417133,10417139,4971510,10470247,10470520,10164638,10164639,10164640,10159675,10159676,10159677,10159678,10159679,10164993,10165090,10165091,10165092,10165262,10165263,10165264,10165265,10165266,10165592,10165753,10165754,10629800,10158900,10164278,10164279,10577142,10571513,10571514,10571515,10571516,10577607,10577608,10577609,10574732,10574733,10568737,10568738,10568739,10574843,10574992,10574993,10571999,10572003,10572377,10572378,10570071,10570072,10567575,10567576,10567577,10521268,10520060,10520061,10520062,10520063,10522385,10523045,10523046,10523047,10523048) 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'