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(7075947,7068364,8569416,4970852,4970992,4970993,8569639,8569640,8569641,10199089,10199090,10199091,10199092,10199093,10199094,10199095,10199096,10199156,7073988,7073989,7073990,7073991,7073992,10199405,10199406,10199407,10199408,10199409,10199410,10199411,7074366,7074369,7074370,10437436,10212768,10212769,10212770,10212771,10212772,10212773,4968872,10212774,10212775,4968873,4968874,10212776,10212777,10212778,10212779,10212780,10212781,10212782,10212783,10212784,4968923,4968924,7066598,10437568,10437570,10437572,7074697,7074698,7074699,7074700,7074701,7074702,7074703,7074704,7074705,7074706,7074707,7074708,7074709,7074710,7074711,7074712,7074713,7074714,7074737,7074738,7074849,7066886,7066969,7075008,7075009,10197446,10197447,10197613,10197893,10197894,10197895,10197896,10197897,10197898,10197899,10197900,10197901,10197902,10197903,10197904,10197905,10197906,10197907,10197908,10197909,10197910,10197911,10197912,10197913,10197914,10197915,10197916,10197917,10197918,10197919,10197920,10197921,10197922,10197923,10197924,10197925,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,10932339,10932417,10932418,10932419,10932420,10932421,10196390,7073196,7073199,7073225,7073281,10932734,10932742,10932748,10932786,10932787,10932788,10932791,10932794,7073385,7073386,7073387,7073388,7073389,7073390,10932984,7073640,10942775,8861258,10207640,8861324,7071532,6000042,6000071,8071734,8071735,8071736,8071737,8071738,8071799,8071800,8071801,8071802,8071803,8071864,8071865,8071866,8071867,8071868,8071929,8071930,8071931,8071932,8071933,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,8859504,8072455,8072470,8072471,8072597,8072607,8072630,8072640,8072713,8072714,8072715,8072716,8072717,8072853,8072854,8072855,8072856,8072857,8072858,8072859,8072860,8073077,8860519,10193880,10942527,10622972,10190073,10190074,10190075,10190076,10190077,10190078,10190079,10190080,10190081,10190082,10618017,10618024,10618025,10618026,10618027,10618146,10618147,10618148,10618149,10618150,10618151,10618152,10618153,10618154,10618155,10618156,10618157,10618158,10618159,10618160,10618161,10618320,10623326,10623420,10618578,10618579,10618580,10618581,10618582,10618583,10618584,10618585,10618586,10618891,10618892,10618893,10618894,10618895,10618896,10618897,10191046,8071139,8071140,8071141,8071187,8071291,8071303,8071388,8071389,8071390,8071416,8071417,8071418,8071443,8071444,8071445,8071466,8071467,8071468,8071536,8071537,8071538,8071539,8071540,8071604,8071605,8071606,8071607,8071608,8071669,8071670,8071671,8071672,8071673,10922499,10922502,10922503,10922504,10922506,10922507,10922508,10922509,10922510,10922516,10922517,10927571,10922893,10922894,10922895,10922896,10922897,10922898,10922899,10922900,10928149,10190021,10190052,10190053,10190054,10190055,10190056,10190057,10190058,10614972,10920691,8570024,8570025,8570026,10615219,10615220,10615225,10615226,10615227,10615228,8570175,8570200,8570201,8570203,10200511,10615516,10930643,10930644,10930645,10930646,10930873,10930913,10930951,10921904,10921905,10921906,10921907,10921908,10921909,10921910,10921911,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,6665803,10614635,10559788,10559789,8864620,8864669,10614842,8864728,8864729,8864730,6666263,6666296,6666297,8861867,8862128,8862129,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,7058267,10563908,10563909,10563910,10563911,10563912,10563913,10563914,10563915,10563916,10563917,10563918,10563919,10563920,10563921,10563922,8862672,8862792,8862842,10613037,10613038,7058563,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,7058677,10558409,7058825,7058827,10561527,10561528,10561529,10561530,7058901,7058902,7058903,7058904,7058905,7058906,7058907,7058908,7058931,7058932,7058933,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,10564994,10513217,10513218,7055670,7055782,7055783,4974479,7055896,4974667,4974669,4974748,4974749,4974750,10513826,10514017,10516235,10516236,10516237,10516376,10516627,10516628,10516629,10516630,10516631,10516632,10512751,10512752,10512781,7057176,2809651,8861571,8861572,7057292,7057293,7057294,7057295,7057296,7057297,7057298,7057299,7057300,7057301,7057302,7057303,8918241,4973594,10419675,7054928,10419704,4973868,4973869,4973870,4973871,4973872,10420065,4974126,4974127,4974128,4974129,4974130,4974131,4974132,4974133,4974134,8916398,10469746,8916858,8916864,8916865,8916866,10469825,8917515,8917519,8917563,10470724,8917818,8917858,10628105,10628220,10628862,10628863,10628864,10628866,10628867,10628868,10628869,10628870,10155639,10629513,10629514,10629515,10629516,10627349,10627350,10627351,10627570,10627577,10627578,10630058,10630102,10625147,10625148,10625149,10625150,10626732,10626739,10626740,10626741,10626742,10571370,10571371,10571372,10571373,10571374,10571375,10571376,10571377,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'