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(10939560,10939570,10939580,10939586,10939595,10939626,10939627,10939628,10939636,10939652,10939745,10939905,10939906,10939907,10939908,10939909,4970650,4970666,4970667,4970668,4970669,4970672,10940098,10940099,4970745,4970753,10940153,10940155,4970783,10940168,10940170,10940173,10940174,10940176,10940177,10940178,10940179,10940181,10940182,10940183,10940184,10940185,10940192,10940195,10940196,4970916,4970917,4970918,4970919,4970920,4970921,4970922,4970923,4970924,4970925,4970926,4970927,4970928,4970929,4971043,4971044,4971045,4971061,4971062,4971077,4971078,4971079,4971080,4971084,4971126,8066888,8066889,8066890,8066896,8066909,8066918,4968208,4968209,4968210,4968220,4968226,4968227,4968230,4968231,8067002,8067003,4968316,4968317,4968324,4968325,4968326,4968335,4968410,4968411,8067162,8067163,8067164,8067165,8067166,8067167,8067168,8067185,8067216,8067233,8067259,8067275,8067276,8067277,8067278,8067279,8067280,8067281,8067312,8067339,4968608,4968609,4968610,4968611,4968612,8067345,4968616,8067359,4968646,4968655,4968656,4968657,4968658,4968659,4968660,8067414,8067415,8067476,8067493,8067541,4968847,8067648,8067652,8067677,8067685,8067686,8067687,8067695,8067709,8067752,4969362,4969363,4969569,4969570,10939186,10939187,10939439,8075220,8075221,8075222,8075316,8075317,8075318,8075319,8065796,8065916,8065965,8065984,8066082,8066119,8066165,8066180,8066181,8066247,8066394,8066395,8066396,8066397,8066417,8066418,8066419,8066420,8066582,8066603,8066604,8066605,8066655,8066676,8066739,8066766,8066808,8066809,8066810,8066811,8066829,8066845,8066846,8066859,8066860,8066879,8064652,8064692,8074499,8074500,8074501,8074502,8074503,8074504,8074505,8074506,8074507,8074508,8074509,8074510,8074511,8074512,8074513,8074514,8074515,8074516,8074517,8074518,8074519,8074520,8074521,8074522,8074523,8074524,8074525,8074526,8074527,8074528,8074529,8074530,8074531,8074532,8074533,8074534,8074535,8074536,8074537,8074538,8074539,8074540,8074541,8074542,8074543,8064759,8074544,8074545,8074546,8074547,8074548,8074549,8074550,8074551,8074552,8074553,8074554,8074555,8074556,8074557,8074558,8074559,8074560,8074561,8074562,8074563,8074564,8074565,8074566,8074567,8074568,8074569,8074570,8074571,8074572,8074573,8074574,8074575,8074576,8074577,8074578,8074579,8074580,8074581,8074582,8074583,8074584,8074585,8074586,8074587,8074588,8074589,8074590,8074591,8074592,8074593,8074594,8074595,3655558,3655559,3655560,3655626,8072312,8072373,8072374,8072383,8072384,8072427,8072434,8072435,8072436,8072437,8072447,8072451,8072459,8072460,8072461,8072462,8072465,8072466,8072469,3656338,3656339,3656340,3656341,8072527,3656410,3656411,3656412,3656443,3656453,3656596,8072763,8072764,8072765,8072766,8072767,3656624,3656625,3656626,3656643,3656713,3656714,3656715,8072885,8072886,8072887,8072888,8072889,8072890,8072891,8072892,8072893,8072894,8072895,8072896,8072897,8072898,8072899,8072900,8073000,8073005,3656888,3656897,3656898,3656911,3656913,3656915,3656917,3656918,3656984,3656985,3656986,3656987,3657001,3657002,8073542,8073552,10623042,10623045,10918558,10918559,10918619,10918643,10918676,10918677,10623191,10623192,10623193,10623194,10623195,10623196,10623197,10623249,10623250,10623251,10623252,10623304,10623307,10623344,10623438,10919037,10919038,10919039,10919040,10919041,10919042,10919043,10919361,10919362,10919706,10919707,10919708,10919882,10920258,10920259,10920260,10920261,10920262,10920263,10920264,10920265,10920266,10920267,10920268,10920269,10920270,10920271,10920272,10920273,10920274,10920275,10920276,10920277,10920278,10920279,10917568,10917569,10917570,10917571,10917572,10917573,10917574,10917575,10917791,10917792,10917793,10917794,10917795,10917796,10917797,10917798,10917799,10622404,10622432,10622433,10622434,10622435,10622436,10622437,10622438,10622439,10622440,10622441,10622442,10622443,10622444,10622445,10622446,10917966,10917967,10917968,10917969,10917970,10917971,10917972,10917973,10918066,10918067,10918068,10918069,10918212,10918409,10918410,10918411,10622918,10622937,10622950,10619968,10619969,10619970,10619971,10619972,10619973,10619995,10620051,10620052,10620067,10620079,10620082,10620083,10620114,10620176,10620177,10620178,10620179,10620180,10620181,10620182,10620183,10620184,10620185,10620188,10620224,10620253,10620255,10620256,10620257,10620258,10620259,10620302,10620637,10620638,10620639,10620640,10620641,10620642,10620643,10620644,10620645,10620646,10620647,10620648,10620649,10620650,10620653,10916253,10916254,10916255,10916256,10916257,10916258,10916259,10916260,10916261,10916262,10916263,10916264,10916265,10916266,10916267,10916268,10916269,10916270,10916271,10916272,10916273,10916274,10916275,10916276,10916277,10916278,10916279,10916280,10916281,10916282,10916283,10916284,10916285,10916286,10916287,10916288,10916289,10916290,10916291,10916292,10916293,10916294,10916295,10916296,10916297,10916298,10916299,10916300,10916301,10916302,10916303,10916304,10916305,10916306,10916307,10916308,10916309,10916310,10916311,10916312,10916313,10916314,10916315,10916316,10916317,10916318,10916319,10916320,10916321,10916322,10916323,10916324,10916325,10916326,10916327,10916328,10916329,10916330,10916331,10916332,10916333,10916334,10621108,10621162,10621263,10621425,10621427,10621452,10621458,10621462,10621477,10621478,10621489,10621490,10917003,10621499,10621570,10621576,10621577,10621578,10621579,10621580,10621610,10621611,10621612,10621613,10621614,10621615,10621616,10621617,10621618,10621619,10621621,10621622,10621623,10621624,10621625,10621626,10621635,10621643,10621648,10621663,10621670,10621681,10621682,10621686,10621691,10621697,10621701,10621702,10621712,10621729,10621730,10621734,10621750,10917269,10917270,10917271,10917272,10917273,10917274,10917275,10917276,10565152,10565312,10565313,10565314,10565334,10565908,10565909,10565910,10565911,10565912,10565913,10565914,10565915,10565916,10565917,10565918,10565919,10565920,10565921,10565922,10565923,10565924,10565925,10566004,10566060,10563568,10563590,10563591,10563592,10563593,10563594,10563595,10563596,10563597,10563598,10563599,10563600,10563601,10563602,10563657,10563658,10563659,10563660,10563661,10563662,10563663,10563664,10563665,10563666,10564444,10564445,10564446,10564447,10564448,10564449,10564450,10564451,10564452,10564453,10564469,10564470,10564683,10564687,10564712,10564803,10564804,10564820,10564821,10564822,10564823,10564824,10517320,10517449,10517450,10517546,10517614,10517615,10517616,10517617,10517618,10517619,10517623,10517624,10517625,10517626,10517627,10517628,10517629,10517630,10517631,10517632,10517671,10517749,10517750,10517751,10517752,10518648,10518649,10518650,10518651,10518652,10518653,10518654,10518655,10518656,10518657,10518658,10518659,10518660,10518661,10518662,10518663,10518664,10518665,10518666,10518667,10518668,10518669,10518670,10518671,10518672,10518673,10518674,10518675,10518676,10518677,10518678,10518679,10518680,10518681,10518682,10518683,10518684,10518685,10518686,10518687,10518688,10518689,10518690,10518691,10518692,10518693,10518694,10518695,10518696,10518697,10518698,10518699,10518700,10518701,10518702,10518703,10518704,10518705,10518706,10518707,10518708,10419254,10419342,10419349,10419361,10419362,10419413,10419414,10419473,10419474,10419475,10419476,10419489,10419490,10419493,10419523,10419527,10419538,10419572,10419573,10419577,10419579,10419580,10419581,10419582,10419583,10419584,10419585,10419586,10419589,10419610,10419611,10419612,10419613,10419614,10419615,10419616,10419617,10419622,10419623,10419624,10419625,10419626,10419627,10419628,10419630,10419631,10419632,10419633,10419634,10419635,10419636,10419637,10419638,10419639,10419640,10419641,10419642,10419643,10419644,10419645,10419646,10419647,10419648,10419649,10419650,10419651,10419652,10419656,10419657,10419658,10419659,10419660,10419661,10419662,10419663,10419664,10419665,10419666,10419667,10419722,10419908,10419909,10419910,10419911,10419912,10419913,10419922,10419924,10419925,10419932,10419933,10419934,10419935,10419936,10419937,10419938,10419945,10419946,10419947,10419948,10419949,10419950,10419967,10420088,10420089,10420090,10420173,10420174,10420175,10420176,10420177,10420178,10420179,10420180,10420181,10420182,10420183,10420184,10420185,10420186,10420187,10420188,10420189,10420190,10420191,10420192,10420193,10420194,10420195,10420196,10420197,10420198,10420199,10420203,10420204,10420205,10420206,10420207,10420208,10420209,10420210,10420211,10420212,10420213,10420214,10420215,10471073,10471074,10471075,10471118,10471119,10471120,10471172,10471217,10471233,10471279,10471497,10470092,10470113,10470114,10470124,10470412,10470413,10470533,10470534,10470605,10470643,10470672) 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'