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(10939634,10939635,7075947,10963006,10963007,10963008,10963009,10963010,10963011,10963012,10963013,7068364,10963072,8569416,4970852,10976310,10976311,10976312,10976313,10976314,10976315,10976316,10976317,10976318,10976319,10976320,10976321,10976322,10976323,10976324,10976325,10976326,4970992,4970993,10963342,10963343,10963344,10963345,10963346,8569639,10963347,10963348,8569640,8569641,7073988,7073989,7073990,7073991,7073992,8067088,8067213,8067287,8067371,7074366,7074369,7074370,8067469,8067470,8067554,10437436,4968872,4968873,4968874,8067636,4968923,4968924,7066598,10437568,10437570,10437572,10964350,7074697,7074698,7074699,7074700,7074701,7074702,7074703,7074704,7074705,7074706,7074707,7074708,7074709,7074710,7074711,7074712,7074713,7074714,7074737,7074738,8067809,10938499,7074849,7066886,10961598,7066969,7075008,7075009,10961899,10961900,10961901,10961902,10961903,10961904,10961905,10961906,10961907,10961908,10961909,10961910,10961911,10961912,10961913,10961914,10961915,10961916,10961917,10961918,10961919,10961920,10961921,10961922,10961923,10961924,10961925,10961926,10961927,8064886,8064888,6000105,6000106,6000107,6000108,6000117,6000118,7071869,6000170,7071978,6000293,6000294,6000295,6000296,6000297,6000298,7064040,7064090,10931638,10931639,10931642,7072459,7072483,7064486,7064487,7064488,7064489,4967141,4967142,4967143,10932261,10932262,8065917,10932339,8066022,10932417,10932418,10932419,10932420,10932421,7073196,7073199,7073225,7073281,10932734,10932742,10932748,10932786,10932787,10932788,10932791,10932794,7073385,7073386,7073387,7073388,7073389,7073390,10932984,7073640,10961402,10961403,8064011,10942775,8861258,8861324,7071532,6000042,6000071,8071670,8071671,8071672,8071673,3655553,3655554,8071734,8071735,8071736,8071737,8071738,8071799,8071800,8071801,8071802,8071803,8071864,8071865,8071866,8071867,8071868,8071929,8071930,8071931,8071932,8071933,3655772,3655773,3655774,3655775,3655776,8071994,8071995,8071996,8071997,8071998,8072059,8072060,8072061,8072062,8072063,8072124,8072125,8072126,8072127,8072128,8072189,8072190,8072191,8072192,8072193,10944861,8072254,8072255,8072256,8072257,8072258,8072357,8072363,8072369,8072375,8072379,8072384,8072385,8072386,8072390,8072397,8072401,8072405,8072406,8072407,8072413,8072417,8072423,8072429,8072430,8072431,8072433,8072435,8072438,8072443,8072448,8072455,8859504,8072470,8072471,8072597,8072607,8072630,8072640,8072713,8072714,8072715,8072716,8072717,8072853,8072854,8072855,8072856,8072857,8072858,8072859,8072860,8073077,10958011,8860519,10942527,10622972,10618017,10618024,10618025,10618026,10618027,10918615,10918616,10918618,10618146,10618147,10618148,10618149,10618150,10618151,10618152,10618153,10618154,10618155,10618156,10618157,10618158,10618159,10618160,10618161,10618320,10623326,10623420,10618578,10618579,10955118,10618580,10618581,10618582,10618583,10618584,10618585,10618586,10618891,10618892,10618893,10618894,10618895,10618896,10618897,10919919,8071139,8071140,8071141,8071187,8071291,8071303,10920163,8071388,8071389,8071390,8071416,8071417,8071418,8071443,8071444,8071445,8071466,8071467,8071468,8071536,8071537,8071538,8071539,8071540,8071604,8071605,8071606,8071607,8071608,8071669,10922499,10922502,10922503,10922504,10922506,10922507,10922508,10922509,10922510,10922516,10922517,10927571,10922893,10922894,10922895,10922896,10922897,10922898,10922899,10922900,10917961,10917962,10917963,10954117,10954147,10954148,10954149,10954150,10954151,10954152,10954153,10928149,10954178,10954179,10954180,10954181,10954182,10954183,10954184,10954185,10954186,10954187,10614972,10920691,8570024,8570025,8570026,10615219,10615220,10615225,10615226,10615227,10615228,8570175,10915858,10915859,10915860,10915861,10915862,10915863,10915864,10915865,10915866,10915867,10915868,10915869,10915870,10915871,10915872,10915873,10915874,8570200,8570201,8570203,10615516,10930643,10930644,10930645,10930646,10930873,10930913,10930951,10921904,10921905,10921906,10921907,10921908,10921909,10921910,10921911,10917164,10917165,10917166,10917167,10917168,10917169,10917170,10917171,10922220,10922221,10922222,10922225,10922226,10922227,10922228,10922229,10922230,10922231,10922232,10922236,10922237,10922238,10922239,10922240,10922241,10922242,10922251,10922254,10922255,8863833,10565144,10559335,10614230,10614384,10614385,6665732,10614401,6665799,6665800,10614635,10559788,10559789,8864620,8864669,10614842,8864728,8864729,8864730,8861867,8862128,8862129,10609330,10612516,10612527,10612579,10612580,10563791,10563792,10563793,10612643,10563794,10563795,10563796,10563797,10563798,10563799,10563800,10563801,10563802,10563803,10563804,10563805,10563806,10563807,10563808,10563809,10563810,10563811,10563812,10563813,10563814,10563815,10563816,10563817,10563818,10563819,10563820,10563821,10563822,10563823,10563824,10563825,10563826,10563827,10563828,10563829,10563830,10563831,10563832,10563833,10563834,10563835,10563836,10563837,10563838,10563839,10563840,10563841,10563842,10563843,10563844,10563845,10563846,10563847,10563848,10563849,10563850,10563851,10563852,10563853,10563854,10563855,10563856,10563857,10563858,10563859,10563860,10563861,10563862,10563863,10563864,10563865,10563866,10563867,10563868,10563869,10563870,10563871,10563872,10563873,10563874,10563875,10563876,10563877,10563878,10563879,10563880,10563881,10612731,10563882,10612732,10563883,10563884,10563885,10563886,10563887,10563888,10563889,10563890,10563891,10563892,10563893,10563894,10563895,10563896,10563897,10563898,10563899,10563900,10563901,10563902,10563903,10563904,10563905,10563906,10563907,10563908,10563909,10563910,10563911,10563912,10563913,10563914,10563915,10563916,10563917,10563918,10563919,10563920,10563921,10563922,8862672,8862792,8862842,10613037,10613038,10561223,10561224,10561225,10561226,10561227,10561228,10561229,10561230,10561231,10561232,10561233,10561234,10561235,10561236,10561237,10561238,10561239,10561240,10561241,10561242,10561243,10561244,10561245,10561246,10561247,10561248,10561249,10561250,10561251,10561252,10561253,10561254,10561255,10561256,10561257,10561258,10561259,10561260,10561261,10561262,10561263,10561264,10561265,10561266,10561267,10561268,10561269,10561270,10561271,10561272,10561273,10561274,10561275,10561276,10561277,10561278,10561279,10561280,10561281,10561282,10561283,10561284,10561285,10561286,10561287,10561288,10561289,10561290,10561291,10561292,10561293,10561294,10561295,10561296,10561297,10561298,10561299,10561300,10561301,10561302,10561303,10561304,10561305,10561306,10558409,10561527,10561528,10561529,10561530,10558879,10558880,10558881,10558882,10558883,10558884,10558885,10558886,10558887,10558888,10558889,10558890,10558891,10558892,10558893,10558894,10558895,10558896,10558897,10558898,10558899,10558900,10558901,10558902,10558903,10558904,10558905,10558906,10558907,10558908,10558909,10558910,10558911,10558912,10558913,10558914,10558915,10558916,10558917,10558918,10558919,10558920,10558921,10558922,10558923,10558924,10558925,10558926,10558927,10558928,10558929,10558930,10558931,10558932,10558933,10558934,10610823,10564994,10513217,10513218,4974479,4974667,4974669,4974748,4974749,4974750,10513826,10514017,10516235,10516236,10516237,10516376,10516627,10516628,10516629,10516630,10516631,10516632,10512751,10512752,10512781,2809651,8861571,8861572,10415597,4973594,10419675,10419704,4973868,4973869,4973870,4973871,4973872,10420065,4974126,4974127,4974128,4974129,4974130,4974131,4974132,4974133,4974134,10469746,10469825,10463836,10463837,10463838,10463839,8563203,10470724,10462739,10628105,10628220,10628862,10628863,10628864,10628866,10628867,10628868,10628869,10628870,10629513,10629514,10629515,10629516,10627349,10627350,10627351,10627570,10627577,10627578,10625147,10625148,10625149,10625150,10626732,10626739,10626740,10626741,10626742,10566123,10566124,10566381,10566382,10566383,10566384,10566385,10566386,10566387,10566388,10566389,10566390,10566391,10566392,10566393,10566394,10566395,10566396,10566397,10566398,10566399,10566400,10566401,10566402,10566403,10566404,10566405,10566536,10566537,10566538,10566539,10566540,10566541,10566542,10566543,10566544,10566545,10566546,10566547,10566548,10566549,10566550,10566551,10566552,10566553,10566554,10566555,10566599,10566600,10566601,10566602,10566603,10566604,10566605,10566606,10566607,10566608,10566609,10566610,10566611,10567377,10567378,10567379,10567380,10567381,10567382,10567383,10567483,10567484,10567485,10567486,10567487,10567488,10567489,10567490,10567491,10567492,10567493,10567494,10567495,10519544,10519545,10519546,10519547,10519548,10420343,10420394,10472975,10473121,10473122,10473123,10473124,10473125,10473126,10473613,10473614,10473615,10473616,10473630,10473631,10473695,10473696,10473834) 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'