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(10943827,10943828,10943829,10943830,10943831,8583263,10950454,10950470,10950471,10950473,10437144,10437160,10437161,10099970,10099978,10099979,10099988,10099990,3228088,3228187,3228189,3228190,3228192,3228193,10858140,10931311,10931312,10931361,10931362,10931363,10931364,10931365,10931366,10931367,10931368,7064873,7064874,7064875,7064876,7064877,7064878,7064879,7064880,7064881,7064882,7064883,7064884,7064885,7064947,7064950,7064951,7064952,7064953,7064954,7064955,7064956,7064957,7064958,7064959,7064960,7064961,7064962,8572426,8572427,8572509,8572510,8572511,8572512,8572513,8572514,8572515,8572516,8572517,8572518,8572519,8572520,10099860,10099862,10099863,10099866,10099867,10099908,10099909,10099912,10929036,10929037,10099923,8834444,8834468,8834469,8834471,7069011,10100644,10100645,10100646,10100647,10100648,10100649,10100650,10100651,10100652,10100653,10100654,10100655,10100656,10100657,10100658,10100725,10100726,10100727,10100728,10100729,10100730,10100732,10100733,11035518,11035519,8859805,8859806,8859807,8859808,8615817,8859933,8859934,8859935,8859936,8859937,8859938,8859939,8859940,11035728,11035864,11035865,8070349,8070350,8070489,8070490,8070491,8070492,8070493,10955607,10955608,10955609,10955610,10955611,10955612,10955613,10955614,10955615,10955616,10955617,10955618,10955619,10955620,10955621,10955622,10955623,10955624,10955625,10955626,10955627,10955628,10955629,10955630,10955631,10955632,10955633,10955634,10955635,10838921,10955883,10955884,10955885,10955886,10955887,10955888,10955889,10955890,10955891,10955892,10955893,10955894,10955895,10955896,10955897,10955898,10955901,10955902,10955903,10955904,10955905,10955906,10955907,10955908,10955909,10955910,10955911,10955912,10955913,10955914,10955915,10955916,10955917,10955918,10955919,10955920,10955921,10955922,10955923,10955924,10955925,10955926,10955927,10955928,10955929,10955930,10955931,10955932,10955933,10955934,10955935,10955936,10955937,10955938,10955939,10955940,10955941,10955942,10955943,10955944,10955945,10955946,10955947,10955948,10955949,10955950,10956434,10956435,8553305,8553306,8553307,8553308,8553309,8553310,8553381,8553382,8553384,8553385,8553386,8553387,8553388,8553395,3923006,3923007,3923049,3923050,3923051,3923052,3923071,3923072,3923073,9216691,9216692,9216693,10425699,10425700,8610361,8610362,8610363,8610364,8610491,8610492,8610493,8610494,8610495,8610496,8610498,8610499,8633330,8540470,7154707,7154708,7154709,7154710,7154711,7154712,7154713,7154714,7154715,7154716,7154717,7154718,7154720,7154721,7154722,7154723,7154724,10851517,10851518,10851519,10851520,10851521,10851522,10851539,10851540,10851541,10851542,10851543,8904681,8904682,8904683,8904684,8904685,8904692,10714061,10714062,10714063,6665904,6665905,6665906,6665907,6665908,6665909,6665915,6665916,6665993,9163316,9163317,9163318,9163319,9163320,9163321,9163322,9163323,9163324,9163325,9163326,9163327,9163328,9163329,9163330,9163331,9163332,9163333,9163334,9163335,9163336,9163337,9163338,9163339,9163340,9163341,9163342,9163344,9163345,9163346,9163347,9163348,9163349,9163350,9163352,9163353,9163354,9163355,9163356,9163357,9163358,9163359,9163360,9163361,9163362,9163363,9163364,9163365,9163366,9163367,9163368,3652613,3652614,3652615,3652616,8861957,8566005,8566006,8566007,8566008,8566009,8566010,8566011,8566013,8566014,8566016,8566018,8566019,8566020,8566057,8566058,8566060,8566061,8566062,8566063,8566066,8566067,8566068,8566069,8566070,9163734,9163735,9163736,9163737,9163738,9163739,9163740,9163741,9163742,9163743,9163744,9163746,9163747,9163748,9163749,9163750,9163751,9163752,9163753,9163754,9163755,9163756,9163757,9163758,9163759,9163760,9163761,9163762,9163763,9163764,9163765,9163766,9163767,9163768,9163769,9163770,9163771,9163772,9163773,9163774,9163775,9163776,9163778,9163779,9163780,9163781,9163782,9163783,9163784,9163787,9163788,9163789,9163790,9163791,9163792,9163793,9163794,9163795,9163796,9163797,9163798,9163799,9163800,9163802,9219776,9163803,9219777,9219778,9219779,9219780,9219818,9219819,9219820,9219821,9219822,9219823,9219824,9219825,6676139,9221203,9221204,9221205,9221206,9221207,7056501,7056505,9178530,3652474,9911013,9911014,9911015,9911016,9911017,9911045,7055087,7055089,7055114,7055115,7055116,7055117,7055118,7055119,10659970,10659972,10659975,10659976,10659977,10659978,8549630,8549631,8549632,8549659,9166803,8916564,8916565,8916566,8916567,6671296,6671297,6671298,10427532,10878472,10878473,10878474,10878475,10878476,10878477,10878478,10878479,10878480,10878481,10878482,10878483,10878484,10878485,10878487,10878488,10878489,10878490,10878491,10878492,10878493,10878494,10878495,10878496,10878497,10878498,10878499,10878500,10878501,10878502,10878503,10878504,10878505,10878506,10878507,10878508,10893761,10946938,10946939,10946940,10946941,10946942,7000743,10878263,10878264,10878265,10878266,10878267,10878268,10878269,10878270,10878271,10878272,10878273,10878274,10878275,10878276,10878277,10878278,10878279,10878280,10878281,10878282,8593308,8593309,10878470,10878471,10157258,10157259,10157260,10157261,10157262,10157263,10157267,10157268,10157269,10157270,10157271,10157272,10157277,10157278,10157279,10157280,10157281,10157282,10157283,10157284,10157285,10157286,10157287,10157288,10157290,10157292,10157293,10157294,10157295,10157296,10157297,10157298,10157299,10157300,10157301,10157302,10157303,10157304,10157306,10157307,10157308,10157309,10157310,10157311,10157312,10157313,10157314,10574131,10571146,10571560,10605562,10575917,10645095,10645096,10645097,10645098,10645099,10645100,10645101,10607604,10607605,10607606,10502530,10502531,10502532,10502533,10502534,10502535,10502536,10502537,10502538,10502539,10502540,10502541,10502542,10502543,10502544,10502545,10502546,10502547,10502548,10502549,10502550,10502551,10502552,10502553,10502554,10502555,10502556,10502557,10502558,10502559,10502560,10502561,10502562,10502563,10502564,10502565,10502566,10502567,10502568,10502569,10502570,10502571,10502572,10502573,10502574,10502575,10502576,10502577,10502578,10502579,10502580,10502581,10502582,10502583,10502584,10502585,10502586,10502587,10502588,10502589,10502590,10502591,10502592,10502593,10502594,10502595,10502596,10502597,10502598,10502599,10502600,10502601,10502602,10502603,10502604,10502605,10502606,10502607,10502608,10502609,10502610,10502611,10502612,10502613,10502614,10502615,10502616,10502617,10502618,10502619,10502620,10502621,10502622,10502623,10502624,10502625,10502626,10502627,10502628,10502629,10502630,10502631,10502632,10502633,10502634,10502635,10502636,10502637,10502638,10502639,10502640,10502641,10502642,10502643,10502644,10502645,10502646,10502647,10502648,10502649,10502650,10502651,10502652,10502653,10502654,10502655,10502656,10502657,10502658,10502659,10502660,10502661,10502662,10502663,10502664,10502665,10502666,10502667,10502668,10502669,10502670,10502671,10502672,10502673,10502674,10502675,10502676,10502677,10502678,10502679,10502680,10501867,10501868,10501869,10501870,10501871,10501872,10501873,10501874,10501875,10501876,10501877,10501878,10501879,10501880,10501881,10501882,10501883,10501884,10501885,10501886,10501887,10501888,10501889,10501890,10501891,10501892,10501893,10501894,10501895,10501896,10501897,10501898,10501899,10501900,10501901,10501902,10501903,10501904,10501905,10501906,10501907,10501908,10501909,10501910,10501911,10501912,10501913,10501914,10501915,10501916,10501917,10501918,10501919,10501920,10501921,10501922,10501923,10501924,10501925,10501926,10501927,10501928,10501929,10501930,10501931,10501932,10501933,10501934,10501935,10501936,10501937,10501938,10501939,10501940,10501941,10501942,10501943,10501944,10501945,10501946,10501947,10501948,10501949,10501950,10501951,10501952,10501953,10501954,10501955,10501956,10501957,10501958,10501959,10501960,10501961,10501962,10501963,10501964,10501965,10501966,10501967,10501968,10501969,10501970,10501971,10501972,10501973,10501974,10501975,10501976,10501977,10501978,10501979,10501980,10501981,10501982,10501983,10501984,10501985,10501986,10488495,10488499,10488500,10488502,10488503,10488504,10488513,10488514,10488515,10488516,10488519,10488520,10488521,10488522,10488523,10488524,10471928,10471932,10471935,10471936,10471937,10471939,10471940,10471942,10471943,10471944,10471946,10714669,10714670,10408420,10408421,10408422,10408423,10408424,10408425,10408434,10408435,10412711,8562115,8562116) 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'