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(11001741,11001742,11001743,7076289,7068372,7068373,10846312,8569604,8569605,8569606,8569607,8569608,8569609,8569610,8569611,8569612,8569613,8569614,8569615,8569641,8621592,8621593,8621594,10944316,10459516,10933367,11041715,10950796,10950797,10950798,10950799,10950800,10950801,10950802,10950803,10950804,10950805,10950806,10950840,3229698,3229699,3229700,3229701,3229702,3229703,3229704,3229705,3229706,3229707,3229708,3229709,3229710,3229711,3229712,3229713,3229714,3229715,3229716,3229717,3229718,3229719,3229720,3229721,3229722,3229723,3229724,3229725,3229726,3229727,3229728,3229729,3229730,3229731,3229732,3229733,3229734,3229735,3229736,3229737,3229738,3229739,3229740,3229741,3229742,3229743,3229744,3229745,3229746,3229747,3229748,3229749,3229750,3229751,3229752,3229753,3229754,3229755,3229756,3229757,3229758,3229759,3229760,3229761,3229762,3229763,3229764,3229765,3229766,3229767,3229768,3229769,3229770,3229771,3229772,3229773,3229774,3229775,3229776,3229777,3229778,3229779,3229780,3229781,3229782,3229783,3229784,3229785,3229786,3229787,3229788,3229789,3229790,3229791,3229792,3229793,3229794,3229795,3229796,3229797,3229798,3229799,3229800,3229801,3229802,3229803,3229804,3229805,3229806,3229807,3229808,3229809,3229810,3229811,3229812,3229813,3229814,3229815,3229816,3229817,3229818,3229819,3229820,3229821,3229822,3229823,3229824,3229825,3229826,3229827,3229828,3229829,3229830,3229831,3229832,3229833,3229834,3229835,3229836,3229837,3229838,3229839,3229840,7066423,3229841,7066424,3229842,3229843,7066425,7066426,3229844,7066427,3229845,7066428,3229846,7066429,3229847,7066430,3229848,3229849,7066431,7066432,3229850,7066433,3229851,3229852,7066434,3229853,7066435,3229854,7066436,7066437,3229855,3229856,7066438,7066439,3229857,7066440,3229858,7066441,3229859,7066442,3229860,7066443,3229861,7066444,3229862,3229863,7066445,3229864,7066446,3229865,7066447,3229866,7066448,3229867,7066449,3229868,7066450,3229869,7066451,3229870,7066452,3229871,7066453,7066454,3229872,7066455,3229873,7066456,3229874,3229875,7066457,3229876,7066458,7066459,3229877,7066460,3229878,7066461,3229879,3229880,7066462,7066463,3229881,7066464,3229882,3229883,7066465,7066466,3229884,7066467,3229885,7066468,3229886,7066469,3229887,3229888,3229889,3229890,3229891,3229892,3229893,3229894,3229895,3229896,3229897,3229898,3229899,3229900,3229901,3229902,3229903,3229904,3229905,8622367,7074585,8609614,8622754,10929267,10929268,10929269,3227414,10929270,10929271,10929272,10929273,10929274,8573324,7075322,8620493,10447549,10939464,10939465,10939466,10939467,10103107,8617995,8617996,10931533,10103325,10931588,10931589,10931590,10931591,10931592,10931593,10931594,10931595,10931596,10931597,10931598,10931599,10103417,10843048,10843049,7201609,7201610,7201611,7201614,7201615,7201616,7201617,7201620,7072534,8075303,8075304,8075305,3899113,3899114,3899115,3899116,3899117,10999321,10999322,10103931,8836371,8065873,10960757,10960758,10960759,10960760,10960761,10960762,10960763,10960764,10960765,10960766,10960767,10960768,10960769,7073182,10104330,10104363,10104364,7202586,7202648,7202649,10844329,10844376,7073631,10958931,10958932,10958933,10958934,10958935,10958936,10958937,10958938,10958939,10958940,8910366,8834808,8834809,8834810,8834811,8834812,8834813,8834814,8834815,8834816,8834817,8834818,8834819,8834820,8834821,8834822,8834823,8834824,8834825,7200594,7071459,10102599,8835327,10839928,10839965,8908503,7069773,10840676,10101106,10101107,10101108,10101109,10101110,10841049,10841184,10101609,3237005,3237006,3237007,11048499,11048500,11048501,11048502,11048503,7070660,11006870,11006871,4936941,10618364,10968055,10968056,10994235,7197097,7197098,7197099,8907091,8907094,8070790,8070791,8070792,8070793,8070794,8070795,10838878,10839134,10839135,8071179,4938653,4938654,10617326,10617332,8542070,10617646,10617647,10617648,10617649,10617650,10617651,10617652,10617653,10617654,10617655,10617656,10617657,10617658,10617659,10617660,10617661,10617662,10617663,10617664,10617665,10617666,10617667,10617668,10617669,10617670,10617671,10617672,10615243,10615244,10615395,10615396,10848156,10848157,10952183,3231073,3231074,10848555,8610897,8540765,8611623,8611624,8611625,8611626,8611627,8611628,8611629,8611630,8611631,8611632,8611633,8611634,8611635,8611636,8611637,8611638,8611639,8611640,8611641,10122062,9165992,9165993,9165994,9165995,9165996,9165997,9165998,9165999,9166000,9166001,9166002,9166003,9166004,9166005,9214146,9190241,8542485,8542486,8542487,8542488,8542489,8542490,8542491,8542492,8542493,8542494,8542495,8542496,8542497,10609333,10609334,10609335,9211857,8862587,8862588,8862589,8862590,8862591,8862592,8862593,8862594,8862595,8862596,8862597,8862598,8862599,8862600,8862601,8862602,9172247,9172248,9220289,9220290,9220291,9220292,9220293,9220294,9220295,9220296,9220297,9220298,9220299,9220300,9220301,9220302,9220303,10613028,9172469,9172497,10561807,9204996,10564992,10564993,10125570,9185413,9185414,9185415,7055701,7055702,7055703,7055704,7055705,7055706,7055707,7055708,7055709,7055710,7055711,7055712,7055713,7055714,7055715,7055716,7055717,9209645,9209646,9209647,10515781,10515782,10515783,9170033,10515926,10515927,10515928,10515929,10515930,10515931,10515932,10515933,10515934,10515935,10515936,10515937,10515938,10515939,10515940,10515941,10515942,10515943,10515944,10515945,10515946,10515947,10514094,10514095,10514096,10514097,10514098,10514099,10514100,9170513,9170514,9170515,9170516,9170517,9170518,9170519,9170520,9170521,9170522,9170523,9170524,9170525,9170526,9170527,9170528,9170529,9170530,9170531,9170532,9170533,9170534,9170535,9170536,10118733,9170537,10118734,9170538,10118735,9170539,10118736,9170540,10118737,9170541,10118738,9170542,10118739,9170543,10118740,9170544,10118741,9170545,10118742,9170546,10118743,9170547,10118744,9170548,10118745,9170549,10118746,9170550,10118747,9170551,10118748,9170552,10118749,9170553,10118750,9170554,10118751,9170555,10118752,9170556,10118753,9170557,10118754,9170558,10118755,9170559,10118756,9170560,10514373,10118757,10514374,9170561,10118758,9170562,10118759,9170563,10118760,9170564,10118761,9170565,10118762,9170566,10118763,9170567,10118764,9170568,9170569,9170570,9170571,9170572,9170573,9170574,9170575,9170576,9170577,10514408,10514409,10514412,10514413,10514414,10514415,10514416,10514417,10514418,10514419,10514420,10514421,10514422,10514423,10514424,10514425,10514426,10514427,10514428,10514429,10514430,10514431,10514432,10514433,10514434,10514466,10514467,10514468,10514469,10514470,10514471,10516524,10514966,10514967,10514968,10514969,10514970,10515064,10515065,10515066,4973186,9168395,8918060,8918061,10419679,10419969,10419970,10419971,10419972,10419973,10117319,10117418,6666370,6666371,6666372,6666373,6666374,6666375,6666376,6666377,6666378,6666379,6666380,6666381,6666382,6666383,6666384,6666385,6666386,6666387,6666388,6666389,6666390,6666391,6666392,6666393,6666394,6666395,6666396,6666397,6666398,6666399,6666400,6666401,6666402,6666403,6670768,8865257,9199073,8550271,8550272,8550273,8550274,8550275,8550276,8550277,8550278,8550279,8550280,8550281,8550282,8916847,8916848,8916849,8916850,8916851,8916852,8916853,10123499,10469939,10469941,6667428,6667429,8550655,6671897,8563596,6667877,9208019,9168022,6668152,10466747,10468780,10628316,10159898,10159899,10159900,10159901,10159902,10159903,10159904,10159905,10159906,10159907,10159908,10159909,10885312,10890423,10890424,10890425,10890426,10890427,10890428,10890429,10890430,7000871,7000872,7000873,10632305,7001079,8593381,8593439,10162308,10162309,10162310,10162311,10162312,10162313,10162314,10162315,10162316,10162317,10162318,10162319,10162320,10162321,10162322,10162323,10891440,10891444,10881543,10187636,10187637,10187638,10187639,10187640,10187641,10187642,10882294,10882362,10646172,10646173,10646174,10646175,10646176,10646177,10646178,10601182,10601183,10598666,10647762,10647763,10647764,10647765,10647766,10647767,10647768,10647769,10647770,10647771,10582552,10646171,10545940,10545941,10545950,10545951,10545959,10545971,10545972,10545973,10545982,10545983,10545984,10545985,10545986,10545987,10545988,10542173,10542174,10522673,10544844,10522866,10506510,10506511,10506512,10506513,10506514,10506515,10506516,10506517,10506518,10506519,10506520,10506521,10424013,10424014,10422016,10484500,10484501,10484506,10484507,10484508,10484509,10484512,10484513,10484514,10484515,10484516,10484519,10484520,10406968) 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'