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,10940057,4970766,10940199,10940200,4970797,4970873,4970898,10940359,8067177,8067178,8067253,8067292,8067478,8067591,8067592,8067593,8067594,10938582,10938583,10938584,4969316,10939100,10939388,8074684,8074685,8074686,8074687,8074688,8074689,8074690,8074691,8074692,8074693,8074694,8074695,8074696,8074697,8074698,8074699,8074700,8074701,8074702,8074703,8074704,8074705,8074727,8074728,8074729,8074730,8074731,8074732,8074733,8074734,8074735,8074736,8074737,8074738,8074739,8074740,8074741,8074742,8074743,8074744,8074745,8074746,8074747,8065090,8065091,8065092,8065093,8065094,8065095,8065160,8074946,8074947,8074948,8074949,8074950,8074951,8074952,8074953,8074954,8074955,8074956,8074957,8074958,8074959,8074960,8074961,8074962,8074963,8074964,8074965,8074966,8074967,8074968,8074969,8074970,8074971,8074972,8074973,8074974,8074975,8074976,8074977,8074978,8074979,8074980,8074981,8074982,8074983,8074984,8074985,8074986,8074987,8074988,8074989,8074990,8074991,8074992,8074993,8074994,8074995,8074996,8074997,8074998,8074999,8075000,8075001,8075002,8075003,8075004,8075005,8075006,8075007,8075008,8075009,8075010,8075011,8075012,8075013,8075014,8075015,8075016,8075017,8075018,8075019,8075020,8075021,8075022,8075023,8075024,8075025,8075026,8075027,8075028,8075029,8075030,8075031,8075032,8075033,8075488,4967034,8066037,4967424,4967425,4967426,4967427,4967428,4967429,4967430,4967431,4967432,4967433,4967434,4967435,4967436,8064224,8064225,8064226,8064227,8064228,8064229,8064230,8064231,8064232,8064233,8064234,8064235,8064236,8064237,8064238,8064239,8064240,8064241,8064242,8064243,8064862,3655566,3656265,3656266,3656267,3656268,3656270,3656271,3656273,3656276,3656278,3656444,3656484,3656612,3656613,3656700,3656935,3657150,3657151,3657152,3657153,3657157,3657267,3657268,3657269,3657270,3657271,3657272,11049566,8073517,8073518,8073519,8073520,8073521,8073522,8073525,10622962,10622965,10918551,10918552,10918553,10918974,10918975,10918976,10918977,10918978,10918979,10919023,10919029,10623770,10919321,10919323,10919326,10919343,10919344,10919351,10919352,10919693,10919694,10919878,10919879,10919880,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,10624874,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,10917546,10917547,10917548,10622265,10917778,10917787,10622420,10622424,10622443,10622444,10918062,10918186,10918202,10918378,10918382,10918405,10622961,10620236,10916084,10916085,10916086,10916087,10916088,10916089,10565346,10563450,10563452,10563453,10563454,10563457,10563458,10563459,10563460,10563461,10563462,10563463,10563464,10563465,10563466,10563467,10563605,10563606,10563607,10563608,10563609,10563610,10563611,10563612,10563613,10563614,10563615,10563616,10563617,10563618,10563619,10563620,10563621,10563622,10563623,10563624,10563625,10563626,10563627,10563628,10563629,10563630,10563631,10563632,10563633,10563634,10563635,10563636,10563637,10563638,10563639,10563640,10563641,10563642,10563643,10563644,10563645,10563646,10563647,10563648,10563649,10563650,10563651,10563652,10563653,10563654,10563655,10563656,10563657,10563658,10563659,10563660,10563661,10563662,10563663,10563664,10563665,10563666,10563667,10563668,10563669,10563670,10563671,10563672,10563673,10563674,10563675,10563676,10563677,10563678,10563679,10563680,10563681,10563682,10563683,10563684,10563685,10563686,10563687,10563688,10563689,10563690,10563691,10563692,10563830,10563831,10563832,10563833,10563835,10563842,10563847,10563848,10563849,10563850,10563851,10563852,10563853,10563854,10563855,10563856,10563857,10563858,10563859,10563860,10563861,10563862,10563863,10563864,10563865,10563866,10563874,10563881,10563882,10563883,10563884,10563886,10563887,10563891,10563892,10563893,10563894,10563895,10563896,10563897,10563898,10563899,10563900,10563901,10563902,10563903,10563904,10563917,10563918,10563919,10563921,10518075,10518076,10518090,10518091,10518092,10518093,10518094,10518095,10518096,10518097,10518098,10518099,10518100,10518101,10518102,10518103,10518104,10518105,10518106,10518107,10518548,10518549,10518550,10519002,10419722,10419723,10419747,10419778,10419779,10469904,10470015,10470016,10470221,10470247) 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'