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(10939575,10939583,10939590,10939605,10939606,10939608,10939609,10939613,10939797,10939963,10940099,10940153,10940182,10940191,10940199,10940444,4971100,4971104,4971105,4971106,10940490,10940509,10940510,10940511,8066888,8066898,8066899,8066900,8066911,8066912,8066913,8066914,8066915,8067214,8067324,4968633,8067369,4968638,4968639,4968640,4968641,8067533,8067534,8067548,10938503,10938504,10938505,10938506,10938507,10938508,10938509,10938510,10938731,10938732,4969493,4969494,4969495,4969496,4969497,4969498,4969499,4969500,4969501,4969502,4969503,4969504,4969505,4969506,4969507,4969508,4969509,4969510,4969511,4969512,4969513,4969514,4969515,4969516,4969517,4969518,4969519,4969520,4969521,4969522,4969523,4969524,4969628,4969629,4969630,4969631,4969632,4969633,4969634,4969635,4969636,4969637,4969638,4969639,4969640,4969641,4969642,4969643,4969644,4969645,4969646,4969647,4969648,4969649,4969650,4969651,4969652,4969653,4969654,4969655,4969656,4969657,4969658,4969659,4969660,4969661,4969662,4969663,4969664,4969665,4969666,4969667,4969668,4969669,4969670,4969671,4969672,4969673,4969674,4969675,4969676,4969677,4969678,4969679,4969680,4969681,4969682,4969683,4969684,4969685,4969686,4969687,4969688,4969689,4969690,4969691,4969692,4969693,4969694,4969695,4969696,4969697,4969698,4969699,4969700,4969701,4969702,4969703,4969704,4969705,4969706,4969707,4969708,4969709,4969710,4969711,4969712,4969713,4969714,4969715,4969716,4969717,4969718,4969719,4969720,4969721,4969722,4969723,4969724,4969725,4969726,4969727,4969728,4969729,4969730,4969731,4969732,4969733,4969734,4969735,4969736,4969737,4969738,4969739,4969740,4969741,4969742,4969743,4969744,4969745,4969746,4969747,4969748,4969749,4969750,4969751,4969752,4969753,4969754,4969755,4969756,4969757,4969758,4969759,4969760,4969761,4969762,4969763,4969764,4969765,4969766,10939146,4969767,10939147,4969768,4969769,10939148,10939149,4969770,4969771,10939150,4969772,10939151,4969773,10939152,4969774,10939153,4969775,10939154,10939155,4969776,4969777,10939156,4969778,10939157,4969779,10939158,4969780,10939159,4969781,10939160,4969782,10939161,10939162,4969783,4969784,10939163,4969785,10939164,4969786,10939165,4969787,10939166,4969788,10939167,10939168,4969789,10939169,4969790,4969791,4969792,4969793,4969794,4969795,4969796,4969797,4969798,4969799,4969800,4969801,4969802,4969803,4969804,4969805,4969806,4969807,4969808,4969809,4969810,4969811,4969812,4969813,4969814,4969815,4969816,4969817,4969818,4969819,4969820,4969821,4969822,4969823,10939203,4969824,4969825,10939204,4969826,10939205,4969827,10939206,4969828,10939207,10939208,4969829,4969830,10939209,4969831,10939210,4969832,10939211,4969833,10939212,4969834,10939213,4969835,10939214,4969836,10939215,10939216,4969837,4969838,4969839,4969840,4969841,4969842,4969843,4969844,4969845,4969846,4969847,4969848,4969849,4969850,4969851,4969852,4969853,4969854,4969855,4969856,4969857,4969858,4969859,10939380,10939381,10939384,10939458,8065151,8065152,8065153,8065154,8065155,8065156,8065157,8065158,8065159,8065160,8065235,8065236,8065237,8065238,8065239,8065240,8065241,8065242,8065243,8065244,8065245,8065246,8065247,8065248,8065249,8065250,8065251,8065252,8065253,8065254,8065255,8065256,8065257,8065258,8065259,8065260,8065261,8065262,8065263,8065264,8065265,8065266,8065267,8065268,8065269,8065270,8065271,8065272,8065273,8065274,8065275,8065276,8065277,8065278,8065279,8065280,8065281,8065282,8065283,8065284,8065285,8065286,8065287,8065288,8065289,8065290,8065291,8065292,8065293,8065294,8065295,8065296,8065297,8065298,8065299,8075225,8075298,4967148,4967149,4967150,4967151,4967152,4967153,4967154,4967155,4967156,4967157,4967158,4967159,4967160,8065961,8065962,8066033,8066034,8066035,8066036,8066037,8066038,8066039,8066040,8066126,8066452,8066453,8066454,8066467,8066471,8066472,8066509,8066516,8066528,8066581,8066582,8066592,8066609,8066620,8066681,8066781,8066877,8066878,8970134,8970135,8064013,8064014,3655547,3655564,3655565,3655701,3655702,3655703,3655704,3655705,3655706,3655707,3655708,3655710,3655711,3655712,3655713,3655714,3655715,3655716,3655717,3655747,3655748,3655749,3655750,3656193,3656194,3656195,3656196,3656203,3656204,3656205,3656298,3656299,3656300,3656301,8072554,8072555,8072586,8072587,3656462,3656463,8072753,8072754,8072755,8072756,8072757,8073024,8073025,8073026,8073027,8073028,8073030,8073044,8073045,8073046,8073047,8073048,3657267,8970109,8970110,8970111,8970112,8970113,8970114,8970115,8970116,8970117,8970118,8970119,8970120,8970121,8970122,8970123,8970124,8970125,8970126,8970127,8970128,10622993,10622994,10622995,10622997,10622998,10622999,10918549,10623057,10918617,10918738,10623334,10623428,10918960,10918989,10918990,10918991,10918992,10918993,10918994,10918995,10623605,10623606,10919331,10919332,10919673,10919674,10919855,10919856,10919857,10919870,10919871,10920222,10621981,10917549,10917550,10917551,10917552,10917553,10917554,10917690,10622260,10622261,10622263,10622270,10622272,10622277,10622279,10622305,10622343,10622361,10622362,10622363,10622364,10622366,10622371,10622376,10622378,10622379,10622399,10622400,10622417,10622425,10622433,10622434,10622438,10622439,10622457,10622458,10622506,10622521,10622524,10622525,10622527,10622528,10622530,10622535,10622537,10622538,10918050,10622939,10622940,10620014,10620015,10620016,10620018,10620209,10620210,10620211,10620212,10620239,10620240,10620241,10620252,10620361,10620362,10620491,10916106,10916107,10916108,10916109,10916110,10916111,10916112,10916113,10916114,10916115,10916116,10916117,10916118,10916119,10916120,10621282,10621283,10621360,10621361,10621363,10621364,10621365,10621366,10621369,10621370,10621373,10621424,10621430,10621431,10621434,10621442,10621443,10621494,10621495,10621498,10621499,10621504,10621506,10621509,10621512,10621535,10621536,10621579,10621612,10621613,10621614,10621616,10621617,10621618,10917219,10611025,10611198,10611224,10611342,10611345,10611346,10611347,10565673,10611801,10611802,10611830,10609392,10609848,10609849,10609850,10609928,10609978,10610001,10610002,10610003,10610004,10610005,10610045,10610197,10564428,10564429,10564430,10610282,10564433,10564434,10564435,10564436,10564437,10564438,10564439,10610289,10564440,10564443,10610357,10610362,10610364,10610372,10610373,10610501,10610694,10610702,10610703,10564991,10564995,10610862,10517555,10555577,10555578,10517714,10517715,10517716,10517717,10555844,10555845,10555846,10555847,10555857,10555858,10555859,10517958,10517959,10517960,10517961,10517962,10517963,10517964,10517965,10517966,10517967,10517968,10517969,10517970,10517971,10517972,10517973,10517974,10517975,10517976,10556066,10556079,10556080,10518145,10518146,10518147,10518424,10518425,10518426,10518427,10518428,10518429,10518430,10518431,10518432,10518433,10518434,10518435,10518436,10518437,10518438,10518439,10518440,10518441,10518442,10518443,10518444,10518445,10518446,10518447,10518448,10518449,10518450,10518451,10518452,10556906,10556907,10556908,10556909,10556910,10556911,10556912,10556913,10556914,10556915,10556916,10556917,10556918,10556919,10556920,10556921,10556922,10556923,10556924,10556925,10556926,10556927,10556928,10556929,10556930,10556931,10556932,10556933,10556934,10556935,10556936,10556937,10556938,10556939,10556940,10556941,10556942,10556943,10556944,10556945,10556946,10556947,10556948,10556949,10556950,10556951,10556952,10556953,10556954,10556955,10556956,10556957,10556958,10556959,10556960,10556961,10556962,10556963,10556964,10556965,10556966,10556967,10556968,10556969,10556970,10556971,10556972,10556973,10556974,10556975,10556976,10556977,10556978,10556979,10556980,10556981,10556982,10556983,10556984,10556985,10556986,10556987,10556988,10556989,10415234,10415235,10415304,10415305,10419364,10419365,10415371,10415377,10419388,10419389,10419390,10419391,10415423,10415460,10415461,10415462,10415463,10415464,10415465,10415466,10419569,10419570,10415732,10415733,10415734,10415785,10415817,10415833,10415884,10419908,10419909,10419910,10419911,10419912,10419913,10419914,10419915,10419916,10419918,10419919,10419920,10419922,10419924,10419926,10419927,10419928,10419929,10419930,10419931,10419932,10419933,10419934,10419935,10419939,10419940,10419941,10419943,10419945,10419946,10419947,10419948,10419949,10415950,10419950,10415960,10415961,10415977,10415984,10415988,10415994,10420003,10420005,10416140,10416141,10416169,10463010,10463055,10463403,10463438,10463733,10463803,10463814,10463815,10463816,10463817,10469909,10469918,10469950,10469953,10470407,10470529,10470630) 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'