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,4970759,4970762,4970763,4970765,4970766,7065968,7065982,7066011,7066027,7066056,7066061,7066137,7066213,7066214,7066230,7066239,7066244,7066245,7066246,7066249,7066267,8067903,8067921,8067922,8067923,8067924,8067925,8067930,8067932,10939390,10939439,7064547,7064548,8065809,7065918,7065919,8064692,10944446,11048369,11048370,11048402,11048403,11048404,11048434,11048436,11048440,11048456,11048475,11048481,11048485,11048490,11048491,10623505,10623959,10621987,10622406,10622429,10622454,10622537,10620121,10610999,10613999,10611037,10614048,10614050,10611053,10611054,10614054,10611055,10614098,10614102,10614103,10611147,10611150,10611176,10614178,10611179,10614179,10614180,10614188,10614189,10614193,10614205,10611223,10611232,10614287,10611304,10611313,10614321,10614363,10611370,10614377,10614379,10614411,10614427,10614443,10614444,10614445,10614446,10614452,10614455,10614475,10614487,10614489,10611508,10614516,10559704,10559708,10559710,10559712,10614566,10614567,10614568,10614588,10559766,10614639,10614642,10614669,10611685,10611712,10614713,10611736,10611745,10611746,10614770,10611783,10614819,10611823,10611830,10611831,10611832,10611833,10611834,10611835,10611852,10614853,10614854,10611854,10611857,10614858,10614859,10614864,10611864,10611895,10614935,10614936,10611959,10611960,10611961,10614961,10611962,10608986,10608987,10608988,10611989,10608989,10608990,10608991,10608992,10608993,10608994,10608995,10608996,10608997,10608998,10608999,10609000,10609001,10609036,10612042,10612046,10609064,10612089,10612093,10609093,10609095,10609096,10609097,10609098,10609102,10612108,10612121,10612126,10609133,10609138,10612159,10612160,10612189,10609229,10609230,10609261,10612267,10612270,10612271,10612284,10609284,10609285,10612294,10612328,10612330,10612344,10609347,10609360,10609362,10609363,10609364,10609366,10609367,10612381,10609397,10609398,10612408,10612409,10612410,10612433,10612471,10612487,10612497,10612505,10609505,10612506,10612507,10612508,10612509,10612510,10612513,10612517,10612519,10612520,10612521,10612522,10612523,10612524,10612525,10612529,10612530,10612534,10612539,10612542,10612543,10612544,10612545,10612546,10612554,10612562,10612577,10612578,10612579,10612580,10612586,10612587,10612588,10612599,10612602,10612605,10612606,10612607,10612608,10612609,10612610,10612613,10612615,10612616,10612617,10612622,10612638,10612650,10612652,10612659,10609676,10612678,10612681,10612682,10612683,10612691,10609694,10609695,10612702,10612703,10612706,10609719,10609723,10612727,10612728,10612729,10612741,10609751,10609752,10612756,10612757,10609764,10609765,10609772,10612773,10612774,10612775,10612776,10612777,10612778,10612779,10612780,10612782,10612800,10612803,10612804,10612810,10612811,10612812,10612813,10612815,10609815,10612816,10609817,10609818,10609819,10612823,10612825,10609826,10609827,10612835,10612841,10612843,10612845,10612850,10612852,10612854,10609854,10609855,10612856,10609856,10609857,10609858,10609859,10609860,10609861,10609862,10609863,10612863,10612864,10609864,10609865,10609866,10609867,10609868,10609869,10609870,10612871,10609871,10612872,10609872,10612873,10609873,10609874,10609875,10609876,10609877,10612877,10612878,10609878,10609879,10609880,10609881,10609882,10609897,10609925,10609926,10609927,10612940,10612942,10609944,10609949,10612958,10612960,10612961,10612962,10609965,10612966,10612968,10609968,10609969,10612969,10612974,10609976,10609983,10609990,10610006,10613019,10610025,10613026,10613034,10610041,10610048,10610053,10610054,10610067,10610077,10613078,10613125,10613145,10613157,10613187,10610197,10613230,10610233,10610260,10610271,10610289,10613293,10613294,10613295,10610296,10613296,10613297,10613298,10613299,10613300,10613301,10613302,10613303,10613304,10610310,10610311,10613311,10613342,10613350,10613356,10613357,10610364,10613365,10610365,10613366,10613367,10613368,10613369,10610408,10610409,10610410,10610411,10610412,10610417,10613440,10610440,10610441,10613465,10610468,10610476,10613490,10610493,10610494,10610513,10610520,10613562,10610615,10613646,10613653,10610668,10613675,10610675,10613676,10613677,10610692,10613693,10610693,10610694,10610700,10610701,10613707,10613708,10613709,10613722,10610729,10610730,10610739,10613755,10613757,10613758,10613767,10610773,10610790,10613802,10613829,10613840,10610846,10610851,10610852,10613853,10613860,10610862,10610865,10610868,10610870,10610908,10613908,10610915,10613929,10610933,10610937,10610939,10610940,10610942,10610958,10517788,10517789,10517790,10517791,10517792,10517793,10517794,10517795,10517796,10517797,10517798,10517799,10517801,10517802,10517803,10517804,10517805,10517806,10517807,10517808,10512852,10416223,10416227,10416228,10416229,10419232,10419255,10416256,10415256,10419256,10415258,10415259,10415260,10419261,10415264,10415265,10415267,10415271,10417271,10415272,10417273,10417274,10417275,10417276,10415277,10415279,10415280,10416281,10417284,10415285,10415287,10419288,10415292,10419306,10419307,10419308,10419309,10415309,10419310,10415310,10419311,10415312,10419312,10415313,10419313,10415314,10419314,10419315,10415315,10415316,10419316,10419317,10419318,10415318,10419319,10419320,10416320,10419321,10415321,10416321,10419322,10416322,10419323,10419324,10419325,10419326,10419327,10416328,10419328,10419329,10415336,10415342,10415343,10415344,10415346,10415347,10415358,10417358,10417359,10419364,10419365,10419370,10419371,10419372,10419377,10419378,10419379,10419380,10419382,10419383,10419385,10416385,10419386,10415387,10419387,10415388,10419388,10416389,10419389,10419390,10417391,10416391,10417392,10417393,10419398,10419399,10419403,10419409,10419410,10419411,10419412,10419413,10419414,10419415,10415416,10419416,10415417,10419417,10415418,10419418,10415419,10419419,10419420,10415424,10415425,10415426,10415427,10419427,10419428,10419429,10415430,10419430,10419431,10419432,10415432,10415433,10419433,10419434,10415435,10419435,10419436,10415438,10415439,10415440,10415441,10415442,10415443,10415444,10416444,10415445,10416445,10415446,10416446,10416447,10417448,10416453,10415455,10415456,10416458,10416459,10417462,10416463,10417463,10416466,10419468,10416469,10419470,10416470,10415481,10416481,10415483,10415484,10415485,10415486,10417486,10416487,10415487,10419494,10416495,10415495,10416498,10415506,10415507,10415508,10415509,10415510,10415511,10415512,10415513,10415518,10415520,10415521,10415522,10415523,10415524,10417531,10417534,10415537,10415538,10419543,10419544,10419545,10419546,10419547,10419548,10419549,10419550,10419551,10419552,10419553,10419554,10419558,10419559,10419560,10419561,10419564,10419565,10419593,10415596,10415605,10415607,10416610,10416612,10415616,10416617,10416618,10415619,10415621,10415625,10415626,10415628,10415634,10416640,10416641,10417649,10416649,10417650,10416651,10419651,10416652,10419652,10416653,10419653,10416654,10419654,10416655,10419655,10416656,10419656,10419657,10416658,10419658,10419659,10416659,10419660,10416661,10419661,10416662,10419662,10419663,10419664,10419665,10415668,10415670,10415672,10416673,10416674,10416675,10415675,10416676,10415676,10415677,10415678,10415680,10416694,10416714,10416715,10416716,10416721,10416723,10416725,10416727,10416728,10416729,10416730,10416731,10417743,10419759,10419760,10419761,10416763,10416765,10416766,10416770,10419773,10416774,10419774,10419775,10419776,10419777,10419778,10419779,10416779,10416781,10415782,10415783,10415784,10415785,10415786,10415787,10415788,10417800,10417801,10417802,10417803,10417804,10416805,10417835,10419878,10419879,10419880,10415887,10415888,10415889,10415896,10415897,10415898,10415910,10415911,10415913,10415914,10415937,10416955,10416956,10416957,10416979,10416980,10416981,10416982,10416007,10416008,10416009,10416010,10416011,10416012,10416013,10418014,10416014,10416015,10416016,10416017,10416018,10416019,10416020,10416021,10416022,10418023,10418027,10418030,10417030,10418032,10418033,10418034,10418036,10417037,10418048,10416050,10416054,10418060,10418068,10418076,10416076,10418077,10418078,10418079,10416079,10416113,10416114,10416115,10416117,10416118,10416119,10418141,10418142,10418143,10418144,10418145,10418146,10416182,10416183,10416185,10416186,10416187,10416188,10416189,10416190,10416191,10416192,10416193,10416195,10416205,10416212,10471005,10471006,10471007,10471008,10471009,10471014,10471015,10471016,10471029,10471035,10471071,10471078,10471083,10471084,10471085,10471086,10471087,10471088,10471089,10471090,10471091,10471092,10471093,10471094,10471095,10471096,10471099,10471113,10471115,10471120,10471126,10471127,10463688,10465711,10465712,10469902,10469966,10470107,10470145,10470146,10470147,10470148,10470164,10464254,10464285,10464356,10470657,10470658,10470669,10470670,10470690,10470705,10470707,10470708,10470709,10470710,10470720,10470724,10462729,10470735,10470804,10470806,10470834,10470835,10470836,10470837,10470838,10470839,10470840,10470841,10470842,10470843,10470844,10470845,10470846,10470867) 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'