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(7065955,7065956,7065957,7065958,7065986,7066024,7066025,7066077,7066078,7066100,7066172,7066182,7066231,7066238,7066239,7066240,7066241,8067903,8067916,8067928,8067930,8067938,10939103,10939425,10939435,7064547,7064548,8065814,8065846,7065336,8860384,8860446,8860448,10623063,10618180,10618292,10623493,10619897,10616970,10617000,10617002,10617005,10617026,10617031,10617044,10617054,10617055,10617056,10617072,10617082,10617083,10617084,10617086,10617087,10617088,10617097,10617123,10617136,10617144,10617145,10617146,10617147,10617148,10617149,10617150,10617151,10617152,10617154,10617155,10617156,10617157,10617230,10617231,10617233,10617236,10617238,10617240,10617242,10617243,10617246,10617249,10617250,10617254,10617255,10617274,10617312,10617313,10617314,10617316,10617317,10617323,10617324,10622363,10622406,10622419,10622424,10622428,10622429,10617437,10622441,10617441,10617461,10622508,10617509,10622525,10622537,10614971,10615024,10615050,10615147,10615161,10615162,10615163,10615232,10615234,10615246,10615312,10615315,10615325,10615326,10615334,10615336,10615337,10615398,10615403,10615473,10615483,10615536,10615540,10615571,10615583,10615599,10615609,10615623,10615646,10615647,10615681,10615717,10615719,10615725,10615727,10615729,10615730,10615731,10615732,10615734,10615736,10615737,10615741,10615742,10615743,10615744,10615745,10615746,10615747,10615748,10620750,10615768,10615772,10615780,10615781,10615782,10615783,10615784,10615785,10615786,10615787,10615788,10615789,10615790,10615791,10620791,10615792,10615814,10615821,10615870,10615908,10615909,10615924,10615925,10615929,10615934,10615935,10615936,10615937,10615939,10615951,10615952,10615954,10615969,10615970,10615981,10615983,10615984,10616016,10616017,10616018,10616046,10616052,10616060,10616061,10616121,10616122,10616123,10616124,10616125,10616126,10616127,10616128,10616129,10616130,10616131,10616132,10616133,10616134,10616135,10616136,10616193,10616194,10616204,10616210,10616211,10616219,10616220,10616229,10616243,10616245,10616248,10616252,10616253,10616258,10616267,10616268,10616287,10616295,10616298,10616302,10616303,10616311,10616323,10616324,10616329,10616333,10616334,10616335,10616336,10616337,10616338,10616339,10616340,10616341,10616342,10616343,10616344,10616345,10616346,10616347,10616348,10616349,10616350,10616351,10616352,10616353,10616354,10616355,10616356,10616357,10616358,10616359,10616360,10616361,10616362,10616363,10616364,10616365,10616366,10616367,10616368,10616369,10616370,10616371,10616387,10616389,10616393,10616394,10616395,10616400,10616401,10616404,10616407,10616410,10616412,10616423,10616430,10616431,10616443,10616453,10616462,10616464,10616465,10616466,10616467,10616468,10616476,10616477,10616479,10616486,10616487,10616488,10616489,10616490,10616491,10616492,10616493,10616494,10616495,10616496,10616497,10616498,10616499,10616500,10616501,10616502,10616503,10616505,10616506,10616507,10616508,10616509,10616510,10616511,10616517,10616518,10616519,10616520,10616525,10616526,10616527,10616528,10616529,10616530,10616533,10616534,10616535,10616537,10616546,10616548,10616549,10616562,10616563,10616564,10616578,10616597,10616633,10616634,10616635,10616636,10616637,10616638,10616655,10616656,10616657,10616665,10616683,10616684,10616685,10616686,10616689,10616690,10616691,10616692,10616694,10616707,10616718,10616719,10616720,10616721,10616722,10616723,10616724,10616725,10616726,10616727,10616728,10616755,10616779,10616780,10616781,10616782,10616783,10616784,10616788,10616796,10616797,10616798,10616799,10616800,10616801,10616804,10616840,10616841,10616842,10616843,10616847,10616868,10616880,10616888,10616900,10616913,10616943,10613981,10614028,10611037,10614048,10614092,10614094,10614095,10611126,10614148,10614160,10565319,10614238,10611293,10614316,10611343,10611358,10614364,10611367,10614368,10614377,10614418,10614432,10614464,10614472,10614486,10614488,10614489,10614490,10614492,10614518,10614530,10559708,10559710,10614567,10614568,10614580,10614587,10614588,10614629,10614639,10614641,10611655,10614663,10611727,10614730,10614731,10611736,10611764,10611801,10611802,10611811,10611813,10611816,10611819,10614822,10611823,10611835,10611850,10611852,10614858,10614859,10614860,10611957,10611958,10608963,10611967,10609002,10609003,10609004,10609005,10609006,10609007,10609008,10609009,10609010,10612010,10609011,10609012,10609013,10609014,10609015,10609016,10609017,10609018,10612030,10612032,10609033,10612033,10612034,10612035,10612036,10612051,10612065,10612066,10612067,10612069,10612075,10612076,10609153,10609167,10612174,10612175,10609188,10612189,10609247,10612248,10609260,10612263,10612264,10612265,10612272,10612285,10609305,10609334,10609336,10612340,10612341,10609348,10609350,10609351,10609352,10612354,10609357,10609358,10609359,10609360,10609362,10609363,10609367,10609368,10609369,10612372,10609376,10612384,10609385,10612407,10612408,10612409,10612410,10612411,10612413,10612428,10612434,10612493,10612516,10612518,10612520,10612523,10612524,10609524,10612525,10612526,10612527,10612528,10612531,10612532,10612538,10612547,10612551,10612552,10612553,10612554,10612555,10612556,10612557,10612558,10612565,10612566,10612567,10612568,10612570,10612571,10612573,10612579,10612580,10612581,10612585,10612594,10612600,10612608,10612609,10612618,10612619,10612644,10612645,10612651,10609677,10609704,10609705,10612755,10612790,10612791,10612792,10612809,10609827,10612836,10612837,10612838,10612839,10612844,10612845,10612848,10612849,10612853,10612865,10612874,10612875,10612876,10612879,10612880,10612883,10609883,10609884,10609885,10612897,10612898,10612915,10609928,10609929,10609934,10612941,10609975,10609978,10610025,10610042,10610045,10610046,10613055,10613065,10613079,10613080,10613133,10613135,10610152,10613155,10613156,10613163,10613169,10613173,10613175,10613176,10613189,10613191,10613192,10613193,10610197,10613242,10613243,10613265,10613266,10610274,10610285,10613293,10613300,10613301,10613305,10610323,10613342,10613359,10610359,10610362,10610364,10613365,10610369,10610372,10610373,10610375,10613395,10610408,10610417,10613441,10610480,10610481,10613492,10613496,10610535,10613536,10613543,10613546,10613547,10613553,10613645,10613652,10613664,10610667,10610669,10610671,10613672,10610674,10613678,10613679,10613680,10613681,10613682,10613683,10610683,10613684,10613685,10613686,10610692,10613710,10613711,10613712,10613721,10610789,10610794,10613801,10610838,10610854,10613909,10613912,10517794,10517795,10517803,10517804,10517807,10517808,10419232,10415255,10417273,10417274,10417275,10417276,10417279,10418287,10415292,10415294,10418302,10418303,10416316,10418316,10418317,10416317,10418318,10418319,10418320,10418321,10416321,10418322,10416322,10418323,10416323,10418324,10416324,10418325,10416325,10416326,10418326,10416327,10418327,10418328,10416328,10418329,10416329,10416330,10418330,10418331,10418333,10418335,10418344,10415344,10418345,10418346,10418347,10418348,10415348,10418349,10415349,10418350,10418351,10418352,10418353,10418354,10418355,10418356,10418357,10418358,10418359,10417359,10418360,10418361,10418362,10418363,10418364,10419364,10418365,10419365,10418366,10418367,10418368,10418369,10418370,10418371,10418372,10418373,10418374,10418375,10418376,10418377,10415377,10418378,10418379,10418380,10418381,10418382,10418383,10418384,10419384,10418385,10418386,10418387,10418388,10419388,10418389,10416389,10419389,10418390,10419390,10418391,10416391,10418392,10418393,10416393,10418394,10418395,10418396,10418397,10418398,10416398,10418399,10418400,10418401,10418402,10418403,10418404,10418405,10418406,10418407,10419407,10415407,10418408,10418409,10418410,10418411,10419411,10418412,10419412,10418413,10418414,10418415,10418416,10418417,10418418,10418419,10418420,10418421,10418422,10418423,10418424,10418425,10418426,10418427,10418428,10419428,10418429,10419429,10418430,10418431,10418432,10418433,10418434,10418435,10415440,10415441,10418444,10417462,10416470,10418473,10418474,10416479,10415482,10418488,10418493,10418495,10418498,10415514,10418553,10418555,10418556,10418557,10418569,10418570,10418571,10418578,10418579,10415619,10415634,10416717,10419760,10419780,10419781,10415785,10415786,10415888,10415940,10415941,10415942,10415943,10416971,10416973,10417980,10416983,10416984,10416985,10417019,10417021,10416023,10416024,10416025,10416026,10417027,10417029,10418048,10418141,10418144,10418145,10416182,10416183,10416184,10416185,10416186,10416187,10416188,10416189,10416190,10416191,10416192,10416193,10416194,10416205,10471017,10471018,10471025,10471037,10471038,10471039,10471065,10471066,10471069,10471080,10471081,10471097,10471098,10467104,10467409,10463432,10467570,10467615,10467634,10467635,10465711,10465712,10465736,10470145,10470166,10470191,10462516,10470671,10470676,10462729,10470736,10470737,10470847,10470848,10470849,10470850,10470851,10470852,10470853,10470854,10470855,10470856,10470857,10470858,10470859,10470860,10470861,10470862,10470863,10470864) 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'