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(7075872,7076289,10198527,7076309,7068347,7068353,7068355,4970700,7068366,10276868,10276869,10276870,10276871,7068707,7068708,7068709,7068710,10199312,10199313,10199314,10277338,10277339,10277340,10277341,10277342,10277343,10277344,10277346,10277347,10277348,10277349,10277350,10277351,10277352,10277353,10277354,10277355,10277356,10277357,10277358,10277359,10277360,10277362,10277363,10277364,10277365,10277366,10277367,10277368,10277459,10277460,10199468,10199469,10277486,7066260,10199539,10199555,10199556,10199557,10277596,10277597,10277610,10238648,10212805,7074738,7066783,7066826,7074881,7074953,7074967,8067968,8067969,8067970,8067971,8067972,10275228,8067973,8067974,8067975,8067976,8067977,10275422,10275423,10275424,10275428,10275430,10275453,7067237,10275496,10275505,10275506,10275507,10275509,7075277,7075289,7075290,10275572,10275580,10275581,10275586,10275619,10275620,10275621,10275622,10275623,10275624,10275625,10275626,8068509,8068510,8068511,8068512,8068513,8068514,8068515,8068516,8068517,8068518,8068519,8068520,8068521,8068522,8068523,10249860,10249861,10249906,7075726,7075727,7075728,7075765,10250035,10250036,6000140,10247281,10247282,10247283,10221378,10221379,10221380,10221381,10221382,10221383,10221384,10221385,10221386,10221387,10221388,10221389,10221423,10221424,10221425,10195456,10195457,10221469,10221470,10221471,10932191,10274836,10274837,10274838,10274839,10274840,10274841,10274842,10274860,10274861,10274931,10274944,10274945,7073742,10194176,10194237,7071097,7071098,10943109,10943147,10943148,10943149,10943180,8861400,10943229,10943230,10231209,10231210,10218579,10218580,10218581,10218582,10218583,10218584,10218585,10218586,10218587,10218588,7069416,7069422,10232220,10232221,10942031,10942032,10245770,10245771,10245772,10245773,10203120,10203121,10203128,10203144,10618830,10618831,10618973,10618974,10618975,10619063,10619064,10619065,10619066,10619067,10619068,10619090,10619091,10619092,10619093,10619094,10619095,10619124,10204226,10204288,10204289,10204290,10619354,10619355,10619959,10927479,10927481,10927482,10927483,10927484,10927485,10927486,10927487,10927488,10927489,10927490,10922688,10189384,10202410,10202411,10202412,10202413,10202414,10202415,10202416,10202417,10202418,10202419,10202420,10202421,10202422,10202423,10202424,10202425,10202426,10202427,10202428,10202429,10202430,10202431,10202432,10215432,10202433,10215433,10202434,10215434,10202435,10215435,10202436,10215479,10622427,10622429,10622430,10202560,10202561,10202562,10202563,10215604,10923114,10923117,10923118,10923119,10923121,10923122,10923124,10923145,10923149,10923152,10923154,10923157,10923158,10923162,10923163,10923166,10923167,10923168,10923170,10923172,10923173,10923177,10923178,10923179,10923180,10923181,10923194,10923195,10923197,10923202,10923203,10202896,10202897,10202898,10202899,10202900,10202901,10202902,10202903,10202904,10202905,10202906,10923415,10923416,10923418,10923421,10923427,10923435,10923436,10923437,10923438,10923439,10619999,10620000,10620001,10615019,10620029,10620106,10615202,10615520,10239746,10239755,10926184,10926185,10200800,10926236,10615860,10615870,10616044,10616045,10926705,10926706,10926707,10926708,10621247,10621248,10621249,10621250,10621251,10621381,10621382,10621383,10621384,10621385,10616464,10188569,10616485,10616490,10616494,10616495,10922117,10922118,10922119,10201933,10201934,10201935,10201936,10201937,10201938,10201939,10201940,10201941,10201942,10201943,10201944,10201945,10201946,10201947,10201948,10201949,10201950,10201951,10201952,10201953,10201954,10201955,10201956,10201957,10201958,10201959,10201960,10201961,10201962,10201963,10201964,10201965,10201966,10201967,10201968,10201969,10201970,10201971,10927437,10927438,10927439,10927440,10927441,10927442,10927443,10927444,10927445,10927446,10927447,10927448,9189341,10614447,6665783,10614449,9173857,10565700,9173907,9173908,8864442,9173980,9173989,9174009,9174010,9174011,9174012,10565859,10565860,10565861,10565862,10565863,10565864,10565865,10565866,10565867,10565868,10565869,10565870,10565871,10565872,10565873,10565874,10565877,10566006,10566013,10566064,10566065,10566073,10566074,10566075,7057607,10612203,10557611,10557612,10557613,10612500,10612542,7058177,9172239,10612987,10612988,10612989,9172435,10613101,7058848,7058854,7058858,7058933,8863314,8863315,8863316,9196811,7059075,7059089,7059097,7059098,7059100,7059101,7059102,7059111,8863528,8863529,8863530,8863531,9177311,10513140,10513141,10517256,10517257,10517258,10517309,10517310,10517325,9193562,10513386,10511471,10511496,9169698,10511511,10511512,10511513,10511514,10511515,10511516,10515517,10511517,10515518,10511518,10515519,10511578,10511579,10511580,10511598,10511599,10511600,10511601,10511602,10511603,9177795,7055963,9169870,9169871,10511704,10511705,10511706,10511707,10511708,7056078,7056079,7056085,7056086,10511766,10511767,7056127,7056142,7056143,7056144,7056163,10511851,10511852,10511853,10511854,10511855,10511856,10511857,10511858,10511859,10511860,10511861,10511862,10511863,10511864,10511865,10511893,9162150,9186201,10512056,9170290,9170300,4975159,4975160,4975161,4975162,4975163,4975164,4975165,4975166,4975167,4975168,10514129,4975169,10514130,4975170,4975171,9170326,9170338,10514156,10514172,10514173,9170383,9170384,9170400,9170420,10514241,10514354,10514355,10514507,10514511,10514512,9170699,10516512,10514513,10514532,10514647,9178909,9178910,9178911,9178912,10512747,10512748,10512756,10514767,10514768,10514816,10514817,10514818,10514826,10514837,10514838,9171078,9171080,10516906,10514979,10514990,10514991,10514992,10514993,10514994,10514995,9171195,10515082,10418259,9160351,9192364,9192365,10418333,9160470,9160471,7054876,10418819,10420039,9193136,10420171,10420172,10417184,9169264,9193285,9193288,8864923,8864924,8864925,8864926,8864927,8864928,4971344,4971355,4971356,8865034,8865035,8865036,8865037,8865067,10471128,8865130,8865131,8865132,8865147,8865148,8865149,8865150,8865151,8865162,8916386,8916387,4972038,4972039,4972040,6667205,9175225,9167300,9175313,9175314,9175315,9175316,9175317,9175318,9175376,9175377,9175378,9175379,9175380,8917028,9175396,9175397,9175474,9175475,9175476,9175523,9175594,9175611,9167672,6667791,9175899,9175979,9191987,9168119,6668123,9168169,9176234,9168282,10159848,10159849,10159850,10159851,10171140,10171141,10163798,10163799,10163839,10163840,10163841,10163842,10163843,10163844,10163859,10163889,10163890,10163891,10163925,10163973,10627631,10627712,10627724,10627731,10174357,10174358,10174359,10161773,10630314,10162266,10162267,10630848,10631014,10631015,10631016,10631017,10626267,10631325,10631326,10631327,10626440,10626441,10631669,10631670,10631671,10631672,10631707,10631708,10626723,10168286,10168287,10168288,10168289,10168290,10168291,10626831,10583836,10583837,10583838,10583839,10583840,10583841,10583879,10583880,10583881,10583999,10584000,10584001,10584002,10584003,10584004,10584005,10584006,10584007,10584008,10584009,10584010,10584011,10584012,10584013,10584014,10584015,10584016,10584017,10584018,10584019,10584201,10584202,10584203,10584204,10584829,10584830,10584831,10584832,10584833,10582552,10585590,10585591,10585592,10585593,10585594,10585595,10585596,10585597,10585598,10585599,10585600,10585601,10585602,10585603,10585604,10585605,10585606,10585607,10585608,10585609,10585610,10585611,10585612,10585613,10585614,10585615,10585616,10585617,10585618,10585619,10585620,10585621,10585622,10585623,10585624,10585625,10585626,10585627,10585628,10585629,10585630,10585631,10585632,10585633,10585634,10585635,10585636,10585637,10585638,10585639,10585640,10585641,10585642,10585643,10585644,10585645,10585646,10585647,10585648,10525160,10525161,10525162,10525163,10525164,10525165,10525181,10525197,10525206,10525208,10523218,10523235,10525248,10525249,10525250,10525251,10525252,10525284,10527833,10527834,10527835,10527836,10522016,10522017,10528118,10522118,10528119,10528120,10528121,10528122,10528123,10528124,10528125,10528126,10528127,10528128,10528129,10528130,10528131,10528132,10528133,10522211,10522212,10522229,10522235,10522236,10522258,10522259,10522260,10522318,10522319,10522320,10522321,10522322,10522323,10522441,10522442,10522443,10522444,10522445,10522446,10522447,10522448,10522449,10522450,10522452,10522453,10522454,10522456,10522526,10522657,10520835,10524856,10524858,10524859,10524860,10420296,10424345,10420365,10420400,10420583,10498510,10424657,10422676,10424044,10425085,10425086,10421087,10425087,10421088,10423103,10480944,10480945,10480946,10481000,10479135,10479136,10479198,10479199,10479200,10479965,10479966,10479977,10482003,10482085,10482094,10482095,10482098,10482100,10482101,10482102,10482103,10482104,10482105,10482121,10482122,10476165,10476166,10476167,10476218,10476259,10476260,10476292,10476293,10472533,10478683) 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'