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(8630581,8630582,8630583,8630584,8630585,8630586,8630587,8630588,8630589,8630590,8630591,8630592,8630593,8630594,8630595,8630596,8630597,8630598,8630599,8630600,8630601,8630602,8630603,8630604,8630605,8630606,8630607,8630608,8630609,8630610,8630611,8630612,8630613,8630614,8630615,8630616,8630617,8630618,8630619,8630620,8630621,8630622,8630623,8630624,8630643,8630647,8630649,8630650,8630651,8630652,8630653,8630654,8630657,8630658,8630661,8630663,8630664,8630669,8630670,8630671,8630672,8630673,8630674,8630675,8630676,8630677,8630678,8630679,8630680,8630681,8630682,8630683,8630684,8630685,8630686,8630687,8630688,8630689,8630690,8630691,8630698,8630699,8630700,8630701,8630702,8630703,8630704,8630710,8630711,8630712,8630713,8630714,8630715,8630716,8630717,8630718,8630719,8630720,8630721,8630722,8630723,8630724,8630725,8630726,8630727,8630728,8630729,8630730,8630731,8630732,8630733,8630734,8630735,8630736,8630737,8630738,8630739,8630740,8630741,8630742,8630744,8630745,8630747,8630748,8630749,8630750,8630751,8630755,8630756,8630759,8630760,8630765,8630766,8630767,8630768,8630769,8630770,8630771,8630772,8630773,8630774,8630775,8630776,8630779,8630780,8630782,8630786,8630787,8630794,8630795,8630796,8630797,8630798,8630799,8630800,8630801,8630802,8630803,8630804,8630805,8630806,8630807,8630811,8630839,8630843,8630854,8630863,8630864,8630865,8630866,8630867,8630868,8630892,8630896,8630897,8630906,8630907,8630908,8630918,8630936,8630958,8630959,8630963,8630965,8630967,8630970,8630971,8630972,8630973,8630974,8630976,8630977,8574513,8630987,8630988,8630989,8630990,8630991,8630993,8630994,8630995,8630996,8630997,8630998,8630999,8631001,8631002,8631003,8631004,8631005,8631007,8631009,8631010,8631011,8631013,8631028,8631071,8631075,8631091,8631092,8631093,8631094,8631095,8631096,8631097,8631098,8631099,8631100,8631101,8631102,8631103,8631104,8631105,8631106,8631107,8631108,8631109,8631110,8631111,8631112,8631113,8631114,8631115,8631116,8631117,8631118,8631128,8631129,8631130,8631131,8631132,8631139,8631140,8631141,8631142,8631143,8631144,8631145,8631147,8631180,8631181,8631182,8631183,8631185,8631186,8631187,8631189,8631192,8631194,8631195,8631196,8631197,8631198,8631199,8631200,8631201,8631202,8631203,8631204,8631208,8631209,8631210,8631211,8631212,8631213,8631214,8631215,8631216,8631217,8631218,8631219,8631220,8631221,8631222,8631223,8631224,8631225,8631226,8631227,8631228,8631229,8631230,8631231,8631232,8631233,8631234,8631235,8631236,8631237,8631238,8631239,8631240,8631241,8631242,8631243,8631244,8631245,8631246,8631247,8631249,8631251,8631252,8631276,3229130,3229131,8631382,8631383,8631384,8631385,8631386,8631387,8631388,8631389,8631390,8631391,8631392,8631393,8631394,8631395,8631396,8631397,8631398,8631399,8631401,8631402,8631403,8631404,8631413,8631414,8631415,8631416,8631417,8631418,8631419,8631422,8631423,8631424,8631425,8631428,8631429,8631430,8631431,8631432,8631433,8631434,8631435,8631437,8631438,8631439,8631440,8631441,8631442,8631443,8631450,8631451,8631480,8631481,8631482,8631483,8631484,8631485,8631486,8631487,8631488,8631489,8631490,8631491,8631492,8631493,8631494,8631495,8631496,8631497,8631498,8631499,8631500,8631501,8631502,8631503,8631504,8631505,8631506,8631507,8631508,8631509,8631510,8631511,8631512,8631513,8631514,3229285,8631515,8631516,8631517,8631518,8631519,8631526,8631527,8631528,8631529,8631530,8631531,8631532,8631533,8631534,8631535,8631536,8631537,8631565,8631566,8631567,8631589,8631590,8631596,8631597,8631598,8631607,8631608,8631610,8631612,8631613,8631617,8631618,8631619,8631620,8631630,8631658,8631659,8631661,8631662,8631667,8631668,8631670,8631672,8631673,8631674,8631676,8631677,8631678,8631679,8631680,8631681,8631685,8631686,8631689,8631690,8631691,8631694,10950685,8631708,8631709,8631714,8631715,8631716,8631717,8631718,8631719,8631721,8631722,8631724,8631725,8631728,8631730,8631731,8631732,8631736,8631738,8631739,8631743,8631744,8631745,8631749,8631750,8631752,8631753,8631755,8631756,8631757,8631758,8631763,8631764,8631765,8631775,8631793,8631794,8631795,8631796,8631797,8631798,8631799,8631807,8631808,8631813,8631814,8631816,8631817,8631818,8631819,8631820,8631821,8631822,8631823,8631824,8631825,8631826,8631827,8631828,8631842,8631843,8631844,8631847,8631848,8631849,8631853,8631856,8631857,8631858,8631859,8631860,8631861,8631862,8631863,8631866,8631868,8631870,8631871,8631872,8631873,8631890,8631899,8631900,8631901,8631902,8631903,8631904,8631905,8631906,8631907,8631908,8631909,8631910,8631911,8631912,8631913,8631914,8631915,8631916,8631917,8631918,8631919,8631920,8631921,8631922,8631923,8631957,8631958,8631959,8631960,8631961,8631962,8631963,8631964,8631965,8631966,8631967,8631968,8631969,8631970,8631971,8631972,8631973,8631995,8631996,8631997,8631998,8631999,8632000,8632001,8632002,8632003,8632004,8632005,8632006,8632007,8632008,8632009,8632010,8632011,8632012,8632013,8632014,8632015,8632016,8632017,8632018,8632019,8632020,8632021,8632022,8632023,8632024,8632025,8632026,8632027,8632028,8632029,8632030,8632031,8632032,8632033,8632034,8632035,8632036,8632037,8632098,8632099,8632100,8632101,8632102,8632103,8632104,8632105,8632106,8632107,8632108,8632109,8632110,8632111,8632112,8632113,8632114,8632115,8632116,8632117,8632118,8632119,8632120,8632121,8632122,8632123,8632124,8632125,8632126,8632127,8632128,8632129,8632130,8632131,8632132,8632133,8632134,8632135,8632136,8632137,8632138,8632139,8632140,8632141,8632142,8632143,8632144,8632145,8632146,8632147,8632187,8632190,8632191,8632192,8632193,8632194,8632195,8632196,8632197,8632198,8632199,8575733,8632202,8575734,8632203,8575735,8632204,8632205,8632211,8632212,8632213,8632214,8632215,8632216,8632217,8632218,8632219,8632220,8632221,8632222,8632223,8632224,8632225,8632226,8632227,8632228,8632229,8632230,8632231,8632232,8632233,8632234,8632235,8632236,8632237,8632238,8632240,8632241,8632242,8632243,8632244,8632245,8632246,8632247,8632248,8632249,8632250,8632251,8632252,8632253,8632254,8632255,8632256,8632257,8632258,8632259,8632260,3230230,8837553,10930095,7201309,7201366,7201399,7201616,7201727,7201728,7201729,7201741,7201742,7201775,7201776,7201777,7201778,7201779,7201780,7201781,7201782,7201974,7202129,7202130,7202133,7202137,7202139,7202140,7202162,7202165,7202168,7202171,7202200,8618791,7202208,7202265,7202266,7202314,7202316,7202325,7202327,7202369,7202524,9794578,9794579,9794580,9794587,9794588,9794592,7202769,9794594,3237396,3237398,7200578,10959088,10100083,7198688,7198784,7198785,7070473,7196291,7196378,7196524,7197051,8613644,7197075,8906893,8906894,8906895,8906896,10838801,10838923,7197725,7197726,7197727,7197728,7197729,7197730,7197731,7197732,7197733,7197734,7197735,7197736,7197737,7197738,7197739,7197740,7197741,7197742,7197743,7197744,7197745,7197746,7197747,7197793,7197941,10619895,10619896,3232382,8541549,8905240,3232913,3232914,3232915,8542165,8905711,10425910,10425937,10426193,10426197,8540418,8540631,10616644,10616655,9205364,9205365,9205366,6669828,10611856,6666259,10612320,10612321,10612916,10613179,10613214,10613215,10610233,10613513,10613514,9204938,10610881,10610901,10610954,10515423,6674198,6674280,6674327,6674328,6674329,6674330,6674331,10514037,10514038,10514090,10514091,10514092,10514093,10514364,10514391,10514392,10514393,10514394,10514395,10514396,10514397,10514398,10514399,10514400,10514401,10514402,10514403,10514404,10514405,10514406,10514407,10514408,10514409,10514412,10514413,10514414,10514415,10514416,10514426,10514427,10514428,10514429,10514430,10514431,10514433,10514434,10515072,10515087,10515088,10515089,10515090,10515091,10515092,10515093,10515094,10515095,10515096,10515097,6672592,6672686,10416481,6672896,6672897,6672898,6672899,6672900,6672901,6672960,6673017,6673021,6673025,6673035,6673036,6673051,6673122,6673124,6673125,8550037,8550038,9168101,10883562,10883589,10883590,10883591,10883592,10883593,10883596,10883626,10883630,10883966,10893986,10893987,10893988,10889019,10889020,10889021,10884083,10884652,10889707,10889997,10890165,10885316,7000826,10627319,10883421,10888457,10886057,10886878,10886910,10887052,10882359,10582561,10588641,10542654,10505583) 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'