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(10962637,10962689,7068176,10943628,10940343,7068720,7068725,7068728,7068731,7068732,7068734,7068735,7068736,7068737,7068739,7068741,7068743,7068745,8569722,7068752,7068757,7068758,7068767,7068774,10940403,10940404,10940405,10940408,10940409,10940410,10940413,10940414,10940415,7068792,10940418,8569777,8569778,7068802,10963487,8569779,7068806,7068808,8569785,7068810,8569786,8569787,8569788,7068813,8569789,7068814,8569791,8569792,7068816,10940440,8569793,8569794,10940441,10940442,8569795,10940443,8569796,8569797,8569801,8569802,8569803,8569805,8569806,7068831,8569807,7068832,8569808,7068833,7068835,7068837,7068839,7068841,7068842,7068843,7068844,7068845,7068861,7068867,7068915,7068916,7068917,7068918,7068919,7068920,7068921,7068922,7068923,7068930,7068931,8066960,10963667,8066961,10963668,8066966,7074192,7074266,7074290,7074292,10977246,10977272,10977289,10977290,10977291,10977292,10977293,10977294,10977295,10977296,10977297,10977298,10977299,10990310,10977320,10977326,10977354,10977368,10977370,10977371,10977399,10977428,10977429,10977430,4968962,4968963,4968964,4968965,10977436,10977443,10977451,8067746,10977454,10977483,10977485,7066802,10977492,10977493,10977494,10977495,10977496,10977497,10977498,10977499,10977500,10977501,10977502,10977503,10977504,10977505,10977506,10977507,10977508,10977509,10977510,10977511,10977512,10977513,10977514,10977515,10977516,10977517,10977518,10977519,10977520,10977521,10977522,10977523,10977524,10977525,10977526,10977527,10977528,10977529,10977530,10977531,10977532,10977533,10977534,10977535,10977536,10977537,10977538,10977539,10977540,10977541,10977542,10977543,10977544,10977545,10977546,10977547,10977548,10977549,10437719,10977550,10977551,10977552,10977553,10977554,10977555,10977556,10977557,10977558,10977559,10977560,10977561,10977562,10977563,10977564,10977565,10977566,10964566,10964567,10977567,10977568,10977569,10977570,10977571,10977572,10977573,10977574,10977575,10977576,7066894,10987656,10987678,10987680,7075053,10961917,10961918,7075248,7067250,10961939,10961940,10961945,10961950,10961951,10961952,10987956,10987957,8068215,8068283,7067446,8068368,10962198,10962234,10939190,10988336,10988337,10988338,8068569,10988378,10988379,10988384,10988395,10988396,7075751,10962452,10962593,8068804,8068806,10962611,8064955,8064956,10972674,10972679,10972681,10972682,7072039,7072225,7072274,10960010,10960011,10973079,10973082,10973083,10973093,10973094,10986173,10960228,10960229,7072553,7064569,10986355,10986397,10986432,10986433,10986435,10986436,10986437,10986438,10986439,10986524,10986525,7072884,7072911,7072932,7072933,7073117,7073118,10960807,7073163,7073174,10932544,8066196,8066214,8066215,8066216,8066217,8066299,7065457,8066438,10932916,10933013,10933261,10971629,10971651,10971690,7071014,10971701,10971706,10971714,10971719,10971807,10984908,10971948,10984959,10971982,10971989,10984999,10985009,10972015,10972016,10972025,10985027,10985035,10972039,10972045,10972046,10972047,10985055,10972083,10959087,10972118,10972147,10972188,10972189,10959201,10959202,10959203,10959204,10959205,10972300,10972301,10972302,10972303,10972304,10972337,10972339,10972348,10972384,10972486,8970200,10972499,10972503,10972505,10972507,10972513,10972515,10972516,10972525,10972527,7071857,10972548,10972549,10972551,10972569,10972581,10972582,10972585,10972586,10972591,10972592,10940724,10940725,10940743,7069223,7069224,7069268,10944693,10944709,7069414,10944954,10944989,10941266,10957382,3656271,3656272,3656273,3656274,3656519,10957659,10957660,10957661,10957662,10957663,3656647,3656654,7070091,3656817,10970994,10970998,11048691,11048692,11049692,11049693,11049694,10971553,10971611,10971612,10971613,10971614,10971615,10971616,10971617,10971618,10618299,10623492,10968179,10619016,10619017,10968686,10624122,10624123,10619350,10619844,10956521,10922567,10922568,10922574,10922575,10622093,10953892,10953893,10622306,10622341,10622478,10617573,10925617,10925618,10925619,10925620,10920660,10920663,10615225,10964884,10964885,10615227,10615228,10925826,10925879,10620404,8570383,10921234,10921268,10921303,10921304,10921305,10921306,10921310,10921311,10921312,10930733,10921313,10930734,10921314,10930751,10921534,10621117,10621118,10621120,10621121,10621124,10621125,10621126,10621127,10621128,10621129,10621130,10621131,10621133,10621134,10621135,10621136,10621144,10621145,10621147,10621148,10621149,10621151,10621152,10621155,10621156,10621157,10621158,10621159,10621160,10621161,10616173,10952894,10952895,10621255,10621256,10621257,10621346,10621347,10621369,10922027,10621675,10610965,7059477,7059478,10613979,10565155,7059722,7059723,10614317,10559714,10559735,10559736,10559737,10614624,10611859,6666232,6666239,10611952,10557113,10611981,10557232,10557233,10557234,10557235,10557236,10557237,10557238,10557239,10557240,7057596,8862003,10612206,10609282,10609422,10612518,10612546,10612633,7058164,7058165,7058166,7058167,7058168,10609715,10609716,10612767,10609794,10609836,7058368,7058370,7058377,7058470,10558142,10610017,8862927,10610070,10613112,7058752,10558443,10558446,10613298,10613369,8863297,8863298,8863299,10558647,10613504,10558669,10558682,10558686,10558687,8863462,10610677,10610679,10610946,10610952,10555124,10555125,10555126,10555127,10555128,10555129,10555130,10555131,10555132,10555133,10555134,10555135,10555136,10555137,10555138,10555139,10555140,10555141,10555142,10555143,10555144,10555145,10555146,10555147,10555148,10555149,10555150,10555151,10555152,10555153,10555154,10555155,10555156,10555157,10555158,10555159,10555160,7055530,10555238,7055636,10517287,10517288,10517298,10517299,10515330,10515331,10515332,10515333,10515334,10515335,10515336,7055724,10515437,10515438,10515439,7055836,10515597,10515598,10513625,7056001,10517669,10517672,10513723,10513724,10513725,10515728,10515729,10513832,10513833,4974979,4974980,4974981,4974989,10514000,7056356,4975050,7056390,7056399,7056400,7056401,7056412,7056417,7056418,7056419,7056420,7056423,7056424,7056425,7056426,7056427,7056428,7056429,7056430,7056431,7056432,7056433,7056437,7056438,7056439,7056440,7056441,7056442,7056443,7056444,7056448,7056449,7056450,7056451,10512210,10512211,10512212,10512213,4975264,10514279,10514363,10512379,10512380,10512381,10512382,10512383,10512384,10512385,10512386,10512387,10512388,10512389,10512390,10512391,10512392,10512393,10512394,10512395,10512396,10512397,10512398,10512399,10512400,10512401,10512402,10512403,10512404,10512405,10512406,10512407,10512408,10512409,10512410,10512411,10512412,10512413,10512414,10512415,7056956,7056960,7056961,7056964,10514616,10514617,10514618,7056987,7056988,7056989,7056990,7056991,7056992,7056993,7056994,7056995,7056996,7057027,7057028,7057029,7057030,7057031,7057032,7057033,7057034,10516936,10516937,10516938,10516939,10516940,10516941,10516942,10516943,10516944,10516945,10516946,10516947,10516948,10516949,10516950,10516951,10516952,7057321,10557073,10557098,7057453,10557101,8917947,8917948,8917949,10417224,8917950,10417282,8918022,8918023,8918024,10417342,10416346,10416418,10419459,10417554,10416711,10418716,10418720,10418724,10418728,10417821,10417822,10417827,10417828,10419897,10417944,10417010,10418149,10417213,7055460,10417216,10417218,10417220,8864898,8864914,10463004,10463007,8864985,10463044,8865056,10467114,10471161,4971474,10465271,10465272,10465273,10465274,10465275,10463655,10463662,10463665,4971954,4971961,4971962,4971968,4971969,4971970,4971971,4971972,4971973,4971974,4971976,4971981,4971982,4971988,4971989,4971990,4971991,4971994,4971995,4971996,4971997,4972002,4972003,4972004,4972005,4972018,4972019,4972020,10465790,10467864,10469921,10463926,8917185,8917186,8917187,8917188,8917190,8917191,8917193,8917194,8917195,8917196,8917197,8917198,8917199,8917200,8917201,8563456,10466214,10464298,10462315,10466324,10466391,10468420,10462454,10462455,10464477,10464478,10464479,10462536,10464806,10154620,10628246,10628247,10628250,10155755,10155756,10155757,10155758,10155759,10155760,10155761,10155762,10155763,10629815,10627101,10627751,10627787,10627814,10627840,10627841,10627849,10627884,10627886,10627921,10627924,10630100,10630101,10630102,10630103,10630104,10630105,10625211,10630854,10630855,10631110,10626135,10631241,10631291,10626314,10626325,10626442,10631683,10631684,10631850,10521170,10521171,10521182,10521183,10521254,10521260,10521261,10521263,10521264,10521903,10522155,10522259,10522455,10522840,10520863,10520948,10520949,10520950,10520951,10520952,10520953,10520954,10421276,10421951,10421952,10421954,10421955,10421956,10421072,10421075,10421076,10421077,10421078,10421080,10422159,10422188,10475665,10475722,10475723,10475724,10475725,10475726,10475727,10473953,10474123,10472820,10472822,10472823,10472824,10472825) 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'