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(4970738,3228953,8569566,3229038,3229039,3229040,3229041,3229072,3229073,3229074,3229075,3229076,3229077,3229078,3229079,3229080,3229081,3229082,3229083,3229084,3229186,3229187,3229188,3229189,3229190,3229191,3229192,3229193,3229194,3229195,3229199,3229200,3229201,7065953,7065974,8583528,10950688,10950700,7066140,7066158,7066159,7066160,7066245,7066246,8575736,8067905,8067920,8067921,8067928,3227423,8573288,8573289,10939103,7201195,7201196,7201414,7201415,7201416,7201417,7201418,7201419,7201420,7201421,7201542,7201543,7201640,7201654,7201656,7201680,7201682,7201769,7201770,7201771,7201772,7201773,7201774,8065845,7202175,7202241,7202262,7202287,7202289,7202620,7202621,7202628,7202629,7202632,7202662,3227093,3227194,3227195,3227196,7200116,7200132,7200149,7200340,7200341,7200342,7200343,7200344,7200345,7200346,7200347,7200348,7200349,7200350,7200351,7200352,7200353,7200354,7200355,7200356,7200357,7200358,7200359,7200360,7200361,7200362,7200363,7200364,7200365,7200366,7200367,7200368,7200369,7200370,7200371,7200372,7200373,7200374,7200375,7200376,7200377,8910236,8910237,8910238,8910239,8910240,8910241,8910242,8910243,8910244,8910245,8910246,8910249,8910250,8910253,8910254,8910255,8910258,8834738,8834748,10101531,10101546,10101547,10101575,8860371,8860372,8860373,8860389,8860391,8860392,8860399,8860417,8860424,8860425,8860426,8860427,8905873,8905874,8905875,8905876,8905877,8905878,8905879,8905880,8905953,10837649,10837667,10623490,10623491,10623492,8906592,8906785,8906786,8906787,8906788,8906789,8906790,8906791,8906792,8906793,8906794,10838647,10838649,10838911,10838938,10838939,10838941,10619887,10619895,10619896,10619898,10619899,10619900,10619901,10619902,10616970,10616971,10616996,10616997,10616998,10617000,10617002,10617005,10617006,10617008,10617054,10617055,10617056,10617069,10617070,8904981,10617071,8904982,10617079,10617080,10617081,10617082,10617083,10617084,10617085,10617086,10617087,10617088,10617089,10617090,10617091,10617092,10617093,10617094,10617095,10617096,10617097,10617098,10617231,10617232,10617233,10617236,10617238,10617240,10617242,10617243,10617246,10617247,10617248,10617250,10617251,10617255,10617261,10617311,10617312,10836918,10617314,10617316,10617317,10617318,10617332,8905343,10622453,10617489,8612185,10622506,10622524,10622528,10928330,8905845,8905846,8905847,8905848,8905849,8905850,8905851,10615024,10615097,10615100,10615101,10615104,10615110,10615111,10615112,10615128,10615134,10615135,10615161,10615162,10615163,10615202,10615246,10615312,10615338,10615363,10615516,10615624,10615685,10615708,10615709,10615710,10615818,10615826,10615827,10615833,10615842,10615925,10615926,10615931,10615947,10616030,10616044,10616045,10616193,10426445,10616462,10616464,10616469,10616471,10616472,10616473,10616474,10616476,10616477,10616479,10616490,10616491,10616492,10616493,10616494,10616495,10616497,10616498,10616499,10616500,10616501,10616502,10616503,10616505,10616506,10616507,10616508,10616511,10616512,10616513,10616517,10616518,10616519,10616520,10616522,10616525,10616526,10616527,10616528,10616529,10616530,10616533,10616534,10616546,10616547,10616577,10616644,10616698,10616701,8611392,8611393,8611394,10616730,10616739,10616745,10616746,10616747,10616748,10616749,10616750,10616751,10616752,10616753,10616754,10616755,10616756,10616757,10616758,10616759,10616760,10616761,10616762,10616763,10616764,10616765,10616766,10616767,10616768,10616769,10616770,10616771,10616772,10616773,10616774,10616775,10616791,10616804,10616841,10616901,10611044,10614050,10611123,10611129,10611176,10611179,9165550,9165551,9165552,9165553,10614230,10611236,10614239,10714134,10614338,10714164,10714165,10714169,10714170,10614383,10614384,10614385,10614386,10614387,10614388,10614389,10614390,10614391,10614392,10614393,10614394,10614395,10614396,10614397,10614398,10614399,10614400,10614401,10614402,10614403,10614404,10614405,10614406,10614463,10614566,10614567,10614568,10614593,10614594,10614595,10614596,10614597,10614598,10614599,10614600,10614601,10614602,10614603,10614604,10614605,10614606,10614607,10614608,10614609,10614610,10614611,10614612,10614613,10614614,10614615,10614616,10614617,10614618,10614619,10614620,10614621,10614622,10614623,10614624,10614625,10614626,10614627,10614628,10614629,10614630,10614631,10614632,10614633,10614634,10614635,10614636,10614637,10614638,10614639,10614640,10614642,10614643,10614644,9166039,10614742,10611800,10611873,10611874,10611875,10611876,10611879,10612082,10612083,10612252,10609285,10609307,10609344,10609345,10609350,10609367,10612380,10612381,10612414,10612500,10612507,10612508,10612509,10612510,10609562,10612575,10612596,10609770,10612893,10612894,10612945,10610025,10610046,10610093,10610104,10613293,10613294,10613295,10613296,10613297,10613298,10613299,10613300,10613301,10613302,10613303,10613304,10610345,10610346,10610347,10613355,10613356,10613357,10613365,10613366,10613367,10613368,10610371,10610399,10610416,10610480,10610481,10610793,10610795,10613805,10610823,10610824,10610825,10610832,10610833,10610901,10610902,10610928,9169318,9169319,9169320,9169321,9169322,9169323,9169324,9169325,9169326,9169354,10117561,7055530,10117562,10117563,7055541,7055546,9169397,9169398,9169399,9169400,10117752,10117753,10117798,9169635,9169636,10117860,9169808,9169809,9169810,9169811,10118139,10118204,10118205,10118206,10118207,10118208,10118242,10118249,10118250,10118399,10118497,10118524,10118534,10118537,10118538,10118571,10118572,10118580,10118606,10118607,9168322,9168356,10416281,10417296,10417297,10417298,10417300,10417308,10417309,10417310,10417311,10417312,10417313,10417314,10417315,10417318,10417319,10417320,10417321,10417322,10417323,10417324,10417325,10417326,10417327,10415327,10415328,10417331,10415333,10417336,10417337,10417338,10418338,10417339,10415339,10417340,10415340,10417341,10418341,10415380,10415381,10415402,10415403,10415404,10415405,10415406,10116718,10116725,10116735,10415472,10415473,10415474,10415475,10415489,10415490,10415491,10415493,10415494,10415495,10415496,10415497,10415498,10415499,10415500,10415501,10415502,10415503,10415504,10415505,10415506,10415507,10415508,10415509,10415510,10415511,10415512,10415513,10415514,10116833,10416631,10416633,10416635,10415686,10415687,10415688,10415689,10415690,10415691,10415692,10415693,10415694,10415695,10415696,10415697,10415698,10415699,10415700,10415701,10415702,10415703,10415704,10415705,10415706,10415707,10415708,10415709,10415710,10415711,10415712,10415713,10415714,10415715,10415716,10415717,10415718,10415719,10415720,10415721,10415722,10415723,10415724,10415725,10416783,10416784,10416785,10416786,10416787,10416788,10416789,10419795,10417797,10417798,10417799,10417800,10419801,9168920,10415845,10415846,10415848,10415849,10415850,9168929,10415851,10415852,10415853,10415854,10415856,10415857,10415858,10415859,10415860,10415861,10415862,10415863,10415864,10415865,10415866,10415867,10415868,10415869,10415870,10415871,10415872,9168953,10415890,10415891,10415892,10415893,10415894,10415895,10415899,10415900,10415901,10415902,10415903,10415904,10415905,10415906,10415907,10415908,10415912,10415915,10415916,10415917,10415918,10415919,10416934,10416935,10416936,10416937,10416938,10416939,10416940,10416941,10416942,10416954,10416992,9169100,10416028,10416030,9169109,10416032,10416034,10418047,9169131,9169151,9169152,10419123,10419124,10419125,10419126,10419127,10419128,10419129,10419130,10419131,10419132,10419133,10419134,10419135,10419136,10419137,9169223,9169229,9169235,9169236,9169239,9169240,9169241,9169242,9169243,9169244,9169245,9169253,9169267,9169268,7055454,10468892,10468894,10471087,10471088,10471089,10471090,10471091,10471092,10471093,10471094,10471095,10469247,10469248,10471264,10471265,8550000,8550018,8550046,8550092,8550100,8550106,10469542,10469543,10469544,10469545,10469546,10469547,10469548,10469549,10469550,10469551,10469641,10469642,10469643,10469644,10469645,10469646,10469647,10469648,10469649,10469650,10469651,10469652,10469653,10469654,10469655,10469656,10469657,10469658,10469659,9175177,10115704,9167641,10464219,10464244,10464274,9167776,9167812,9167932,9167967,9167968,9168146,10883474,10883828,10883829,10883830,10883969,10883970,10883971,10628564,10628565,10884196,10884197,10884198,10884322,10884354,10884427,10884479,10884592,10884675,10884676,10884744,10884745,10884746,10884747,10884748,10884749,10884750,10884751,10884752,10884753,10884754,10884755,10884756,10884757,10884758,10884783,10884784,10885203,10629836,10877538,10883087,10883358,10883359,10883378,10883396,10883397,10883430,10883431,10883432,10161857,10875851,10161867,10162029,10876043,10162120,10162121,10162122,10162123,10162124,10162125,10162126,10162219,10162220,10626442,10626443,10582559,10582560,10528214,10481988) 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'