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(4970714,4970724,4970747,4970758,4970765,4970766,4970767,4970768,8067919,8067922,8067923,10939419,10939431,10939434,10939435,8065850,10623060,10623491,10623492,10623493,10623508,10623605,10623606,10621987,10622027,10622040,10622365,10622525,10610978,10610984,10610985,10614024,10614027,10611048,10614048,10614050,10614066,10614078,10614079,10614085,10614086,10614089,10611095,10611126,10611141,10611179,10614214,10614220,10611232,10614259,10611267,10614274,10611275,10614282,10614287,10611293,10611295,10611298,10611302,10611304,10611311,10611313,10614314,10611315,10611316,10611317,10614327,10614328,10611328,10614329,10611334,10611335,10611336,10611338,10611339,10611343,10611348,10611358,10611367,10611368,10611369,10611370,10614376,10614411,10614427,10614432,10614443,10614463,10614464,10614475,10614476,10614485,10614486,10614488,10614489,10614492,10614501,10614537,10614541,10614569,10614572,10614592,10614629,10614632,10611710,10611711,10614713,10611716,10611745,10611746,10611750,10611764,10611773,10611774,10611788,10611801,10611802,10611812,10611819,10611823,10611830,10611831,10611832,10611833,10611834,10611835,10611854,10614858,10614859,10614862,10614863,10614864,10611878,10611879,10611895,10611956,10611957,10611958,10611968,10612030,10612032,10612033,10612034,10612042,10612046,10612051,10612053,10612055,10609064,10612069,10612082,10612083,10612089,10612093,10612159,10612160,10612168,10612169,10612172,10612173,10612179,10609239,10612248,10612263,10612264,10612265,10612267,10612273,10612284,10609284,10609285,10612285,10612286,10612287,10612294,10609305,10612328,10609334,10609336,10612341,10612342,10612344,10609355,10609360,10612384,10609402,10612407,10612408,10612409,10612410,10612411,10612412,10612414,10612417,10612424,10612426,10612427,10612428,10612429,10612430,10612431,10612433,10612434,10609438,10612440,10612442,10609443,10609444,10612465,10609470,10609471,10612480,10612483,10612484,10612485,10612486,10612487,10612488,10612489,10612490,10612491,10612492,10612493,10612496,10612497,10612498,10612499,10612500,10612501,10612502,10612503,10612505,10612506,10612507,10612508,10612509,10612510,10612513,10612516,10612517,10612518,10612519,10612520,10612521,10612522,10612523,10612524,10612525,10612526,10612527,10612528,10612529,10612530,10612531,10612532,10612534,10612535,10612536,10612538,10612539,10612542,10612543,10612546,10612547,10612551,10612552,10612553,10612554,10612555,10612556,10609556,10612557,10612558,10612559,10612562,10612563,10612565,10612566,10612567,10612568,10612570,10612571,10612573,10612575,10612577,10612578,10612579,10612580,10612583,10612584,10612585,10612586,10612587,10612588,10612589,10612592,10612594,10612595,10612596,10612597,10612599,10612601,10612604,10612608,10612609,10612611,10612618,10612619,10612620,10612622,10612623,10612624,10612625,10612626,10612633,10612635,10612637,10612638,10612639,10612641,10612642,10612643,10612644,10612645,10612646,10612647,10612648,10612650,10612651,10612652,10612653,10612655,10612657,10612658,10612659,10612660,10612661,10609662,10612663,10612664,10612666,10612667,10612668,10612673,10612675,10612677,10612678,10612679,10612680,10612681,10612682,10612683,10612684,10612685,10609685,10612687,10612688,10612689,10612690,10609694,10609695,10612697,10612698,10612699,10612700,10612701,10612702,10612703,10612704,10609704,10612705,10609705,10612706,10612707,10612711,10612713,10612714,10612715,10612716,10612717,10612718,10612720,10612721,10612722,10612724,10612725,10612727,10612728,10612729,10612730,10612734,10612736,10612737,10612746,10612755,10612757,10612763,10612765,10612766,10612767,10609770,10612771,10612782,10609818,10609819,10612824,10612825,10609826,10609828,10612833,10612834,10612836,10612837,10612838,10609838,10612839,10612840,10612841,10612842,10612843,10609843,10612844,10609844,10612845,10612846,10612847,10612848,10612850,10612852,10612853,10612856,10612860,10612862,10612863,10612864,10612865,10612866,10609866,10612867,10612868,10612869,10612870,10612871,10609871,10609872,10612872,10612873,10612874,10612875,10609875,10612876,10612877,10612878,10612879,10612880,10612881,10612882,10612884,10609887,10612896,10612897,10612898,10612900,10612907,10612912,10612914,10612915,10612924,10612932,10612933,10612936,10612937,10612938,10612939,10612941,10612942,10612943,10612945,10612951,10609966,10609967,10609975,10609976,10609978,10609979,10609981,10612984,10609998,10610006,10613019,10610035,10610037,10610039,10610041,10610042,10610044,10610046,10610048,10610053,10610054,10610067,10613079,10613080,10613087,10613091,10613095,10610108,10613139,10613140,10613156,10613193,10610233,10610237,10610268,10610270,10610271,10613286,10610289,10610298,10613305,10613310,10610318,10610319,10613322,10610323,10613325,10613349,10613350,10610359,10610362,10610364,10610365,10613369,10610369,10610371,10610372,10610373,10610375,10610396,10610417,10610418,10610419,10610420,10610421,10610422,10610423,10610424,10610425,10610426,10610427,10613440,10613442,10610466,10610476,10610486,10610492,10610493,10613513,10613514,10613637,10613639,10613640,10613641,10613642,10613645,10613653,10613654,10610671,10613672,10610674,10610675,10610676,10613679,10610694,10613707,10613708,10613709,10613721,10610789,10610790,10610793,10610836,10610838,10613844,10610901,10610908,10610933,10610937,10610939,10610940,10610941,10610942,10610956,10610957,10610958,10517791,10517792,10517793,10416223,10419253,10415255,10419255,10419256,10415256,10419257,10415257,10419258,10415258,10419259,10415259,10416259,10415260,10419260,10419261,10419262,10415264,10415265,10415267,10415269,10415271,10415272,10415276,10415277,10415279,10415280,10415282,10415284,10415285,10419285,10419286,10415287,10419288,10415292,10419292,10415294,10419295,10419296,10415297,10419297,10419298,10415299,10419300,10419301,10419302,10419303,10419304,10419305,10419306,10419307,10419308,10419309,10415309,10419310,10415310,10419311,10419312,10419313,10415314,10419314,10419315,10419316,10419317,10419318,10415318,10419319,10419320,10416320,10415321,10419321,10419322,10415323,10419323,10419324,10419325,10419326,10419327,10419328,10419329,10419330,10419331,10415343,10415344,10419370,10419371,10419372,10419378,10419379,10419380,10419381,10419382,10419383,10419384,10419385,10419386,10419387,10419388,10419389,10419390,10419392,10419394,10419395,10415416,10415417,10415418,10415419,10415424,10415425,10415426,10415427,10415430,10415431,10415432,10415433,10415434,10415435,10415438,10415439,10415440,10415441,10415442,10415443,10415444,10415445,10415446,10416453,10415455,10415456,10416457,10416458,10416459,10416460,10416461,10416462,10416463,10416464,10419464,10416465,10419465,10416466,10416467,10416468,10416469,10416470,10416471,10416472,10416473,10416474,10416475,10416476,10416477,10416478,10416479,10416480,10416481,10415489,10415490,10415491,10415492,10415493,10419493,10415494,10416495,10415495,10415496,10415497,10415498,10415499,10415500,10415501,10415502,10415503,10415504,10415505,10415506,10415507,10415508,10415509,10415510,10415511,10415512,10415513,10415514,10415537,10415538,10419543,10419544,10419545,10419546,10419547,10419548,10419549,10419550,10419551,10419552,10419553,10419554,10419558,10419559,10419560,10419561,10419564,10419565,10419593,10416593,10416594,10416595,10416596,10416597,10416598,10416599,10416600,10416601,10416602,10416603,10416604,10416605,10416606,10416607,10416608,10416610,10416612,10416617,10415619,10415621,10415625,10415626,10415628,10415634,10416640,10415641,10416641,10415642,10416649,10416651,10419651,10416652,10419652,10416653,10419653,10419654,10416654,10416655,10419655,10416656,10419656,10419657,10419658,10416658,10419659,10416659,10419660,10419661,10416661,10416662,10419662,10419663,10419664,10419665,10415666,10415667,10415669,10415670,10415671,10416673,10416674,10415688,10415689,10416704,10416731,10416762,10416763,10416765,10416766,10416770,10416805,10419876,10419877,10419878,10419879,10419880,10419881,10415910,10415911,10415913,10415914,10416955,10416956,10416957,10416971,10416972,10416973,10416974,10416975,10416993,10416994,10416995,10417017,10417019,10416076,10416113,10416118,10416187,10416190,10416205,10416212,10470909,10471025,10471083,10471099,10471100,10471101,10471102,10471103,10471121,10471122,10471123,10471124,10471125,10469900,10469966,10470061,10470107,10470115,10470145,10470146,10470147,10470148,10470155,10470164,10470165,10470166,10470191,10470210,10470654,10470655,10470656,10470657,10470658,10470659,10470660,10470661,10470662,10470663,10470664,10470665,10470666,10470667,10470668,10470669,10470670,10470671,10470672,10470673,10470674,10470675,10470676,10470677,10470678,10470679,10470680,10470681,10470682,10470683,10470684,10470685,10470686,10470687,10470688,10470689,10470690,10470691,10470692,10470693,10470694,10470695,10470696,10470697,10470698,10470699,10470700,10470701,10470702,10470703,10470704,10470705,10470706,10470707,10470708,10470709,10470710,10470711,10470712,10470713,10470714,10470715,10470716,10470717,10470718,10470719,10470720) 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'