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(7075912,10939642,10962637,10939736,10939905,10939941,10939942,10963506,10963507,10963674,10964440,10964441,10964442,10964443,10964444,10964445,10964446,10964447,10964448,10964449,10964450,8067942,8067943,7067196,7067271,7075460,7075498,10962467,10962468,10962469,10962470,10962471,10962472,10962473,10962474,6000119,6000194,6000195,6000196,6000197,6000198,6000199,11011910,11011911,10960062,10999062,8065953,8065954,8065955,8065956,8065957,8065958,10999913,10999914,10999915,10999974,10999975,11000113,11000114,11010576,10997780,10997857,10997858,10997859,10958953,10958954,10959184,10985228,10985229,10985230,11011425,11011426,11011427,10944385,10995822,11009270,11009273,11009274,11009345,10941948,8860418,8860420,8860498,8860613,10618253,10618254,10618255,10618256,10618281,10967846,11007192,11007193,11007194,11007195,10618861,10618862,10968422,10968571,10619193,10619229,10619352,10619353,11008162,11008163,10624632,10624633,10619898,10619899,10617026,10617071,10622264,10622265,10622266,10622267,10622268,10617332,10617340,10617341,10617342,10617343,10617347,10617348,10617349,10617350,10617351,10617352,10617355,10617356,10617357,10617358,10617359,10617360,10617361,10617363,10617364,10617365,10617369,10617372,10617375,10617376,10617385,10617386,10617387,10617388,10617389,10617393,10617394,10617395,10617396,10617397,10617398,10617402,10617403,10617404,10617405,10617418,10617419,10617420,10617421,10617422,10617426,10617427,10617431,10617434,10617435,10617438,10617447,10617451,10617457,10617458,10954113,10954114,10954313,10993372,10620096,10620208,10620290,10620291,10620292,8570123,10620301,10620303,10615342,10615389,10965320,10965372,10965373,10930665,10930666,10930667,10615896,10930728,10616006,10616243,10616245,10616265,10616404,10616417,10616426,10616476,10922133,10922134,10562118,10562119,10562120,10562121,10562122,10562123,10562124,10562125,10562126,10562127,10562128,10562129,10562130,10562131,10562132,10562133,10610987,10611014,10562168,10562169,10562170,10562171,10562172,10562173,10614064,10565220,10562223,10562224,10565247,10565248,7059607,10559332,10559333,10559334,7059733,7059734,9173711,9173712,9173713,9173714,9173715,9173716,9173717,9173718,9173719,9173720,9173721,9173722,9173723,9173724,9173725,9173726,9173727,9173728,9173729,9173730,9173731,9173732,9173733,9173734,9173735,9173736,9173737,9173738,9173739,9173740,9173741,9173742,9173743,9173744,9173745,9173746,9173747,9173748,9173749,10559585,10614500,10614502,10611527,10614593,9173984,9173985,9173986,9173987,9173991,9173992,9173993,10611782,9166129,6666210,6666211,6666212,6666213,6666214,6666215,10611906,10611907,10611908,10611909,10611910,10611911,10611914,10611915,10611918,10611920,10611922,10611923,10611924,10611925,10611926,10611927,10611928,10611932,10611936,10611937,10611938,10611939,10611941,10611969,10612022,10612086,10609099,10612105,10612107,10612131,10609285,10612295,10609375,10612381,10609844,9172211,9172212,9172214,9172215,9172216,9172217,9172218,9172219,9172220,9172221,9172222,9172224,9172225,9172226,9172227,9172228,10609916,10609917,10609918,10609919,10609920,10609921,10609922,10609923,10609924,10609925,10609926,10609927,10609928,10609929,10609930,10609931,10609932,10609933,10609934,10609935,10609936,10612936,10609937,10609938,10609939,10612939,10609940,10612940,10609941,10609942,10612942,10609943,10609944,10609945,10609946,10609947,10609948,10609949,10609950,10612959,10609986,10609988,9196362,10610026,7058533,7058534,10610063,10610064,7058620,9172491,10613362,10561523,10561524,10558591,10558593,9172859,9172860,9172879,9172880,9172881,9172884,9172885,9172888,9172891,10610666,10613736,10613737,10613738,10564973,10610841,10610890,10610895,10610898,10610899,9169306,9169307,9169308,9169310,9161492,7055723,9169586,9185608,10515422,9185626,9185757,7055956,9169822,9185850,9161857,9169864,7056039,9169935,9169942,9169944,9169945,9169946,9169947,9169948,9186049,9186050,9170074,10513914,10513915,9162145,9162146,9162147,9162148,9162151,9162157,9162158,9162159,9162160,9162161,9162162,9162163,10514015,10516128,10516130,10516131,10516132,10516142,9178490,9178492,9186540,9186541,9186542,9186543,9186544,9186782,9178826,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,10516867,9171078,9171080,10516929,10516930,10516931,10516934,10516935,10516936,10516937,10516938,10516939,10516940,10516941,10516942,10516943,10516944,10516945,10516953,10516954,10516955,7057449,9160319,10416255,9160334,10416256,9160335,9160361,9168366,9168367,10419307,9168394,8918080,10416364,10416365,10416366,9176446,9184492,10419496,10419501,10419502,10419503,10419504,10419505,10419506,10419507,10419508,10419509,10419510,10419511,10419512,10419513,10419514,10419515,10419516,10419517,10419518,10419519,10419520,10419521,10419522,10419523,10419538,9168710,10418676,10419676,10419679,10419688,10418689,10418691,10419694,10418708,10419719,10419720,10419722,10419723,10419724,10419725,10419726,10419727,10419728,10419729,10419730,10419731,10419732,10419733,10419734,10419736,10419737,9168816,10419738,10419739,9168818,10419740,10419741,10419742,10419743,10419744,10419745,10418806,10417811,10417814,10417816,10417820,10417824,10417826,10417830,10417832,10417834,10417839,10417843,10417845,10417849,10417850,10417852,10417856,9168937,9168938,10417860,9168939,9168940,10417862,9168941,10417866,10417868,10417870,10417874,10417878,10417883,10417885,10417887,10419890,10417891,10419891,10419894,10417895,10419895,10419896,10417897,10419899,10417901,10417903,10419904,10417905,10419905,10419907,10417909,10417913,10417915,10417919,10417921,10417925,10417930,10417934,10417938,10419971,10420036,10420053,10417053,10420054,10417054,10420055,10417055,10420056,10420059,10417059,10417060,10417078,10417079,10417096,10417097,10417098,10417099,10417100,10417102,10417109,10417111,10417112,10417121,10417122,10417129,10417130,10417135,10417138,10417140,10417142,10417146,10417147,10420149,10417152,10417153,10417154,7055457,9161295,10471172,8916426,10469950,9167397,9167398,8917096,9175497,9175498,9167682,10468329,9167782,9175790,9167792,9175796,10468410,9167850,9175853,9167872,9167873,9167875,9175892,9175893,9175894,9175895,9175896,9175897,9175898,9175955,9168025,9168027,9160297,10155853,10155856,10163532,10163533,10163534,10632040,10632047,10632048,10632049,10632050,10632055,10632056,10632166,10632312,10153863,10631236,10631237,10631241,10631242,10631243,10631455,10631456,10167992,10631789,10631790,10631791,10163475,10568112,10568113,10568114,10568115,10568116,10568117,10568118,10568119,10568120,10568121,10568122,10568123,10568124,10568125,10568126,10568127,10568128,10568129,10568130,10568294,10568295,10568296,10568297,10568298,10568299,10568300,10568301,10568302,10568303,10568304,10568305,10568306,10568307,10568308,10568309,10568310,10568311,10568312,10568313,10568314,10568315,10566178,10566179,10566180,10566181,10566182,10566183,10566184,10566185,10566186,10566187,10578444,10578445,10578446,10578447,10578448,10582566,10582569,10567621,10567622,10567623,10567624,10567625,10568110,10568111,10519391,10519475,10527741,10529861,10530125,10528185,10528186,10528187,10528188,10528189,10528190,10528191,10522309,10522310,10522311,10522312,10522313,10522314,10522315,10522316,10522317,10522358,10522359,10522360,10522404,10522451,10522455,10522459,10522460,10522461,10522466,10522467,10522468,10421272,10425325,10425332,10421379,10422380,10422381,10422382,10423394,10422403,10422404,10422405,10421486,10421487,10423500,10420540,10422543,10421543,10420543,10422544,10420546,10422561,10423584,10422585,10422588,10420588,10420589,10422595,10422596,10422599,10421608,10421636,10421645,10424655,10421675,10421676,10423739,10421751,10420753,10421810,10498703,10498704,10422817,10422818,10422819,10422820,10422822,10422823,10420841,10498744,10421878,10424883,10424885,10424887,10421889,10421890,10421895,10423919,10423920,10423922,10423964,10423022,10423024,10425029,10425030,10424051,10422058,10425083,10425084,10423155,10422188,10422218,10422219,10422220,10477873,10477874,10477875,10477876,10477877,10478003,10478004,10478007,10478008,10478009,10478010,10478011,10478012,10478013,10478014,10478015,10478016,10478017,10478018,10478019,10478020,10478021,10478023,10478024,10478025,10478026,10478027,10478028,10478029,10478030,10478031,10478032,10478033,10476457,10476460,10476461,10476506,10476507) 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'