Kod:
-- --------------------------------------------------------------------------------
-- _jcomments
-- --------------------------------------------------------------------------------
INSERT INTO
baza-mysql-j25.prefix-j25_jcomments
(
id, parent, thread_id, path, level, object_id, object_group, object_params, lang,
userid, name, username, email, homepage, title, comment, ip, date, isgood, ispoor,
published, subscribe, source, source_id, checked_out, checked_out_time, editor
)
SELECT
id, parent,
CASE WHEN SUBSTRING(path, LOCATE(',', path)+1, LOCATE(',', path, 2))='' THEN 0
ELSE SUBSTRING(path, LOCATE(',', path)+1, LOCATE(',', path, 2)) END AS thread_id,
path, level, object_id, object_group, object_params, lang,
userid, name, username, email, homepage, title, comment, ip, date, isgood, ispoor,
published, subscribe, source, source_id, checked_out, checked_out_time, editor
FROM
baza-mysql-j25.jos_jcomments;
itd.
Komentarze się chyba zgadzają, mimo że na liście nie pojawia się info, do którego wpisu się odnoszą (