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(8574018,10447828,10939794,8838628,10940100,10940107,10940114,8575021,8575022,11041584,8621783,7074269,7074271,7074272,7074303,10977003,10977004,10977005,10977006,10977007,10977008,10977009,10977010,10977011,10977012,10977013,10977014,10977015,10977016,10977017,10977018,8575589,10951350,10951353,8837402,8837403,8619973,8619974,8620114,8620268,8837947,10962157,8838003,8838004,8838005,8838006,7071866,8617713,7064028,10972715,10972849,8835749,10103405,8835793,10986063,8835870,10986081,8835890,8835891,8835898,10986123,7072604,7072707,10960433,8836263,8836364,8836365,7072896,7072962,7073014,7073551,8619575,8619645,8619646,10984826,10984827,10984828,10984829,10984830,10984831,10984832,10984833,10984834,10984835,10984836,10984837,10984838,10984839,10984840,10984841,10984842,10984843,10984844,8617000,10984881,10984882,10984883,10984884,10984885,10984886,10984888,10985045,10102519,10102520,10102524,10102525,10102545,10102546,10102547,10972106,8910534,8617453,8617454,10102757,7071645,7071646,7071647,7071648,7071688,7071701,7071774,8617625,10982602,10982603,10982604,10982605,10982606,10982607,10982608,10982609,10982610,10982611,10982612,10982613,10982614,10982615,10982616,10982617,10982618,10982619,10982620,10982621,10982622,10982623,10982624,10982625,10982626,10982627,10982628,10982629,10982630,10982631,10982632,10982633,10982634,10982635,10982636,10982637,10982638,10940772,7069241,7069242,10969931,10969932,8615128,8615129,8615134,10970214,10996390,10996392,8615592,11035490,8615718,8615719,8615720,10970632,10970702,10970703,10970704,10983767,10983768,10983769,10983786,10983787,10983788,7070105,8909168,8909169,8909282,8909283,10996925,10996926,10996927,10996928,10996929,10996930,10996931,10996937,10996938,10996939,10996940,11036004,11036005,11036006,11036007,11036008,3657271,10984338,10984339,10984398,10984399,10984400,10984401,10984402,10984403,10984404,10984405,10942437,10984406,10984407,10984408,10984409,10984410,10984411,10984412,10984413,10984414,10984415,10984416,10984417,10984418,8612731,8612732,11045608,11045609,11045610,11045611,11045612,10993799,10993800,10993801,10993802,8906176,10993814,10993815,10993816,10993817,10993818,10993819,10918841,10918842,8906346,10919249,10919250,10994525,10994526,10994527,10994528,10994529,10994530,8613924,8613963,11007845,11046860,10981997,10982110,10982111,10982112,10982113,10920087,10622131,10927961,10918152,10918153,10918154,11006207,10918337,11016509,10920564,8569898,10951622,10915666,10951691,10920979,10920980,10921076,10921077,8576603,11043175,11043176,8576777,8576778,10965287,8576908,10921559,10616089,10921675,8577237,8577302,8577400,8577401,10565221,10565222,10565249,7019184,7019185,7019186,7019187,7019188,7019189,7019190,7019191,7019192,7019193,7019194,7019195,7019196,7019197,9213593,9181712,7019393,7019394,7019395,7019396,7019397,7019398,7019399,7019400,9189746,9189747,9189748,9181750,9181751,9181752,9181753,9181754,9181755,9181756,9181757,9181758,9181759,9181760,9181761,7019493,7019494,7019495,7019496,7019497,7019498,7019499,7019500,7019501,7019502,7019503,9189849,7019504,9189850,9189851,7019505,7019506,9181885,9189896,9189897,9189898,9189899,9189900,9189901,9189902,9189903,9189904,9189905,9189906,9189907,7019660,7019661,7019662,7019663,7019664,7019665,7019666,7019667,7019668,7019669,7019670,7019671,9174039,9174040,9174041,7019718,7019719,7019720,7019721,7019722,7019723,7019724,7019725,7019726,7019727,7019728,7019729,7019730,7019731,7019732,7019733,7019734,7019735,7019736,7019737,9182091,9182092,9182093,9182094,9182095,9214137,9182155,9182156,9182157,9182158,9182159,9182160,9182161,9182162,9182163,9182164,9182165,9182166,9182167,9182168,9182169,9182170,9182171,9182172,9182173,9182174,9182175,9182176,9182177,9182178,9182179,9182180,9182181,9182182,9182183,9182184,9182185,9182186,9182187,9182188,9182189,9182190,9182191,9182192,9182193,9182194,7019872,7019873,7019874,7019875,7019876,7019877,7019878,7019879,7019880,7019881,7019882,7019883,7019884,7019885,9198273,9171314,7057540,7057541,7057542,9195382,9195383,9195436,9203479,10557338,9195548,9195624,9195625,9195626,7057796,9203674,9187984,9196077,10612822,9204180,9188279,9188280,9188281,9188282,9188283,8862884,8862885,9212427,8862952,7058694,9196535,9196536,10613295,10613304,9196893,9180943,9180944,9180945,9188970,9188971,9188972,9188973,9188974,10515177,7015133,7015134,7015135,7015136,7015137,7015138,7015139,7015140,10555424,10555425,10555426,10555427,10555428,10555429,9193666,4974647,4974648,4974649,4974650,4974651,4974652,4974653,4974654,4974655,4974656,4974657,4974658,4974659,9201823,9177845,9177846,9177847,9177848,9177849,9177850,9177851,9177852,9177853,9177854,7056036,9193892,10555831,9170042,9170043,9170052,9194089,9194334,10556292,10556293,10556294,9202572,9194593,10556531,10556532,10556533,10556534,10556535,10556536,10556537,10556538,9202737,10514619,10514620,10514625,7056981,7056982,9194842,9194843,7057020,7057021,7057022,7057023,9186986,9186987,9187054,9187055,9195104,10519089,9160310,9184325,9200454,9168525,9168526,9176527,9168527,10416596,9200714,9208753,9200834,4973709,4973713,9200980,9208991,9208992,9193100,9193120,9201220,9182386,9174513,9174514,9174515,9175282,9175283,9175284,9175285,9175500,10468113,10468116,10468117,10468118,10468119,10468120,4972467,4972468,4972469,4972470,9199998,9199999,9200000,9200001,9200287,10164488,10164489,10164490,10164491,10164492,10164781,10164782,10628266,10628267,10164821,10165056,10180121,10180122,10180123,10180124,10170139,10170140,10170229,10170230,10170231,10170232,10170233,10170234,10170235,10170236,10170237,10170238,10170239,10170240,10170241,10170242,10170280,10170281,10170287,10170336,10170337,10170338,10170339,10170340,10170341,10170342,10170343,10170344,10170345,10170346,10170347,10170348,10170353,10170354,10170355,10170356,10170357,10170358,10170359,10170360,10170361,10180530,10180531,10180532,10165553,10170633,10170634,10170635,10170636,10170637,10170638,10170639,10170640,10170674,10170675,10165688,10170689,10170690,10170691,10170692,10170693,10170694,10170695,10170702,10170703,10170704,10170705,10165856,10165857,10180920,10180921,10165960,10181208,10183498,10627021,10627022,10627023,10183745,10164234,10174404,10166932,10182024,10182025,10182026,10182027,10182028,10182029,10182198,10182199,10172224,10167228,10182362,10182469,10182600,10187698,10949502,10182794,10177924,10177925,10182942,10182943,10182944,10182984,10626506,10183070,10183135,10183247,10183314,10577433,10577434,10577435,10577436,10577437,10577438,10577439,10577440,10577441,10577442,10577443,10568630,10571813,10584138,10578156,10578157,10575159,10575160,10572264,10572265,10575419,10575420,10578707,10569714,10578975,10578976,10567545,10570552,10570553,10570554,10570555,10576703,10591839,10586005,10577104,10577105,10521149,10521150,10521151,10525182,10525198,10533210,10533211,10523341,10535375,10535376,10535377,10535378,10533426,10533427,10533428,10533429,10533430,10533431,10533432,10533433,10533434,10533435,10533436,10533510,10533511,10533512,10533513,10533514,10533515,10533516,10533517,10533518,10533519,10533520,10533521,10533522,10533523,10533524,10533525,10533526,10533527,10533528,10533529,10533530,10533531,10533532,10533533,10533534,10533535,10533536,10533537,10521599,10523611,10523612,10523613,10523614,10523615,10523616,10523617,10523618,10523619,10523620,10523621,10535946,10535947,10535948,10535949,10535950,10535951,10530122,10530123,10538305,10538306,10528362,10536402,10536403,10522502,10522503,10536660,10524676,10524677,10524678,10524679,10524680,10524681,10524682,10524683,10524684,10524700,10524701,10524702,10524703,10524704,10524705,10524706,10524707,10524708,10528719,10528725,10528726,10528751,10528752,10528755,10536759,10536760,10528787,10528839,10528840,10528841,10528845,10528846,10528847,10520849,10520850,10520851,10520852,10520853,10520854,10520855,10528855,10528856,10534880,10534881,10534882,10524906,10528909,10525006,10421225,10423980,10424038,10424039,10480884,10480885,10487922,10488004,10486022,10481039,10481042,10481045,10481049,10481051,10481053,10481058,10481067,10481076,10481077,10481086,10481094,10479145,10479146,10483146,10479147,10483147,10483151,10483152,10483153,10483154,10483155,10483156,10481639,10481682,10481683,10481691,10486697,10481701,10481702,10481703,10481708,10481709,10481827,10481888,10481894,10481895,10481898,10481901,10477903,10481903,10481905,10481909,10481914,10481918,10481921,10481925,10481928,10481951,10481955,10481956,10481957,10481962,10481963,10481964,10481966,10481967,10481968,10481969,10481970,10481973,10481974,10478012,10478065,10482088,10482089,10482110,10482111,10478114,10478115,10482118,10482770) 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'