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(10939603,10943514,10943515,10939731,7068341,10939964,10939990,7068370,7068371,10940199,10940200,4970873,7068847,7066238,8067292,8067293,8067422,8067478,7066782,7066900,8067844,10938582,10938583,10938584,7067073,7067081,10939100,10939432,7064301,10931687,10931688,10931719,10931720,10931721,10931722,10931723,10931724,10931725,10931726,10932427,10932428,10932429,10932485,10932486,10932487,8066117,4967424,4967425,4967426,4967427,4967428,4967429,4967430,4967431,4967432,4967433,4967434,4967435,4967436,7065438,10932804,10932823,8066886,10942631,10942746,8064224,8064225,8064226,8064227,8064228,8064229,8064230,8064231,8064232,8064233,8064234,8064235,8064236,8064237,8064238,8064239,8064240,8064241,8064242,8064243,10943075,5999941,5999967,6000057,6000058,6000059,6000060,6000061,6000062,6000063,6000064,8970192,8970217,3656265,3656266,3656267,3656268,3656269,3656270,3656271,3656272,3656273,3656274,3656275,3656276,3656277,3656278,3656484,10941762,10941763,11048578,11048588,11049566,8073517,8073518,8073519,8073520,8073521,8073522,8073523,8073524,8073525,8073526,10942542,10918547,10623340,10623434,10918969,10918970,10918971,10918972,10918973,10919019,10919020,10919023,10919321,10919322,10919323,10919324,10919325,10919343,10919344,10919345,10919346,10919347,10919348,10919668,10919692,10919868,10919919,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,10920365,10920366,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,10624956,10920466,10920467,10920468,10920469,10920470,10920471,10917787,10918060,10918062,10918186,10918378,10918379,10918380,10918381,10918382,10918383,10918384,10918385,10918386,10918400,10918401,10918402,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,10620235,10620236,10920791,10916195,10916196,10916197,10916198,10916199,10916200,10916201,10916202,10916203,10921223,10921224,10921225,10921226,10921227,10921228,10921229,10921230,10921287,10921497,10921498,10921499,10921500,10921501,10921502,10921503,10921504,10921505,10921506,10921507,10921508,10921509,10921510,10921511,10921512,10921513,10921514,10921515,10921516,10921517,10921518,10921519,10921520,10921521,10921522,10921523,10921524,10921525,10921526,10921527,10921528,10921529,10921530,10921531,10921532,10921533,10921534,10921535,10921784,10921785,10926889,10917239,10917240,10917241,10917242,10917243,10917244,10917245,10917246,10917247,10917248,10922262,10922263,10922289,10922466,10614470,10559715,10559716,10559717,10614653,10609271,10563450,10563451,10563452,10563453,10563454,10563455,10563456,10563457,10563458,10563459,10563460,10563461,10563462,10563463,10563464,10563465,10563466,10563467,10609401,10557569,10557570,10557571,10557572,10563572,10557573,10563629,10563630,10563631,10563632,10563633,10563634,10563635,10563636,10563637,10563638,10563639,10563640,10563641,10563642,10563643,10563644,10563667,10563668,10563669,10563670,10563778,10563786,10563787,10563790,10563839,10563840,10563841,10557875,10557876,10557877,10557878,10557879,10557880,10557881,10557882,10557883,10557884,10557885,10557886,10557887,10557888,10557889,10557890,10557891,10557892,10557893,10557894,10557895,10557896,10557897,10557898,10557899,10609749,10557900,10557901,10557902,10557903,10557904,10557905,10612834,10613074,10564271,10564272,10564273,10564274,10564325,10564326,10564391,10610295,10564455,10613455,10610480,10610481,10613573,10610878,10511141,10511142,10511153,10511154,10511155,10511163,10511164,10511165,10511166,10511167,10556067,10556068,10556069,10556070,10556071,10556072,10518075,10518076,10556081,10518090,10518091,10518092,10518093,10518094,10518095,10518096,10518097,10518098,10518099,10518100,10518101,10518102,10518103,10518104,10518105,10518106,10518107,10518536,10518537,10518538,10518557,10518558,10518559,10518560,10518561,10518562,10518563,10518564,10518565,10518566,10518567,10518568,10512757,10512849,10512850,10512851,10416400,10416427,10415742,10415820,10415962,10462892,10462893,10462894,10462895,10462896,10462897,10462898,10462899,10462900,10462901,10469925) 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'