Ошибка базы данных WordPress:
[You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'get FROM ( SELECT k.emetalx, k.emetaly, ( SELECT changer' at line 5]
SELECT e.*, o.*, IF (e.start < e.startx && e.start <> 0, 1.0000, IF (e.startx <> 0, e.start / e.startx, e.start)) give, IF (e.start < e.startx && e.start <> 0, e.startx / e.start, IF (e.startx <> 0, 1.0000, e.startx)) get FROM ( SELECT k.emetalx, k.emetaly, ( SELECT changer FROM `wp_emetal` e WHERE e.emetalx = k.emetalx AND e.emetaly = k.emetaly AND rezerv > 10.000000 ORDER BY koef DESC, rezerv DESC LIMIT 1) xobmen FROM `wp_kurs` k ORDER BY kursx) as k LEFT JOIN `wp_emetal` e ON e.emetalx = k.emetalx AND e.emetaly = k.emetaly AND e.changer = k.xobmen INNER JOIN `wp_xobmen` o ON o.xobmen = k.xobmen AND o.xblock = 0 WHERE k.xobmen IS NOT NUL
SELECT e.*, o.*, IF (e.start < e.startx && e.start <> 0, 1.0000, IF (e.startx <> 0, e.start / e.startx, e.start)) give, IF (e.start < e.startx && e.start <> 0, e.startx / e.start, IF (e.startx <> 0, 1.0000, e.startx)) get FROM ( SELECT k.emetalx, k.emetaly, ( SELECT changer FROM `wp_emetal` e WHERE e.emetalx = k.emetalx AND e.emetaly = k.emetaly AND rezerv > 10.000000 ORDER BY koef DESC, rezerv DESC LIMIT 1) xobmen FROM `wp_kurs` k ORDER BY kursx) as k LEFT JOIN `wp_emetal` e ON e.emetalx = k.emetalx AND e.emetaly = k.emetaly AND e.changer = k.xobmen INNER JOIN `wp_xobmen` o ON o.xobmen = k.xobmen AND o.xblock = 0 WHERE k.xobmen IS NOT NUL
Подскажите, как исправить?
Ответы (2)
Сергей, пришлите нам запрос на почту hello@hardkod.ru, проведем диагностику.