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(8068808,8068810,8068816,8068838,8068843,8068878,4970650,4970666,4970667,4970668,4970669,4970672,4970745,4970753,4970783,10944065,10944066,10944067,10944068,4970916,4970917,4970918,4970919,4970920,4970921,4970922,4970923,4970924,4970925,4970926,4970927,4970928,4970929,4971043,4971044,4971045,4971061,4971062,4971077,4971078,4971079,4971080,4971084,10944267,4971126,4968208,4968209,4968210,4968220,4968226,4968227,4968230,4968231,10933336,10933337,10933357,10933372,10933373,10933389,4968316,4968317,4968324,4968325,4968326,4968335,4968410,4968411,10437038,10437195,10437196,4968608,4968609,4968610,4968611,4968612,4968616,10437241,10437242,10437243,4968646,4968655,4968656,4968657,4968658,4968659,4968660,10437277,10437335,10437336,10437337,10437338,10437342,10437343,10437344,10437345,10437346,10437407,4968847,10437584,10437614,8067910,8067911,8067912,8067988,8067989,8067990,4969362,4969363,8068016,8068017,8068125,8068126,8068127,8068128,8068129,4969569,4969570,8068247,8068248,8068249,8068250,8068353,8068354,8068355,8068356,8068357,8068358,8068395,8068396,8068397,8068425,8068520,8068521,8068522,8068523,8068610,8068615,8068630,8068643,8068665,8068675,8068684,8068704,8068705,8068708,8068717,8068718,8068721,8068729,8068740,8068752,8068765,10931530,10931531,10931534,10931535,10931536,10931537,10931607,10931620,10931623,10931626,10931627,10931640,10931657,10931658,10931751,10931783,10931795,8075220,8075221,8075222,10931849,10931852,10931860,10931871,8075316,8075317,8075318,8075319,10931918,10931923,10931930,10931931,10931932,10931933,10931934,10931942,10931952,10931953,10931954,10931965,10931966,10931967,10931982,10931983,10931984,10931985,10931986,10931987,10931988,10931989,10931990,10931993,10932006,10932029,10932030,10932031,10932032,10932033,10932040,10932051,10932052,10932053,10932054,10932085,10932086,10932087,10932093,10932099,10932102,10932103,10932104,10932162,10932282,10932283,10932284,10932289,10932316,10932317,10932326,10932327,10932335,10932336,10932344,10932345,10932352,10932597,10932606,10932613,10932638,10932643,10932644,10932665,10932668,10932672,10932678,10932687,10932838,10932845,10932847,10932852,10932853,10932861,10932863,10932877,10932888,10932898,10932913,10932914,10932915,10932945,10932946,10933012,10933021,10933022,10933073,10933074,10933111,10933112,10933113,10933114,10933115,10933116,10933117,10933118,10933119,10933120,10933121,10933122,10933123,10933131,10942632,10942742,10942794,10942891,10942892,10942893,10942894,10942972,10942973,10942983,10942984,10942998,10942999,10943000,10943001,10943009,10943080,10943095,10943096,10943162,10943195,10943286,10943287,10943288,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,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,10940562,10940563,10940564,10940565,10940566,10940567,10940568,10940569,10940570,10940571,10940685,10940686,10940687,10940688,10940689,10940690,10940691,10940692,10940693,10940694,10940695,10940744,10940810,10940985,10940991,10941034,8072312,8072373,8072374,8072383,8072384,8072427,8072434,8072435,8072436,8072437,8072447,8072451,8072459,8072460,8072461,8072462,8072465,8072466,8072469,8072527,8072763,8072764,8072765,8072766,8072767,10941676,8072885,8072886,8072887,8072888,8072889,8072890,8072891,8072892,8072893,8072894,8072895,8072896,8072897,8072898,8072899,8072900,10941765,10941851,8073000,8073005,10941996,10942042,10942075,10942076,10942077,10942078,10942079,10942080,10942081,10942109,10942138,10942154,10942155,10942156,10942157,10942172,10942173,10942174,10942175,10942176,10942177,10942178,10942220,10942221,10942230,10942231,10942233,10942240,10942241,10942252,10942268,10942288,10942290,10942306,10942324,8073542,8073552,10942467,10942476,10623042,10623045,10923620,10923621,10923680,10923681,10923682,10923683,10923684,10623191,10623192,10623193,10623194,10623195,10623196,10623197,10623249,10623250,10623251,10623252,10923784,10923785,10923786,10923787,10923788,10923789,10923790,10923791,10923792,10923793,10923794,10923795,10923796,10923797,10923798,10923799,10923800,10623304,10623307,10923849,10623344,10623438,10622404,10622432,10622433,10622434,10622435,10622436,10622437,10622438,10622439,10622440,10622441,10622442,10622443,10622444,10622445,10622446,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,10621108,10621162,10621263,10621425,10621427,10621452,10621458,10621462,10621477,10621478,10621489,10621490,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,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'