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(7076366,7074013,7074056,7074141,8067260,8067261,8067262,7074303,7066485,7074877,7074878,7074887,7074888,7074917,11001127,11001128,11001129,7064029,7064069,10985949,7064308,7072335,7072372,7072421,7064470,7064471,7064472,7072547,7072550,7072599,7072618,7072640,7072694,7072800,10986508,10986509,10986510,10986511,10986512,10986513,10986514,10986515,10986516,7072993,7072995,7073008,7073046,7073117,7073119,11000170,10987346,7071617,7071618,7071619,7071620,7071621,7071622,7071623,7071624,7071625,7071626,7071627,7071628,7071629,7071630,7071631,7071632,7071633,7071634,7071635,7071636,7071637,7071638,7071639,7071640,7071641,7071642,7071643,7071644,7071645,7071646,7071647,7071648,7071649,7071650,7071651,7071652,7071653,7071654,7071655,7071656,7071657,7071658,7071659,7071660,7071661,7071662,7071663,7071664,7071665,7071666,7071667,7071668,7071669,7071670,7071671,7071672,7071673,7071674,7071675,7071676,7071677,7071678,7071679,7071680,7071681,7071682,7071683,7071684,7071685,7071686,7071687,7071688,7071689,7071690,7071691,7071692,7071693,7071694,7071695,7071696,7071697,7071698,7071699,7071700,7071701,7071702,7071703,7071704,7071705,7071706,7071707,7071708,7071709,7071710,7071711,7071712,7071713,7071714,7071715,7071716,7071717,7071718,7071719,7071720,7071721,7071722,7071723,7071724,7071725,7071726,7071727,7071728,7071729,7071730,7071731,7071732,7071733,7071734,7071735,7071736,7071737,7071738,7071739,7071740,7071741,7071742,7071743,7071744,7071745,7071746,7071747,7071748,7071749,7071750,7071751,7071752,7071753,7071754,7071755,7071756,7071757,7071758,7071759,7071760,7071761,7071762,7071763,7071764,7071765,7071766,7071767,7071768,7071769,7071770,7071771,7071772,7071773,7071774,7071775,7071776,7071777,7071778,7071779,7071780,7071781,7071782,7071783,7071784,7071785,7071786,7071787,7071788,7071789,7071790,7071791,7071792,7071793,7071794,7071795,7071796,7071797,7071798,7071799,7071800,7071801,7071802,7071803,7071804,7071805,7071806,7071807,10996719,10996720,10996916,10996917,10996918,10996919,10996920,10996921,10996922,10996923,10996924,10996925,10996926,10996927,10996928,10996929,10996930,10996931,10996932,10996933,10996934,10996935,10996936,10996937,10996938,10996939,10996940,10996941,10996942,10996943,10996944,10996945,10996946,10996947,10996948,10996949,10996950,10996951,10996952,10996953,10996954,10996955,10996956,10996957,10996958,10996959,10996960,10996961,10996962,10996963,10996964,10996965,10996966,10996967,10996968,10996969,10996970,10996971,10996972,10996973,10996974,10996975,10996976,10996977,10996978,10996979,10996980,10996981,10996982,10996983,10996984,10996985,10996986,10996987,10996988,10996989,10996990,10996991,10996992,10996993,10996994,10996995,10996996,10996997,10996998,10996999,10997000,10997001,10997002,10997003,10997004,10997005,10997006,10997007,10997008,10997009,10997010,10997011,10997012,10997013,10997014,10997015,10997016,10997017,10997018,10997019,10997020,10997021,10997022,10997023,10997024,10997025,10997026,10997027,10997028,10997029,10997030,10997031,10997032,10997033,10997034,10997035,10997036,10997037,10997038,10997039,10997040,10997041,10997042,10997043,10997044,10997045,10997046,10997047,10997048,10997049,10997050,10997051,10997052,10997053,10997054,10997055,10997056,10997057,10997058,10997059,10997060,10997061,10997062,10997063,10997064,10997065,10997066,10997067,10997068,10997069,10997070,10997071,10997072,10997073,10997074,10997075,10997076,10997077,10997078,10997079,10997080,10997081,10997082,10997083,10997084,10997085,10997086,10997087,10997088,10997089,10997090,10997091,10997092,10997093,10997094,10997095,10997096,10997097,10997098,10997099,10997100,10997101,3656988,10997102,10997103,10997104,10997105,10997106,10997107,10997108,10997109,10997110,10997111,10997112,10997113,10997114,10997115,10997116,10997117,10997118,10997119,10997120,10997121,10997122,10997123,10997124,10997125,10997126,10997127,10997128,10997129,10997130,10997131,10997132,10997133,10997134,10997135,10997136,10997137,10997138,10997139,10997140,10997141,10997142,10997143,10997144,10997145,10997146,10997147,10997148,10997149,10997150,10997151,10997152,10997153,10997154,10997155,10997156,10997157,10997158,10997159,10997160,10997161,10997162,10997163,10997164,10997165,10997166,10997167,10997168,10997169,10997170,10997171,10997172,10997173,10997174,10997175,10997176,10997177,10997178,10997179,10997180,10997181,10997182,10997183,10997184,10997185,10997186,10997187,10997188,10997189,10997190,10997191,10997192,10997193,10997194,10997195,10997196,10997197,10997198,10997199,10997200,10997201,10997202,10997203,10997204,10997205,10997206,10997207,10997208,10997209,10997210,10997211,10997212,10997213,10997214,10997215,10997216,10997217,10997218,10997219,10997220,10997221,10997222,10997223,10997224,10997225,10997226,10997227,10997228,10997229,10997230,10997231,10997232,10997233,10997234,10997235,10997236,10997237,10997238,10997239,10997240,10997241,10997242,10997243,10997244,10997245,10997246,10997247,10997248,10997249,10997250,10997251,10997252,10997253,10997254,10997255,10997256,10997257,10997258,10997259,10997260,10997261,10997262,10997263,10997264,10997265,10997266,10997267,10997268,10997269,10997270,10997271,10997272,10997273,10997274,10997275,10997276,10997277,10997278,10997279,10997280,10997281,10997282,10997283,10997284,10997285,10997286,10997287,10997288,10997289,10997290,10997291,10997292,10997293,10997294,10997295,10997296,10997297,10997298,10997299,10997300,10997301,10997302,10997303,10997304,10997305,10997306,10997307,10997308,10997309,10997310,10997311,10997312,10997313,10997314,10997315,10997316,10997317,10997318,10997319,10997320,10997321,10997322,10997323,10997324,10997325,10997326,10997327,10997328,10997329,10997330,10997331,10997332,10997333,10997334,10997335,10997336,10997337,10997338,10997339,10997340,10997341,10997342,10997343,10997344,10997345,10997346,10997347,10997348,10997349,10997350,10997351,10997352,10997353,10997354,10997355,10997356,10997357,10997358,10997359,10997360,10997361,10997362,10997363,10997364,10997365,10997366,10997367,10997368,10997369,10997370,10997371,10997372,10997373,10997374,10997375,10997376,10997377,10997378,10997379,10997380,10997381,10997382,10997383,10997384,10997385,10997386,10997387,10997388,10997389,10997390,10997391,10997392,10997393,10997394,10997395,10997396,10997397,10997398,10997399,10997400,10997401,10997402,10997403,10997404,10997405,10997406,10997407,10997408,10997409,10997410,10997411,10997412,10997413,10997414,10997415,10997416,10997417,10997418,10997419,10997420,10997421,10997422,10997423,10997424,10997425,10997426,10997427,10997428,10997429,10997430,10997431,10997432,10997433,10997434,10997435,10997436,10997437,10997438,10997439,10997440,10997441,10997442,10997443,10997444,10997445,10997446,10997447,10997448,10997449,10997450,10997451,10997452,10997453,10997454,10997455,10997456,10997457,10997458,10997459,10997460,10997461,10997462,10997463,10997464,10997465,10997466,10997467,10997468,10997469,10997470,10997471,10997472,10997473,10997474,10997475,10997476,10997477,10618012,10618041,10618049,10618053,10618054,10618055,10618056,10618057,10618058,10618059,10618060,10623191,10623192,10623193,10623194,10623195,10623196,10623197,10623303,8070020,8070021,10968024,8570281,8570282,8570283,8570287,8570289,8570291,10615682,10930850,10559318,10559319,7059716,10559477,10559478,10614417,8864452,9166215,9166216,8864751,10612023,7057796,7057797,10558317,10558318,10558319,10558320,7058790,10558578,10610823,9161542,9161543,9161544,7055754,7056092,9162389,9162390,9160412,4973420,8864828,10467104,10467409,10463692,10462581,10462582,10462583,10462584,10462585,10462586,10462587,10462588,10462589,10462590,10462591,10462592,10462593,10462594,10462595,10462596,10462597,10462598,10462599,10462600,10462601,10462602,10462603,10462604,10462605,10462606,10462607,10462608,10462609,10462610,10462611,10462612,10462613,10462614,10462615,10462616,10462617,10462618,10462619,10462620,10462621,10462622,10462623,10462624,10462625,10462626,10462627,10462628,10462629,10462630,10462631,6668110,10628152,10629519,10629521,10629633,10626981,10627020,10627021,10627022,10627023,10627024,10627025,10627026,10627027,10627028,10627029,10627030,10627031,10627032,10627033,10627034,10627035,10627036,10627037,10627038,10627039,10627040,10627041,10627042,10627043,10627044,10627045,10627046,10627047,10627048,10627049,10627050,10627051,10627052,10627053,10627054,10627055,10627056,10627057,10627058,10627059,10627060,10627061,10627062,10627063,10627064,10627065,10627066,10627067,10627068,10627069,10627070,10627071,10627072,10627073,10627074,10627075,10627076,10627077,10627078,10627079,10627080,10627081,10627082,10627083,10627084,10632167,10632168,10153933,10630397,10631207,10631208,10626952,10522625) 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'