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(10950752,10950753,10950754,10950755,7066190,7066191,7066263,7066264,8067913,8067918,8067937,8911630,8065847,10933212,8910256,8910257,8834754,10958953,10958954,8910595,8860436,8860437,8860440,8905972,8906028,8906029,8906030,8906031,8906032,8906033,8906034,8906035,8906036,8906037,8906038,8906039,8906040,8906041,8906042,8906043,8906044,8906045,8906046,8906047,8906048,8906049,8906050,8906051,8906052,8906053,8906054,8906055,8906056,8906057,8906058,8906059,8906060,8906061,8906062,8906063,8906064,8906065,8906066,8906067,8906068,8906069,8906070,8906071,8906072,8906073,8906074,8906075,8906076,8906077,8906078,8906079,8906080,8906081,8906082,8906083,8906084,8906085,8906086,8906087,8906088,8906089,8906090,8906091,8906092,8906093,8906094,8906095,8906096,8906097,8906098,8906099,8906100,8906101,8906102,8906103,8906104,8906105,8906106,8906107,8906108,8906109,8906110,8906111,8906112,8906113,8906114,8906115,8906116,8906117,8906118,8906119,8906120,8906121,8906122,8906123,8906124,8906125,8906126,8906127,8906128,8906129,8906130,8906131,8906132,8906133,8906134,8906135,8906136,8906137,8906138,8906139,8906140,8906141,8906142,8906143,8906144,8906145,8906146,8906147,8906148,8906149,8906150,8906151,8906152,8906153,8906154,8906155,8906156,8906157,8906158,8906159,8906160,8906161,8906162,8906163,8906164,8906165,8906166,8906167,8906168,8906169,8906170,8906171,8906172,8906173,8906174,8906175,8906176,8906177,8906178,8906179,8906180,8906181,8906182,8906183,8906184,8906185,8906186,8906187,8906188,8906189,8906190,8906191,8906192,8906193,8906194,8906195,8906196,8906197,8906198,8906199,8906200,8906201,8906202,8906203,8906204,8906205,8906206,8906207,8906208,8906209,8906210,8906211,8906212,8906213,8906214,8906215,8906216,8906217,8906218,8906219,8906220,8906221,8906222,8906223,8906224,8906225,8906226,8906227,8906228,8906229,8906230,8906231,8906232,8906233,8906234,8906235,8906236,8906237,8906238,8906239,8906240,8906241,8906242,8906243,8906244,8906245,8906246,8906247,8906248,8906249,8906250,8906251,8906252,8906253,8906254,8906255,8906256,8906257,8906258,8906259,8906260,8906261,8906262,8906263,8906264,8906265,8906266,8906267,8906268,8906269,8906270,8906271,8906272,8906273,8906274,8906275,8906276,8906277,8906278,8906279,8906280,8906281,8906282,8906283,8906284,8906285,8906286,8906287,8906288,8906289,8906290,8906291,8906292,8906293,8906294,8906295,8906296,8906297,8906298,8906299,8906300,8906301,8906302,8906303,8906304,8906305,8906306,8906307,8906308,8906309,8906310,8906311,8906312,8906313,8906314,8906315,8906316,8906317,8906318,8906319,8906320,8906321,8906322,8906323,8906324,8906325,8906326,8906327,8906328,8906329,8906330,8906331,8906332,8906333,8906334,8906335,8906336,8906337,8906338,8906339,8906340,8906341,8906342,8906343,8906344,8906345,10623491,10623492,10617099,10617198,10622344,10622401,10622404,10622409,10622414,10617426,10622430,10614975,10614979,10615019,10615021,10615022,10615074,10615075,10615076,10615077,10615078,10615079,10615080,10615152,10615153,10615202,10615268,10615349,10615350,10615391,10615397,10620572,10615582,10615583,10615584,10615585,10615586,10615587,10615588,10615589,10615590,10615591,10615592,10615593,10615594,10615595,10615596,10615597,10615598,10615599,10615600,10615601,10615602,10615603,10615604,10615605,10615606,10615607,10615608,10615609,10615610,10615611,10615612,10615613,10615614,10615615,10615616,10615617,10615618,10615619,10615620,10615621,10615622,10615623,10615624,10615625,10615626,10615627,10615628,10615629,10615630,10615631,10615632,10615633,10615634,10615635,10615636,10615637,10615638,10615639,10615640,10615641,10615642,10615643,10615644,10615645,10615646,10615647,10615648,10615649,10615650,10615651,10615652,10615653,10615654,10615655,10615656,10615657,10615658,10615659,10615660,10615661,10615662,10615663,10615664,10615665,10615666,10615667,10615668,10615669,10615670,10615671,10615672,10615673,10615674,10615675,10615676,10615677,10615678,10615679,10615680,10615681,10615682,10615683,10615684,10615685,10615689,10615718,10615874,10615904,10616001,10616221,10616429,10616475,10616861,10616883,10616884,10616885,10616886,10616887,10616888,10614071,10614128,10614267,10614268,10614269,10614270,10614271,10611344,10614425,10614599,10614654,10611667,10611668,10611669,10611670,10611671,10611672,10611673,10611674,10611675,10611676,10611677,10611678,10611679,10611699,10611700,10611701,10611702,10611703,10611765,10614871,10614885,10614891,10614892,10614929,10611955,10611991,10611992,10611993,10612082,10612083,10609088,10612265,10612266,10612267,10609283,10609328,10612346,10609707,10612930,10612987,10612988,10612989,10613056,10613057,10613058,10613075,10613079,10613080,10613153,10610323,10613633,10613645,10610671,10610674,10610675,10610676,10610691,10610696,10613696,10610773,10613773,10610775,10610791,10610838,10610955,9169332,9161527,9169554,9169555,9169556,9169557,9169558,9169559,9169560,9169561,9169562,9169563,9169564,9169565,9169566,9169567,9169568,9169569,9169570,9169571,9169572,9169573,9169834,9169835,10418225,10419243,10419258,9168361,10416299,10415318,10415319,10415320,10415321,9168487,10416445,10416447,10416448,10416449,10416450,10416451,10416452,10416453,10416454,10416455,10416457,10416458,10416459,10416461,10416462,10416464,10416465,10416466,10416467,10416469,10416470,10416471,10416472,10416473,10416474,10416475,10416476,10416477,10416478,10416479,10416480,10416481,10416482,10416483,10416484,10416485,10416486,10416487,10416488,10417531,10417532,10417533,10417534,10417535,10417536,10417537,10417538,10417539,10415539,10417540,10415540,10417541,10415541,10417542,10415542,10417543,10417544,10417545,10417546,10417547,10417548,10417549,10417550,10417551,10417552,10417553,10417554,10417555,10417556,10417557,10417558,10417559,10417560,10417561,10417562,10417563,10417564,10417565,10417566,10417567,10417568,10417569,10417570,10417571,10417572,10417573,10417574,10417575,10417576,10417577,10417578,10417579,10417580,10417581,10417582,10417583,10417584,10417585,10417586,10417587,10417588,10417589,10417590,10417591,10417592,10417593,10417594,10417595,10417596,10417597,10417598,10417599,10417600,10417601,10417602,10417603,10417604,10417605,10417606,10417607,10417608,10417609,10417610,10417611,10417612,10417613,10415613,10417614,10417615,10417616,10417617,10417618,10417619,10417620,10417621,10417622,10417623,10417624,10417625,10417626,10417627,10417628,10417629,10417630,10417631,10417632,10417633,10417634,9168713,10415635,10417635,10417636,10417637,10417638,10416639,10417639,10417640,10417641,10417642,10417643,10417644,10417645,10417646,10417647,10417648,10417649,10417650,10417651,10417652,10417653,10417654,10417655,10417656,10417657,10417658,10417659,10417660,10417661,10417662,10417663,10417664,10417665,10417666,10417667,10417668,10417669,10417670,10417671,10417672,10417673,10417674,10417675,10417676,10417677,10417678,10417679,10417680,10417681,10417682,10417683,10417684,10417685,10417686,10417687,10417688,10417689,10417690,10417691,10417692,10417693,10417694,10417695,10417696,10417697,10417698,10417699,10417700,10417701,10417702,10417703,10417704,10417705,10417706,10417707,10417708,10417709,10417710,10417711,10417712,10417713,10417714,10417715,10417716,10417717,10417718,10417719,10417720,10417721,10417722,10417723,10417724,10417725,10417726,10417727,10417728,10417729,10417730,10417731,10417732,10417733,10417734,10417735,10417736,10417737,10417738,10417739,10417740,10417741,10417742,10417743,10417744,10417745,10417746,10417747,10417748,10417749,10417750,10417751,10417752,10417753,10417754,10417755,10417756,10417757,10417758,10417759,10417760,10417761,10417762,10417763,10417764,10417765,10417766,10417767,10417768,10417769,10417770,10417771,10417772,10417773,10417774,10417775,10417776,10417777,10417778,10417779,10417780,10417781,10417782,10417783,10417784,10417785,10417786,10417787,10417788,10417789,10417790,10416790,10417791,10416791,10417792,10416792,10417793,10416793,10417794,10416794,10417795,10416795,10417796,10416796,10417797,10417798,10417799,10417800,10417801,10417802,10417803,10417804,9169226,9169269,10419212,10419214,9167396,10470138,10470139,10470140,10470141,10470142,10470143,10470144,10470145,10470146,10470147,10470148,10470149,9167634,9167771,10468421,10468422,10468423,10468424,10468425,10468426,10468427,10468428,10468429,10468430,10468431,10468432,10468433,10468434,10468435,9167994,9168076,9168096,9168097,10627724,10627725,10627726,10627727,10627773,10162154,10162176,10625931,10625932,10625933,10626445,10420813,10420814,10420815,10420816,10420817,10420818,10420819,10420820,10420821,10420822,10420823,10420824,10420825,10420826,10420827,10420828,10420829,10486679,10486680,10486681) 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'