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(10962693,10962694,7076124,7076126,7076127,10943628,8569453,4970721,4970722,4970723,4970738,8569625,10963750,7066105,7066106,7066107,7066108,7066109,7066110,7066111,7066178,7066265,8067255,8067256,8067257,7066344,7066348,8067396,10964441,10964442,10964443,10964444,10964445,10964446,10964447,10964448,10964449,10964450,7066825,8067927,8067931,8067942,7067196,10938832,10961933,10962009,10962010,10962442,10962443,10962444,10962455,10939439,10962578,7075912,10960062,10960174,8065506,8075333,8075334,8075335,8075336,10960404,10960411,10960412,10960413,7064761,8065807,10960526,10960527,10960528,10960529,10960530,10960531,10960532,10960533,10960534,10960535,10960536,10960537,10960538,10960539,10960540,10960541,10960542,10960543,10960544,10960545,10960546,8065841,8065842,7064911,10960604,10960605,10960606,7064985,7064986,10960851,10960858,7065457,10961222,7065694,7065695,7065832,7065837,11049004,10958953,10958954,10942913,10958987,10958988,10958989,11049264,8064474,8064475,8064476,7071523,7071524,7071537,10943257,8970239,10944447,10944645,10944646,3655849,3655890,3656988,7070473,10942147,11048460,11048461,11048462,10942401,10942410,10623063,10623064,10623065,10618183,10623481,10623482,10623490,10623810,10619835,10619836,10619863,10619864,10619865,10619866,10619885,10619886,10619889,10619891,10619892,10619895,10619896,10619901,10619902,10617126,10617138,10617139,10617140,10622257,10622258,10622264,10622265,10622266,10622267,10622268,10617322,10617323,10617324,10617327,10617343,10954002,10954003,10954004,10617346,10622360,10622365,10622402,10622405,10622408,10617426,10617427,10622428,10622431,10622445,10622447,10617448,10617450,10617455,10617456,10622460,10622514,10622516,10622523,10617573,10954310,10954313,10617793,10614969,8570011,8570020,8570104,10615167,10620186,10620187,10620188,10620189,10620190,10620191,10620192,10620193,10620194,10620195,10620196,10620197,8570148,10620198,10620199,10620200,10620201,10620202,10620207,10620208,10615222,10615229,10620298,10620303,10615334,10615338,10615339,10615340,10615341,10615342,10615343,10615344,10615363,10615389,10926086,10926087,10926113,10926176,10615711,10926285,10615780,10930731,10930732,10930733,10930734,10930735,10930736,10930737,10930738,10930752,10930754,10930755,10930776,10930777,10615896,10615938,10616005,10621034,10616044,10616045,10616059,10616476,10616479,10953318,10616888,10616898,10613962,10613963,10613964,10613965,10610965,10613966,10613967,10613968,10613969,10613970,10613971,10613972,10613973,10613974,10613975,10613976,10613977,10613978,10613979,10613980,10613981,10613982,10613983,10613984,10610984,10613985,10610985,10613986,10613987,10613988,10613989,10613990,10613991,10613992,10613993,10613994,10613995,10613996,10613997,10613998,10613999,10614000,10614001,10614002,10614003,10614004,10614005,10614006,10614007,10614008,10614009,10614010,10614011,10614012,10614013,10614014,10614015,10614016,10614017,10614018,10614019,10614020,10614021,10614022,10614023,10614024,10614025,10614026,10614027,10614028,10614029,10614030,10614031,10614032,10614033,10614034,10614035,10614036,10614037,10614038,10614039,10614040,10614041,10614042,10614043,10614044,10614045,10614046,10614047,10614048,10614049,10614050,10614051,10614052,10614053,10614054,10614055,10614056,10614057,10614064,10559321,10565349,10614203,10614220,10614260,10614261,10614262,10614263,10614264,10614269,10614376,10614415,10614416,10559609,8864323,8864327,10614495,10614496,10614497,10614498,10614499,10614500,10614501,10614502,10614503,10614504,10614505,10559701,10559705,10559706,10559709,10562767,10611646,10611655,10611789,10611856,10611954,10611957,10611969,10612104,10612105,10612106,10612107,10612135,10612136,10612137,10609155,10609285,10612291,10612294,10609307,10609313,10609369,10612381,8862672,10609844,10612916,10612936,10561087,10612937,10561088,10612938,10561089,10612939,10561090,10561091,10612941,10561092,10612942,10561093,10612943,10612961,10609971,10610015,10610030,10613127,10613135,10613136,10613137,10558303,10558304,10558317,10558318,10558319,10558320,10613172,10610347,10613350,10613369,10613391,10613392,10613393,10613394,10613434,10613435,10613483,10613501,10613504,10613505,10613506,10613513,10613514,10613515,10613523,10613527,10613528,10613529,10613545,10610697,10610709,10610729,10610730,10613732,10564883,10613733,10613736,10613738,10610739,10613811,10613812,10613813,10613814,10613815,10613816,10613817,10613818,10613819,10613820,10613821,10613822,10613823,10613824,10613825,10613826,10613827,10613828,10613829,10613830,10613831,10613832,10613833,10613834,10613835,10613836,10613837,10613838,10613839,10613840,10613841,10613842,10613843,10613844,10613845,10613846,10613847,10613848,10613849,10613850,10613851,10613852,10613853,10613854,10613855,10613856,10613857,10613858,10613859,10613860,10613861,10613862,10613863,10613864,10613865,10613866,10613867,10613868,10613869,10613870,10613871,10613872,10613873,10613874,10610874,10613875,10613876,10613877,10613878,10613879,10613880,10613881,10613882,10613883,10613884,10613885,10613886,10613887,10613888,10613889,10613890,10613891,10613892,10613893,10613894,10613895,10613896,10613897,10613898,10613899,10613900,10613901,10613902,10613903,10613904,10613905,10613906,10613907,10613908,10613909,10613910,10613911,10613912,10613913,10613914,10613915,10613916,10613917,10613918,10613919,8863778,10613920,10613921,10613922,10613923,10613924,10613925,10613926,10613927,10613928,10613929,10613930,10613931,10613932,10613933,10613934,10613935,10613936,10613937,10613938,10613939,10613940,10613941,10613942,10613943,10613944,10613945,10613946,10613947,10610947,10613948,10613949,10613950,10613951,10613952,10613953,10610954,10613954,10613955,10613956,10613957,10613958,10613959,10613960,10613961,10517202,10517203,10517204,10517205,10517206,10517207,10517208,10517209,10517210,10517211,10517212,10517213,10517214,10517215,10517216,10517217,10517218,10517219,10517222,10517223,10517224,10515309,10515377,10513407,10515422,10515423,10515683,10515684,10515685,10515686,10515687,10515688,10515689,10515690,10515691,10515692,10515693,10515694,10515695,10515696,10515697,10515698,10515699,10515700,10515701,10515702,10515703,10515704,10515705,10515706,10515707,10515708,10515709,10515710,10515711,10513728,10513729,10513952,10513961,10513975,10513994,10513997,10513998,10513999,10514017,10514023,10514028,10514031,10514032,10514033,10514037,10514038,10516193,4975242,4975243,10514407,10512530,10516789,10516928,10515087,10515088,10515089,10515090,10515091,10515092,10515093,10515094,10515095,10515096,10515097,10415325,10415366,10415367,10415368,10415369,10415370,10415371,10415372,10415373,10415374,10415375,10415376,4973308,10415392,10415393,10415394,4973399,4973400,10419469,4973401,10419470,4973402,4973403,4973404,4973405,4973406,4973407,4973408,4973409,4973410,10416481,10419493,10419494,10419495,10419496,10419499,10419500,10419501,10419502,10419503,10419504,10419505,10419506,10419507,10419508,10419509,10419510,10419511,10419512,10419513,10419514,10419515,10419516,10419517,10419518,10419519,10419520,10419521,10419522,10419523,10419524,10419525,10419526,10419527,10419528,10419529,10419530,10419531,10419532,10419533,10419534,10419535,10419536,10419537,10419538,10415586,10415614,10417633,4973643,10417079,10417080,10417081,10417082,10417083,10417084,10417085,10417086,10417087,10417088,10417089,10417090,10417091,10417092,10417093,10417094,10417095,10417096,10417097,10417098,10417099,10417100,10417101,10417102,10417103,10417104,10417105,10417106,10417107,10417108,10417109,10417110,10417111,10417112,10417113,10417114,10417115,10417116,10417117,10417118,10417119,10417120,10417121,10417122,10417123,10417124,10417125,10417126,10417127,10417128,10417129,10417130,10417131,10417132,10417133,10417134,10417135,10417136,10417137,10417138,10417139,10417140,10417141,10417142,10417143,10417144,10417145,10417146,10417147,10417148,10417149,10417150,10417151,10417152,10417153,10417154,10417155,10417156,10417157,10417158,10417159,10417160,10463181,10463182,10463183,10469337,10469338,10469339,10469340,10469341,10469342,10469343,10469344,10469345,10469346,10469347,10469348,10469349,10469350,10469351,10469352,10469353,10469354,10469355,10469356,10469357,10469358,10469359,10469360,10469361,10469362,10469363,10469364,10469365,10469366,10469367,10469368,10469369,10469370,10469371,10469372,10469373,10469374,10469375,10469376,10469377,10469378,10469379,10469380,10469381,10469382,10469383,10469384,10469573,4972257,4972480,10468237,4972613,10628177,10626963,10627145,10627319,10627630,10627710,10627771,10627775,10626143,10626144,10626145,10626298,10626299,10626300,10626301,10626375,10626378,10626379,10626429,10626430,10626431,10626724,10626725,10626878,10626879,10626880,10626881,10626882,10626883,10626884,10626885,10626886,10626887,10626888,10626889,10626890,10626891,10626892,10626893,10626894,10626895,10626896,10626897,10626898,10626899,10626900,10626901,10626902,10626906,10626907) 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'