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(10939609,10939612,10939615,8068888,7067955,10962653,10962664,10962665,10962677,10962678,10962679,10962680,10962681,10962682,10962683,10962684,10962685,10962686,10962687,10962688,10962689,10962690,10962693,10962694,7068229,7068230,7068231,7068232,7068233,7068234,7068235,7068236,7068237,7068238,7068239,7068240,7068241,7068242,10940156,10940157,10940158,10940159,4970861,4970862,4970863,4970864,10963304,4970970,10963320,10963321,10963322,10963326,10963491,10933286,10933287,7074315,7074316,10437309,7074640,7074650,7074670,10974500,10974501,10974502,10974503,10974504,10974505,7066822,10974506,7074823,10974507,7066824,10974508,7074824,7074825,7066825,10974509,10974510,10974511,10974512,10974513,10974514,10974515,10974516,10974517,10974518,10974519,10974520,10974521,10974522,10974523,10974524,10974525,10974526,10974527,10974528,10974529,10974530,10974531,10974532,10974533,10974534,10974535,10974536,10974537,10974538,10974539,10974540,10974541,10974542,10974543,10974544,10974545,10974546,10974547,10974548,10974549,10974550,10974551,10974552,10974553,10974554,10974555,7074871,10974556,7074872,10974557,10974558,10974559,10974560,10974561,10974562,10974563,10974564,10974565,10974566,10974567,10974568,10974569,10974570,10974571,10974572,10974573,10974574,10974575,10974576,10974577,10974578,10974579,10974580,10974581,10974582,7074899,10974583,10974584,10974585,10974586,10974587,10974588,10974589,10974590,10974591,10974592,10974593,10974594,10974595,10974596,10974597,10974598,10974599,10974600,7066917,10974601,10974602,10974603,10974604,10974605,10974606,10974607,10974608,10974609,10974610,10974611,10974612,8067911,10974613,8067912,10974614,10974615,10974616,10974617,10974618,10974619,10974620,7074937,10974621,10974622,10974623,10974624,10974625,10974626,10974627,10974628,10974629,10974630,10974631,10974632,10974633,10974634,10974635,10974636,10974637,10974638,10974639,10974640,10974641,10974642,10974643,10974644,10974645,10974646,10974647,10974648,10974649,10974650,10974651,10974652,10974653,10974654,10974655,10974656,10974657,10974658,10974659,10974660,10974661,10974662,10974663,10974664,10974665,10974666,10974667,10974668,10974669,10974670,10974671,10974672,10974673,10974674,10974675,10974676,10974677,10974678,10974679,10974680,10974681,10974682,10974683,10974684,10974685,10974686,10974687,10974688,7075033,7075034,7075035,10961739,10961740,7075082,7075083,7075084,7075147,10962047,10962048,10962049,7075442,7075460,8068597,10939397,6000102,7071822,7071823,7071824,6000222,10972705,10972842,10972943,7072496,10960180,10960426,10960427,10960428,10960457,10960458,10960459,10960460,10960464,10960599,8066020,10932673,10932683,10961205,10961206,10961282,10961283,10961284,10961285,10961286,4968072,4968073,10933203,10961472,10961473,10961474,10961475,10961476,10961477,10961478,10961479,10974485,10974486,10974487,10974488,10974489,10974490,10974491,10974492,10974493,10974494,10974495,10974496,10974497,10974498,10974499,7070885,7070886,7070887,7070888,7070909,7071003,7071167,10942968,7071360,7071361,10943153,10943154,5999963,7071695,10972420,8970226,6000094,3655668,10940708,10940709,7069019,7069226,7069227,10944756,7069457,10944974,10944975,3656576,10970670,10970671,8073079,10971391,10942436,7070744,10942500,10918490,10918491,10918492,10918493,10918494,10918498,10918499,10618193,10918788,10918792,10918793,10918794,10918795,10918796,10918797,10918798,10918799,10918800,10618362,10618363,10618365,10618367,10618368,10618370,10924036,10924037,10924038,10924039,10924040,10924041,10924042,10968088,10968089,10618821,10618822,10618823,10618824,10618825,10919529,10919530,10919531,10919532,10924580,10924581,10924582,10924583,10924584,10924585,10924586,10924587,10924588,10924589,10924590,10924591,10924592,10619131,10619132,10619135,10619136,10619137,10968675,10619138,10619139,10619141,10619142,10619143,10619146,10619147,10619148,10968783,10924770,10919831,10919832,10919834,10919835,10619330,10619331,10968959,10968960,10968961,10968962,10968963,10968964,10968965,10925374,10966549,10966550,10966551,10966552,10966553,10927874,10927875,10927876,10927877,10927878,10918003,10617518,10617519,10918304,10925542,10925543,10925544,10925545,10925546,10920555,8570032,10925714,10925715,10925716,10925717,10925718,10925719,10615240,10615241,8570071,10615294,10615352,10925878,10620429,10920968,8570366,8570488,10921206,10921249,10616016,10930888,10930889,10930895,10930896,10921638,10921739,10921740,10921741,10921742,10921743,10926786,10621421,10927078,10927079,10927080,10927274,10917443,10917444,10917445,10562118,10562136,10562137,10562138,10562139,10562156,10562184,10565195,10562205,10562206,10562207,10562222,10562232,10562242,10562244,10562245,10559318,10559319,10562374,10562399,10562412,10559484,10559485,10559486,10559487,10559488,10614339,10559489,10559490,10559491,10559492,10559493,10559494,10559495,10559496,10559497,10559500,10559501,10559502,10559503,10562505,10562506,10562569,10562570,10562579,10562580,10562581,10559616,10559617,10559618,10559619,10559620,10559621,10562623,10562624,10562625,10562626,8864336,10562633,10559693,10559788,10559789,8864502,8864507,10611701,10559926,10559927,10559928,10559929,10559930,10559931,10559932,10559933,10557448,10557533,10557534,10563535,10557535,10563536,10557536,10557537,10557538,10557539,10557540,10557541,10557542,10557543,10557544,10557545,10557546,10557547,10557548,10557549,10557550,10557551,10557552,10557553,10557554,10557555,10557556,10557557,10557558,10557559,10557560,10557561,10557562,10557563,10557564,10557565,10557566,10557567,10557568,10557569,10557570,10557571,10557572,10557573,10557574,10557575,10557576,10557577,10563578,10557578,10557579,10563579,10557580,10557581,10557582,10563582,10557583,10557584,10557585,10557586,10557587,10557588,10563588,10557589,10563589,10557590,10557591,10557592,10557593,10557594,10557595,10557596,10557597,10557598,10557599,10557600,10557601,10557602,10557603,10557604,10557605,10557606,10557607,10557608,10557609,10563720,10563721,10563722,10563723,10563724,10563725,10563726,10563727,10563795,10563796,10563805,10563813,10563827,10563828,10563829,10563924,10563925,10563936,10563937,10563945,10563946,10563955,10563963,10563964,10563965,10563966,10563967,10563968,10563969,10563975,10563976,10612990,10564141,10564142,10564151,10564200,10613087,10613088,10613098,10613191,10613192,8863133,10613275,10564426,10564429,10564430,10564431,10564432,10564434,10564435,8863144,10564436,10564437,10564438,10564439,10564440,10564441,10564448,10564449,10564451,10564452,10564453,10558466,10558470,10561555,10561556,10561613,10561614,10561615,10561616,10561617,10561618,10561619,10561620,10561621,10561622,10564646,10561666,10561667,10561668,10561669,10561670,10561671,10561672,10561673,10564735,10564736,10564737,10564738,10564739,10561752,10561759,10561760,10561761,10561762,10561763,10561764,10561765,10564806,10564807,10561813,10561859,10561860,10561861,10561862,10561863,10561864,10610715,10561865,10561866,10561867,10561868,10561869,10561870,10561871,10561872,10564994,10562059,10562060,10555298,10555299,10555381,4974615,4974616,4974617,4974618,10515719,10515720,10515721,10513730,10515737,10515738,10515743,10515744,10515745,10515746,10515747,10515748,10515749,10515777,10515778,10515779,10515780,10515784,10515785,10515786,4974831,10515793,10515797,10515798,10515799,10515800,10515814,10515815,10515816,10515822,10515823,4974864,10515834,10515835,10515836,10513941,10513942,10513943,10515965,10515966,10515967,10515968,10513969,4975009,10515969,10515970,10515971,10515972,10515973,10515974,10515975,10515976,10515977,10515978,10515979,10515980,10515981,10515982,10515983,10515984,10515985,10515986,10515987,10515988,10515989,10515990,10515991,10515992,10515993,10515994,10515995,10515996,10515997,10515998,10515999,10516000,10516001,10516002,10516003,10516004,10516005,10514006,10516006,10514007,10516007,10516008,10516009,10516010,10516011,10516012,10516013,10516055,10516064,10556671,10516677,10516679,10512783,10512784,10512821,2809640,10518855,10513042,10419343,10417738,10416799,10416807,10418809,10418810,10418811,4973769,4974001,10417087,10417088,10417094,10417095,10417181,4974127,10471105,10471118,4971505,10467478,10471482,10471483,10471484,10471485,10471486,8563404,10462393,10470676,10628431,10628446,10628512,10628521,10628522,10628523,10628530,10628548,10628786,10629349,10629522,10629656,10627121,10627129,10627716,10626732,10626733,10626734,10626735,10626739,10626740,10626741,10626743,10626744,10568547,10568596,10567317,10567348,10567349,10567350,10567351,10567354,10567355,10567361,10567448,10567450,10567453,10567455,10567669,10567678,10567687,10520762,10520773,10520928,10520929,10520930,10520933,10520958,10520959,10520960,10520961,10520962,10520963,10520964,10520965,10420383,10420415,10420848,10421105,10421106,10473010,10473019,10473343,10473344,10473420,10473421,10473422,10473423,10473424,10473485,10473497,10473498,10473499,10473500) 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'