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(8068810,10930168,10962586,10962587,10962589,10962595,10962634,8838461,8838462,10447890,10930292,10447950,10963065,10963066,10963067,10963096,10459153,4970924,4970925,4970926,4970927,4970928,4970929,10963297,10963298,10963299,10963300,10963301,10963312,10963313,10963314,10963315,10963316,10963317,8569635,8569649,3229101,10459500,10933373,8067003,4968316,4968317,4968326,10846746,4968335,10459605,10459613,10459621,10846807,4968410,4968411,8067233,8583701,8067312,8067359,10437241,10437242,10437243,10950927,10950947,10437277,7074378,7074420,7074440,7074441,8067541,8575682,8575683,8575684,8575685,7074532,7074540,10951315,10951316,10951317,10951318,8575921,7074762,7074763,7074764,7074765,7074766,7074767,7074768,8575945,7074769,7074770,7074771,10844632,10844633,7067082,10961896,3227659,8573592,10845321,10845322,10845329,10845336,10845337,10962294,10962295,10102946,8835353,8835354,8835355,7072035,7201299,10103234,10931623,10931626,10931627,10103420,10103421,10931751,10103452,10103463,10931849,10931852,10931860,10931918,10931923,10931930,10931931,10931932,10931933,10931934,10931942,10931952,10931953,10931954,10103670,10932040,7064612,8618476,11038337,11038338,11038339,10843462,10843463,10932162,10999492,8836334,8618695,7202109,10999550,10999551,7202114,8618709,8618729,10932344,10932345,10104052,10104053,10843783,10843784,10843790,8836543,10932606,10932613,10932638,10932643,10932665,10932668,10932672,10932678,10932687,7065283,10844109,10932838,10932845,10932847,10932852,10932853,10932913,10932914,10933131,10101974,10984611,10997618,10997626,11010642,11036829,11036832,11036833,11036834,11036837,11036838,11036839,11036840,11036854,11036858,11036859,11036860,11036863,11036864,11036871,11036872,11036880,11036895,11036898,11036900,11036901,11036903,11036904,11036905,11036906,11036911,8861132,11036913,11036914,11036919,11036920,11036921,11036923,11036924,11036925,11036929,11036930,11036931,11036989,11036990,10102492,10102493,11037060,11037061,7071385,8834904,11037180,8861417,10943288,11037268,11037274,3655558,8614704,3655559,3655560,10940692,10940693,10940694,10940695,10995833,10995834,10995835,10995836,10995837,10995838,10995839,10995840,10995841,10995842,10995843,10995844,10995845,10995846,10944745,10995978,8615262,8615263,8072312,11009188,11009211,11009212,11009307,11009308,11009309,11009310,11009311,11009312,11009313,11009322,11009323,8615527,8615528,8615529,8615530,8615531,8615545,8615556,10957464,10957465,10957466,10957467,10957474,10957475,8072763,8072764,8072765,8072766,8072767,10941676,10840960,10840961,8564992,8565059,8565082,8565083,8565084,10942109,10101564,10101565,10101566,11010174,11010175,11010176,11010177,11010178,11010206,11010207,11010219,11010233,11010253,10942290,11010285,10101739,10101752,10101885,10841546,10954692,10954693,10954697,8612907,8612908,4936808,4936810,4936814,4936925,4936974,10954937,4936978,4936982,4936986,4936990,4936994,4936998,4937008,10967981,4937064,4937076,4937088,4937100,8906878,11007527,11007528,11007529,11007530,11007531,11007532,11007533,11007534,11007535,11007536,11007537,11007538,10619107,10619108,10968648,10968649,10968650,10968651,10968652,10968653,10968654,10968655,10968656,10968657,10968658,10968659,10968660,10968661,10968662,10968663,10968664,10968665,8613834,8613835,8613836,8070916,8613912,11007764,11007765,11007766,11007767,8070950,8071015,8071016,8071154,4938050,8071222,8071226,8071230,8071234,8071238,8071242,8071246,8071256,11008097,8071317,8071318,8071331,8071347,8071359,10839305,10839306,10839307,10839308,10839309,10839427,10619859,4938467,4938468,4938469,4938470,4938471,10922529,8611958,8611970,10617349,10617350,10617351,10617352,10953989,8612192,8612362,8612364,10837494,10837540,10620083,8576127,8576128,8576159,10951715,8570162,8570176,10615397,10952030,10848209,10848210,10848211,10965410,10965411,10965412,10930893,10930894,10930904,10930905,8540819,11044072,11044073,8611331,8541009,8541010,8541012,10621729,10621730,8541099,10922309,10922314,10922327,8541212,8577951,10979467,10979468,10979469,9205352,10562246,9165558,10559395,10559479,8864226,8864227,8864448,9166018,9166150,9190252,10612059,7057608,8542630,9211668,9211669,9211670,9211671,7057907,9179786,9180080,9180081,9180082,9180083,9180084,9180085,9180086,9180087,9180088,9180089,9180090,9180091,9172369,10120569,9188628,9188629,9196678,9196679,9172680,9196680,9196681,9204776,10121009,10564683,10564687,10564712,7059084,7059085,7059086,7059087,7059088,7059089,7059090,9188928,10564803,10564804,9173001,10558817,10558818,10564820,10564821,10564822,10564823,10564824,9165250,7059443,9185358,7055697,9161595,7055827,10515497,10515515,10515516,10515551,10517619,10515670,7056044,7056045,10126078,9162127,9162128,9162147,9162155,10516499,10516500,10516501,10516502,10516503,10118954,10512706,10516869,10516886,10516887,10516888,9171139,10514972,10514973,9171217,9171218,9171219,9171220,9192301,9192302,9192303,4973281,10116666,4973348,10418489,4973422,10418504,4973479,4973492,4973552,10125020,10125021,10125022,10125023,9208861,9208862,9208863,10125223,10417035,10417043,10417048,9177127,9177128,10122514,10122585,9198470,9198471,9198472,6666477,6666478,9198514,9198515,9198528,9198541,9198545,9198550,9190734,4971751,4971752,10123266,9175086,8550323,8550325,8550328,8550341,6667203,6667220,6667242,8916926,8916981,8550504,8917089,8563400,9191526,9191615,8550822,8550824,8550840,8550844,8550945,8550946,8550947,8550948,10466390,8550971,8550972,8550982,8550986,8551003,10466445,9191904,9191906,9191912,8551069,9191917,9191929,10462534,9191981,8551162,8551163,8551196,8551197,10169671,10628394,10175007,10175008,10170134,10170135,10170136,10170137,10170138,10165242,8594509,8594510,10165574,8068985,8068986,8068987,8068988,10165671,10165689,10175717,10175742,10165761,10165775,10175784,10165786,10175791,10165800,10165807,10175812,10165821,10165831,10155834,10155835,10155844,10155845,8069250,8069251,10889942,10889963,10165979,10165980,10165986,10166031,10156038,10156040,10156107,10156124,10890134,10156213,10627097,10173660,10887650,10887651,10163758,10163759,10163760,10163761,10163762,10158780,10158781,10158791,10173852,10173853,7001088,10877911,10887967,10627564,10627565,10174112,10184127,10184133,10184138,10184149,10184150,10184151,10184191,10174305,10174306,10174307,10174308,10174309,10174310,10174311,10174312,10630253,10630254,10630255,10172381,10172503,10172504,10172520,10172521,10172522,10172549,10172550,10172551,10172586,10172587,10172680,10187692,10626462,10949812,10949813,10949814,10949815,10949820,10949821,10949822,10949823,10163096,10173100,10949955,10949973,10950042,10950045,10626726,10626728,10626729,10173265,10173266,10173267,10173270,10173271,10950091,10626830,10580500,10581335,10581336,10581337,10581338,10581339,10581340,10587411,10590484,10590485,10590486,10590487,10590488,10590489,10590490,10590491,10585967,10543430,10543448,10521455,10537538,10537539,10537540,10537541,10537542,10537543,10537544,10537545,10537546,10537547,10537608,10537646,10541793,10540072,10520090,10520837,10520838,10423385,10423387,10423390,10421475,10422645,10420650,10505553,10505575,10422750,10422753,10490001,10490033,10490037,10490038,10490039,10490063,10490064,10490104,10490105,10490106,10477115,10477116,10490125,10490126,10490127,10490128,10488185,10488186,10488187,10473277,10473290,10473291,10473312,10473313,10473314,10496334,10496335,10473348,10473357,10473358,10473379,10473380,10473381,10473382,10473383,10490384,10473384,10490390,10490394,10473399,10473400,10490401,10473401,10490402,10473402,10490403,10490408,10490412,10490414,10490418,10490426,10490428,10490436,10490441,10473441,10490443,10490446,10490448,10490458,10490459,10473460,10473461,10490462,10490463,10490466,10473466,10473467,10473468,10486473,10490474,10486474,10486475,10486476,10473479,10490482,10473484,10473489,10473490,10473496,10490499,10473510,10473511,10475648,10475651,10473725,10473730,10473733,10473743,10473745,10473747,10473751,10473755,10490759,10473759,10473766,10473769,10473776,10473777,10473780,10473791,10473795,10473803,10473804,10473806,10473809,10473811,10473815,10473820,10473827,10473829,10473853,10473854,10473866,10473945,10473946,10473947,10473948,10473949,10473950,10473951,10473952,10473994,10473995,10497005,10474022,10474023,10474024,10474025,10474026,10474027,10474067,10497077,10497084,10497103,10497104,10474123,10474125,10497165,10497166,10487183,10497203,10487203,10487442,10487443,10489512,10489513,10489514,10489515,10489516,10489519,10489540,10489546,10472671,10472672,10472673,10472674,10472675,10472676,10472677,10472678,10472679,10472680,10472681,10472717,10472718,10472719,10472720,10472721,10472734,10472735,10472736,10472737,10472749,10474756,10474757,10474758,10474759,10474760,10472820,10472839) 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'