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(10939560,7075956,10962653,8068885,8068886,8068887,8068888,8068889,8068890,8068891,8068892,8068893,8068894,8068895,4970265,4970266,4970267,4970268,4970269,11014821,11014822,11001856,11001876,11001877,11001878,11001879,11001880,11001881,11001882,11001883,11001884,4970649,8569523,11015239,11015240,11015241,11028319,10963384,10944177,11041548,11041549,11041550,11041581,8583374,8583375,10950889,10950890,8067349,8067350,10437254,8067415,4968846,4968847,4968848,4968859,4968860,4968861,4968862,8584148,10437626,10437627,10437628,10437629,10437630,8575978,8575979,8575980,8575981,7074899,7074900,7074901,7066983,8067892,8837536,10961880,10938930,10939103,10939279,10939280,10939281,10939282,10939283,10939284,10939285,10939286,8838289,7072314,8911462,8911463,11038111,11038112,11038113,11038114,11038115,11038116,11038117,11038118,11038119,11038120,11038121,11038122,11038123,11038124,11038125,11038126,11038127,11038128,11038129,11038130,11038131,11038132,11038133,11038134,11038135,11038136,11038137,11038138,11038139,11038140,11038141,11038142,11038143,11038144,11038145,11038146,11038147,11038148,11038149,11038150,11038151,11038152,11038153,11038154,11038155,11038156,11038157,11038158,11038159,11038160,7064492,10103639,10103640,10960195,10960196,10960197,10960198,10960199,10960200,10960201,10960202,10960203,10960204,10960205,10960206,10960207,8065500,10960208,8065501,8065502,10960209,8065503,8065504,10103846,11012671,11025821,7065144,7065145,7065146,7065147,7065149,7065150,7065153,7065155,10932528,10932529,10932530,10932531,10932532,10932533,10932534,10932535,10932536,10932537,10932538,10932539,7073273,8836769,8836770,8836900,7073476,7065495,7065496,7073500,11000288,11000289,11000290,11000291,11000292,11000293,11000294,7065860,8834530,8834671,8834672,8834673,7071213,8834723,10942887,10942888,10958953,10958954,11036994,11036995,11036996,8910777,8910778,8910779,10959521,10959522,10959523,10959524,10959525,10959526,10959527,10959528,10959529,10959530,10959531,10959532,10959533,10959534,10959535,10959536,10959537,10959538,10959539,10959540,10959541,10959542,10959543,10959544,10959545,10959546,10959547,10959548,10102994,6000162,6000163,10957380,10957381,10957382,10957383,10957384,8564520,8564521,8564522,8564523,8564524,8564525,11009695,11009696,11009697,11009698,11009699,11009700,11009701,11009702,11009703,11009704,10983765,10101210,11035900,11035901,11048338,11048339,8565283,11048483,8565319,10101792,7070771,10101941,11010511,7070828,11010512,11049769,10942552,11049770,10618143,11032817,11032818,11045860,10623349,10618364,10623443,8906896,10920290,10920291,10920292,10925367,10925368,10925369,10925370,11005703,10622096,10622097,10622098,8578303,8578304,8578305,8578306,8578307,8578308,8578309,8578310,8578311,8578312,8578313,8905265,11005943,10927875,10927876,10927877,10927878,11006123,10954193,10954194,10923088,10923089,10923090,10923091,10923092,10923093,10923094,10923095,10923096,10923097,10923098,10923099,10923100,10923101,10923102,10923103,10923104,10923105,10923106,10923107,11006319,11032606,8570039,8576280,8576281,8576456,10926060,10926133,11030286,11030287,10916400,10916401,10916402,10916403,10916404,10916405,10916406,10916407,10916408,10916409,11017670,11017671,11017672,11017673,11017674,11017675,11017676,11017677,11017678,11017679,11017680,11017681,11017682,11017683,11017684,11017685,11017686,11017687,10952634,10931009,10952722,8577625,8577987,8577988,8577989,10922361,10922463,10922467,9205328,9181386,9181387,9181388,9181389,9181390,9181391,9181392,9181393,9181394,9181395,9181396,9181397,9181398,9181399,9181400,9181401,9181402,9181403,9181404,9181405,10559271,10559334,9213737,7019394,7019500,7019518,10559693,10559694,10559695,10559696,10559697,7019598,7019633,9198009,9198010,9198011,9198012,7019680,7019701,7019711,7019782,8864737,10563176,10563177,10563178,10563179,10563180,10563181,10563182,10563183,10563184,10563185,10563186,9171375,8861968,9211518,10563356,9171562,10612253,8862267,8862268,8862269,8862270,8862271,9211982,9211983,10612657,10612681,9172065,7058275,7058276,7058277,7058278,10612943,9204733,9164756,9164757,9164759,9164760,9164761,9164762,10561579,10561580,10561581,9164770,9164771,10561585,9164773,10561588,10561589,10561590,10561591,10561596,10561598,10561607,10561617,10561618,10561619,10561620,10561623,10561624,10561628,10561629,10561630,9196818,10561638,10561639,10561658,10561659,10561660,10561661,10561669,10561678,10561679,10561680,10561681,10561682,10561697,10561698,10561704,10561705,7059061,10561710,10561714,10561715,10561716,10561717,10561718,10561739,10561740,10561741,7059193,7059194,7059195,7059196,7059197,7018703,7059415,7059416,7059417,7059418,7059419,7059420,7059421,7059422,7059423,7059424,7059425,7059426,7059427,7059428,7059429,7059430,7059431,7059432,7059433,7059434,7059435,7059436,7059437,7059438,7059439,7059440,9189274,7059441,7059442,10515126,7014974,7015023,9201371,7015089,7015142,4974530,9193749,9193750,9193751,9201754,10515793,2809258,9186760,7056960,7056961,7056962,9170890,9202994,9202995,7013981,7013982,7013983,7013984,7013985,7013986,9192583,9192584,10416520,10418531,10416563,4973677,4973921,7014799,10416108,10416109,7014884,7014927,8549504,8549505,8549506,8549507,8549508,9166493,9166494,9166495,9166496,9166497,9166498,9166499,9166500,9166501,9166502,9166503,10467252,10467253,10467254,9174723,9174724,9183235,9207265,10469889,9167325,9167326,9167327,9167328,9167329,9207506,8550785,10468250,8550847,8917597,8917598,8917599,8917600,8917601,8917602,8917603,8917604,8917605,8917606,6668099,10466790,10466791,10466792,10628020,10174549,10174550,10628191,10174839,10159931,10946773,10175131,10175132,10175133,10175134,10175135,10175204,8594218,8594219,10175362,10175363,10175364,10175365,10175366,10175367,10175368,8068958,8068959,8068960,8068961,8068962,8068963,8068964,8068965,10160702,10160703,10160704,10160705,10160706,10160707,10160708,10160709,10160710,10160711,10160712,10160713,10160714,10160715,10160716,10160717,10160718,10160719,10160720,10160721,10160722,10160723,10160724,10160725,10160726,10160727,10160728,10160729,10160730,10160731,10160732,10160733,10160734,10160735,10160736,10160737,10160738,10160739,10160740,10160741,10160742,10160743,10160744,10160745,10160746,10160747,10160748,10160749,10160750,10160751,10160752,10160753,10160754,10186341,10186342,10186343,10186344,10186345,10186346,10186347,10186348,10186349,10186350,10173547,10178673,10178674,10178675,10178676,10178677,10178678,10178679,10178680,10178681,10178682,10178683,10178684,10178685,10158782,10158783,10184189,10184190,10184191,10184192,10174349,10174361,8593403,8593433,10948365,10948366,10948367,10948368,10948369,10948370,10948371,10948372,10948373,10948374,10948375,10948376,10948377,10948378,10948379,10948380,10948381,10948382,10948383,10948384,10948385,10948386,10948387,10948388,10948389,10948390,10948391,10948392,10948393,10948394,10948395,10948396,10948397,10948398,10948399,10948400,10948401,10948402,10948403,10948404,10630083,10948405,10948406,10630104,10161664,10161665,10161666,10161667,10176800,10176801,10187072,10187073,10187074,10187075,10187076,10187077,10187078,10187079,10630824,10630825,10630826,10630827,10630828,10630829,10630830,10630831,10630832,10630833,10630834,10630835,10630836,10630837,10630838,10630839,10630840,10630841,10630842,10162890,10631458,10631742,10626823,10631827,10574130,10571262,10571558,10571559,10586909,10586910,10586911,10586912,10586913,10586914,10586915,10586916,10586917,10586918,10586919,10586920,10586921,10586922,10586923,10586924,10586925,10586926,10586927,10586928,10586929,10586930,10586931,10586932,10586933,10586934,10586935,10568958,10581286,10581287,10581288,10581289,10581290,10581291,10581292,10581293,10581294,10581295,10581296,10581297,10581298,10581299,10581300,10581301,10581302,10581303,10581304,10581305,10581306,10581307,10581308,10581309,10581787,10581788,10581789,10581790,10569996,10585186,10573290,10582563,10567662,10567674,10567675,10567969,10567970,10567971,10567972,10567973,10567974,10567975,10567976,10567977,10567978,10567979,10567980,10567981,10567982,10567983,10567984,10567985,10567986,10567987,10567988,10567989,10567990,10567991,10567992,10567993,10567994,10567995,10567996,10567997,10567998,10567999,10568000,10568001,10568002,10568003,10525288,10525289,10525290,10529305,10525381,10525382,10520095,10520096,10520097,10520098,10520099,10520100,10520101,10520102,10520103,10520104,10520105,10520106,10520107,10520108,10520109,10520110,10520111,10520112,10520113,10424521,10422814,10425039,10421068,10473197,10481479,10473859,10473860,10473861,10489210,10480485,10480486,10487633,10487634,10487635,10487636,10487637,10487638,10487639,10487640,10487641,10487642,10487643,10487644,10487645,10487646,10487647,10476841) 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'