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(7068248,7068250,7068253,7068257,7068288,7068289,7068292,7068295,7068300,10976030,10976031,10976032,10976033,7068350,10976034,10976035,7068351,7068352,7068361,10940153,10940155,10940161,10940184,10976284,10976290,10976330,10976331,10976332,10976344,10976359,10976360,10976361,10976362,10976363,10976369,10940324,10940327,4970959,4970985,10940400,7068795,7068798,7068803,4971034,4971035,4971036,7074109,10976795,10976796,10976797,10976798,10976799,10976800,10976801,10976802,10976803,10976804,7074152,7074153,7074154,7074155,10976867,10976868,10976869,10976870,10976871,10976872,7066335,7066659,7066660,7066661,7066662,7066663,7066664,10977452,10977453,10977464,10977465,7066798,10974713,10987780,10987781,10987782,10987783,10987816,10987817,10987818,10975115,10975116,10975117,10975118,10975119,10975120,10975121,10975122,10975123,7067544,7067545,10975398,10975425,10962449,10972626,10972627,10972650,10972651,10972801,10972802,10972803,10972804,10972805,10972806,10972807,10972808,10972809,10972810,10972811,10972812,10972813,10972814,10972815,10972816,10972817,10972818,10972819,10972820,10972821,10972822,10972823,10972824,10972825,10972826,10972827,10972828,10972829,10972830,10972831,10972832,10972833,10972834,10972835,10972836,10972837,10972838,7072341,7072342,7072346,7072413,7072414,10973154,10973155,8066166,8066294,10974334,10974335,10974375,10974376,10974377,10974444,10974445,10974446,10971633,10971634,7070960,10984658,7071015,7071017,7071023,7071028,7071051,7071052,10971771,10971772,10942746,10984813,10942792,10971900,10971901,10971902,10971934,10958963,10972003,10972004,10972005,10972042,10943021,10972088,10943038,10985152,10985172,10985173,10985174,7071605,7071607,10972515,10972516,10972517,3655587,3655594,10940838,10940839,7069224,7069390,10970281,10970282,10970283,10970284,10970285,10970286,10970287,10970288,10970289,10970290,10970291,10970292,10970293,10970294,10970295,10970296,10970297,10970298,10970299,10970300,10970301,10970302,10970303,10970304,10970305,10970306,10970307,10970308,10970309,10970310,10970311,10970312,10970313,10970314,10970315,10970316,10970317,10970318,10970319,10970320,10970321,10970322,10970323,10970324,10970325,10970326,10970327,10970328,10970329,10970330,10970331,10970332,10970333,10970334,10970335,10970336,10970337,10970338,10970339,10970340,10970341,10970342,10970343,10970344,10970345,10970346,10970347,10970348,10970349,10970350,10970351,10970352,10970353,10970354,10970355,10970356,10970357,10970358,10970359,10970360,10970361,10941323,10941339,10970477,10996529,7070099,7070100,7070101,10996817,10996824,10996835,10996836,10996837,10996838,10996844,10996845,10996846,10996862,10996863,10983868,10983869,10996873,10996874,10996875,10996879,10996880,10996881,10983915,10983924,10971020,10971021,10971022,10971023,10971024,10971025,10971026,10971027,10971028,10971029,10971030,10971031,10971032,10971033,10971034,10971035,10971036,10971037,10971038,10971039,10971040,10971041,10971042,10971043,10971044,10971045,10971046,10971047,10971048,10971049,10971050,10971051,10971052,10971053,10971054,10971055,10971056,10971057,10971058,10971059,10971060,10971061,10971062,10971063,10971064,10971065,10971066,10971067,10971068,10942041,10942042,10942043,10942045,10942365,8073496,8073522,10971531,10971585,10971586,10971587,10971588,10971589,10971590,10971591,10971592,10971593,10618036,10993798,10618140,10618141,11006895,10994016,10994017,10994018,10994019,10994020,10994021,10994022,10994023,10994024,10968648,10618993,10618994,10924790,10924791,10924792,10924793,10924794,10924795,10924796,10924797,10924798,10924799,10925105,10925106,10925107,10925113,10925114,10925115,10982402,10982445,10966679,10622345,10622346,10622347,10622349,10922863,10922864,10922865,10922866,10622371,10925866,10620403,10620419,10620420,10620421,10965320,10965372,10965373,10965390,10965391,10978399,10978400,10978519,10978520,10978522,10978523,10978524,10621113,10621114,10621276,10621280,10922032,7059607,10562930,10562931,10562932,9182297,9182298,7057546,7057547,9171425,9171515,9171516,9171517,9171518,9171519,9171520,9171689,10609419,10557638,10557803,10557804,7058213,7058217,7058383,9172305,9172357,9180539,8863160,10613359,7058871,7058872,10610390,9180784,10558610,10610463,9172843,9172844,9172845,9172846,9172847,9172848,9172849,9172850,9180879,9180923,7059148,7059157,7059210,7059258,7059259,7059271,9181246,9177300,9177302,9177303,9177305,9177306,9177311,9177320,9177322,9177323,9177325,10515198,10515199,10515200,9169443,9177547,9177550,9177551,10513498,10513499,10513500,10513501,10513502,10513503,9177699,9177700,10513530,10513531,9177725,9177726,7055909,7056231,7056253,7056256,9178096,9178097,7056282,7056287,7056290,7056295,7056393,9178228,7056394,7056396,7056397,9178506,9178542,9178543,9178847,9178849,9178850,9171143,10516964,9171175,9176488,9176489,9176490,9176491,9176497,9176501,9176502,9176503,9176601,9176602,9176603,9176604,9176605,9176606,9176607,9176608,9176609,9176610,9176611,9176612,9176613,9176614,9176684,9176685,9176686,9176745,9176746,9176747,9176748,9176749,9176750,9176751,9176752,9176753,9176754,9176755,9176756,9176757,9176758,9176759,9176791,9176865,9176872,4973751,9176958,9176959,9176960,9176961,9176962,9176963,9176964,9176965,9176966,9176967,9176968,9177146,9177280,9177297,6666560,6666588,4971591,4971592,4971593,4971594,4971639,6666929,4971951,10469982,10469983,10468115,10470279,10470317,10470346,10470377,9167870,10470481,10470589,8917914,10170284,10165489,10165490,10165491,10165492,10165493,10165494,10165495,10165496,10165497,10165498,10165499,10165500,10165501,10165502,10165503,10165504,10165505,10165506,10165507,10165508,10165509,10165510,10165511,10165512,10165513,10165514,10165515,10165516,10165517,10165518,10165519,10165520,10165521,10165522,10165523,10165524,10165525,10165526,10165527,10165528,10165529,10165530,10165531,10165532,10165533,10165534,10165535,10165536,10165537,10165538,10165539,10165540,10165541,10165542,10165543,10165544,10165545,10165546,10165547,10165548,10165549,10165550,10165551,10165552,10165553,10165554,10165555,10165556,10165557,10165558,10165559,10165560,10165561,10165562,10165563,10165564,10165565,10165566,10165567,10165568,10165569,10165570,10165571,10165572,10165573,10165574,10165575,10165576,10165577,10165578,10165579,10165580,10165581,10165582,10165583,10165584,10165585,10165586,10165587,10165588,10165589,10165590,10165591,10165592,10165593,10165594,10165595,10165596,10165597,10165598,10165599,10165600,10165601,10165602,10165603,10165604,10165605,10165606,10165607,10165608,10165609,10165610,10165611,10165612,10165613,10165614,10165615,10165616,10165617,10165618,10165619,10165620,10165621,10165622,10165623,10165624,10165625,10165626,10165627,10165628,10165629,10165630,10165631,10165632,10165633,10165634,10165635,10165636,10165637,10165638,10165639,10165640,10165641,10165642,10165643,10165644,10165645,10165646,10165647,10165648,10165649,10165650,10165651,10165652,10165653,10165654,10165889,10629719,10629720,10629721,10629756,10629792,10629793,10629872,10629873,10627007,10627008,10627009,10627010,10627011,10627690,10166559,10166560,10166561,10630050,10166669,10630223,10630224,10630225,10166756,10166788,10161849,10630363,10630383,10167077,10167078,10167079,10630613,10167157,10163060,10571408,10571409,10571410,10571411,10574780,10574781,10571799,10571800,10571801,10571802,10571803,10575153,10572263,10572523,10572524,10572525,10572526,10572527,10572528,10572529,10572530,10572531,10572532,10572533,10572534,10575543,10575678,10575679,10576194,10576195,10570549,10570550,10571062,10571063,10571064,10571065,10571066,10571067,10571068,10571069,10571070,10525123,10523123,10523193,10523216,10523249,10523250,10523252,10523253,10523260,10525383,10525384,10525385,10523413,10523418,10523419,10523420,10523421,10523422,10523423,10523424,10523425,10523426,10523427,10523434,10523435,10523436,10523437,10523438,10523439,10523440,10524219,10524220,10524221,10524222,10524223,10524224,10524225,10524226,10524227,10524228,10524314,10524315,10524316,10522504,10522521,10524880,10523044,10523045,10523046,10523047,10523048,10525072,10525100,10525101,10422985,10477213,10477884,10477885,10477886,10477887,10477888,10477889,10477890,10478058,10478059,10478060,10478061,10478062,10478063,10478064,10478065,10478066,10478067,10478068,10478069,10478070,10478071,10478072,10478073,10478074,10478075,10478076,10478077,10478078,10478079,10478080,10478081,10478082,10478083,10478084,10478085,10478086,10478087,10478088,10478089,10478090,10478091,10478092,10478093,10478094,10478095,10478096,10478097,10478098,10478099,10478100,10478101,10478102,10478103,10478104,10478105,10478106,10478112,10478166,10478178,10478179,10478180,10478181,10478182,10478183,10478184,10478222,10478243,10478244,10478245,10478246,10478517,10478686,10478687,10478737,10478738,10478739) 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'