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(7067847,7075847,7075911,10962701,7076064,7076070,10939811,7068142,7068143,7076252,7068254,7076255,7068262,7076272,7076276,7076277,7076280,7076321,7068327,7076329,7068332,7068334,7076340,7068343,7068344,7068349,7068350,7068356,7076360,10940199,10976285,10976344,7068738,10963429,10963430,10963431,7068749,10940468,10940503,10933288,10963644,10963676,7074102,7074130,8067203,7074137,7066138,7066169,7066171,7066185,7074268,10437311,10437312,10437313,10437314,7066402,8067505,8067595,8067596,8067635,8067659,8067660,7074619,7066665,7074730,7074781,7066827,7074847,7074940,7074986,7074987,7066997,8067991,8067992,8067993,8067994,8067995,8067996,8067997,8067998,8068001,8068002,8068032,8068033,8068034,8068035,8068042,8068043,8068044,10961747,10961748,8068050,8068086,8068211,8068222,8068223,10961932,8068237,8068238,8068266,8068282,8068283,8068293,8068294,8068374,8068407,8068408,7067453,8068473,8068474,8068475,8068484,8068530,8068531,8068532,8068617,8068625,8068640,8068641,7071827,10972808,10972945,10973115,7072436,7072457,7064458,7072458,7072548,7072549,7072550,7072551,7072552,7072553,7072554,7072555,7072579,7072603,10960333,7064678,8065797,7072800,8065994,7072947,7072961,7073068,8066249,8066250,8066251,8066252,8066253,8066254,8066274,8066275,8066283,8066296,8066309,8066339,8066343,8066344,8066359,8066360,10932773,7073346,8066429,8066430,8066475,8066476,8066511,8066610,8066611,8066612,8066634,8066635,8066636,8066668,10961287,10961288,10961289,8066717,8066718,10961481,10961482,10961483,7070819,7070849,7071029,8861087,10942931,10942944,8861320,10972105,8861351,8861352,10972171,10972172,10972176,10943291,8861497,10943315,10943316,8861542,8861547,8861548,10943383,10943391,10943401,10943418,8970220,7071755,7071771,7071772,7071773,7068937,7068963,7068964,7068965,7068981,7069009,7069183,7069233,7069234,7069235,7069236,7069237,7069238,10969929,10969930,7069257,10969986,10969987,10969988,7069462,10970245,10970246,10970312,10970313,10970314,10970315,10970316,10970317,10941354,10970385,10970386,3656577,10970631,7069984,10970696,10941727,10970697,10970698,10970699,10970700,10941844,10941845,10941855,10941912,10941913,10941956,10941971,10941972,10941978,10942035,10971036,8860337,3657268,7070651,10942429,10971399,10971400,7070732,7070741,7070742,7070743,10942458,10942473,7070798,10923480,10923481,10923482,10923483,10918506,10918507,10918508,10923519,10923520,10923534,10923544,10923565,10923566,10928576,10928590,10923593,10928597,10928601,10923619,10928621,10928622,10928633,10923636,10923653,10923654,10928654,10928655,10923655,10928656,10923656,10928657,10928658,10928659,10928660,10928661,10618235,10918764,10918765,10918766,10618277,10967818,10967819,10967820,10928812,10923829,10918836,10918837,10923882,10923974,10923975,10923976,10923977,10924056,10924057,10924058,10924059,10919234,10919235,10919236,10919237,10919238,10924390,10619022,10619023,10619024,10619025,10619026,10619027,10619028,10919559,10919560,10919561,10919562,10919563,10968652,10968653,10968677,10968796,10968797,10924784,10924785,10924786,10924787,10924788,10924789,10924875,10924876,10924877,10924878,10924879,10919911,10919912,10969051,10969052,10969053,10969054,10969055,10969056,10969057,10969058,10969059,10969060,10969061,10969062,10969063,10969064,10969065,10969066,10925186,10925187,10925188,10925239,10925240,10925383,10925384,10925385,10925386,10617063,10617064,10617107,10922644,10922645,10922730,10922731,10922732,10922733,10922734,10922754,10922760,10922761,10922762,10922763,10922764,10922765,10922766,10922767,10922768,10922813,10622345,10622346,10622347,10622348,10622349,10622350,10622351,10622352,10622353,10622354,10622355,10622356,10622357,10622358,10622359,10922898,10922907,10917956,10917957,10922960,10922961,10927992,10928006,10918018,10617509,10918019,10918020,10923030,10928062,10923147,10923148,10923176,10923281,10923282,10918284,10918324,10918325,10918326,10918327,10918328,10918329,10918330,10918331,10918332,10923361,10923390,10923406,10923407,10923408,10923409,10923452,10923453,8569814,10925505,10925506,10925507,10925508,10615014,10920537,10920557,8569880,8569881,8569884,10615078,10615079,10915605,10915620,10915621,10915622,10925721,10925722,10925723,10925724,10925725,10925726,10925842,10920873,10920874,10964942,10620408,10620422,8570282,8570301,10615471,8570302,8570347,10620664,10620670,10921211,10921239,10615820,10930729,10930730,10615987,10921499,10615989,10615990,10965546,10921597,10921598,10921599,10921614,10965655,10930962,10921731,10921751,10921752,10621252,10621253,10621254,10621255,10621256,10621257,10621269,10621270,10621271,10621277,10616284,10616285,10616286,10616287,10616288,10621300,10621311,10965879,10965880,10965881,10621374,10917052,10917056,10621652,10621653,10621654,10616669,10621706,10611104,10559290,10559320,10614296,7059848,7059853,7059872,7059873,10611453,10611454,10611455,10611456,10614472,8864335,10611615,10614821,10611850,10611853,10611866,10611880,10611898,10611899,10611955,7057466,7057480,7057486,7057494,7057503,7057521,10612033,10612069,10560242,10560243,10560244,10560245,10560246,7057630,10609282,10557504,10557633,10557634,10557635,10557636,10557637,10612488,10612518,10612589,10612604,10612633,10612641,10612647,10612648,10612655,10612658,10612675,10612684,10612685,10612689,10612690,10612701,7058230,8862666,7058319,10612836,10612938,10612943,10609975,10613106,7058748,10564454,10613306,8863171,8863176,10613342,7058853,7058870,8863314,8863320,8863321,8863322,8863323,8863324,8863325,8863347,8863348,10610491,8863362,8863363,8863364,8863365,8863390,8863395,8863411,10613553,8863412,8863413,7059064,7059065,7059099,10613608,8863472,8863473,8863474,7059124,8863500,8863510,8863511,7059156,8863542,8863543,8863544,8863545,8863546,8863547,10610716,7059273,7059323,7059449,10610950,7059460,10555344,10555345,10555346,10555347,10555348,10555349,7055749,10555399,10555400,10555401,10555402,10555403,10555404,10555405,10555406,10555407,10555408,10555409,10517544,10515597,10515598,10515599,4974647,10515614,4974794,7056108,4974854,7056232,10513887,7056285,10513962,10513963,7056481,7056482,7056483,10512142,10556440,10556441,10556442,10556443,10556444,10516557,2809381,10556700,10512758,10512759,10512760,10512761,10512787,10519053,10519054,10519055,10519056,10519057,10519058,10519089,10416244,10418260,10418261,10418262,8917988,10415461,10417544,10419568,8918320,10417739,10417760,10417766,10417775,10417790,10417817,10417818,10418829,10417836,10417837,10417853,10417854,10417871,10417872,10417888,10417889,10419892,10419896,10419902,10417906,10417907,10418984,10420040,10417057,10420058,10417058,10417076,10418083,10417093,10418095,10419104,10417106,10417107,10419107,10417108,10418124,10418131,7055433,10463042,10463043,10463044,10463045,10463046,10463047,10463048,10463049,10463050,10463051,10463052,10463053,10463054,10463055,10463056,10463057,10463058,10463059,10463060,10469149,10471178,10471179,10471180,10471194,4971471,4971507,4971508,8865219,4971604,10467359,4972038,4972039,4972040,4972077,4972098,4972128,4972129,4972236,10467985,10468019,10468044,8563379,8563399,10468141,8917229,10470376,10470380,10470381,10470385,10470483,10470490,10470590,10470593,10628012,10628013,10628014,10628015,10628016,10628017,10628022,10628090,10628828,10629606,10629607,10629658,10629754,10629755,10629808,10629837,10629904,10627002,10632053,10632094,10627279,10627281,10627282,10630114,10630191,10630213,10630227,10630228,10630230,10630351,10630360,10630361,10630362,10630373,10630374,10630375,10630376,10630377,10630378,10630379,10630380,10630381,10630382,10630455,10630461,10630502,10630515,10630516,10630517,10630518,10630519,10630520,10630521,10630522,10630523,10630524,10630525,10630526,10630527,10630610,10630611,10630612,10630711,10630712,10630713,10630878,10630895,10631005,10631008,10631009,10626131,10631155,10631156,10626195,10631204,10631207,10631208,10631238,10631239,10631240,10631241,10631242,10631243,10631244,10631245,10626441,10626516,10626551,10626552,10626742,10631885,10571402,10571403,10571404,10571405,10571406,10571407,10568619,10568620,10571658,10571659,10571789,10571790,10571791,10571792,10571793,10571794,10571795,10571796,10571797,10571798,10569290,10569291,10569292,10569293,10566470,10566471,10566472,10566473,10566474,10566475,10566476,10566477,10566478,10566479,10566480,10569495,10569496,10569518,10569519,10569520,10569521,10569684,10569685,10569686,10569687,10569688,10569705,10569706,10569707,10569708,10569709,10569710,10569711,10569712,10569713,10569852,10570067,10570068,10570081,10570082,10520827,10520829,10520830,10520831,10520832,10520833,10520834,10520850,10520852,10520853,10520854,10520855,10520901,10520904,10520905,10520917,10420288,10420314,10420643,10420899,10421091,10421102,10473626,10472871) 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'