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(10845673,10845727,10845734,10845735,10845737,10845754,10845755,10845760,10845832,10845838,10845839,10845936,10846047,10846053,7076338,7076339,10448291,7073835,7073836,7073848,10963571,10963666,8621884,7074056,7074058,7074063,8067518,8584030,7066586,8619777,8619803,8619812,8837684,8837720,8837721,8837722,8837723,8837724,8573419,8837763,8620235,8620245,10845210,10962153,7067660,7075724,6000194,6000195,6000297,11011828,11011829,11011830,11011831,11011832,11011833,11011834,11011835,11011836,11011837,10842917,11011868,10843006,10843054,10103439,10843076,10843121,10843401,8836245,10843713,7073430,8619333,10961221,10844451,10844453,10844461,7073724,10102054,10942701,10942702,10942703,10942706,10942707,8860896,11010826,11010827,11010828,10943153,10943155,8064652,10943381,10943400,5999972,5999983,5999984,5999985,5999986,5999987,5999988,5999989,5999990,5999991,5999992,8910837,8910838,10839840,10839851,8615067,8615080,3656108,3656109,8615708,10941854,10941883,11009869,11009870,11009871,11009872,11009873,11009874,11009875,10941911,10941955,10941977,10101559,10101560,10101561,7070731,7070735,7070765,7070769,7070774,7070789,10993544,10993545,10993546,10993547,10993548,8905928,10928558,10928646,10928671,10928672,11045815,10838033,10838039,10838040,11045986,11045989,8906548,11046731,11046818,10838892,11046902,11046903,11046938,11046939,11046941,11046942,11046943,11046944,11046970,11046972,11046973,11046974,11046975,11047002,11047003,11047006,11047007,11047008,11047050,11047051,11047067,11047081,11047112,11047113,11047114,11047115,11047116,11047117,11047122,11047123,11047124,11047125,11047126,11047199,11047200,11047227,11047228,11047229,11047230,11047231,11047232,11047257,11047276,11047278,11047280,11047281,11047282,11047298,10992602,10992603,10992604,10992605,10992612,10992613,10992614,10992615,10992616,10992617,8904996,10992644,10992722,10992792,10992801,10992802,10992803,10992804,10992868,10992869,10992871,10992872,10992932,10992933,10992934,10992935,10992936,10992937,10992938,10992939,10992976,10992977,10992978,10992979,10992980,11045038,10993042,10837119,10837120,10837121,10993070,10993071,10993099,10993100,10993101,10993107,10993108,10993170,10993188,10993189,10993190,10993191,10993192,10993193,10993194,10993195,10993196,10993197,10928198,10928199,10993274,10993292,10993293,10993294,10993306,10993307,10993331,10993334,10993424,8905817,8622728,8622733,10920560,8622756,10920619,10951626,10920657,11042900,11042901,10964949,10964950,8570260,8570261,8576498,10951965,10951966,10952052,10952252,10615826,10615840,10991471,10991472,10991521,10991522,10991523,10991529,10991606,10991608,10991609,10991610,10991611,10991612,10991644,10991645,10991646,10991664,10991665,10991666,10991667,10991671,10991672,10991673,10991674,10991675,10991676,10991677,10991678,10991755,10991776,10991786,10992013,10992014,10992015,10992016,10992017,10992102,8611397,10992246,10992247,10992405,10992406,10992408,10992416,10992418,10992419,10992420,10992421,10565130,10559201,10559202,10559203,10559210,9213533,9213559,9213560,9213618,9213619,9189638,10559466,10559477,9213671,9213684,10559565,10559566,10559567,10559568,10559569,9213756,9213757,10559570,10559571,10559572,10559574,10559575,10559576,9213763,10559577,10559578,10559579,10559580,9213768,10559581,10559582,9213769,10559583,10559584,10559594,10559595,10559596,10559597,10559598,10559599,10559600,10559601,10559604,10559605,10559606,10559607,10559608,10559609,9213834,9213850,9213851,9213887,9213888,9213889,10122133,10122145,9213951,9213952,9213953,9213954,10122158,9213971,9213972,10122180,10122181,8864515,10122191,8864517,10122192,10122212,10122213,10122234,8864573,8864580,9214061,8864606,8864643,8864679,8864685,8864690,7057485,7057501,7057502,7057508,7057509,7057510,9203345,9203346,7057519,7057520,9211427,9211452,10563450,10563452,10563457,10563459,10563460,10563461,10563462,10563463,10563464,10563465,10563466,10563467,10563542,7057910,9195883,9195886,9195888,9195896,9195897,9195898,10557816,10557817,10557818,9196011,9188276,9188283,9212353,9188405,7058604,9204440,9204441,9172459,9188555,7058741,7058742,9188583,10561523,10561524,10558578,9189017,9189235,9189240,9189253,9189271,9189289,9161515,9193520,9185588,9185589,9185590,9209590,9185600,9209619,9185700,9185706,9185713,9185716,4974609,9161758,4974619,4974620,4974628,9185784,9185785,4974642,10515724,9185959,9185978,9186010,9186047,9186110,9186187,9186218,9186241,9186247,9186248,9186249,9186250,9186326,9186379,9186380,9186386,9186414,9186431,9186460,9186510,9186520,9202521,9186554,9186571,9186572,9186573,9186574,9186607,9186608,9186679,9186692,9186711,10512577,10518617,9186817,9186818,9186824,9186852,9186853,9186861,9186866,9186870,9210934,9203128,9203131,9203190,9203196,9203197,10513028,10513029,10513030,10513043,10513044,10513045,9187263,10419314,10419564,10419565,10419566,10419567,8918314,10419614,10419615,10419616,10419617,9168759,10417726,10417080,10417081,9161229,9185253,9182551,9166810,9198998,6667149,6667151,6667235,9199296,9175425,6667584,6667594,8917291,10470358,9207841,10470451,10470452,9207950,10470576,9168098,9168108,10628636,10628923,10629223,10629224,10629225,10629226,10629227,10629241,10629242,10629243,10629244,10629245,10629246,10629403,10629404,10629582,10629589,10629590,10629591,10629615,10629616,10629617,10629665,10178658,10178708,10178709,10153837,10178891,10179278,10179281,10179372,10179397,10176677,10181768,10181769,10181852,10181853,10181902,10181903,10181904,10161942,10162189,10178218,10178450,10178454,10568112,10568113,10568128,10568129,10568130,10568196,10568197,10568297,10568298,10568299,10568300,10568301,10568306,10568307,10568308,10568309,10568315,10568319,10568320,10568321,10568336,10568337,10568338,10568339,10568340,10568341,10568342,10568343,10568344,10568345,10568346,10568347,10568348,10568349,10568350,10568351,10568352,10568353,10568354,10568355,10568356,10568357,10568359,10568360,10568361,10568362,10568374,10568375,10568376,10568381,10568392,10568395,10568441,10568442,10568443,10568444,10568445,10568447,10568448,10568449,10568450,10568455,10568456,10568478,10568515,10568531,10598913,10598947,10598948,10598949,10598972,10599073,10599074,10599075,10587162,10587163,10587164,10584211,10584212,10584213,10584366,10590500,10590622,10590930,10590931,10590932,10590933,10590934,10590935,10590936,10590975,10590976,10576282,10576289,10576368,10576369,10576370,10576371,10591372,10576372,10591381,10591406,10591428,10591429,10567498,10567499,10567501,10591509,10591510,10591511,10591512,10591513,10591514,10591515,10591616,10591671,10591672,10591673,10591674,10591675,10591676,10591677,10591678,10591679,10591680,10588687,10567795,10568111,10521191,10521293,10531381,10531382,10531383,10537408,10537411,10537439,10537440,10537470,10531538,10531614,10531615,10531616,10531617,10531618,10531619,10531620,10531621,10531622,10531623,10531624,10531625,10531626,10531627,10531628,10531629,10531630,10531631,10531673,10531674,10531675,10531676,10531677,10531678,10531679,10531680,10531681,10521818,10521819,10521820,10521821,10521822,10521823,10531855,10527881,10529931,10531933,10529978,10529979,10529980,10532019,10532020,10532021,10532022,10532023,10532024,10530070,10532080,10522089,10530118,10530126,10532176,10532177,10532178,10532179,10532181,10532182,10532183,10532184,10532185,10522195,10532231,10532232,10532233,10532234,10530271,10530272,10530273,10530274,10530275,10538311,10538312,10538313,10538314,10532328,10538336,10532389,10532390,10538412,10538424,10538425,10532430,10532431,10532432,10530432,10532433,10530433,10532434,10530434,10532435,10532436,10532437,10532438,10532439,10532440,10532441,10532442,10532443,10532444,10532445,10532446,10532447,10532448,10532449,10532450,10532451,10532452,10532453,10532454,10532455,10532456,10532457,10538471,10538486,10538532,10530591,10530699,10530700,10530701,10530702,10530707,10530708,10532730,10532740,10532741,10532742,10532743,10532744,10532745,10532746,10536749,10536750,10536751,10536752,10536753,10536754,10536755,10536756,10530772,10530773,10530774,10532777,10522782,10522783,10522784,10530809,10530810,10530811,10530812,10530813,10530814,10522818,10538841,10532870,10532871,10532872,10530889,10530890,10530891,10530893,10532906,10532907,10532908,10524924,10524925,10530933,10530941,10530942,10532943,10532944,10532946,10532957,10532958,10532972,10530974,10530975,10521018,10521019,10531032,10531033,10531034,10531035,10531070,10533081,10539101,10539102,10539103,10539104,10539105,10539106,10539107,10539108,10423516,10423517,10421973,10422004,10422035,10422036,10422060,10422061,10422116,10422192,10488169,10488170,10492871,10492872,10492873,10492877,10492880,10492886,10492887,10492888,10492889,10492891,10492893,10492894,10492917,10474107,10476143,10476144,10476145,10491251,10493332,10493333,10493334,10493335) 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'