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(10939564,7075862,8068884,8838419,10943458,10943459,7067978,7067979,7067980,7067981,7067982,7067983,7067984,7067985,7067986,7067987,7067988,7067989,7067990,7067991,7067992,10939712,10939713,10939714,10939715,10939716,8838563,8838564,8838565,8838566,8838637,11001848,10940039,10940040,10940041,10940042,10940043,10940044,8621187,10940170,8569707,8569743,8569750,10963493,11041553,11041554,11041555,11041556,11041557,11041558,11041559,11041560,7073975,11041730,10963881,10963882,10963946,10963947,10963948,10963949,10963950,10963951,10963952,10963953,10963954,10963955,10963956,10963957,10963958,10963959,10963960,10963961,10963962,10963963,10964186,10964187,7074564,8067656,8067657,7074600,7074622,7074652,7074678,10938494,10938495,10938496,10938497,10938498,11039500,10961500,11039502,11039503,11039504,11039505,11039506,7074828,7074950,7067030,11039850,11039852,11039853,7075171,7075187,7075188,7075189,7075190,7075191,7075192,7075193,7075194,7075195,7075196,7075197,7075198,7075199,7075200,7075201,7075202,7075203,7075204,7075205,7075206,7075207,7075208,7075209,7075210,7075211,7075212,7075213,7075214,7075215,7075216,7075217,7075218,7075219,7075220,7075221,7075222,7075223,7075224,7075225,7075226,7075227,7075228,7067228,7067229,7075229,7075230,7067230,7075231,7067231,7067232,7067233,7067234,7075235,7067235,7067236,7075244,7075299,8573487,7075311,7075315,7075316,8837892,8837906,8837907,8837908,11040153,11040154,11040155,11040156,8837988,8837989,8837990,8838126,7075756,11037579,6000227,7064085,7064086,7064087,7064088,7064089,7072189,10931662,10931671,7072297,8911530,8911531,8911532,11038312,11038313,10973348,10973349,10973350,10973351,10973352,10973353,10973354,10973355,10932156,4967112,4967113,4967114,4967115,4967116,4967117,4967118,4967119,4967120,4967121,4967122,4967123,4967124,4967125,4967126,4967127,4967128,4967129,4967130,4967131,4967132,4967133,4967134,4967135,4967136,4967137,4967138,4967139,4967140,11038577,11038578,11038579,11038580,10999584,10999585,8065982,8572090,10999601,10999602,10999603,10999604,10999605,8836795,11039029,11039030,11039031,11039471,11039472,11039473,11039497,10961497,11039498,10961498,11039499,10961499,8064008,8064009,8064010,8860928,10997874,10942969,10102400,10102413,10943052,10943053,10943054,8835009,8835010,8835011,5999931,5999939,10944384,3655566,10944463,8908017,8908018,8908019,7069020,7069021,7069022,11009474,3656627,3656628,3656629,11035949,8565316,8565317,7070626,8860560,10101807,10101808,10101809,8909765,8909766,8909775,10942496,10918517,10918518,8579046,8579056,10923580,10967841,10967842,10923830,10923831,10923832,10923833,10923834,10923835,10923836,10623405,10924063,10924064,10924065,10924066,10924067,10924307,10924308,10924402,10924403,10924404,10924405,10924406,10924407,10924408,10924409,10924410,10924411,10924412,10924413,10924414,10924415,10924416,10924417,10924418,10924419,10924420,10924421,10924422,10924423,10924424,10924425,10924426,10924427,10924428,10924429,10924430,10924431,10924432,10924433,10924434,10924435,10924436,10924437,10924438,10924439,10924440,10924441,10924442,10924443,10924444,10924445,10924446,10924447,11033567,10924623,10924624,10924625,10924626,10924627,10924628,10924629,10924630,10924631,10924632,10924633,10924634,10924635,10924636,10924637,10924638,10924639,10924640,10924641,10924642,10924643,10924644,10924645,10924646,10924647,10924648,10924649,10924650,10924651,10924652,10924653,10924654,10924655,10924656,10924657,10924658,10924659,10924660,10924661,10924662,10924663,10924664,10924665,10924666,10924667,10619242,10619243,10619244,10619245,10619246,10619247,10619248,10619249,10619250,11046826,11046832,8907283,8907284,8907285,10617051,11005687,11005688,11005714,11005715,11005716,11005717,11005718,11005719,11005720,11005721,11005722,11005723,11005724,11005725,11005726,11005727,11005728,11005729,11005730,11005731,11005732,11005733,11005734,11005735,11005736,11005737,11005738,11005739,11005740,11005741,11005742,11005743,11005744,11005745,11005746,11005747,11005748,11005749,11005750,11005751,11005752,11005753,11005754,11005755,11005756,11005757,11005758,11005759,11005760,11005761,11005762,11005763,11005764,11005765,11005766,11005767,11005768,11005769,11005770,11005771,11005772,11005773,11005774,11005775,11005776,11005777,11005778,11005779,11005780,11005781,11005782,11005783,10917756,11005784,10927910,8578531,8578532,8578562,8578563,8578564,8578565,8578566,8578567,8578568,8578569,8578610,8578611,8578612,8578878,11006494,11006495,10990500,10964558,10964559,10964560,10964561,10951830,10620540,10926066,10926067,10926068,10926069,10952040,10926070,10926071,10926072,10926073,10926074,10926075,10926076,10926077,10926078,10926079,11043276,11043277,11043278,10926254,10926273,10991604,10921760,10921761,10952839,10952922,10952923,10952924,9173334,9173335,9173336,9173337,9173338,9173339,8864308,8864315,9173893,9173894,9173895,9173896,9173897,9173898,9173899,9173900,9173901,9173902,10562790,10562791,10562792,10562793,10562794,10562795,10562796,10562797,10562798,10562799,10562800,10562801,10562802,8864677,9171326,9171351,9187403,7057702,9187904,9187905,9196112,9196113,9196114,8862825,8862826,8862827,8862828,8862829,8862830,8863258,7058968,7018595,7018596,7018597,7018598,7018599,7018600,7018601,7018602,7018603,7018604,7018605,7018606,7018607,7018608,7018609,7018610,7018611,7018612,7018613,7018614,7018615,7018616,7018617,7018618,7018619,7018620,7018621,7018622,7018623,7018624,7018625,7018626,7018627,7018628,7018629,7018630,7018631,7018632,7018633,7018634,7018635,7018636,7018637,7018638,7018639,7018640,7018641,7018642,7018643,7018644,7018645,7018646,7018647,7018648,7018649,7018650,7018651,7018652,7018653,7018654,7018655,7018656,7018657,7018658,7018659,7018660,7018661,7018662,9189053,9189201,9189223,7059417,7059418,7059433,9173276,9161491,9161596,9161597,9193732,9193733,9193734,7055960,4974791,4974920,4974921,4974922,4974925,4974926,4974927,9202099,10517950,10517951,10517952,10517953,10517954,10517955,10517956,10517957,10518046,10518047,10518048,10518049,10518050,10518051,10518052,10518053,10518054,10518055,10518056,10518057,10518058,10518059,10518060,10518061,10518062,10518063,10518064,10518065,10518066,10518067,10518068,10518069,10518070,10518071,10518072,10518073,10518074,10514137,10514138,10514139,10514140,7016165,8861569,8861570,10518914,10518915,10518916,10518917,10518918,10518919,10518920,10518921,10518922,10518923,10518924,10518925,10518926,10518927,10518928,10518929,8918046,8918047,8918048,9192466,9160474,9160475,9160476,9160477,9160478,9192546,9200722,9200723,9200724,9200736,9177035,10417123,8864867,8864884,9206482,9206619,4971676,4971677,4971678,4971679,4971680,4971681,4971682,4971683,4971684,4971685,4971686,4971687,4971688,4971689,4971690,4971691,4971692,10471487,9183004,6667206,6667309,8916990,8563463,8563464,9207582,9207596,9207597,9207598,9207599,9207600,9207601,9207602,9207603,9207604,9207605,9207606,9207607,9207608,9207609,9207610,9207611,9207612,9207613,9207614,9207615,9207616,9207617,9207622,9207664,9199764,9175882,9207889,9207892,9175910,9175922,9191924,9191959,8551242,10462733,10462734,10462735,10462736,10462737,10462738,8917839,10159588,10179767,10179768,10179769,10159774,10159775,10159776,10159777,10159778,10159779,10159780,10628315,10179960,10170714,10155842,10875270,10875271,10875272,10875273,10875274,10875275,10875276,10875277,10875278,10875279,10186312,10186313,10186314,10186315,10186316,10186317,10163494,10163495,10163496,10163497,10163498,10163499,10163500,10163712,10163713,10163714,10627199,10173884,10173887,10627413,10627414,10186550,10186551,10186552,10186606,10161903,10187076,10187077,10162154,10162544,10162554,10187555,10187556,10187557,10187558,10172744,10631262,10631263,10631296,10631308,10187990,10626524,10626525,10626526,10626527,10626528,10163325,10163349,10163350,10163351,10163352,10163353,10163354,10163355,10631864,10945215,10945216,10945217,10945218,10945219,10945220,10945221,10945222,10945223,10589584,10583755,10583756,10583757,10583758,10583759,10583760,10567348,10567349,10567350,10567351,10567352,10567353,10588391,10529334,10534189,10528227,10528228,10528229,10528230,10538460,10520778,10520779,10520780,10520781,10520782,10520783,10520784,10520785,10527004,10527005,10420572,10420573,10420688,10421929,10423960,10423961,10479193,10477386,10477611,10479654,10479655,10479656,10479657,10479658,10479659,10479661,10479662,10479663,10479664,10479665,10479666,10479667,10479668,10479669,10479670,10479671,10480009,10480010,10480011,10480012,10480013,10480014,10480015,10487494,10487501,10487502,10476546,10476547,10476548,10476549,10476550,10476551,10476552,10476553,10472607) 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'