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(4970273,4970274,4970275,4970276,4970277,4970278,4970279,4970280,4970281,4970282,4970283,4970284,4970285,4970286,4970287,4970288,4970289,4970290,4970291,4970301,4970302,4970303,4970304,4970305,4970306,4970307,4970308,4970309,4970310,4970311,4970312,4970313,4970314,4970315,4970316,4970317,4970318,4970319,4970320,4970321,4970322,4970323,4970324,4970325,4970326,4970327,4970328,4970329,4970330,4970331,4970332,4970333,4970334,4970335,4970336,4970337,4970338,4970339,4970340,4970341,4970342,4970343,4970344,4970345,4970346,4970347,4970348,4970349,4970350,4970351,4970352,4970353,4970354,4970355,4970356,4970357,4970358,4970359,4970360,4970361,4970362,4970363,4970364,4970365,4970366,4970367,4970368,4970369,4970370,4970371,4970372,4970373,4970374,4970375,4970376,4970377,4970378,4970379,4970380,4970381,4970382,4970383,4970384,4970385,4970386,4970387,4970388,4970389,4970390,4970391,4970392,4970393,4970394,4970395,4970396,4970397,4970398,4970399,4970639,4970652,4970653,4970654,4970655,4970656,4970657,4970658,4970669,4970699,4970700,4970705,4970718,4970724,4970733,4970745,4970754,4970755,4970792,4970878,4970892,4970912,4970913,4970914,4970923,4970927,4970933,4970934,4970953,4970966,4971129,4971130,4968152,4968153,4968154,4968155,4968156,4968157,4968158,4968159,4968160,4968161,4968162,4968163,4968164,4968165,4968166,4968167,4968172,4968218,4968228,4968229,4968328,4968337,4968338,4968699,4968700,4968802,4968803,4968843,4968849,4969011,4969012,4969013,4969014,4969015,4969177,4969330,4969331,4969418,4969419,4969420,4969530,8075240,8075241,8075306,8075324,8075325,8075326,8075327,8075328,8075329,8075330,8075331,8075489,8075524,8075525,8075526,8075527,8075528,8075529,8075530,8075531,8075532,4967774,4967775,4967776,4967777,4967778,4967779,4967780,4967781,4967782,4967783,4967784,4967785,4967786,4967787,4967788,4967789,4967790,4967791,4967792,4967793,4967794,4967795,4967796,4967797,4967798,4967799,4967800,4967801,4967802,4967803,4967804,4967805,4967806,4967807,4967808,4967809,4967810,4967811,4967812,4967813,4967814,4967815,4967816,4967817,4967818,4967859,4968076,4968077,4968078,4968144,4968145,4968146,4968147,4968148,4968149,4968150,4968151,8072318,8072319,8072320,8072321,8072322,8072323,8072324,8072325,8072326,8072327,8072328,8072329,8072330,8072331,8072332,8072333,8072334,8072335,8072336,8072337,8072338,8072339,8072340,8072341,8072342,8072343,8072344,8072345,8072346,8072347,8072348,8072349,8072350,8072351,8072352,8072353,8072354,8072355,8072356,8072773,8072774,8072775,8072776,8072777,8072920,8072921,8072922,8072923,8072924,8072927,8072928,8072929,8072930,8072931,8073053,8073521,8073522,8073523,8073524,8073525,8073526,10622972,10623136,10623137,10623138,10623160,10623161,10623236,10623237,10623238,10623239,10623240,10623241,10623242,10623243,10623362,10623372,10623454,10623463,10623478,10623479,10623491,10623492,10623493,10623503,10623647,10623648,10623649,10623653,10623654,10623806,10624116,10624117,10624118,10624135,10624136,10624137,10624138,10624139,10624140,10624141,10624142,10624143,10624144,10624145,10624146,10624147,10624148,10624149,10624150,10624151,10624152,10624153,10624154,10624155,10624156,10624157,10624158,10624159,10624271,10624343,10624404,10624405,10624406,10624407,10624408,10624409,10624410,10624411,10624412,10624427,10624428,10624429,10624430,10624431,10624432,10624433,10624582,10624583,10624584,10624585,10624586,10624726,10624727,10624728,10624883,10624884,10624885,10624886,10624887,10624888,10624892,10624893,10624894,10624956,10624959,10624960,10621979,10621980,10621985,10621989,10621992,10621997,10621998,10621999,10622000,10622001,10622002,10622003,10622004,10622005,10622006,10622007,10622008,10622009,10622010,10622011,10622037,10622038,10622039,10622043,10622044,10622045,10622046,10622047,10622048,10622049,10622050,10622051,10622052,10622054,10622055,10622070,10622081,10622092,10622093,10622094,10622123,10622173,10622174,10622175,10622176,10622177,10622178,10622234,10622251,10622337,10622338,10622343,10622392,10622393,10622469,10622481,10622482,10622488,10622489,10622514,10622516,10622536,10622539,10622667,10622669,10622811,10622812,10622818,10622819,10622880,10622901,10622916,10622920,10620007,10620008,10620009,10620030,10620031,10620032,10620034,10620035,10620055,10620098,10620116,10620122,10620164,10620168,10620169,10620183,10620213,10620238,10620268,10620269,10620343,10620364,10620365,10620366,10620367,10620368,10620406,10620412,10620413,10620484,10620485,10620486,10620487,10620488,10620489,10620490,10620491,10620492,10620493,10620494,10620495,10620496,10620497,10620498,10620499,10620500,10620501,10620502,10620503,10620504,10620505,10620506,10620507,10620508,10620509,10620528,10620669,10620682,10620683,10620684,10620699,10620700,10620701,10620702,10620703,10620704,10620705,10620706,10620707,10620708,10620709,10620710,10620711,10620712,10620779,10620780,10620796,10620812,10620824,10620825,10620826,10620827,10620848,10620849,10620939,10620940,10620953,10620954,10620982,10621046,10621120,10621125,10621130,10621133,10621134,10621135,10621145,10621160,10621164,10621166,10621251,10621252,10621279,10621300,10621301,10621314,10621315,10621342,10621351,10621352,10621353,10621354,10621355,10621396,10621465,10621470,10621564,10621586,10621627,10621628,10621629,10621630,10621631,10621632,10621633,10621634,10621635,10621636,10621637,10621638,10621639,10621640,10621641,10621642,10621643,10621644,10621645,10621646,10621647,10621648,10621649,10621650,10621651,10621652,10621653,10621654,10621655,10621656,10621657,10621658,10621659,10621660,10621661,10621662,10621663,10621664,10621665,10621666,10621667,10621668,10621669,10621670,10621671,10621672,10621673,10621674,10621675,10621676,10621677,10621678,10621679,10621680,10621681,10621682,10621683,10621684,10621685,10621686,10621687,10621688,10621691,10621692,10621693,10621694,10621697,10621698,10621700,10621705,10621706,10621707,10621710,10621714,10621716,10621717,10621718,10621719,10621720,10621721,10621724,10621728,10621731,10621732,10621733,10621734,10621736,10621742,10621790,10621791,10621817,10621818,10621819,10621820,10621821,10621822,10621823,10621824,10621825,10621826,10621827,10621828,10621829,10621830,10621831,10621832,10621833,10621834,10621835,10621836,10621837,10621838,10621839,10621840,10621841,10621842,10621843,10621844,10621845,10621846,10621847,10621848,10621849,10621850,10621851,10621852,10621853,10621854,10621855,10621856,10621857,10621858,10621859,10621860,10621861,10621862,10621863,10621864,10621865,10621866,10621867,10621868,10621869,10621870,10621871,10621872,10621873,10621874,10621875,10621876,10621877,10621878,10621879,10621880,10621881,10621882,10621883,10621884,10621885,10621886,10621887,10621888,10621889,10621890,10621891,10621892,10621893,10621894,10621895,10621896,10621897,10621898,10621899,10621900,10621901,10621902,10621903,10621904,10621905,10621906,10621907,10621908,10621909,10621910,10621911,10621912,10621913,10621914,10621915,10621916,10621917,10621918,10621919,10621920,10621921,10621922,10621923,10621924,10621925,10621926,10621927,10621928,10621929,10621930,10621931,10621932,10621933,10621934,10621935,10621936,10621937,10621938,10621939,10621940,10621941,10621942,10621943,10621944,10621945,10621946,10621947,10621948,10621949,10621958,10565148,10565154,10565155,10565157,10565158,10565189,10565195,10565223,10565225,10565324,10565325,10565326,10565327,10565348,10565703,10565704,10565705,10565706,10566056,10566080,10566081,10566082,10566083,10563195,10563200,10563208,10563280,10563281,10563310,10563311,10563312,10563451,10563519,10563520,10563530,10563531,10563532,10563533,10563534,10563535,10563536,10563537,10563538,10563539,10563540,10563541,10563542,10563543,10563544,10563545,10563559,10563560,10563561,10563562,10563563,10563685,10563686,10563687,10563688,10563689,10563690,10563691,10563692,10563870,10563983,10563984,10563985,10563986,10563987,10563988,10563989,10563990,10563991,10563992,10563993,10563994,10563995,10563996,10563997,10563998,10563999,10564000,10564001,10564002,10564003,10564004,10564005,10564006,10564007,10564008,10564009,10564010,10564011,10564012,10564013,10564014,10564015,10564016,10564017,10564018,10564019,10564020,10564021,10564022,10564023,10564024,10564025,10564026,10564027,10564028,10564029,10564030,10564031,10564032,10564033,10564034,10564035,10564036,10564037,10564038,10564039,10564040,10564041,10564042,10564043,10564044,10564045,10564046,10564047,10564048,10564049,10564050,10564051,10564052,10564053,10564054,10564055,10564056,10564057,10564058,10564059,10564060,10564061,10564062,10564063,10564064,10564065,10564066,10564067,10564068,10564069,10564070,10564071,10564072,10564073,10564074,10564075,10564076,10564077) 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'