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(7067886,4970679,4970700,4970759,10989324,7066008,7066017,7066157,7066158,8067933,8067934,8067935,8067936,8065824,8065825,10958950,10959104,10985232,10985233,10985234,10985235,10985236,10931197,8860327,8860328,8860360,8860361,8860362,8860398,8860400,8860448,8860449,10616988,10617064,10617072,10617135,10617145,10617146,10617154,10617158,10622268,10622272,10622360,10617449,10617450,10954017,10954018,10614968,10614997,10615011,10615014,10615024,10615037,10615062,10615077,10615078,10615079,10615083,10615085,10615090,10615092,10615097,10615098,10615099,10990672,10615135,10990673,10990674,10990675,10990676,10615202,10615269,10615313,10615334,10615462,10615463,10615464,10615467,10615470,10615516,10615540,10615545,10615556,10615624,10615720,10615723,10615724,10615725,10615726,10615727,10615728,10615729,10615730,10615731,10615732,10615733,10615734,10615735,10615736,10615737,10615738,10615739,10615740,10615741,10615742,10615743,10615744,10615745,10615746,10615747,10615748,10615749,10615750,10615751,10615752,10615753,10615754,10615755,10615756,10615757,10615758,10615759,10615760,10615761,10615762,10615763,10615765,10615766,10615767,10615769,10615770,10615771,10615772,10615773,10615774,10615775,10615776,10615777,10615778,10615779,10615780,10615781,10615782,10615783,10615784,10615785,10615786,10615787,10615788,10615789,10615790,10615791,10615792,10615793,10615794,10615795,10615796,10615797,10615798,10615799,10615800,10615801,10615802,10615803,10615804,10615805,10615806,10615807,10615808,10615809,10615810,10615811,10615812,10615813,10615814,10615821,10615898,10615914,10615941,10615947,10615990,10616036,10616089,10616092,10616548,10616576,10616783,10616810,10616811,10616842,10616881,10616888,10616890,10616891,10616913,10616932,10610965,10614048,10611179,10614220,10611226,10614282,10611338,10611339,10611367,10611368,10611369,10611370,10614376,10614377,10614414,10614443,10611449,10611514,10611517,10614518,10614572,10614588,10614592,10614629,10614632,10614641,10614642,10614643,10614644,10611703,10614729,10614739,10614749,10614752,10614753,10614765,10614766,10614767,10614772,10614773,10614774,10614775,10614776,10614777,10614778,10614779,10614780,10614781,10614782,10614783,10614784,10614785,10614786,10614787,10614788,10614789,10614790,10614791,10614792,10614793,10614794,10614795,10614796,10614797,10614798,10614799,10614800,10614801,10614802,10611802,10614803,10614804,10614805,10614806,10614807,10614808,10614809,10614810,10614811,10614812,10614813,10614814,10614815,10614816,10614817,10611819,10614821,10611823,10614840,10614846,10614847,10614857,10614858,10614859,10614860,10614861,10614862,10614863,10614864,10611878,10614887,10609034,10612051,10612069,10612140,10612141,10612142,10612143,10612144,10612145,10612146,10612147,10612148,10612149,10612150,10612151,10612152,10612153,10612154,10612155,10612156,10612157,10612163,10612164,10612165,10612166,10612167,10612168,10612169,10612170,10612191,10612234,10612235,10612236,10612237,10612238,10612248,10612253,10612254,10612255,10612256,10612257,10612260,10612265,10612266,10612268,10612344,10612345,10612346,10609392,10612407,10612408,10612409,10612410,10612411,10612412,10612414,10612424,10612426,10612427,10612428,10612429,10612430,10612483,10612484,10612485,10612486,10612487,10612488,10612489,10612490,10612491,10612492,10612493,10612496,10612497,10612498,10612499,10612501,10612505,10612506,10612513,10612516,10612517,10612518,10612519,10612520,10612521,10612522,10612523,10612524,10612525,10612526,10612527,10612528,10612529,10612530,10612532,10612535,10612539,10612542,10612546,10612547,10612551,10612552,10612553,10612554,10612556,10612557,10612558,10612562,10612565,10612566,10612567,10612568,10612570,10612571,10612573,10612575,10612577,10612578,10612583,10612584,10612585,10612586,10612587,10612588,10612589,10612592,10612596,10612597,10612599,10612601,10612604,10612608,10612609,10612611,10612618,10612619,10612620,10612623,10612625,10612626,10612637,10612639,10612641,10612644,10612645,10612647,10612648,10612651,10612652,10612655,10612657,10612660,10612663,10612664,10612666,10612667,10612668,10612673,10612675,10612677,10612678,10612679,10612680,10612682,10612683,10612684,10612685,10612688,10612689,10612690,10612697,10612698,10612699,10612700,10612701,10612702,10612703,10612704,10612705,10612706,10612707,10612711,10612713,10612714,10612715,10612717,10612718,10612720,10612721,10612722,10612723,10612737,10612742,10612743,10612744,10612745,10612746,10612747,10612748,10612749,10612750,10612751,10612752,10612753,10612755,10609772,10612791,10612792,10609815,10609818,10609819,10609826,10609828,10612833,10612834,10612836,10612837,10612838,10612839,10612841,10612842,10612843,10612844,10612846,10612850,10612852,10612853,10612856,10612862,10612863,10612865,10612866,10612867,10612868,10612869,10612870,10612871,10612872,10612873,10612874,10612875,10612876,10612877,10612878,10612879,10612881,10612884,10612886,10612888,10612898,10612914,10612915,10612938,10612939,10612943,10609981,10609994,10609999,10610002,10610003,10610005,10610006,10613023,10610025,10613027,10613031,10610044,10610053,10610054,10613066,10613083,10613119,10610174,10610178,10610180,10610181,10610182,10610189,10610191,10610271,10610279,10610285,10610299,10613335,10613342,10613349,10610372,10610396,10613503,10613567,10613576,10610703,10613719,10610724,10610780,10613804,10613805,10613806,10610872,10610941,7055490,9169327,9169334,9169336,9169348,9169349,9169350,9169358,9169359,9169361,9169362,7055532,9169377,9169378,9169396,9169453,7055669,9169534,9169637,9169639,9169656,9169748,10514102,10514103,9168308,9168309,9168322,10416256,10419257,10416262,10416263,10416265,10416266,10417284,10419291,10418296,10418298,10416305,10416306,10419307,10416307,10415312,10415313,10415314,10415318,10416321,10416322,10416323,10416324,10416325,10416326,10416327,10416328,10416329,10416330,9168428,9168429,9168430,9168431,10415377,10415387,10415388,10415389,10415390,10415391,10419398,10419399,10419403,10419409,10419410,10419411,10419412,10419413,10419414,10419415,10419416,10419417,10419418,10419419,10419420,10417424,10419427,10419428,10419429,10419430,10419431,10419432,10419433,10419434,10419435,10419436,10419446,10419447,10419448,10419449,10416457,10416498,10417642,10416691,10416692,10416693,10416694,10416695,10416696,10416697,10416774,10415782,10419797,9160928,10418864,10418865,10415887,10415888,10415889,10415896,10415897,10415898,10415929,10415944,10415945,10415946,10415947,10415948,10415949,10415950,10415951,10415952,10415953,10415954,10415955,10415956,10415957,10415958,10415959,10415960,10415961,10415962,10415963,10415964,10415965,10415966,10415967,10416967,10415968,10415969,10415970,10415971,10415972,10415973,10415974,10415975,10415976,10415977,10415978,10415979,10415980,10415981,10416043,10416045,10418048,10418122,10418123,10418124,10418125,10418126,10418127,10418128,10418129,10418130,10418131,10418132,10418133,10418134,10418135,10418136,10418137,10418138,10418139,10419181,10416182,10416183,10416184,10416185,10419186,10416186,10416187,10416188,10416189,10416190,10416191,10416192,10416193,10416194,10467104,10467409,10463432,10469672,10469673,10469674,10469675,10469676,10469677,10469679,10469680,10469681,10469695,10469696,10469697,10469698,10469699,10469700,10469701,10469702,10469703,10469704,10469705,10469706,10469707,10469708,10469709,10469710,10469711,10469712,10465712,10469713,10469714,10469715,10469716,10469717,10469718,10469719,10469720,10469721,10469722,10469723,10469724,10469725,10469726,10469727,10469728,10469729,10469730,10469731,10469732,10469733,10469734,10469735,10469736,10469737,10469738,10469739,10469740,10469741,10469742,10469743,10469744,10469745,10469746,10469747,10469748,10469749,10469750,10469751,10469752,10469753,10469754,10469755,10469756,10469757,10469758,10469759,10469760,10469761,10469762,10469763,10469764,10469765,10469766,10469767,10469768,10469769,10469770,10469771,10469772,10469773,10469774,10469775,10469776,10469777,10469778,10469779,10469780,10469781,10469782,10469783,10469784,10469785,10469786,10469787,10469788,10469789,10469790,10469791,10469792,10469793,10469794,10469795,10469796,10469797,10469798,10469799,10469800,10469801,10469802,10469803,10469804,10469805,10469806,10469807,10469808,10469809,10469810,10469811,10469812,10469813,10469814,10469815,10469816,10469817,10469818,10469819,10469820,10469821,10469822,10469823,10469824,10469825,10469826,10469827,10469828,10469829,10469830,10469831,10469832,10469833,10469834,10469835,10469836,10469837,10469838,10469839,10469840,10469841,10469842,10469843,10469844,10469845,10469846,10469847,10469848,10469849,10469850,10469851,10469852,10469858,10469903,10467937,10467938,10467939,10467940,10467941,10467942,10467943,10467944,10469946,10468175,10468176,10462287,10468459,10468460,10468461,10468462,10468463,10468464,10468465,10468466,10468467,10468468,10468469,10462516,10468518,10462729,10468753,10628155,10628156,10625241,10631455,10631456,10521879,10521880,10472555) 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'