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(10939606,8068876,10939609,10939613,7068145,7068258,7068259,10939951,7068371,10939999,10940108,7068763,8569816,8569883,8067004,7074032,7074133,7066186,7066406,8067492,7074576,7074602,7074631,8067616,8067617,8067618,8067621,7074654,8067642,8067647,8067707,8067708,7074896,7066922,7074958,7075003,7075004,8067907,8067938,8068036,8068051,8068052,8068053,8068118,8068177,8068239,8068240,8068268,8068295,8068571,8068620,8068629,7072372,7072378,7072400,7072426,7072437,7072618,7072628,7072982,7073019,7073058,8066036,7073080,8066260,8066284,8066297,8066298,8066299,8066300,8066536,8066537,8066538,8066539,8066616,8066650,8066651,8066652,8066653,8066654,8066734,8066735,7071078,10942740,10942771,10942794,10942802,11049097,10942927,11049325,11049333,10943091,11049378,7071721,7071723,3655520,3655521,3655522,3655523,7069008,10940856,7069264,10940989,7069473,3656239,7070075,7070080,7070497,10942152,7070795,10918472,10918473,10918474,10923498,10923499,10923500,10923501,10923529,10618045,10923599,10923600,10923601,10923602,10923666,10923668,10923669,10918708,10918723,10918724,10918734,10918735,10923772,10923773,10923774,10923775,10923776,10923777,10923847,10923848,10923913,10923914,10923915,10923916,10918964,10918965,10923986,10923987,10923988,10923989,10923990,10923991,10919008,10919009,10924076,10924080,10924081,10924297,10919336,10919337,10919338,10919339,10919340,10919341,10919342,8070854,10919666,10919667,10919687,10919688,10919689,10919690,10919691,10924806,10924807,10924808,10924809,10924810,10924811,10924812,10924813,10924814,10924815,10924816,10924817,10924818,10924819,10924820,10919866,10919867,10919877,10925023,10925024,10925025,10925026,10925027,10925028,10925118,10925119,10925120,10925190,10925193,10925194,10925195,10925196,10925297,10925298,10925299,10925300,10925301,10925302,10925303,10925304,10925305,10925399,10925400,10925401,10925402,10925403,10925404,10925405,10925406,10925407,10925408,10617082,10922803,10922829,10927873,10922962,10922963,10922969,10922970,10917991,10917992,10917993,10917994,10917995,10917996,10917997,10917998,10917999,10918000,10918001,10918002,10918003,10918004,10918005,10918006,10918007,10918008,10918009,10918010,10918011,10918012,10918013,10918014,10918015,10918016,10918017,10918018,10918019,10918020,10918021,10918022,10918023,10918024,10918025,10918026,10918027,10918028,10918029,10918030,10918031,10918032,10918033,10918034,10918035,10918036,10918037,10918038,10918039,10918040,10918041,10918042,10918043,10918044,10918045,10918046,10918047,10918048,10918049,10918050,10918051,10918052,10918053,10918054,10918055,10918056,10918057,10918058,10918059,10918060,10918061,10918062,10918063,10918064,10918065,10918066,10918067,10918068,10918069,10918070,10918071,10918072,10923073,10918073,10918074,10918075,10918076,10918077,10918078,10918079,10918080,10918081,10918082,10918083,10918084,10918085,10918086,10918087,10918088,10918089,10918090,10918091,10918092,10918093,10918094,10918095,10918096,10918097,10918098,10918099,10918100,10918101,10918102,10918103,10918104,10918105,10918106,10918107,10918108,10918109,10918110,10918111,10923111,10918112,10918113,10918114,10918115,10918116,10918117,10923117,10918118,10923118,10918119,10923119,10918120,10918121,10918122,10918123,10918124,10918125,10918126,10918127,10918128,10918129,10918130,10918131,10918132,10918133,10918134,10918135,10918136,10918137,10918138,10918139,10918140,10918141,10918142,10918143,10918144,10918145,10918146,10918147,10918148,10918149,10918150,10918151,10918152,10918153,10918154,10918155,10918156,10918157,10918158,10918159,10918160,10918161,10918162,10918163,10918164,10918165,10918166,10918167,10918168,10918169,10918170,10918171,10918172,10918173,10918174,10918175,10918176,10918177,10918178,10918179,10918180,10918181,10918182,10918183,10918184,10918185,10918186,10918187,10918188,10923188,10918189,10918190,10918191,10918192,10918193,10918194,10918195,10918196,10918197,10918198,10918199,10918200,10918201,10918202,10918203,10918204,10918205,10918206,10918207,10918208,10918209,10918210,10918211,10918212,10918213,10918214,10918215,10918216,10918217,10918218,10918219,10918220,10918221,10918222,10918223,10918224,10918225,10918226,10918227,10918228,10918229,10918230,10918231,10918232,10918233,10918234,10918235,10918236,10918237,10918238,10918239,10918240,10918241,10918242,10918243,10918244,10918245,10918246,10918247,10918248,10923248,10918249,10918250,10918251,10918252,10918253,10918254,10918255,10918256,10918257,10918258,10918259,10918260,10918261,10918262,10918263,10918264,10918265,10918266,10918267,10918268,10918269,10918270,10918271,10918272,10918273,10918274,10918275,10918276,10918277,10918278,10918279,10918280,10918281,10918282,10918283,10918284,10918285,10918286,10918287,10918288,10918289,10918290,10918291,10918292,10918293,10918294,10918295,10918296,10918297,10918298,10918299,10918300,10918301,10923302,10918302,10918303,10923303,10918304,10923304,10923305,10918305,10918306,10918307,10918308,10918309,10918310,10918311,10918312,10918313,10918314,10918315,10918316,10918317,10918318,10918319,10918320,10918321,10918322,10918323,10918324,10918325,10918326,10918327,10918328,10918329,10918330,10918331,10918332,10918333,10918334,10918335,10918336,10918337,10918338,10918339,10918340,10918341,10918342,10918343,10918344,10918345,10918346,10918347,10923347,10918348,10923348,10918349,10918350,10918351,10918352,10918353,10918354,10918355,10918356,10918357,10918358,10918359,10918360,10918361,10918362,10918363,10918364,10918365,10918366,10918367,10918368,10918369,10918370,10918371,10918372,10918373,10918374,10918375,10918376,10918377,10918378,10918379,10918380,10918381,10918382,10918383,10918384,10918385,10918386,10918387,10918388,10918389,10918390,10918391,10918392,10918393,10622883,10918394,10918395,10918396,10918397,10918398,10918399,10918400,10918401,10918402,10918403,10918404,10918405,10918406,10918407,10918408,10918409,10918410,10918411,10918412,10918413,10918414,10918415,10918416,10918417,10918418,10918419,10918420,10918421,10918422,10918423,10918424,10918425,10918426,10918427,10918428,10918429,10918430,10918431,10918432,10918433,10918434,10918435,10918436,10918437,10918438,10918439,10918440,10923441,10918441,10918442,10918443,10918444,10918445,10918446,10918447,10918448,10918449,10918450,10918451,10918452,10918453,10918454,10918455,10918456,10918457,10918458,10918459,10918460,10923461,10918461,10918462,10918463,10918464,10918465,10918466,10918467,10918468,10918469,10918470,10918471,10925497,10925498,10925499,10920523,10925524,10925525,10920707,10920708,10920783,10620349,10925864,10920927,10615488,10615490,10921117,10921118,10620656,10620657,10620658,10620659,10620666,10921283,10615846,10615879,10921488,10921512,10921535,10921670,10621275,10621282,10621283,10621285,10621287,10921798,10921799,10616363,10616364,10616365,10616366,10616367,10616368,10616369,10616370,10616371,10921910,10921911,10921913,10621451,10621471,10621472,10616510,10922123,10621737,10611550,10611551,10611552,10611553,10611554,10611555,10611556,10611557,10611558,10611559,10611560,10611561,10611562,10611563,10611564,10611565,10559786,10559787,10611681,10557144,10557145,10557146,10557614,10612755,10613354,10561557,10610737,10610764,10610774,10610775,10555591,10555592,10555593,10555594,10555595,10555596,10555597,10555598,10555599,10555600,10555601,10555602,10555603,10555630,10555631,10555632,10555633,10555634,10555635,10515751,10515752,10515753,10515754,10515755,10515756,10515757,10515758,10515759,10515760,10515761,10515762,10515763,10515764,10515787,10515788,10515789,10515790,10515791,10515792,10515812,10515813,10516014,10516015,10516016,10516017,10516018,10516019,10516020,10516021,10516022,10516023,10516024,10516025,10516026,10516027,10516028,10516029,10516030,10516031,10516032,10516033,10516034,10516035,10516036,10516037,10516038,10516039,10516040,10516041,10516042,10516043,10516044,10516045,10516046,10516047,10516048,10516049,10556351,10556466,10556467,10556468,10556766,10556767,10556768,10556769,10556770,10556771,10556772,10512797,10512798,10556945,10556946,10513075,10416249,10416399,10419466,10415556,10417769,10417785,10417793,10418087,10418097,10418127,10417132,10418133,10417137,10418138,10417201,10467104,10471199,10471200,10463399,10467409,10463432,10465712,10465796,10465797,10465798,10465799,10465800,10465801,10465802,10465803,10465804,10465805,10465806,10465807,10465808,10465809,10465810,10465811,10465812,10465813,10465814,10465815,10465816,10465817,10465818,10465819,10465820,10465821,10465822,10465823,10465824,10465825,10465826,10465827,10465828,10465829,10465830,10465831,10465832,10465833,10465834,10465835,10465836,10465837,10465838,10465839,10465840,10465841,10465842,10465843,10465844,10465845,10465846,10465847,10465848,10465849,10465850,10465851,10465852,10465853,10465854,10465855,10469911,10470009,10470010,10470011,8563381,10470398,10470401,10470405,10462516,10470519,10470526,10470603,10470623,10462729) 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'