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(11001593,10943433,7067934,7067935,7067936,7076009,11014894,11014961,11014962,7076285,11014983,11014984,11014985,11014986,11014987,7076310,7076311,11015527,11015528,11015529,11015530,11015531,11041533,7073975,7073976,7073999,7066018,7066270,7066271,8067414,8067415,11016119,11016120,11016121,11016122,11016123,11016124,11016125,11016126,11016127,11016128,11016129,11016130,11016131,11016132,11016133,11016134,11016135,11016183,11016184,11016185,11042299,11042300,11042301,11042312,11042313,11042314,11042315,7066753,7066754,7066755,10938479,10964455,10964456,11013500,11013501,11013502,11013503,11013504,11013505,11013506,11013507,11013508,11013509,11013510,11013511,11013512,11013513,11013514,11013515,11013516,11013517,11013518,11013519,11013520,11013521,11013522,11013523,11013524,11013525,11013526,11013527,11013528,11013529,11013530,11013531,11013532,11013533,11013534,11013535,11013536,11013537,11013538,11013539,11013540,11013541,11013542,11013543,11013544,11013545,11013546,11013547,11013548,11013549,11013550,11013551,11013552,11013553,11013554,11013555,11013556,11013557,11013558,11013559,11013581,11013590,11013591,8067906,7067197,7067205,7067207,10962082,11040262,11040263,11040264,10962311,10962364,10962365,10962366,11014367,10962367,10962418,10962419,10962420,10962421,11001486,11001487,11001488,11011500,6000215,7064055,7064071,10960053,11012240,11012241,11012242,11012243,11012244,11012245,11012246,7072588,7072589,7072590,7072591,7072592,7072593,7072594,7072607,11012346,11012347,11012348,4967055,10960456,8065959,8065960,8065961,8065962,8065963,8065964,8065965,8065966,8065971,8065972,8065973,8065974,8065975,10999630,10999631,10999632,11012822,11012823,11012824,11012825,11012826,11012827,11012876,11012877,11012878,10932646,7065339,10961233,11013294,11013295,11013296,11013297,11013298,11013309,11013310,11013430,11013431,11013432,11013433,11013434,11013435,11013436,11013437,10933193,11013438,10933194,11013439,11013440,11013441,11013442,11013443,11013444,11013445,11013446,11013447,11013448,11013449,11013450,11013451,11013452,11013453,11013454,11013455,11013456,11013457,11013458,11013459,11013460,11013461,11013462,11013463,11013464,11013465,11013466,11013467,11013468,11013469,11013470,11013471,11013472,11013473,11013474,11013475,11013476,11013477,11013478,11013479,11013480,11013481,11013482,11013483,11013484,11013485,11013486,11013487,11013488,11013489,11013490,11013491,11013492,11013493,11013494,11013495,11013496,11013497,11013498,11013499,7070944,7071130,10943133,11037179,11037180,11024283,11024284,11024285,11024286,11037310,11011455,7069312,7069313,7069408,11035202,11035203,11035308,8072793,8072794,8072795,8072796,8072797,8072798,8072799,8072800,11022742,11022743,11022744,11022745,11022766,11022767,11022768,11022769,11022770,11022771,11022772,11022851,11022852,11022853,11022854,11022855,11022856,11022857,11022858,11022859,11022860,11022861,11022862,11022863,11022864,11022865,11022866,11022867,11022868,11022869,11022870,11022871,11022872,11022873,11022874,11022875,11022900,11022901,8073096,8073097,10942139,10942140,11010126,8860373,11010272,11010281,11010294,11010295,11010296,7070660,10997356,10997357,10997358,10997359,10971389,10971390,7070766,11006550,11019655,11019656,11019657,11019658,11019662,11019663,11019664,11019667,11019668,11019669,11019670,11019671,11019672,11019673,11019674,11019675,11019676,11019683,10928680,11019781,11019782,11019800,11032841,11032845,11032866,11032867,11032868,11032869,11032870,11032881,11032882,11032923,11032924,11032925,11032926,10618389,11032927,11032928,11032931,11033054,11033055,11033056,11033057,10968063,10968064,10968065,11033256,11033257,11033258,11033259,11033260,11033261,11033262,11033263,11033417,11033418,11033419,11033520,11033521,8070921,10619373,11008235,10927481,10953620,11005670,11005671,11005672,11005673,11005674,11018718,10992776,11005846,10992940,10992941,10992942,10927937,11005990,11006164,11006165,11032333,10993344,11019385,11019386,11019412,11019413,11019414,11019415,11019416,11006487,10964517,10964520,10925528,10925529,10925530,10925531,10620072,10920598,10920599,10920600,10615232,10615233,10920847,10920848,10920849,10920850,10920851,10920852,10920853,10920854,10920855,10920856,10920857,10920858,10920859,10926016,10926017,10926018,10926019,10991297,10991298,10615880,11017478,10965547,10991590,10991591,10921609,10921621,10952825,10952826,10952827,10922064,10927110,10927446,10922458,10922459,9189323,9189501,7059748,7059749,10611408,8864302,9173789,9173790,9173791,9173792,9173793,9173794,9173795,9173796,9173797,9173798,9173799,9173812,9173813,9173814,9173818,9173819,10566059,10566063,10566064,10566065,10566066,7057517,9187495,10557444,10557445,10557446,10557447,9195863,9171967,9171970,9171971,9196152,8862680,8862681,8862682,9172432,9172433,9172434,9172435,10613352,10564680,10564681,10564682,10610714,10610780,10610781,10610785,4974154,4974316,9161480,10517306,10517307,10517308,10517309,10517310,10517311,10517312,9169553,4974415,9185660,9185661,9185662,9185663,10515491,9185969,9170011,10513887,10513888,10513889,10515897,10515898,10515899,10515900,10513900,10515901,10513901,10515902,10513902,10515903,10515904,10515905,10515906,9170190,9186196,9170210,4975159,9186327,10512155,10512156,10512176,10512177,9186494,9186609,9186633,9186703,9186729,10518771,10518772,10518773,10518774,10518775,10518776,10518777,10518778,10518779,10518780,10518781,10518782,10518783,10518784,7057452,10416240,10416242,9160372,9176437,10415402,10415403,10415404,10415489,10415490,10415491,10415492,10416535,10416643,10419668,9168791,4973664,4973665,10417765,10417774,10417782,10417797,10417798,10416934,10416935,10416936,10416937,10416938,10416939,10416940,10418051,10418081,10418093,10418123,4974125,6666532,6666534,4971643,10469516,10469517,10469518,10469587,10469602,8916779,8916787,10465754,8916911,8916912,9175299,10469936,10469937,9183389,10469967,10469968,10469969,8563401,6667539,8917321,8917477,9175900,10468766,10468767,10468768,10468838,10468839,10468840,10468841,10468842,10468843,10468844,10159487,10159488,10159489,10159490,10159491,10159492,10159493,10159494,10159495,10159496,10159497,10159498,10159499,10159500,10159501,10159502,10159717,10159718,10159719,10159898,10159899,10159941,10175655,10175656,10175657,10175658,10175659,10175660,10175661,10175662,10175777,10175778,10175779,10175815,10175819,10170880,10170881,10166143,10156206,10632123,10153845,10153846,10153898,10153899,10153900,10153901,10153902,10153903,10153904,10153905,10153906,10153907,10164043,10164044,10630100,10161838,10171981,10171982,10171983,10172102,10162109,10162400,10162401,10162408,10162409,10162410,10162411,10172510,10631059,10631060,10631061,10163283,10631797,10631810,10631811,10631816,10626954,10583670,10583671,10583672,10583673,10572496,10569676,10569677,10569678,10569679,10569680,10569681,10569682,10569683,10569684,10569685,10569686,10569687,10569688,10569689,10569690,10569691,10569692,10569693,10569694,10569695,10569696,10569697,10569698,10569699,10569700,10569701,10569702,10569703,10569704,10569705,10569706,10569707,10569708,10569709,10569710,10569711,10569712,10569713,10569714,10569715,10569716,10569717,10569718,10569719,10569720,10569721,10569722,10569723,10569724,10569725,10569726,10569727,10569728,10569729,10569730,10569731,10569732,10569733,10569734,10569735,10569736,10569737,10569738,10569739,10569740,10569741,10569742,10569743,10569744,10569745,10569746,10569747,10569748,10569749,10569750,10569751,10569752,10569753,10569754,10569755,10569756,10569757,10569758,10569759,10569760,10569761,10569762,10569763,10569764,10569765,10569766,10569767,10569768,10569769,10569770,10569771,10569772,10569773,10569774,10569775,10569776,10569777,10569778,10569779,10569780,10569781,10569782,10569783,10569784,10569785,10569786,10569787,10569788,10569789,10569790,10569791,10569792,10569793,10569794,10569795,10569796,10569797,10569798,10569799,10569800,10569801,10569802,10569803,10569804,10569805,10569806,10569807,10569808,10569809,10569810,10569811,10569812,10569813,10569814,10569815,10569816,10569817,10569818,10569819,10569820,10569821,10569822,10569823,10569824,10569825,10569826,10569827,10569828,10581965,10581966,10573218,10573219,10573220,10573221,10573222,10570481,10579789,10529161,10525372,10525373,10529908,10530069,10528267,10530401,10522682,10522683,10520738,10520739,10522862,10424641,10424644,10423823,10422006,10422017,10422037,10423051,10483085,10483200,10483201,10483205,10483206,10483213,10483214,10473283,10473284,10473285,10473286,10473287,10473288,10473289,10473290,10473291,10473292,10473293,10473294,10473355,10473356,10473357,10473358,10473359,10473360,10473458,10473459,10473460,10473461,10473462,10473463,10481612,10481613,10481614,10481615,10481616,10481617,10481618,10481619,10481620,10481623,10481624,10481625,10481626,10481627,10481628,10481868,10481869,10479991,10480043,10480046,10476509,10476510) 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'