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(11014740,7076104,7076221,10846139,10846140,10846141,10846142,10846143,10846144,10846145,10846146,10846147,10846148,10846149,10846150,10846151,10846152,10846153,10846154,10846155,10846156,10846157,10846158,10846159,10846160,10846161,10846162,10846163,10846164,10846165,10846166,10846167,10846168,10846169,10846170,10846171,10846172,10846173,10846174,3228859,10846244,10846245,10846248,11015362,11015363,11015364,11015385,11015386,11015388,11015389,8583181,10950386,10950387,7074023,10989721,11028849,10950875,10950937,10847537,8609632,10938668,10929383,7067285,7067377,7067538,8620417,7067624,11014444,8838291,10972620,10972621,10972622,10972623,10972624,10972625,10972626,10972627,10972628,10972629,10972630,10972631,10972632,10972633,10972634,10972635,10972636,10972637,10972638,10972639,10972640,10972641,10972642,10972643,10972644,10972645,10972646,10972647,10972648,10972649,10972650,10972651,10972652,10972653,10972654,10972655,10972656,10972657,10972658,10972659,10972660,10972661,10972662,10972663,10972664,10972665,10972666,10972667,10972668,10972669,10972670,10972671,10972672,10972673,10972674,10972675,10972676,10972677,10972678,10972679,10972680,10972681,10972682,10972683,10972684,8911075,8911076,7072020,7072021,7064330,7064331,7064644,10104028,10999766,10999767,10999768,10999769,10999770,11012773,11012774,8836687,8619203,7073410,10932801,10932837,10932917,7065586,10932936,10932937,10932938,10932939,7065598,7073630,4967850,4967851,4967852,4967853,4967854,4967855,4967856,4967857,4967858,4967859,4967860,4967861,11026359,11026360,7065794,10841765,11036711,11036712,11036713,11036824,11036825,11036826,11037091,11037092,11037093,11037095,8064541,8064542,8064543,10972455,10972456,10972457,10972458,10972459,10972460,10972461,10972462,10972463,10972464,10972465,10972466,10972467,10972468,10972469,10972470,10972471,10972472,10972473,10972474,10972475,10972476,10972477,10972478,10972479,10972480,8910854,10972481,10972482,10972483,10972484,10972485,10972486,10972487,10972488,10972489,10972490,10972491,10972492,10972493,10972494,10972495,10972496,10972497,10972498,10972499,10972500,10972501,10972502,10972503,10972504,10972505,10972506,10972507,10972508,10972509,10972510,10972511,10972512,10972513,10972514,10972515,10972516,10972517,10972518,10972519,10972520,10972521,10972522,10972523,10972524,10972525,10972526,10972527,10972528,10972529,10972530,10972531,10972532,10972533,8970239,10972534,10972535,10972536,10972537,10972538,10972539,10972540,10972541,10972542,10972543,10972544,10972545,10972546,10972547,10972548,10972549,10972550,10972551,10972552,10972553,10972554,10972555,10972556,10972557,10972558,10972559,10972560,10972561,10972562,10972563,10972564,10972565,10972566,10972567,10972568,10972569,10972570,10972571,8910944,10972572,8910945,10972573,10972574,10972575,10972576,10972577,10972578,10972579,10972580,10972581,10972582,10972583,10972584,10972585,10972586,10972587,10972588,10972589,10972590,10972591,10972592,10972593,10972594,10972595,10972596,10972597,10972598,10972599,10972600,10972601,10972602,10972603,10972604,10972605,10972606,10972607,10972608,10972609,10972610,10972611,10972612,10972613,10972614,10972615,10972616,10972617,10972618,10972619,10100244,10100245,10100246,8563968,8563969,8563970,8563971,8563972,10840462,10840463,11047631,11035918,10841253,8565235,10971312,8834213,8834214,11049619,11049620,11049621,11049622,11049623,11019643,11032681,8613140,8613141,10838065,10623376,10838159,10838345,10838507,10838659,10838851,10838852,10920390,10920391,10920409,10920410,10839642,11031869,8612658,8612659,11006573,11006574,11006575,11006576,11006577,11006578,11006579,11006580,11006581,11006582,11006583,11006584,11006585,11006586,11006587,11006588,11006589,11006590,11006591,11006592,11006593,11006594,11006595,11006596,11006597,11006598,11006599,11006600,11006601,11006602,11006603,10615178,11042890,10848380,11043400,11043401,11043402,11043403,11043404,11043405,11030563,11030564,10952542,10952663,10916622,10916623,10916624,10916625,10916626,8611009,10916715,10916716,10916717,10916718,10916719,10916720,8611045,11018014,11018015,8611193,11031101,10921962,10921963,11018146,8577649,10927239,10922257,11005452,10953464,10953465,10953466,10953467,8577961,10953468,8577962,10922441,10922442,10922446,10922447,10922448,10922449,9205329,9205330,9205331,3962510,3962511,8542591,10119837,10119838,10119839,10119840,9171719,9195954,9172150,9172388,9204740,9204741,9204742,9204743,9204744,9204745,9204746,9204747,9204748,9204749,9204750,9204751,9204752,9204753,9204754,9204755,9205255,4974250,4974251,7015071,9201425,9193426,10117680,7055836,4974572,4974671,4974672,4974673,4974674,7056011,4974726,4974727,4974728,4974729,10126216,9186043,10516057,10516058,8551552,10118995,7057119,8552297,9203025,9203098,10119317,8861812,7014007,7014008,7014009,7014010,7014011,7014012,7014013,7014014,7014015,7014016,7014017,7014018,7014019,7014020,10124774,9200923,9176944,9176945,9176946,9176947,9176948,9176949,9176950,9176951,9176952,10117255,9201100,10117306,9161172,9161173,9161174,9161175,9161176,9161177,9161178,9161179,9161180,9161181,9161182,9161183,10463347,10463348,10463349,10463350,10463351,10463352,10463353,10463354,10463355,10463356,10463357,10463358,10463359,9174800,9174872,9174873,9174874,8550494,8550495,10123763,10116020,10116021,10116022,10116023,10116024,10116025,10462424,9192099,8551273,8551294,8917790,10124378,10946287,10946288,10946289,10946290,10946291,10946292,10946293,10946294,10946295,10946296,10946297,10946298,10946299,10946300,10946301,10946302,10946303,10946304,10946305,10946306,10946307,10946308,10946309,10946310,10179604,10628278,10155396,10155397,10155398,10155399,10155400,10155401,10155402,10155403,10155404,10155405,10155406,10155407,10155408,10155409,10155410,10155411,10155412,10155413,10155414,10155415,10155416,10155417,10155418,10155419,10155420,10155421,10155422,10155423,10155424,10155425,10155426,10155427,10629470,10176243,10880290,10166375,10183886,10183887,10183888,10183889,10183890,10183891,10183892,10183893,10183894,10183895,10183896,10178987,10178988,10178989,10178990,10184001,10184002,10184003,10184013,10184089,10184090,10184091,10184092,10184093,10179095,10179096,10179097,10184245,10184246,10174436,10174458,10174464,10174467,10630021,10161606,10156692,10630242,10630243,10167026,10167027,10167028,10167029,10167030,10167031,10167032,10167033,10167034,10167035,10167036,10167037,10167038,10167039,10167040,10167041,10167042,10167043,10167044,10167045,10167046,10167047,10167048,10167049,10167050,10167051,10167052,10167053,10167054,10167055,10167056,10167057,10167058,10167059,10167060,10167061,10167062,10167063,10167064,10167065,10167066,10167067,10167068,10167069,10167070,10167071,10167072,10167073,10172074,10167074,10167075,10167076,10167077,10167078,10167079,10167080,10167081,10167082,10167083,10167084,10167085,10167086,10167087,10167088,10167089,10167090,10167091,10167092,10167093,10167094,10167095,10167096,10167097,10167098,10167099,10167100,10167101,10167102,10167103,10167104,10167105,10167106,10167107,10167108,10167109,10167110,10167111,10167112,10167113,10167114,10167115,10167116,10167117,10167118,10167119,10167120,10167121,10167122,10167123,10167124,10167125,10167126,10167127,10167128,10167129,10167130,10167131,10167132,10167133,10167134,10167135,10167136,10167137,10167138,10167139,10167140,10167141,10167142,10167143,10167144,10167145,10167146,10167147,10167148,10167149,10167150,10167151,10167152,10167153,10167154,10167155,10167156,10167157,10167158,10167159,10167160,10167161,10167162,10167163,10167164,10167165,10167166,10167167,10167168,10167169,10167170,10167171,10167172,10167173,10167174,10167175,10167176,10167177,10167178,10167179,10167180,10167181,10167182,10167183,10167184,10167185,10167186,10167187,10167188,10167189,10167190,10167191,10167192,10167193,10167194,10167195,10167196,10167197,10167198,10167199,10167200,10167201,10167202,10167203,10167204,10167205,10167206,10167207,10167208,10167209,10167210,10167211,10167212,10167213,10172267,10187336,10172424,10876571,10876572,10876573,10876574,10876575,10876576,10876577,10876578,10876579,10876580,10876581,10876582,10187896,10187913,10574245,10574246,10574247,10574248,10574249,10574250,10574251,10580257,10580258,10580259,10586569,10644242,10644243,10644244,10644245,10644246,10644247,10644248,10644249,10644250,10644251,10644252,10644253,10644254,10644255,10587238,10587239,10587240,10572353,10572354,10572355,10572356,10569803,10569804,10585276,10585277,10585278,10585279,10573317,10585471,10585472,10520437,10520438,10520439,10520440,10520441,10520442,10520443,10520444,10520445,10520446,10520447,10520448,10520449,10520450,10520451,10520452,10520453,10520454,10520455,10520456,10520457,10520458,10520459,10520460,10522796,10498231,10424454,10490330,10490331,10490341,10490342,10490343,10473703,10473711,10473712,10493390,10493502,10495789) 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'