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(3229303,7066209,8067919,8573262,10939434,7201307,7201365,7201649,7201867,7202341,7202342,7202634,10102076,10102077,7200757,7200758,7200759,7200874,7201086,7201087,7201088,7201093,7201094,7201095,7201096,7201097,7201098,7201152,10839702,8908214,8908215,8908216,7198677,7199363,7199567,7199568,7199569,7199570,7199571,7199572,7199573,7199574,7199575,7199576,7199577,7199578,7199579,7199580,7199581,7199582,7199583,7199584,7199585,7199586,7199587,7199588,7199589,7199590,7199591,7199592,7199593,7199594,7199595,7199596,7199597,7199598,7199599,7199600,7199601,7199602,7199603,7199604,7199605,7199606,7199607,7199608,7199609,7199610,7199611,7199612,7199613,7199614,7199615,7199616,7199617,7199618,7199619,7199620,7199621,7199622,7199623,7199624,7199625,7199626,7199627,7199628,7199629,7199630,7199631,7199632,7199633,7199634,7199635,10101519,7199636,7199637,7199638,7199639,7199640,7199641,7199642,7199643,7199644,7199645,7199646,7199647,10101532,7199648,7199649,7199650,7199651,7199652,7199653,7199654,7199655,7199656,7199657,7199658,7199659,7199660,7199661,7199662,7199663,7199664,7199665,7199666,7199667,7199668,7199669,7199670,7199671,7199672,7199673,7199674,7199675,7199676,7199677,7199678,7199679,7199680,7199681,7199682,7199683,7199684,7199685,7199686,7199687,10101571,7199688,7199689,7199690,7199691,7199692,7199693,7199694,7199695,7199696,7199697,7199698,7199699,7199700,7199701,7199702,7199703,7199704,7199705,7199706,7199707,7199708,7199709,7199710,7199711,7199712,7199713,7199714,7199715,7199716,7199717,7199718,7199719,7199720,7199721,7199722,7199723,7199724,7199725,7199726,7199727,7199728,7199729,7199730,7199731,7199732,7199733,7199734,7199735,7199736,7199737,7199738,7199739,7199740,7199741,7199742,7199743,7199744,7199745,7199746,7199747,7199748,7199749,7199750,7199751,7199752,7199753,7199754,7199755,7199756,7199757,7199758,7199759,7199760,7199761,7199762,7199763,7199764,7199765,7199766,7199767,7199768,10623060,8906548,8906549,8906550,8906551,8906552,8906553,8906554,8906555,8906556,8906557,8906558,8906559,8906560,8906561,8906562,8906563,8906564,8906565,8906566,8906567,8906568,8906569,8906570,8906571,8906572,8906573,8906574,8906575,8906576,8906577,8906578,8906579,8906580,8906581,8906582,8906583,8906584,8906585,8906586,8906587,8906588,8906589,8906590,8906591,7196889,10838913,7197885,7197886,10617165,10617166,8905942,10615081,10615082,10615202,10615232,10426241,10615905,10615906,10615907,10615908,10615909,10615910,10615911,10615912,10615913,10615914,10615915,10615916,10615917,10615918,10615919,10615920,10615921,10615922,10615923,10615924,10615925,10615926,10615927,10615928,10615929,10615930,10615931,10615932,10615933,10615934,10615935,10615936,10615937,10615938,10615939,10615940,10615941,10615942,10615943,10615944,10615945,10615946,10615947,10615948,10615949,10615950,10615951,10615952,10615953,10615954,10615955,10615956,10615957,10615958,10615959,10615960,10615961,10615962,10615963,10615964,10615965,10615966,10615967,10615968,10615969,10615970,10615971,10615972,10615973,10615974,10615975,10615976,10615977,10615978,10615979,10615980,10615981,10615982,10615983,10615984,10615985,10426408,10426409,10426410,10426411,10426412,10426413,10426414,10426415,10426416,10426417,10426418,10426419,10426420,10426421,10426422,10426423,10426424,10426425,10426426,10426427,10426428,8611314,8611381,10616804,10616932,10610984,10610985,10614220,10714185,10714186,10611956,10611957,10611958,10612046,10609360,7017513,7017514,7017515,7017516,7017517,7017518,7017519,7017520,7017521,7017522,7017523,7017524,7017525,7017526,7017527,7017528,7017529,7017530,7017531,7017532,7017533,7017534,7017535,7017536,7017537,7017538,7017539,7017540,7017541,7017542,7017543,7017544,7017545,7017546,7017547,7017548,7017549,7017550,7017551,7017552,7017553,7017554,7017555,7017556,7017557,7017558,7017559,7017560,7017561,7017562,7017563,7017564,7017565,7017566,7017567,7017568,7017569,7017570,7017571,7017572,7017573,7017574,7017575,7017576,7017577,7017578,7017579,7017580,7017581,7017582,7017583,7017584,7017585,7017586,7017587,7017588,7017589,7017590,7017591,7017592,7017593,7017594,7017595,7017596,7017597,7017598,7017599,7017600,7017601,7017602,7017603,7017604,7017605,7017606,7017607,7017608,7017609,7017610,7017611,7017612,7017613,7017614,7017615,7017616,7017617,7017618,7017619,7017620,7017621,7017622,7017623,7017624,7017625,7017626,7017627,7017628,7017629,7017630,7017631,7017632,7017633,7017634,7017635,7017636,7017637,7017638,7017639,7017640,7017641,7017642,7017643,7017644,7017645,7017646,7017647,7017648,7017649,7017650,7017651,7017652,7017653,7017654,7017655,7017656,10612727,10612728,10612729,10612730,10612825,10612884,10612945,10610006,10610054,10610108,10610271,10610375,10610417,10613844,7055530,10117681,9169656,9169658,9169659,9169660,9169661,9169662,9169663,9169664,9169665,9169666,9169667,9169668,9169669,9169670,9169671,9169672,9169673,9169674,9169675,9169676,9169677,9169678,9169679,9169680,9169681,9169682,9169683,9169684,9169685,9169686,9169687,9169688,9169689,9169771,10118111,10118157,10118158,10118216,10118217,10118499,10118500,10118501,10118502,10118503,10118504,10118505,10118506,10118507,10415258,10415260,10415265,10415271,10415272,10415277,10415280,10418282,10418283,10418284,10415284,10418285,10418286,10418287,10415287,10418288,10418289,10418290,10418291,10418292,10418293,10418294,10418295,10418296,10418297,10418298,10418299,10415299,10418300,10418301,10418302,10418303,10418304,10418305,10418306,10418307,10418308,10418309,10418310,10415310,10418311,10418312,10418313,10418314,10418315,10418316,10418317,10418318,10418319,10418320,10418321,10418322,10418323,10418324,10418325,10418326,10418327,10418328,10418329,10418330,10418331,10418332,10418333,10418334,10418335,10418336,10418337,10418338,10418339,10418340,10418341,10418342,10418343,10418344,10418345,10418346,10418347,10418348,10418349,10418350,10418351,10418352,10418353,10418354,10418355,10418356,10418357,10418358,10418359,10418360,10418361,10418362,10418363,10418364,10418365,10418366,10418367,10418368,10418369,10418370,10418371,10418372,10418373,10418374,10418375,10418376,10418377,10418378,10418379,10418380,10418381,10418382,10418383,10418384,10418385,10418386,10418387,10418388,10418389,10418390,10418391,10418392,10418393,10418394,10418395,10418396,10418397,10418398,10418399,10418400,10418401,10418402,10418403,10418404,10418405,10418406,10418407,10418408,10418409,10418410,10418411,10418412,10418413,10418414,10418415,10418416,10418417,10418418,10418419,10418420,10418421,10418422,10418423,10418424,10418425,10418426,10418427,10418428,10418429,10418430,10418431,10418432,10418433,10418434,10418435,10418436,10418437,10418438,10418439,10418440,10418441,10418442,10418443,10418444,10418445,10418446,10418447,10418448,10418449,10418450,10418451,10418452,10416453,10418453,10418454,10418455,10418456,10418457,10418458,10418459,10418460,10418461,10418462,10418463,10418464,10419464,10418465,10419465,10416466,10418466,10418467,10418468,10416469,10418469,10416470,10418470,10418471,10418472,10418473,10418474,10418475,10418476,10418477,10418478,10418479,10418480,10418481,10418482,10418483,10418484,10418485,10418552,10418553,10418555,10418556,10418557,10418569,10418570,10418571,10418573,10418574,10418575,10418576,10418577,10418578,10418579,10415625,10415634,10419653,10419654,10419655,10419661,10419662,10419663,10419664,10419665,10415688,10415689,10117002,10117003,10117004,10117005,10416731,10117006,10117007,10417743,10418887,10415910,10415911,10415913,10415914,10416973,10416974,10416975,10117423,10117424,9169233,8550149,8550209,8550210,8550211,8550212,8550255,4972028,9167859,9167860,9167861,9168000,10470654,10470655,10470656,10470657,10470658,10470659,10470660,10470661,10470662,10470663,10470664,10470665,10470666,10470667,10470668,10470669,9168092,10470670,9168093,10470671,10470672,10470673,10470674,10470675,10470676,10470677,10470678,10470679,10470680,10470681,10470682,10470683,10470684,10470685,10470686,10470687,10470688,10470689,10470690,10470691,10470692,10470693,10470694,10470695,10470696,10470697,10470698,10470699,10470700,10470701,10470702,10470703,10470704,10470705,10470706,10470707,10470708,10470709,10470710,10470711,10470712,10470713,10470714,10470715,10470716,10470717,10470718,10470719,10470720,10884016,10884017,10884018,10884086,10884426,10884427,10884428,10884429,10884430,10884505,10884642,10884643,10884654,10884723,10875018,10875020,10885078,10885080,10153866,10627666,10883456,10162198,10162199,10585350,10582559,10582560,10524907,10524908,10482596,10482597,10482598,10482599,10482600) 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'