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(7076006,4970782,7068754,7068770,7068785,8569777,8569783,7068846,7068865,7068866,7068867,10940549,7068931,8067261,7066334,8067475,7074601,7066657,7066658,7066664,7066667,7074852,7074853,7074854,7074855,7074856,7074857,7074880,7075002,7075027,10988025,10988026,10988027,10988028,10988029,10988030,10988031,10988032,10988033,10988034,10988035,10988036,10988037,10988038,10988039,10988040,10988041,10988042,10988043,10988044,10988045,10988046,10988047,10988048,10988049,10988050,10988051,10988052,10988053,10988054,10988055,10988056,10988057,10988058,10988059,10988060,10988061,10988062,10988063,7067402,7075423,7067752,7075770,7075771,10939456,10962537,7072200,8075313,8075314,8075323,10960452,7073554,7073555,7073556,7070947,7070948,7070956,7070958,7070976,7070983,7070989,7071008,7071009,7071010,11048943,7071071,7071075,10942904,7071370,7071371,7071378,7071379,7071380,10943041,10943042,10943043,10943044,10943045,10943046,10943047,10943048,11049419,7071525,11049472,7071600,7071601,7071622,7071623,7071629,7071636,7071639,7071643,7071647,7071648,7071651,7071659,7071672,7071673,7071681,7071682,6000096,6000097,7069292,7069293,7069381,3656712,3656860,11048438,11048439,7070620,7070839,7070872,7070898,7070899,7070900,7070901,7070929,7070930,7070931,7070932,7070933,10918516,10923576,10923577,10923578,10923579,10923580,10923581,10923582,10923583,10923584,10923585,10923586,10923587,10923588,10923589,10923590,10923591,10923592,10923593,10923594,10923595,10923596,10923597,10923598,10923599,10923600,10923601,10923602,10923603,10923604,10923605,10923606,10923607,10923608,10923609,10923610,10923611,10923612,10918736,10955120,10955121,10919259,10919260,10919261,10919262,10919263,10919591,8071203,8071204,10925098,10920121,10920122,10619903,10617078,10622099,10622100,10617322,10617323,10617324,10622376,10622377,10918028,10918341,10614991,10615099,10615132,8570090,10615155,10615156,8570107,10620175,10964888,8570354,10965326,10930829,10926756,10917079,10917080,10917081,10917082,10559336,8864541,8864776,10611922,10611941,8861926,7057707,10557800,10557801,10557802,10564129,10564130,10564131,10564132,10564133,10564134,10564135,10564136,10564137,10564138,10564139,10564140,10564141,10564142,10564143,10564144,10564145,10564146,10564147,10564148,10564149,10564150,10564151,10564152,10564153,10564154,10564155,10564156,10564157,10564158,10564159,10564160,10564161,10564162,10564163,10564164,10564165,10564166,10564167,10564168,10564169,10564170,10564171,10564172,10564173,10564174,10564175,10564176,10564177,10564178,10564179,10564180,10564181,10564182,10564183,10564184,10564185,10564186,10564187,10564188,10564189,10564190,10564191,10564192,10564193,10564194,10564195,10564196,10564197,10564198,10564199,10564200,10564201,10564202,10564203,10564204,10564205,10564206,10564207,10564208,10564209,10564210,10564211,10564212,10564213,10564214,10564215,10564216,10564217,10564218,10564219,10564220,10564221,10564222,10564223,10564224,10564225,10564226,10564227,10564228,10564229,10564230,10564231,10564232,10564233,10564234,10564235,10564236,10564237,10564238,10564239,10564240,10564241,10564242,10564243,10564244,10564245,10564246,10564247,10564248,10564249,10564250,10564251,10564252,10564253,10564254,10564255,10564256,10564257,10564258,10564259,10564260,10564261,10564262,10564263,10564264,10564265,10564266,10564267,10564268,10564269,10564270,10564271,10564272,10564273,10564274,10564275,10564276,10564277,10564278,10564279,10564280,10564281,10564282,10564283,10564284,10564285,10564286,10564287,10564288,10564289,10564290,10564291,10564292,10564293,10564294,10564295,10564296,10564297,10564298,10564299,10564300,10564301,10564302,10564303,10564304,10564305,10564306,10564307,10564308,10564309,10564310,10564311,10564312,10564313,10564314,10564315,10564316,10564317,10564318,10564319,10564320,10564321,10564322,10564323,10564324,10564325,10564326,10564327,10564328,10564329,10564330,10564331,10564332,10564333,10564334,10564335,10564336,10564337,10564338,10564339,10564340,10564341,10564342,10564343,10564344,10564345,10564346,10564347,10564348,10564349,10564350,10564351,10564352,10564353,10564354,10564355,10564356,10564357,10564358,10564359,10564360,10564361,10564362,10564363,10564364,10564365,10613215,10564366,10564367,10564368,10564369,10564370,10564371,10564372,10564373,10564374,10564375,10564376,10564377,10564378,10564379,10564380,10564381,10564382,10564383,10564384,10564385,10564386,10564387,10564388,10564389,10564390,10564391,10564392,10564393,10564394,10564395,10564396,10564397,10564398,10564399,10564400,10564401,10564402,10564403,10564404,10564405,10564406,10564407,10564408,10564409,10564410,10564411,10564412,10564413,10564414,10564415,10564416,10564417,10564418,10564419,10564420,10564421,10564422,10564423,10564424,10564425,10610408,7059189,7059190,7059191,7059192,10610813,10511156,10511460,10511461,10511463,10511546,10511547,10511548,10511549,10511550,10511551,10511552,10511553,10511554,10511555,10511556,10511557,7055911,10511558,10511559,10511560,10511561,10511562,10511563,10511564,10511565,10511566,10511567,10511568,10511569,10511570,10511571,10511572,10511573,10511574,10511575,10511576,10511577,10511578,10511579,10511580,10511581,10511582,10511583,10511584,10511585,10511586,10511587,10511588,10511589,10511590,10511591,10511592,10511593,10511594,10511595,10511596,10511597,10511598,10511599,10511600,10511601,10511602,10511603,10511604,10511605,10511606,10511607,10511608,10511609,10511610,10511611,10511612,10511613,10511614,10511615,10511616,10511617,10511618,10511619,10511620,10511621,10511622,10511623,10511624,10511625,10511626,10511627,10511628,10511629,10511630,10511631,10511632,10511633,10511634,10511635,10511636,10511637,10511638,10511639,10511640,10511641,10511642,10511643,10511644,10511645,10511646,10511647,10511648,10511649,10511650,10511651,10511652,10511653,10511654,10511655,10511656,10511657,10511658,10511659,10511660,10511661,10511662,10511663,10511664,10511665,10511666,10511667,10511668,10511669,10511670,10511671,10511672,10511673,10511674,10511675,10511676,10511677,10511678,10511679,10511680,10511681,10511682,10511683,10511684,10511685,10511686,10511687,10511688,10511689,10511690,10511691,10511692,10511693,10511694,10511695,10511696,10511697,10511698,10511699,10511700,10511701,10511702,10511703,10511704,10511705,10511706,10511707,10511708,10511709,10511710,10511711,10511712,10511713,10511714,10511715,10511716,10511717,10511718,10511719,10511720,10511721,10511722,10511723,10511724,10511725,10511726,10511727,10511728,10511729,10511730,10511731,10511732,10511733,10511734,10511735,10511736,10511737,10511738,10511739,10511740,10511741,10511742,10511743,10511744,10511745,10511746,10511747,10511748,10511749,10511750,10511751,10511752,10511753,10511754,10511755,10511756,10511757,10511758,10511759,10511760,10511761,10511762,10511763,10511764,10511765,10512191,10512192,10512193,10512194,10512195,10512196,10512197,10512198,10512199,10512200,10512201,10512202,10512203,10512204,10512205,10512206,10512207,10512208,10512209,10512210,10512211,10512212,10512213,9162434,9162435,9162436,9162437,10512964,10512965,10419235,10417278,10419409,10419410,10416455,10416477,10419561,10419566,10419567,10419602,10419603,10419604,10419605,10419606,10419607,10419608,10419609,10419653,10419654,10419655,10416722,10416723,7054979,10416928,10467456,10467457,10467458,10467459,10467460,10467461,10463876,10463877,10463878,10463879,10463880,10463881,10463882,10463883,10463884,10463885,10463886,10463887,10463888,10463889,10463890,10463891,10463892,10463893,10463894,10463895,10463896,10463897,10463898,10463899,10463900,10463901,10463902,10463903,10463904,10463905,10463906,10463907,10463908,10463909,10469910,10463910,10463911,10463912,10463913,10463914,10463915,10463916,10463917,10463918,10463919,10463920,10463921,10463922,10463923,8916994,10463924,10463925,10463926,10463927,10463928,10463929,10463930,10463931,10467967,10468024,10468077,10468089,10468097,4972462,4972463,8563539,8563540,6667722,6667723,10462756,10464807,10464808,10464809,10464810,10627970,10628097,10156254,10156255,10156256,10156257,10627025,10627037,10627038,10627039,10627065,10627066,10627077,10627078,10627079,10632108,10632109,10632110,10627786,10627856,10627857,10627858,10627859,10627860,10627861,10627862,10627863,10627864,10627865,10627866,10627867,10627868,10627869,10627870,10627871,10627872,10627873,10627874,10627893,10627905,10627906,10627909,10627912,10627913,10627915,10627916,10627918,10627933,10630055,10630187,10630944,10630945,10630946,10630947,10630948,10630949,10630950,10626131,10626303,10626304,10626305,10626306,10626307,10626308,10626313,10626326,10626327,10626328,10626330,10626333,10626334,10631891,10631892,10571432,10573013,10573014,10573015,10573016,10573017,10521185,10523510,10523585,10524667,10524726,10524727,10522892,10522893,10522894,10420404,10420406,10420408,10420450,10422169,10422172,10422173,10422175,10422178) 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'