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(10447848,10962668,8068876,10962669,10939609,10962675,8620959,10988837,10988838,10988839,10448041,8621003,10448052,8621012,8621035,8621043,8621054,8838714,8621061,8621062,8621072,8838730,8838731,8621101,8621105,8574511,8574512,8574513,10448304,8621394,7068763,8569816,10976580,10976581,8569883,8621805,7074133,10950936,8575612,8575613,8067492,8584076,8067621,8584121,8067642,8067647,8067707,8067708,8575975,7074896,10497766,10497767,8619833,8619837,8067907,10497823,10497824,10497825,10497826,8619920,10497887,8068036,8068051,8068052,8068053,8620006,8620007,8837703,8068118,8068177,10498091,8620149,8620150,8620151,8620180,8068239,8068240,8068268,8620214,10498193,10498194,10498195,8068295,8620254,8620259,8620282,8838151,8838152,8068571,8838209,8068620,8068629,8838355,8620737,8620763,8835448,8911237,7072372,7072378,7072400,7072426,7072437,10973123,10973124,10973125,10973126,7072618,7072628,10103947,7072982,7073019,7073058,7073080,8836717,8066260,8066284,8066297,8066298,8066299,8066300,8066536,8066537,8066538,8066539,8066616,8066650,8066651,8066652,8066653,8066654,8066734,8066735,10497636,10497637,10497638,10497672,10497674,8616772,8616789,8616790,8616821,8910043,8616822,10942740,11049097,10942927,10943091,11049378,7071723,3655520,3655521,3655522,3655523,7069008,3656239,8564811,8909345,8909346,8909365,8909594,8909595,8909792,8909805,8909955,10618045,8906088,11032750,11032753,10923666,10923668,10923669,8906207,8906222,10918708,10918723,10918724,10918734,10918735,10923772,10923773,10923774,10923775,10923776,10923777,10923847,10923848,8906394,8906406,10923913,10923914,10923915,10923916,10918964,10918965,10923986,10923987,10923988,10923989,10923990,10923991,10919008,10919009,10924076,10924080,10924081,10924297,10919336,10919337,10919338,10919339,10919340,10919341,8070854,10919666,10919667,10919687,10919688,10924806,10924807,10924808,10924809,10924810,10924811,10924812,10924813,10924814,10924815,10924816,10924817,10924818,10924819,10924820,10919866,10919867,10919877,10925023,10925024,10925025,10925026,10925027,10925028,10925118,10925119,10925120,10925190,10925193,10925194,10925195,10925196,8907769,10925297,10925298,10925299,10925300,10925301,10925302,10925303,10925304,10925305,8907938,8907939,8907940,8907941,8907942,8907943,8907944,8907945,8578201,10617082,8578412,8578444,10922803,10927873,10918185,10918194,10622883,10918398,10920523,10920707,10920708,10920783,8570287,10925864,10920927,8576660,8576661,8576662,10921117,10921118,8576870,10921283,8576950,8577060,8577067,8577068,10930866,10921488,10921512,8577172,10921535,8577256,8577257,10921670,10621275,10621282,10621283,10621285,10621287,10921798,10921799,8577447,8577464,10921910,10979058,10921911,10921913,10979066,10621451,10621471,10621472,10616510,8577771,10621737,9189534,9205933,9190023,9190059,9203331,10557144,10557145,10557146,9195361,9203362,9195459,9195460,9195505,9195506,9203531,9203532,9203533,9203534,9203535,9203553,9203554,9203555,9203556,9195577,9195578,9195579,9187645,9187646,9195659,9195660,9203686,9203693,9203694,9203695,9195729,9195730,9187738,9203758,10557614,9195815,9187825,9187828,9203865,9203866,9203867,9203868,9203869,9203870,9203871,9204031,9204032,7058206,7058232,9196099,7058294,9188133,9204145,9204200,9204219,9188274,9204278,9204333,9204354,9204397,9204412,9172470,9172511,7058728,7058751,9204605,7058892,10561557,8863332,8863349,8863350,8863367,8863384,8863396,8863397,9172951,8863495,10610774,9193406,9193411,9193620,9193621,10555591,10555592,10555593,10555594,10555595,10555596,10555597,10555598,10555599,10555600,10555601,10555602,10555603,10555630,10555631,10555632,10555633,10555634,10555635,4974850,10515812,10515813,4974855,4974856,9202067,4974933,9194142,9194143,9194167,9194168,10516014,10516015,10516016,10516017,10516018,10516019,10516020,10516021,10516022,10516023,10516024,10516025,10516026,10516027,10516028,10516029,9202312,9194379,9194380,9194381,9202450,9202460,9194518,10556351,9194650,9194651,10556466,10556467,10556468,9194780,9194797,9202880,9194927,9194928,10556766,10556767,10556768,10556769,10556770,10556771,10556772,10512797,10512798,10556945,10556946,9195150,9195151,10516968,9195163,9195164,9195165,9195166,9203177,9203186,9203195,9200507,9192549,9200624,9192680,9192681,9192693,9192694,9200757,9192807,10417769,9200855,10417785,9208910,9208911,9208950,9208951,9192958,9192959,9192960,9192961,9192962,9192963,9193004,9193050,9193067,10418127,10417132,10418133,10417137,10418138,9206412,9206531,9206532,9206542,9206646,9206664,9206666,9206667,9198931,6666980,6666981,10465796,10465797,10465798,10465799,10465800,10465801,10465802,4972078,10465803,4972079,10465804,10465805,10465806,10465807,10465808,10465809,10465810,10465811,10465812,10465813,10465814,10465815,10465816,10465817,10465818,10465819,10465820,10465821,10465822,10465823,10465824,10465825,10465826,10465827,10465828,10465829,10465830,10465831,10465832,10465833,10465834,10465835,10465836,10465837,10465838,10465839,10465840,10465841,10465842,10465843,10465844,10465845,10465846,10465847,10465848,10465849,10465850,10465851,10465852,10465853,10465854,10465855,8550493,8563381,10470401,10470405,10470519,10470526,10470603,10470623,9200238,9200269,9200270,9200292,10174507,10628026,10628027,10169556,10628092,8593616,8593635,8593636,8593637,8593638,10169661,10169662,8593663,10169665,8593664,8593665,8593671,8593675,8593676,8593677,8593678,8593711,10169837,10179893,10179996,10180216,10180217,10180218,10180247,10180248,10180631,10180653,10180654,10180655,10180656,8068996,8068997,8069039,10181004,10186199,10629679,10629680,10629681,10181256,10181257,10629737,10181277,10181278,10181279,10181280,10629798,10629799,10629809,10626968,10168495,10168496,10168497,10168515,10168516,10168517,10168518,10168519,10168520,10183661,10183662,10183663,10183664,10168779,10173980,10169034,10169091,10169092,10169293,10181537,10181538,10186625,10186682,10186747,10186748,10186799,10186803,10630367,10630395,10630396,10630397,10630398,10630399,10630400,10630401,10186927,10186928,10186929,10181975,10181976,10630477,10182073,10182086,10182087,10182088,10630628,10182237,10630739,10630740,10630741,10172301,10172320,10172351,10949177,10949178,10182392,10182399,10177435,10949235,10949236,10949237,10182493,10182499,10631012,10631014,10949419,10182668,10167676,10631210,10631211,10167747,10182825,10182836,10172854,10172873,10167912,10182926,10182927,10182928,10182929,10182930,10182931,10167951,10183005,10168018,10183086,10183092,10168158,10183159,10183167,10183220,10168250,10168251,10183261,10168271,10168272,10168273,10168274,10168275,10168276,10168277,10168278,10168327,10183339,10168340,10168341,10183346,10168357,10168358,10168359,10168360,10168361,10168362,10168363,10183385,10168442,10183456,10571508,10571509,10571510,10571511,10571512,10577596,10577597,10577598,10577599,10568729,10568730,10574731,10568731,10574767,10574768,10574785,10577937,10571975,10571976,10571977,10571978,10571979,10571980,10571981,10574983,10574984,10574985,10574986,10578098,10578104,10572320,10572325,10572326,10572327,10572328,10572329,10572330,10572331,10575467,10575468,10575469,10575480,10578502,10590520,10590521,10578539,10578550,10575581,10578592,10581668,10581669,10581670,10575699,10581701,10581714,10581715,10581716,10581717,10569753,10569754,10569755,10569756,10581773,10578820,10569948,10579114,10579115,10579116,10579117,10579118,10579119,10579120,10579121,10579122,10579123,10579124,10579125,10579126,10579127,10579128,10579129,10579130,10579131,10579132,10579133,10579134,10579135,10579136,10579137,10576203,10576204,10576205,10576259,10576260,10576261,10576262,10576263,10576264,10576265,10576266,10576267,10576268,10579274,10579275,10579276,10579277,10579278,10579279,10579280,10579281,10579282,10579283,10579284,10579285,10579286,10579287,10579288,10579289,10579290,10579291,10579292,10579293,10579294,10579295,10579296,10579297,10579298,10579299,10579300,10579301,10582546,10576787,10576788,10576789,10576790,10576791,10576792,10576793,10576794,10576795,10576796,10576797,10576813,10576814,10576815,10576816,10576817,10576818,10576819,10576820,10576821,10576822,10576823,10576824,10576825,10523247,10535483,10535484,10535485,10535486,10535520,10535521,10535522,10535523,10535524,10535525,10535526,10536109,10536621,10536622,10536623,10534700,10534701,10534702,10534997,10534998,10534999,10535000,10535001,10535002,10535003,10535004,10422252,10423918,10487949,10488032,10488089,10479220,10479221,10479407,10479678,10479760,10479761,10479762,10479763,10479774,10479775,10479776,10479782,10479783,10479784,10479785,10479838,10479839,10479840,10479841,10479842,10479971,10480228,10480229,10480373,10480374,10487564,10487590,10487619,10487743,10487744,10487772,10487773,10487774) 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'