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(4970193,4970194,4970195,4970196,4970197,4970198,4970199,4970200,4970201,4970202,4970400,4970401,4970402,4970403,4970404,4970405,4970406,4970407,4970408,4970409,4970627,4970628,4970629,4970630,4970631,4970632,4970633,4970645,4970653,4970667,4970668,4970672,4970677,4970684,4970700,4970710,4970715,4970717,4970733,4970746,4970771,4970775,4970777,4970778,4970779,4970799,4970800,4970801,4970802,4970803,4970853,4970854,4970855,4970856,4970857,4970858,4970860,4970874,4970875,4970876,4970877,4970879,4970880,4970886,4970887,4970888,4970889,4970891,4970894,4970895,4970901,4970902,4970903,4970904,4970907,4970908,4970909,4970910,4970913,4970915,4970916,4970917,4970921,4970922,4970931,4970936,4970951,4970952,4970954,4970955,4970962,4970963,4970964,4970965,4970967,4970968,4970973,4970984,4970986,4970990,4970991,4971023,4971030,4971060,4971061,4971062,4971092,4971093,4971140,4971148,4968180,4968219,4968291,4968292,4968459,4968460,4968488,4968615,4968644,4968650,4968716,4968717,4968718,4968719,4968720,4968721,4968722,4968723,4968822,4968827,4968848,4968850,4968851,4968852,4968853,4968854,4969265,4969266,4969267,4969268,4969269,4969287,4969303,4969304,4969305,4969306,4969307,4969340,4969341,4969342,4969343,4969344,4969345,4969346,4969347,4969426,4969427,4969428,4969429,4969430,4969431,4969432,4969433,4969549,4969588,4969593,4969600,4969648,4969649,4969650,4969651,4969710,4969711,4969712,4969713,4969714,4969715,4969716,4969717,4969718,4969719,8075034,8075035,8075036,8075037,8075038,8075039,8075040,8075041,8075042,8075043,8075044,8075045,8075046,8075047,8075048,8075049,8075050,8075051,8075052,8075053,8075054,8075055,8075056,8075057,8075058,8075059,8075060,8075061,8075062,8075063,8075064,8075065,8075066,8075067,8075068,8075069,8075070,8075071,8075072,8075073,8075074,8075075,8075076,8075077,8075078,8075079,8075080,8075081,8075082,8075083,8075084,8075085,8075086,8075087,8075088,8075089,8075090,8075091,8075092,8075093,8075094,8075095,8075096,8075097,8075098,8075099,8075100,8075101,8075102,8075103,8075104,8075105,8075106,8075107,8075108,8075109,8075110,8075111,8075112,8075113,8075114,8075115,8075116,8075117,8075118,8075119,8075120,8075121,8075122,8075123,8075124,8075125,8075126,8075127,8075223,8075224,8075242,8075288,4967030,4967031,4967032,4967062,4967069,4967070,4967071,4967072,4967073,4967074,4967075,4967076,4967077,4967078,4967079,4967080,4967081,4967097,4967115,4967116,4967119,4967126,4967127,4967134,4967140,4967153,4967156,4967169,4967172,4967179,4967182,4967183,4967198,4967202,4967207,4967213,4967221,4967222,4967223,4967224,4967230,4967231,4967233,4967234,4967246,4967262,4967267,4967270,4967279,4967286,4967287,4967289,4967291,4967293,4967307,4967312,4967327,4967328,4967329,4967330,4967335,4967342,4967344,4967355,4967361,4967380,4967389,4967396,4967397,4967401,4967418,4967436,4967437,4967438,4967439,4967440,4967448,4967449,4967506,4967510,4967514,4967549,4967550,4967551,4967552,4967558,4967561,4967562,4967563,4967564,4967565,4967566,4967574,4967575,4967576,4967577,4967578,4967579,4967580,4967586,4967596,4967597,4967598,4967606,4967613,4967615,4967618,4967646,4967647,4967648,4967654,4967655,4967656,4967657,4967658,4967659,4967666,4967669,4967677,4967678,4967679,4967680,4967706,4967709,4967723,4967731,4967739,4967743,4967759,4967763,4967767,4967770,4967773,4967774,4967775,4967780,4967782,4967785,4967786,4967808,4967817,4967835,4967836,4967841,4967858,4967862,4967863,4967864,4967865,4967866,4967867,4967868,4967869,4967870,4967871,4967872,4967873,4967874,4967875,4967876,4967877,4967878,4967879,4967880,4967881,4967882,4967883,4967884,4967898,4967899,4967933,4967935,4967942,4967944,4967962,4967968,4967969,4967975,4967976,4967980,4967981,4967986,4967987,4967988,4967989,4967992,4967994,4967996,4968007,4968024,4968028,4968037,4968038,4968039,4968040,4968041,4968042,4968043,4968044,4968045,4968046,4968047,4968048,4968050,4968054,4968056,4968057,4968073,8073947,8073948,8073949,8073950,8073951,8073952,8073953,8073954,8073955,8073956,8073957,8073958,8073959,8073960,8073961,8073962,8073963,8073964,8073965,8073966,8073967,8073968,8073969,8073970,8073971,8073972,8073973,8073974,8073975,8073976,8073977,8073978,8073979,8073980,8073981,8073982,8073983,8073984,8073985,8073986,8073987,8073988,8073989,8073990,8073991,8073992,8073993,8073994,8073995,8073996,8073997,8073998,8073999,8074000,8074001,8074002,8074003,8074004,8074005,8074006,8074007,8074008,8074009,8074010,8074011,8074012,8074013,8074014,8074015,8074016,8074017,8074018,8074019,8074020,8074021,8074022,8074023,8074024,8074025,8074026,8074027,8074028,8074029,8074030,8074031,8074032,8074033,8074034,8074035,8074036,8074123,8074124,8074125,8074126,8074127,8074128,8074129,8074130,8074131,8074132,8074133,8074134,8074135,8074136,8074137,8074138,8074139,8074140,8074141,8074142,8074143,8074166,8074167,8074168,8074169,8074170,8074171,8074172,8074173,8074174,8074175,8074176,8074177,8074178,8074179,8074180,8074181,8074182,8074183,8074184,8074185,8074186,8074187,8074188,8074307,8074308,8074309,8074310,8074311,8074312,8074313,8074314,8074315,8074316,8074317,8074318,8074319,8074320,8074321,8074322,8074323,8074324,8074325,8074326,8074327,8074328,8074360,8074361,8074362,8074363,8074364,8074365,8074366,8074367,8074368,8074369,8074370,8074371,8074372,8074373,8074374,8074375,8074376,8074377,8074378,8074379,8074380,8074381,8072303,8072304,8072305,8072306,8072307,8072308,8072472,8072473,8072474,8072475,8072476,8072477,8072478,8072479,8072480,8072481,8072482,8072483,8072484,8072485,8072486,8072487,8072488,8072489,8072490,8072491,8072492,8072493,8072511,8072577,8072610,8072611,8072612,8072613,8072614,8072615,8072643,8072644,8072645,8072646,8072647,8072648,8072649,8072650,8072651,8072652,8072653,8072654,8072655,8072656,8072657,8072658,8072659,8072660,8072661,8072662,8072663,8072664,8072665,8072666,8072667,8072668,8072669,8072670,8072671,8072672,8072673,8072674,8072675,8072676,8072677,8072678,8072679,8072680,8072681,8072682,8072683,8072684,8072685,8072686,8072687,8072688,8072689,8072690,8072691,8072692,8072693,8072694,8072695,8072696,8072697,8072793,8072794,8072795,8072796,8072797,8072798,8072799,8072800,8072801,8072802,8072803,8072804,8072805,8072806,8072807,8072808,8072809,8072810,8072811,8072812,8072813,8072814,8072815,8072816,8072817,8072818,8072819,8072820,8072821,8072822,8072823,8072824,8072825,8072826,8072827,8072828,8072829,8072830,8072831,8072832,8072833,8072834,8072835,8072836,8072837,8072838,8072839,8072840,8072841,8072842,8072843,8072844,8072848,8072849,8072850,8072851,8072852,8072868,8072869,8072870,8072871,8072872,8072886,8072887,8072888,8072889,8072890,8072904,8072905,8072906,8072907,8072908,8072920,8072921,8072922,8072923,8072924,8072935,8072936,8072937,8072938,8072939,8072940,8072941,8072942,8072953,8072954,8072955,8072956,8072957,8072969,8072970,8072971,8072972,8072973,8072996,8073000,8073054,8073060,8073082,8073088,8073094,8073095,8073438,8073441,8073442,8073444,8073501,8073519,8073533,8073534,8073535,8073536,8073537,8073538,8073539,8073540,8073541,8073544,10623022,10623023,10623024,10623025,10623038,10623039,10623048,10623049,10623050,10623054,10623100,10623101,10623168,10623169,10623185,10623186,10623187,10623188,10623189,10623190,10623191,10623192,10623193,10623194,10623195,10623196,10623197,10623248,10623254,10623256,10623300,10623303,10623319,10623378,10623401,10623413,10623466,10623490,10623493,10623504,10623551,10623570,10623593,10623594,10623598,10623599,10623600,10623601,10623602,10623603,10623604,10623672,10623673,10623674,10623771,10623772,10623773,10623807,10623808,10623809,10623810,10623811,10623812,10623813,10623814,10623815,10623816,10623817,10623818,10623819,10623820,10623821,10623822,10623841,10623898,10623908,10623909,10623910,10623911,10623912,10623913,10623914,10623915,10623916,10623917,10623918,10623919,10623920,10623921,10623922,10623923,10623924,10623925,10623926,10623927,10623928,10623929,10623930,10623931,10623932,10623933,10623934,10623935,10623936,10623937,10623938,10623939,10623940,10623968,10623969,10623993,10623994,10624049,10624135,10624136,10624137,10624234,10624235,10624246,10624253,10624273,10624274,10624275,10624279,10624280) 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'