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(10103481,8911496,7076128,10843447,8911755,7076287,7076292,10103986,4971143,10933336,7065936,4968330,4968331,4968332,4968333,4968334,4968335,4968336,4968337,4968338,4968339,10238486,10844846,10844848,10844850,10844852,10844853,8573336,10842104,8910452,10842191,7067302,10102995,10249852,10247090,10247091,10247092,10247093,10247094,10247095,10247096,8908503,8908518,10234506,10247536,10247538,10247539,10247540,10221592,7064652,10195933,10932350,10235637,10102114,10102115,10248804,10248806,10248807,10248808,10248809,10248810,10196893,10235905,10235909,10285093,10285094,10285204,10285205,10285331,10233382,10285426,10285427,10285528,8907880,10285537,10285538,10246544,8907961,10233615,10233777,10233782,10233786,10194863,10194864,8615017,8908289,8908290,10220967,10220968,10220969,10220970,10220971,10220972,10194998,10221012,10221013,10221014,10221015,10221016,10221017,10205078,10205079,10205080,10205081,10231184,10231185,10231186,10231201,8612408,10940929,10837567,8612652,10283602,10283603,8613073,8613074,10283964,10232053,10284074,10284077,10284083,10941757,10941763,10941773,10941782,10838501,10838538,8906887,10284575,10284576,8907034,8907048,10284756,10838967,10838971,10838980,10838999,10284994,10285035,10285036,10229132,10928556,10229138,10229139,10623065,10229231,10229247,10425940,10618265,10618266,10618267,10618268,10618269,10229372,10229373,10618292,10618294,10618295,10618296,10618297,10229393,10229394,10618305,10618306,10618307,10618308,10618309,10618310,10618311,10618312,10618313,10618314,10618315,10229407,10618316,10229408,10618317,10229409,10229410,10618318,10229411,10618319,10618320,10618321,10618322,10618323,10618324,10426151,10229580,10229602,10229603,10229604,10190613,10190614,10190615,10190616,10229617,10229621,10433632,10433633,10190863,8904273,8904285,8904405,8611260,10230298,8611455,10282346,10619384,10619385,10619386,10282597,10619865,10230977,10619885,10228088,10228096,10432052,10432062,8575733,10228277,10228279,10228280,10228281,10228282,10228283,10228284,10228285,10228293,10228294,10228295,8622471,10432278,10432279,10617343,10617347,10617353,10617354,10622405,10617426,10617452,10617457,10617458,10927986,8622721,10432518,10432533,10425349,10425352,10425353,10432568,10425387,10425388,10425390,10432611,10228851,10228852,10228853,10228854,10228855,10228856,10228857,10228858,10425518,10228865,10228866,10228867,10228868,10228869,10228870,10228872,10228873,10228874,10228875,10228876,10228877,10228878,10228879,10228884,10228885,10228886,10228887,10228888,10228889,10228890,10228891,10425551,10280898,10425554,10425555,10425556,10622818,10622819,10622820,10425575,8576394,10229022,10614998,10620202,10615222,10615352,10447778,10447794,10447801,10447803,10278979,8574466,8574467,8574468,10930720,8574473,8574475,8574478,10930731,8574495,8574498,10930777,10616044,10616045,10188377,10616295,10616298,10188482,10188565,10188566,10431592,10431606,10431705,10227998,10227999,10228000,10228003,10228004,10228005,10228006,10228007,10228008,10228009,7059524,9189360,9189363,9189364,10562230,10562231,9213505,10559321,10559322,10614203,10714024,7059718,7059719,7059855,7059859,9173723,9173724,9197737,9197738,10559622,10559626,10559627,10614495,10614496,9173875,9181891,10559706,10559722,10559723,10559724,10559725,10559726,10559744,9173980,9214038,9214180,9214198,9174283,9174284,10612050,9211565,9211566,8862099,9211649,9211650,9211815,9211824,8862558,10120369,7058374,7058375,7058377,9212322,10613018,9196371,10558297,7058687,7058800,7058801,10613369,7018489,9172840,9172859,9172860,7018578,7018579,7018580,7018581,7018582,7018583,7018584,7018585,7018586,7018587,7018588,7018589,7018590,7018591,7018592,7018593,7018594,9189077,9197096,9197097,9197098,9197101,9197102,9197103,9197106,10613875,10613876,10613877,10513118,10513119,10117525,9161492,9209501,10515327,10515328,10515329,10117763,10513386,9185606,9185607,9185609,9185630,7055824,9185737,9185738,9185744,9169748,9185795,9185856,10517670,9185857,9185866,9185879,9185896,9185897,9185909,9169935,9169939,9169940,9185944,9185945,9185946,10118247,9186050,10118248,10118371,10118372,10118373,10118374,10118375,10516123,10516124,10516125,10516126,10516127,9186357,10516193,10118674,9178716,9178723,9178733,9186771,9178778,9178789,9178794,9186800,9186804,10512782,10516928,9211250,4973195,10419307,9176407,9176428,9176429,10416368,10416387,9192468,10416432,10416433,10419454,10419455,10419477,10419478,10419479,10419501,10419502,10419503,10419504,10419505,10419506,10419507,10419508,10419509,10419510,10419511,10419512,10419513,10419514,10419515,10419516,10419517,10419518,10419519,10419520,10419521,10419522,10419523,10419568,9168728,9168752,10418819,10419829,10419831,10419832,10419833,10419894,10419904,9169001,9177036,9209094,10420039,9193119,10420056,10420058,10420059,10417061,10417062,10417063,10417064,10417065,10417066,10417097,10417099,9193180,9193181,10417107,10419108,10419111,10417111,10417119,10417121,10417129,10417150,10417152,10417154,10417156,10417160,9169275,8549455,7020002,7020003,7020004,7020005,7020006,7020007,7020008,7020009,7020010,7020011,7020012,7020013,7020014,7020015,10467108,10467109,10467110,10467115,10467120,10467123,10467124,10467130,10467131,10467145,10467151,10467155,10467159,9190692,10469289,8549884,8549888,8549894,8549957,10467431,10467435,10467438,10467456,10467460,7020538,10467461,7020539,7020540,7020541,7020542,7020543,7020544,7020545,7020546,7020547,7020548,7020549,8550100,10469573,7020668,9199042,9199043,7020761,7020762,7020763,7020764,7020765,7020766,7020767,7020768,7020769,7020770,7020771,7020772,7020773,10465697,7020774,7020807,7020808,7020809,7020810,7020811,7020812,7020813,7020814,7020815,7020816,10465783,10465794,10465799,9175225,10465816,10465817,10465818,10465820,10465821,10465823,10465828,10465832,10465833,10465834,10465837,10465887,10465895,10465896,10465911,9207335,10465914,10463919,10463920,10469949,10464042,10464046,8550648,8550696,10466319,10466321,10466322,10466325,10466327,10466341,10466342,10466345,10466355,10466356,10466366,10466367,10466375,10466379,10468420,10466426,10466432,10466433,10466439,10466440,10466442,10466444,10464581,9192026,6668125,9192208,9176234,10466858,10946563,10628321,8594165,10171195,10171196,10171197,10163491,10163492,10163547,10632051,10632053,10632055,10632163,10632164,10632165,10632169,10632189,10632300,10632301,10632302,10877911,10627775,10172076,10162201,10162249,10949057,10626143,10626144,10626235,10626241,10626298,10168040,10168050,10626602,10626815,10626842,10163479,10583440,10598547,10598548,10598549,10598550,10598551,10598552,10598553,10598554,10598595,10598596,10598597,10598598,10598599,10598600,10598601,10598602,10598603,10598604,10598605,10598606,10598607,10598608,10598609,10598610,10598611,10598612,10598620,10598630,10598653,10598654,10598655,10598656,10598657,10598658,10598659,10598660,10598661,10598662,10598668,10598669,10598673,10598674,10598675,10598676,10598687,10598688,10598689,10598690,10598691,10598692,10598693,10598694,10598695,10598696,10598697,10598698,10598699,10598700,10598701,10598702,10598703,10598704,10598705,10598706,10598707,10598708,10598709,10598710,10598711,10598712,10598713,10598714,10598715,10598716,10598717,10598718,10598719,10598720,10598721,10598722,10598728,10598729,10598747,10598748,10598749,10598750,10598753,10598755,10598762,10598763,10598764,10598765,10598766,10598767,10598768,10598769,10598770,10598771,10598795,10598796,10598797,10598798,10598799,10598808,10598817,10598819,10598820,10598823,10598824,10598825,10598826,10598834,10598835,10598836,10598837,10598838,10598839,10598840,10598841,10598842,10598844,10598845,10598850,10598851,10598852,10598853,10598854,10598856,10598858,10590269,10590270,10590272,10590273,10590274,10590275,10590279,10590280,10590297,10591364,10591365,10582565,10582571,10579778,10579779,10579780,10579781,10591910,10591911,10591928,10580000,10580001,10580002,10525294,10525295,10525569,10521873,10528106,10528107,10528108,10528115,10528116,10528117,10528118,10528119,10528120,10528121,10528122,10528123,10528124,10528125,10528126,10528127,10528128,10528129,10528130,10528131,10528132,10528133,10528142,10528146,10528162,10528176,10528177,10522323,10522441,10522442,10522443,10522444,10522445,10522446,10522447,10522448,10522449,10522450,10522452,10522453,10522454,10522456,10520776,10520777,10524778,10532856,10532857,10532858,10532859,10524895,10420247,10420258,10420262,10420266,10420268,10420427,10420432,10498367,10421486,10421487,10424487,10424488,10420570,10420571,10422597,10498499,10423614,10423618,10421785,10421786,10498692,10498693,10424910,10424941,10424967,10422997,10423003,10423010,10425036,10425042,10425051,10425056,10483067,10483076,10483089,10483092,10492444,10492445,10492446,10492487,10486567,10475757,10475758,10475809,10482014,10482020,10476460) 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'