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(8569558,7065943,7065968,7065981,7065982,7065983,7065984,7065985,7065986,7065987,7065988,7065989,7065990,7066008,7066125,7066144,7066145,7066146,7066165,7066166,7066167,7066168,7066169,7066170,7066171,7066237,7066238,7066239,7066267,8067903,8067938,8067939,10939406,10939407,10939441,10939442,8065817,8065847,3656825,3656826,3656829,3656830,3656831,3656832,8860427,8860428,8860429,8860430,8860431,8860433,8860434,10618320,10623502,8070774,8070775,10616984,10617016,10617048,10617049,10617050,10617058,10617059,10617060,10617210,10617211,10617212,10614970,10620119,10620120,10615249,10615250,10615251,10615252,10615253,10615254,10615255,10615256,10615257,10615258,10615259,10615372,10615376,10615411,10615496,10615497,10615498,10615534,10615536,10615538,10615540,10615547,10615598,10615600,10615602,10615608,10615611,10615612,10615613,10615616,10615617,10615619,10615634,10615637,10615644,10615650,10615651,10615655,10615657,10615664,10615669,10615680,10615882,10616023,10616196,10616197,10616198,10616199,10616200,10616201,10616202,10616203,10616204,10616205,10616206,10616207,10616208,10616209,10616210,10616211,10616212,10616213,10616214,10616215,10616216,10616217,10616218,10616219,10616220,10616221,10616222,10616223,10616224,10616225,10616226,10616227,10616228,10616229,10616230,10616231,10616232,10616233,10616234,10616235,10616236,10616237,10616238,10616239,10616240,10616241,10616242,10616243,10616244,10616245,10616246,10616247,10616248,10616249,10616250,10616251,10616252,10616253,10616254,10616255,10616256,10616257,10616258,10616259,10616260,10616261,10616262,10616263,10616264,10616265,10616266,10616267,10616268,10616269,10616270,10616271,10616272,10616273,10616274,10616275,10616276,10616277,10616278,10616279,10616280,10616281,10616282,10616283,10616284,10616285,10616286,10616287,10616288,10616289,10616290,10616291,10616292,10616293,10616294,10616295,10616296,10616297,10616298,10616299,10616300,10616301,10616302,10616303,10616304,10616305,10616306,10616307,10621651,10621657,10621672,10621673,10621682,10621687,10621705,10614022,10614023,10614047,10614088,10611127,10611128,10611129,10611130,10611131,10611132,10611133,10611134,10611164,10614212,10614220,10611359,10611360,10611361,10611362,10611363,10611364,10611365,10611366,10611367,10611368,10611369,10611370,10611371,10611372,10611373,10611374,10611375,10611376,10611377,10611378,10611379,10611380,10611381,10611382,10611383,10611384,10611385,10611386,10611387,10611388,10611389,10611390,10611391,10611392,10611393,10611394,10611395,10611396,10611397,10611398,10611399,10611400,10611401,10611402,10611403,10611404,10611405,10611406,10611407,10611408,10611409,10611410,10611411,10611412,10611413,10611414,10611415,10611416,10611417,10611418,10611419,10611420,10611421,10611422,10611423,10611424,10611425,10611426,10611427,10611428,10611429,10611430,10611431,10611432,10611433,10611434,10611435,10611436,10611437,10611438,10611439,10611440,10611441,10611442,10611443,10611444,10611445,10611446,10611447,10611448,10611449,10611450,10611451,10611452,10611453,10611454,10611455,10611456,10611457,10611458,10611459,10611460,10611461,10611462,10611463,10611464,10611465,10611466,10611467,10611468,10611469,10611470,10611471,10611472,10611473,10611474,10611475,10611476,10611477,10611478,10611479,10611480,10559631,10611481,10611482,10611483,10611484,10611485,10611486,10611487,10611488,10611489,10611490,10611491,10611492,10611493,10611494,10611495,10611496,10611497,10611498,10611499,10611500,10611501,10611502,10614502,10611503,10611504,10611505,10611506,10611507,10611508,10614508,10611509,10611510,10611511,10611512,10611513,10611514,10611515,10611516,10611517,10611518,10611519,10611520,10611521,10611522,10611523,10611524,10611525,10611526,10611527,10611528,10611529,10611530,10611531,10611532,10611533,10611534,10611535,10611536,10611537,10611538,10611539,10614540,10611540,10614541,10611541,10614542,10611542,10614543,10611543,10614544,10611544,10614545,10611545,10614546,10611546,10614547,10611547,10611548,10611549,10611550,10611551,10611552,10611553,10611554,10611555,10611556,10611557,10611558,10611559,10611560,10611561,10611562,10611563,10611564,10611565,10611566,10611567,10611568,10611569,10611570,10611571,10611572,10611573,10611574,10611575,10611576,10611577,10611578,10611579,10611580,10611581,10611582,10611583,10611584,10611585,10611586,10611587,10611588,10611589,10611590,10611591,10611592,10611593,10611594,10611595,10611596,10611597,10611598,10611599,10611600,10611601,10611602,10611603,10611604,10611605,10611606,10611607,10611608,10611609,10611610,10611611,10611612,10611613,10611614,10611615,10559766,10611616,10611617,10611618,10611619,10611620,10611621,10611622,10611623,10611624,10611625,10611626,10611627,10611628,10611629,10611630,10611631,10611632,10611633,10611634,10611635,10611636,10611637,10611638,10611639,10611640,10611641,10611642,10611643,10611644,10611645,10611646,10611647,10611648,10611649,10611650,10611651,10611652,10611653,10611654,10611655,10611656,10611657,10611658,10611659,10611660,10611661,10614661,10611662,10611663,10611664,10611665,10611666,10611667,10611668,10611669,10611670,10611671,10611672,10611673,10611674,10611675,10611676,10611677,10611678,10611679,10611680,10611681,10611682,10611683,10611684,10611685,10611686,10611687,10611688,10611689,10611690,10611691,10611692,10611693,10611694,10611695,10611696,10614696,10611697,10611698,10611699,10611700,10611701,10611702,10614702,10611703,10611704,10611705,10611706,10611707,10611708,10611709,10611710,10611711,10614711,10611712,10611713,10614713,10611714,10614714,10611715,10611716,10611717,10611718,10611719,10611720,10611721,10611722,10611723,10611724,10611725,10611726,10611727,10611728,10611729,10611730,10611731,10611732,10611733,10611734,10611735,10614735,10611736,10614736,10611737,10611738,10611739,10611740,10611741,10611742,10611743,10611744,10611745,10611746,10611747,10611748,10611749,10611750,10611751,10611752,10611753,10611754,10611755,10611756,10611757,10611758,10611759,10611760,10611761,10611762,10611763,10611764,10611765,10611766,10611767,10611768,10611769,10611770,10611771,10611772,10611773,10611774,10611775,10611776,10611777,10611778,10611779,10611780,10611781,10611782,10611812,10611813,10611819,10614828,10614829,10614830,10614831,10614832,10614833,10614834,10614835,10614836,10614837,10614838,10614839,10614840,10614841,10614842,10614843,10614844,10614845,10614846,10614847,10614848,10614849,10614850,10614851,10614852,10614853,10614854,10614922,10614925,10566080,10566081,10566082,10566083,10614957,10612039,10612041,10612042,10612045,10612051,10612059,10612060,10612079,10612171,10612172,10612173,10612174,10612175,10612176,10612177,10612178,10612179,10612180,10612181,10612182,10612183,10612184,10612185,10612186,10612187,10612188,10612264,10609315,10612320,10612321,10609387,10612480,10609709,10612746,10612747,10612750,10612752,10612754,10612783,10612785,10612786,10612788,10612790,10612791,10612792,10612793,10612794,10612796,10612884,10612916,10612933,10609966,10609981,10609995,10609996,10609997,10609998,10613024,10613025,10613026,10610046,10610068,10610115,10610167,10610168,10610229,10610236,10610251,10610267,10613328,10613329,10613330,10613331,10613332,10613333,10613334,10613335,10613336,10613337,10613338,10613339,10613340,10613341,10613342,10613343,10613344,10613345,10610396,10610397,10610420,10610497,10613527,10613654,10610666,10613732,10613733,10613743,10613744,10613781,10613782,10613783,10610789,10610792,10610793,10610794,10513342,10513343,10513988,10512852,10417271,10415321,10419332,10419371,10419372,10419377,10417429,10417430,10417431,10417432,10417433,10417434,10417435,10417436,10417437,10417438,10417439,10417440,10417441,10417442,10417486,10417493,10415499,10415505,10415512,10419522,10419523,10416569,10416570,10416571,10416572,10416573,10416574,10416575,10416576,10416577,10416578,10416579,10416580,10416581,10416582,10416583,10416584,10416585,10416586,10416587,10416588,10416589,10416590,10416591,10416592,10416593,10416594,10416595,10416596,10416597,10415597,10416598,10415598,10416599,10415599,10416600,10415600,10416601,10415601,10416602,10415602,10416603,10415603,10416604,10416605,10416606,10416607,10416608,10416610,10416611,10416612,10416613,10416617,10416640,10416641,10416649,10416650,10416651,10416652,10416653,10416654,10416655,10416656,10416658,10416659,10416660,10416661,10416662,10415664,10416673,10415673,10416674,10419794,10419795,10419796,10419797,10419798,10419799,10419800,10419801,10418042,10416043,10416044,10416045,10416046,10416047,10416048,10416049,10416050,10416051,10416052,10416053,10416054,10416055,10416056,10416057,10416058,10416059,10416060,10470999,10471000,10471001,10471002,10471003,10471004,10471005,10471006,10471007,10471008,10471009,10471010,10471011,10471012,10471013,10471014,10471015,10471016,10471017,10471018,10471019,10471020,10471021,10471022,10471023,10471024,10471025,10471026,10471170,10469927,10469928,10470089,10470092,10470093,10470094,10470095,10470096,10470697) 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'