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(8630753,8630756,8630810,8630811,8630854,8630855,8630856,10861522,10861523,10861524,10861525,10861530,10861531,10861532,10861533,10861536,10861537,10861538,10861539,10861542,10861543,8630902,10861544,10861545,8630903,10861546,10861547,10861548,10861549,10861550,8630980,8630981,8630982,8630993,8631003,10861663,10861664,8631031,8631032,8631033,8631034,8631035,8631036,8631037,8631038,8631039,8631040,8631041,8631042,8631043,8631044,8631045,8631146,8631148,8631149,8631151,8631152,8631154,8631156,8631157,8631158,8631159,8631160,8631161,8631162,8631163,8631253,3229196,8631540,8631541,8631542,8631543,8631544,8631545,8631546,8631547,8631548,8631549,8631550,8631551,8631552,8631553,8631559,8631596,8631597,8631607,8631608,8631610,8631636,7066100,3229978,10862885,10862897,10862900,10862901,10862911,8629639,8067927,8629705,8629734,8629736,10860677,10860678,10860679,10860687,10860704,10860705,10860716,10860719,10860720,10860721,10860722,10860723,10860724,10860729,10860730,10860733,10860734,10860740,10860746,10860749,10860750,10860751,10860768,10860782,10860786,10860787,10860788,10860792,10860808,10860820,10860822,10860860,10860864,10860869,10860884,10860906,10860914,10860917,10860924,10860925,10860930,10860947,10860948,10860949,10860950,10860951,10860952,10860957,10860973,10860974,3238357,7201333,7201334,3238534,8627789,7201416,7201417,7201418,7201419,7201420,7201421,10858719,10858722,10858723,8628101,7201705,7201743,8595164,8628212,8628249,7201959,8065841,8065842,10859281,10859283,10859284,7202524,7202681,8629273,8629274,8629326,8629327,8629328,8629329,8629330,8629331,8629333,8629340,8629341,10860030,10860031,10860032,8629431,8629471,8629476,8629477,8626840,8626841,8626842,8626843,8626844,8626927,10865832,10857890,10865956,8627471,8627472,10866131,10866134,10866145,10100083,10855624,10855741,7198722,7198723,8625157,7199006,10864309,10864320,10864330,10864331,10856347,8626258,8626259,10857128,3923441,3923467,10853411,3923567,3923602,3923604,3923607,8554352,10623505,8906770,10968547,10854331,10854361,8624409,8624410,8624412,8624413,8624416,8624417,8624418,8624429,8905237,8634955,8634956,3232882,3232883,8905732,8905733,8905734,8905735,8905772,8905777,8632614,8632615,8632616,8632617,8632625,10850371,10850373,10850715,10615599,10615603,10615604,10615605,10615606,10615608,10615609,10615614,10615615,10615620,10615623,10615625,8633332,8633333,8633334,8633335,8633336,8633337,8633343,8633348,8633349,8633350,8633351,8633352,8633353,8633354,8633355,8633356,8633357,8633358,8633359,8633360,8633361,8633362,8633363,8633364,8633365,10615896,10426358,10426359,10426360,8540671,8540672,10616224,8634104,8634107,8634110,8634239,8634240,8634241,8634242,8634243,8634244,8634245,8634246,8634247,8634248,8634249,8634250,8634251,10616655,8634297,8634298,10616696,10616697,10616698,8634378,8634379,10616866,10616932,8634557,8634558,8634560,8634561,8634562,8634563,8634564,10613967,10613981,10613982,10613983,10613987,10613999,7059524,10614022,10614023,10614024,10614027,10614028,10614029,10614034,10614044,10614048,10614050,10614054,10614055,10614056,10614057,10614064,10612413,10609770,10609811,8852014,8852015,8852021,10612904,10612905,10610359,10613453,10613464,10613797,10613801,10613802,10613808,10613809,10613829,10613830,10613831,10613837,10613840,10613844,10613853,10613858,10613859,10613860,10613874,10613904,10613908,10613909,10613912,10613928,10613929,10613942,10613943,6673685,6673688,6673692,6673700,9169559,9169561,9169563,9169845,10118153,6674166,9912638,9912648,9913091,9913092,10415416,10415417,10415418,10415419,10415424,10415425,10415426,10415427,10415430,10415431,10415432,10415433,10415434,10415435,10415438,10415439,10415440,10415441,10415442,10415443,10415444,10415445,10415446,10416453,10416466,10416469,10416470,10416481,10415537,10415538,9168668,10417634,10417649,10417650,6673085,6673088,6673089,9169025,9169028,9169029,9169033,9169055,9169057,9169066,9169075,9169076,9169288,10471078,6670730,10469326,10469354,10469384,8550077,10115665,10427657,10427658,10427659,10427660,10883492,10888681,10888682,10903862,10889247,10889577,10889578,10889579,10889580,10889581,10884759,10874947,10889983,10890249,10888082,10888100,10888275,10885856,10161931,10886041,10886050,10886051,10886057,10886061,10886068,10886071,10886080,10886082,10886135,10886136,10886139,10886154,10886158,10886161,10886163,10886180,10886183,10886270,10886308,10886322,10886361,10886362,10886439,10886446,10886452,10886478,10886547,10886559,10886563,10886568,10886569,10886570,10886582,10886589,10886595,10886601,10886631,10876634,10886654,10886671,10886672,10886678,10886694,10886698,10886725,10886738,10886741,10886742,10886743,10886744,10886745,10886746,10886747,10886748,10886749,10886750,10886751,10886752,10886753,10886761,10886765,10886772,10886773,10886774,10886775,10886799,10886800,10886802,10886818,10886821,10886846,10886861,10631455,10631456,10882238,10608607,10647550,10647551,10647552,10647564,10607702,10508268,10508269,10508567,10507567,10413261,10413264,10413265,10413728,10413730,10413731,10410068,10414424,10414425,10410787,10410902,10414924,10414925,10414926,10414927,10414939,10414940,10414952,10414953,10414955,10414956,10414957,10414958,10414959,10414960,10414961,10414962,10414963,10414965,10414966,10414967,10414968,10414969,10414970,10414971,10414974,10414975,10414976,10414977,10414978,10414987,10414988,10414989,10414990,10414991,10414992,10414994,10414995,10414996,10414997,10414998) 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'