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(10939541,10939621,10939622,10939631,8066937,8067229,8067240,8067310,8067408,8067421,8067470,8067471,8067472,8067475,8067476,8067595,8067596,8067597,8067598,8067599,8067600,8067601,8067602,8067603,8067604,8067605,8067606,8067607,8067608,8067609,8067610,8067611,8067612,8067613,8067614,8067615,8067616,8067617,8067618,8067619,8067620,8067621,8067622,8067623,8067624,8067625,8067626,8067627,8067628,8067629,8067630,8067631,8067632,8067633,8067634,8067635,8067638,8067753,8065186,4967030,8065919,8066096,8066099,8063956,3655525,3655526,3655649,3655650,3655651,3655652,3655653,3655654,3655655,3655815,3655816,3656152,3656153,3656154,3656155,3656457,3656466,3656467,3656485,3656619,8073479,8073490,8073491,10918472,10918473,10918474,10623002,10918641,10918643,10918644,10918645,10918646,10918647,10918648,10918649,10918650,10918670,10918671,10918672,10918687,10918688,10918696,10918718,10918719,10918720,10918721,10918722,10918723,10918724,10918725,10918726,10918727,10918728,10918729,10918773,10918789,10918790,10918791,10918967,10623493,10919195,10919275,10919276,10919484,10919485,10919486,10919487,10919488,10919489,10919490,10919491,10919492,10919493,10919494,10919495,10919496,10919497,10919498,10919499,10919500,10919501,10919502,10919503,10919504,10919505,10919506,10919507,10919508,10919509,10919510,10919511,10919512,10919513,10919514,10919515,10919516,10919517,10919518,10919519,10919520,10919521,10919522,10919523,10919524,10919525,10919526,10919527,10919528,10919529,10919530,10919531,10919532,10919533,10919534,10919535,10919536,10919537,10919538,10919539,10919540,10919541,10919542,10919543,10919544,10919545,10919546,10919547,10919548,10919549,10919550,10919551,10919552,10919553,10919554,10919555,10919556,10919557,10919558,10919559,10919560,10919561,10919562,10919563,10919564,10919565,10919566,10919567,10919568,10919569,10919570,10919571,10919572,10919573,10919574,10919575,10919576,10919577,10919578,10919579,10919580,10919581,10919582,10919583,10919584,10919585,10919586,10919587,10919588,10919589,10919590,10919591,10919592,10919593,10919594,10919595,10919596,10919597,10919598,10919599,10919600,10919601,10919602,10919603,10919604,10919605,10919606,10919607,10919608,10919609,10919610,10919611,10919612,10919613,10919614,10919615,10919616,10919617,10919618,10919619,10919620,10919621,10919622,10919623,10919624,10919625,10919626,10919627,10919628,10919629,10919630,10919631,10919632,10919633,10919634,10919635,10919636,10919637,10919638,10919639,10919640,10919641,10919642,10919643,10919644,10919645,10919646,10919647,10919648,10919649,10919650,10919651,10919652,10919653,10919654,10919655,10919656,10919657,10919658,10919659,10919660,10919661,10919662,10919663,10919664,10919665,10919666,10919667,10919668,10919669,10919670,10919671,10919672,10919673,10919674,10919675,10919676,10919677,10919678,10919679,10919680,10919681,10919682,10919683,10919684,10919685,10919686,10919687,10919688,10919689,10919690,10919691,10919692,10919693,10919694,10919695,10919696,10919697,10919698,10919699,10919700,10919701,10919702,10919703,10919704,10919705,10919706,10919707,10919708,10919709,10919710,10919711,10919712,10919713,10919714,10919715,10919716,10919717,10919718,10919719,10919720,10919721,10919722,10919723,10919724,10919725,10919726,10919727,10919728,10919729,10919730,10919731,10919732,10919733,10919734,10919735,10919736,10919737,10919738,10919739,10919740,10919741,10919742,10919743,10919744,10919745,10919746,10919747,10919748,10919749,10919750,10919751,10919752,10919753,10919754,10919755,10919756,10919757,10919758,10919759,10919760,10919761,10919762,10919763,10919764,10919765,10919766,10919767,10919768,10919769,10919770,10919771,10919772,10919773,10919774,10919775,10919776,10919777,10919778,10919779,10919780,10919781,10919782,10919783,10919784,10919785,10919786,10919787,10919788,10919789,10919790,10919791,10919792,10919793,10919794,10919795,10919796,10919797,10919798,10919799,10919800,10919801,10919802,10919803,10919804,10919805,10919806,10919807,10919808,10919809,10919810,10919811,10919812,10919813,10919814,10919815,10919816,10919817,10919946,10919947,10919948,10919950,10919951,10919952,10919953,10919954,10919955,10919956,10919957,10919958,10919959,10919960,10919961,10919962,10919963,10919964,10919965,10919966,10919967,10919968,10919969,10919970,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,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,10920072,10920073,10920074,10920075,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,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,10920138,10920139,10920140,10920141,10920142,10920143,10920146,10920147,10920148,10920150,10920151,10920152,10920153,10920154,10920155,10920156,10920157,10920158,10920159,10920160,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,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,10920229,10920230,10920231,10920232,10920233,10920234,10920235,10920236,10920237,10920238,10920239,10920240,10920241,10920242,10920243,10920244,10920245,10920246,10920248,10624738,10920249,10920250,10624740,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,10624843,10920354,10920355,10920356,10920357,10920358,10920359,10920360,10920361,10920362,10920363,10920365,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,10622897,10620060,10620209,10620365,10621077,10621078,10565172,10565173,10565198,10565306,10565307,10565796,10565797,10565798,10565799,10565800,10565801,10565802,10565803,10565804,10565805,10565806,10565807,10565808,10565809,10565810,10565811,10565812,10565813,10565814,10565815,10565816,10565817,10565818,10565819,10565820,10565821,10565944,10565945,10565946,10565947,10565948,10566011,10566012,10566102,10566103,10566104,10566105,10566106,10566107,10566108,10563474,10563475,10563476,10563477,10563478,10563479,10563480,10563481,10563482,10563483,10563484,10563485,10563486,10563487,10563488,10563489,10563490,10563491,10517300,10517754,10517755,10517756,10518616,10518617,10419270,10419432,10419591,10419764,10419782,10419787,10419791,10420113,10420126,10471490,10471491,10471492,10471504,10470082,10470216) 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'