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(11014875,11014896,11014918,11014919,11015005,11015055,11015058,11015059,11015060,11015061,11015608,11015609,11015610,11015611,7073981,7073982,11015815,11015816,11015819,11015820,11015821,11015822,11015823,11015827,11015828,11015829,11015830,11015831,11015838,11015839,11015840,11015841,11015842,11015843,11015844,11015845,11015846,11015849,11015850,11015851,11015852,11015853,11015856,11015857,11015858,11015859,11015860,11015861,11015862,11015864,11015865,11015866,11016221,11016222,11016223,11016365,11016366,11016367,11016368,11016369,11016370,11016371,11016372,11016374,11016377,11016378,11016380,11016381,11016382,11016383,11016384,11016386,11016387,11016388,11016391,11016393,11016397,11016401,11016406,11016411,11016412,11016413,11016414,11016415,11016416,11016417,11013701,11013753,11013754,11013762,11013772,11013773,11013775,11013776,11013781,11013786,11013789,11027129,11014515,11012249,11012397,11012895,8619220,8619221,8619222,8619271,8619273,8619467,11013565,11013566,11013567,11013568,11013569,8619724,8619725,8619726,8619727,8619728,11019714,7156587,10919972,10920012,10920054,10920055,10920056,10920057,10920058,10920059,10920060,10920061,10920062,10920063,10920064,10920065,10920066,10920067,10920068,11018645,11018648,11018649,11018650,11018780,11018783,11018784,11018785,10917791,10917795,10917797,10917798,10917800,10917808,11032314,11032317,11032374,11032375,11032376,11032380,11019397,11019429,10915541,10915542,10915543,10915544,10915545,10915556,10915558,10915562,10915563,10915564,10915573,10915574,10915575,10915599,10915603,10915604,8576905,8577576,10917016,10917022,10917023,10917038,10917049,10917050,11031335,11031337,10917460,10917463,9915774,9915777,9915958,9916042,9916070,9916071,9916072,7058676,4974168,4974171,4974173,4974174,4974405,4974433,4974434,4974435,8592992,9202780,9202914,9202920,9202922,9202925,9202926,9202928,9202929,9203042,9203044,9203046,9200330,9200335,9200339,9200341,9200342,9200344,9200346,9200347,9200348,9200350,9200351,9200353,9200355,9200356,9200358,9200361,9200362,9200364,9200365,9200367,9200368,9200369,9200370,9200371,9200372,9200373,9200374,9200375,9200376,9200377,9200378,9200379,9200380,9200382,9200384,9200386,9200390,9200391,9201158,9201159,9201205,4974125,8854932,6679379,6679381,6679422,6679425,9200291,10913472,10913473,10913474,10913475,10913476,10913478,10913479,10913480,10913482,10913484,10913485,10913486,10913493,10913494,10913500,10913501,10913502,10913505,10913506,10913507,10913508,10913515,10913524,10913529,10913530,10913533,10913541,10179559,10913549,10913550,10913551,10913552,10913553,10913556,10913557,10913560,10913562,10913565,10913566,10913567,10913570,10913571,10913572,10913576,10913577,10913582,10913586,10913591,10913592,10913593,10913594,10913595,10913600,10913601,10913602,10913603,10913617,10913618,10913622,10913623,10913627,10913628,10913631,10913632,10913633,10913634,10913635,10913636,10913637,10913638,10913639,10913640,10913641,10913642,10913643,10913644,10913645,10913646,10913647,10913648,10913649,10913650,10913651,10913652,10913653,10913654,10913655,10913656,10913657,10913658,10913659,10913660,10913661,10913662,10913663,10913664,10913665,10913666,10913667,10913668,10179680,10913669,10913670,10913671,10913672,10913673,10913674,10913675,10913676,10913677,10913678,10913679,10913680,10913681,10913682,10913683,10913684,10913685,10913686,10913687,10913688,10913689,10913690,10913691,10913692,10913693,10913694,10913695,10913696,10913697,10913698,10913699,10913700,10913701,10913702,10913703,10913704,10913705,10913706,10913707,10913708,10913709,10913710,10913711,10913712,10913713,10913714,10913715,10913716,10913717,10913718,10913719,10913720,10913721,10913722,10913723,10913724,10913725,10913726,10913727,10913728,10913729,10913730,10913731,10913732,10913733,10913734,10913735,10913736,10913737,10913738,10913739,10913740,10913741,10913742,10913743,10913744,10913745,10913746,10913747,10913748,10913749,10913750,10913751,10913752,10913753,10913754,10913755,10913756,10913757,10913758,10913759,10913760,10913761,10913762,10913763,10913764,10913765,10913766,10179778,10913767,10913768,10913769,10178623,10179452,10179454,10179456,10177303,10177475,10177563,10177566,10177574,10177837,10177840,10177841,10177845,10177847,10177851,10177852,10177861,10177868,10571112,10571113,10571114,10571115,10571116,10571117,10571118,10571119,10571120,10571121,10571122,10571123,10571124,10571125,10571126,10571127,10571128,10571129,10571130,10571131,10571132,10571133,10571134,10571135,10571136,10571137,10571138,10571139,10571140,10571141,10571142,10571143,10571144,10571145,10571146,10571147,10571148,10571149,10571150,10571151,10571152,10571153,10571154,10571155,10571156,10571157,10571158,10571159,10571160,10571161,10571162,10571163,10571164,10571165,10571166,10571167,10571168,10571169,10571170,10571171,10571172,10571173,10571174,10571175,10571176,10571177,10571178,10571179,10571180,10571181,10571182,10571183,10571184,10571185,10571186,10571187,10571188,10571189,10571190,10571191,10571192,10571193,10571194,10571195,10571196,10571197,10571198,10571199,10571200,10571201,10571202,10571203,10571204,10571205,10571206,10571207,10571208,10571209,10571210,10571211,10571212,10571213,10571214,10571215,10571216,10571217,10571218,10571219,10571220,10571221,10571222,10571223,10571224,10571225,10571226,10571227,10571228,10571229,10571230,10571231,10571232,10571233,10571234,10571243,10571244,10571245,10571248,10571249,10571250,10571255,10571256,10571258,10571262,10571263,10571264,10571265,10571274,10571275,10571276,10571277,10571285,10571304,10571305,10571310,10571311,10571318,10571319,10571320,10571330,10571331,10571332,10571333,10571334,10571339,10571340,10571343,10571349,10571350,10571351,10571352,10571353,10571361,10571368,10571369,10574438,10574439,10574440,10569517,10569848,10569849,10569850,10569851,10569868,10569869,10569870,10569871,10569872,10570080,10573227,10573238,10573240,10573242,10570421,10570422,10570423,10570424,10570425,10570448,10570451,10573453,10573455,10570458,10570459,10570460,10570461,10570464,10570476,10570477,10570478,10570479,10570481,10570482,10570526,10570527,10570528,10570529,10570530,10570531,10570532,10570533,10570534,10570535,10570536,10570537,10570538,10570539,10570540,10570541,10570542,10570543,10570544,10570551,10570554,10570557,10570558,10570572,10570573,10570578,10570579,10570580,10570581,10570582,10570584,10570585,10570586,10570604,10570605,10570606,10570607,10570608,10570609,10570610,10570611,10570612,10570613,10570614,10570615,10570616,10570641,10570642,10570645,10570646,10570650,10570657,10570665,10570666,10570671,10570684,10570685,10570708,10570709,10570710,10570711,10570712,10570713,10570714,10570715,10570716,10570717,10570718,10570719,10570720,10570721,10570722,10570723,10570724,10570734,10570745,10570746,10570747,10570748,10570749,10570750,10570755,10570756,10570757,10570759,10570760,10570761,10570762,10570768,10570774,10570775,10570776,10570781,10570782,10570786,10570789,10570790,10570791,10570792,10570799,10570800,10570801,10570804,10570805,10570806,10570813,10570814,10570815,10570816,10570817,10570818,10570819,10570823,10570824,10570837,10570838,10570839,10570840,10570841,10570842,10570843,10570844,10570849,10570850,10570851,10570852,10570854,10570855,10570856,10570872,10570873,10570874,10570875,10570876,10570877,10570878,10570879,10570880,10570881,10570882,10570883,10570884,10570885,10570886,10570888,10570890,10570891,10570892,10570896,10570897,10570898,10570899,10570904,10570905,10570906,10570913,10570920,10570921,10570923,10570932,10570943,10570947,10570948,10570951,10570952,10570953,10570954,10570955,10570956,10570973,10570976,10570977,10570978,10570979,10570994,10570995,10571000,10571001,10571006,10571007,10571008,10571009,10571011,10571012,10571013,10571014,10571015,10571016,10571017,10571018,10571019,10571020,10571021,10571022,10571023,10571024,10571025,10571026,10571027,10571028,10571029,10571030,10571031,10571032,10571033,10571034,10571035,10571036,10571037,10571038,10571039,10571040,10571041,10571042,10571043,10571044,10571045,10571046,10571047,10571048,10571049,10571050,10571051,10571052,10571053,10571054,10571055,10571056,10571057,10571058,10571059,10571060,10571061,10571062,10571063,10571064,10571065,10571066,10571067,10571068,10571069,10571070,10571071,10571072,10571073,10571074,10571075,10571076,10571077,10571078,10571079,10571080,10571081,10571082,10571083,10571084,10571085,10571086,10571087,10571088,10571089,10571090,10571091,10571092,10571093,10571094,10571095,10571096,10571097,10571098,10571099,10571100,10571101,10571102,10571103,10571104,10571105,10571106,10571107,10571108,10571109,10571110,10571111,10546207,10493561,10493564,10493565,10493566,10493568,10493571,10493572,10493574,10493575,10493576,10493577,10493578,10493579,10493580,10493581,10493582,10493583,10493584,10493585,10493586,10493587,10493588,10493589,10493590,10493591,10493592,10493593,10493594,10493597,10493598) 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'