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(4970724,8067906,8067907,8067908,8067910,8067914,8067916,8067917,8067938,8067939,8067940,10939102,10939399,10939400,10939403,10939405,10939406,10939409,10939424,10939425,10939432,10931549,4967032,11049794,8064326,8064692,10931197,10623491,10623492,10623508,10621987,10622027,10622040,10622189,10622258,10622264,10622265,10622267,10622268,10622360,10622429,10622536,10620186,10620200,10620238,10620297,10620298,10620301,10620302,10620303,10620306,10620487,10620488,10620491,10611012,10611051,10611053,10611054,10614080,10614081,10614082,10614083,10614087,10614088,10614090,10614091,10614092,10614093,10614094,10611114,10611143,10611144,10611147,10611148,10614159,10614167,10611179,10611187,10611188,10611191,10614219,10611226,10614228,10611244,10611245,10611250,10611253,10614263,10614264,10611267,10614274,10611275,10614282,10614291,10614292,10611295,10614296,10611297,10611299,10614301,10614303,10611353,10611354,10614355,10611367,10611368,10611369,10614374,10611375,10614375,10611377,10611381,10611385,10611387,10611388,10611393,10611395,10611396,10611397,10611399,10611402,10611406,10611407,10611408,10611410,10614411,10611415,10611416,10611417,10614419,10614420,10611425,10611426,10611431,10611432,10614434,10614435,10614436,10611438,10611439,10614448,10611450,10611451,10611456,10611457,10611462,10611464,10611465,10614466,10611469,10611471,10611472,10614473,10614474,10611475,10614475,10614486,10611488,10611496,10611497,10611498,10611506,10611508,10611509,10611510,10611519,10611521,10611524,10611531,10611533,10611534,10611535,10611540,10611541,10614542,10611544,10611548,10611551,10614555,10611557,10611558,10611559,10614560,10611562,10611565,10611566,10611568,10611578,10611583,10614588,10614589,10611591,10611593,10614595,10611595,10611602,10611610,10611611,10611614,10614617,10614620,10611625,10611626,10614634,10614635,10614636,10614637,10611639,10611642,10611643,10614646,10614647,10611650,10611651,10611657,10611658,10611660,10611661,10611663,10614664,10611666,10611667,10611668,10611670,10611671,10611673,10611675,10611677,10611678,10611679,10611713,10611714,10614724,10614734,10614746,10611764,10611814,10611856,10614857,10614861,10614864,10611869,10611870,10611880,10611881,10611882,10611883,10611884,10611885,10611886,10611887,10611888,10611889,10611890,10611891,10611892,10566084,10611949,10611950,10611951,10611960,10608963,10611972,10611973,10611978,10608980,10611981,10611989,10611995,10611996,10611997,10608999,10612000,10612001,10612002,10612003,10612004,10612008,10612010,10612011,10609014,10609018,10612018,10609028,10612028,10609033,10612042,10612062,10612063,10612064,10612069,10609083,10609085,10612085,10612086,10609087,10612109,10612168,10612169,10609171,10612178,10612179,10612180,10612189,10612191,10612192,10612201,10612210,10609239,10612258,10612262,10612263,10612265,10609265,10612267,10612273,10609285,10609313,10612320,10612321,10609329,10612333,10612346,10609348,10609350,10609351,10609358,10609362,10609363,10609376,10609379,10612380,10612381,10609385,10609387,10609404,10609408,10609412,10609415,10612417,10609419,10612421,10612423,10612424,10609428,10609429,10612431,10612432,10612440,10612442,10609454,10609456,10609457,10609463,10612465,10612467,10612469,10612470,10612471,10612472,10612474,10612481,10612482,10612484,10612485,10612486,10612487,10612488,10612489,10609497,10609498,10609499,10609500,10609501,10609502,10609505,10609510,10609511,10609512,10609513,10609514,10612516,10609516,10612517,10609517,10612518,10609518,10612519,10612520,10612522,10612523,10612525,10612526,10609526,10612527,10612533,10609536,10612540,10612541,10609543,10612544,10609544,10612545,10609547,10609549,10612553,10609562,10609563,10612565,10609568,10609569,10609595,10612598,10612604,10609609,10612611,10612613,10612614,10609614,10612617,10612618,10612619,10609625,10609626,10609630,10609636,10612637,10609639,10609651,10609652,10609653,10609654,10612657,10612658,10612659,10609659,10609661,10609662,10612662,10609666,10609668,10609674,10612675,10609685,10612685,10609688,10609697,10609700,10609701,10609703,10609707,10609708,10609713,10609715,10609716,10612746,10612755,10612757,10612758,10612759,10612760,10609771,10612805,10612816,10609816,10612817,10609817,10612821,10612822,10612824,10609824,10612832,10609834,10609841,10609842,10612849,10612851,10612853,10612867,10609883,10612884,10609884,10609885,10609886,10612886,10612888,10612889,10612890,10612893,10612894,10612895,10612896,10609898,10612900,10612904,10612905,10609905,10612906,10612907,10612908,10612909,10612910,10612911,10609911,10612912,10612913,10612914,10612916,10612931,10609937,10609938,10609943,10612944,10609946,10612953,10612954,10612960,10612961,10612963,10609975,10612994,10613022,10610022,10613025,10610026,10613034,10610035,10610037,10610041,10610044,10610046,10610054,10613056,10610068,10613085,10613087,10613088,10613091,10610098,10610100,10610106,10610108,10613127,10613156,10613157,10613159,10610167,10610168,10613192,10613203,10610233,10610234,10610235,10613235,10610236,10613245,10613247,10613253,10610271,10610298,10610306,10610307,10613308,10613309,10613318,10613320,10610327,10610339,10610340,10613343,10610346,10613350,10610366,10610392,10610394,10610396,10610397,10613405,10613425,10613426,10613427,10613453,10613464,10613468,10613469,10610481,10613490,10610493,10613497,10613514,10613562,10613577,10613578,10613579,10613593,10613594,10613595,10613596,10613609,10613612,10613613,10613627,10613628,10613643,10613646,10613662,10613664,10610666,10610668,10613673,10610675,10610676,10610677,10610678,10613682,10613683,10613685,10613691,10613694,10610705,10613708,10613709,10613710,10610710,10613716,10613717,10613730,10613732,10613741,10613744,10610753,10610764,10610765,10610766,10610767,10610768,10610769,10610770,10610771,10610772,10610773,10610774,10610775,10610776,10610777,10610778,10610799,10610800,10610802,10610804,10610812,10610822,10610825,10610826,10610829,10610830,10610834,10610836,10610850,10610860,10610862,10610868,10610869,10610870,10610880,10610904,10610905,10610906,10610925,10610927,10610945,10610947,10419257,10419258,10419259,10419260,10416262,10419272,10416282,10416283,10419293,10419298,10415315,10415318,10415322,10415323,10419338,10415340,10416347,10416356,10416357,10416362,10416363,10416364,10416365,10416366,10416367,10416368,10416369,10416370,10419370,10419371,10416371,10416372,10416373,10415373,10416374,10415374,10416375,10415375,10416376,10419376,10415376,10416377,10416378,10416379,10416380,10416381,10416382,10419382,10416383,10419383,10415383,10419384,10415384,10419385,10415396,10415397,10415398,10415399,10415400,10415402,10415403,10415404,10415405,10416444,10415449,10415450,10416453,10415453,10415458,10419458,10419459,10416466,10415469,10415470,10416477,10416478,10416488,10419497,10416498,10419498,10416499,10416500,10416501,10416502,10416503,10416504,10416505,10416506,10416507,10416508,10416509,10416510,10416511,10416512,10416513,10416514,10416515,10416516,10416517,10416518,10415518,10416519,10415519,10416520,10415520,10416521,10415521,10415522,10415523,10419524,10415532,10416533,10416534,10416535,10416536,10416537,10416538,10416539,10416540,10416541,10415548,10416550,10419556,10419557,10419568,10416570,10416571,10416572,10416573,10416574,10416575,10416576,10419587,10416609,10416610,10416611,10416612,10416613,10416614,10416615,10416631,10416633,10416635,10416638,10416643,10415643,10416644,10415644,10415645,10415650,10415651,10419654,10415657,10415661,10415662,10415665,10415682,10415687,10415710,10419762,10419763,10419764,10419765,10419766,10419767,10419777,10419778,10419780,10419782,10419783,10415789,10419803,10419852,10419853,10419854,10419855,10419867,10419868,10415877,10415886,10416043,10416056,10416076,10471108,10471109,10471110,10471111,10471114,10471117,10471118,10471119,10471175,10463360,10463361,10463362,10469908,10469909,10469927,10469928,10469932,10469936,10469937,10469965,10469966,10470092,10470161,10470217,10470218,10470219,10470220,10470221,10470222,10470223,10470224,10470225,10470226,10470227,10470228,10470231,10470234,10470236,10470239,10470241,10470243,10470244,10470245,10470246,10470247,10470248,10470249,10470256,10470258,10470259,10470262,10470263,10470264,10470265,10470266,10470267,10470269,10470271,10470272,10470273,10470274,10470276,10470278,10470279,10470284,10470285,10470286,10470287,10470288,10470289,10470290,10470291,10470293,10470294,10470295,10470296,10470298,10470299,10470302,10470303,10470305,10470307,10470308,10470311,10470312,10470320,10470321,10470342,10470344,10470345,10470347,10470355,10470356,10470357,10470358,10470384,10470385,10470386,10470420,10470445,10470447,10470448,10470449,10470450,10470451,10470452,10470489,10470490,10470491,10470492,10470538,10470545,10470572,10462572,10470574,10470575,10470576,10470592,10470593,10470594,10470619,10470620,10470621,10470622,10470624,10470625,10470644,10470645,10470646,10470647,10470648,10470649,10470650,10470651,10470652,10470653,10470666,10470667,10470668,10470693,10470697,10470721,10470722,10462752,10462753) 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'