Tags: b, ul save tag group What are tags?

BBCodes, lets see if they work. 5 years ago by XisZ with 4 comments. Tags: link, b, u, i, hl, hr, ol, ul, li, quote OK, I am just doing some testing here. Please do not mind me. This should be Bold This should be Italic This should be Underlined[/i] This should be Linked This should be Linked This should...

People talking about b and ul also talk about:

add tag linklink add tag bb add tag uu add tag ii add tag hlhl add tag hrhr add tag olol add tag ulul add tag lili add tag quotequote

People talking about b and ul are:

XisZ

OneLobby
QueryQuery TimeAffected Rows
SELECT ts.* FROM k4_tags ts WHERE ts.tag_name IN('b','ul') GROUP BY ts.tag_id

 0.704 

 2 

 
SELECT DISTINCT t.thread_id, t.*, ts.tag_name, GROUP_CONCAT(ts.tag_name SEPARATOR ',') AS tags, u.name AS user_name, uu.name AS edit_user_name FROM k4_thread_tags tt, k4_tags ts, k4_threads t, k4_users u, k4_users uu, k4_thread_tags tt2  WHERE t.deleted=0 AND tt.thread_id = tt2.thread_id AND tt2.tag_id IN(87,93) AND t.thread_id=tt.thread_id AND ts.tag_id=tt.tag_id AND t.user_id=u.user_id AND t.edit_user_id=uu.user_id GROUP BY t.thread_id, tt2.tag_id ORDER BY t.created DESC

 0.7102 

 1 

 
SELECT ts.*, COUNT(tt2.tag_id) AS tag_count FROM k4_tags ts, k4_thread_tags tt1 JOIN k4_thread_tags tt2 USING ( thread_id )   WHERE tt1.tag_id IN(87,93) AND tt1.tag_id <> tt2.tag_id AND ts.tag_id = tt2.tag_id GROUP BY ts.tag_id, tt2.tag_id LIMIT 250

 0.7117 

 10 

 
SELECT DISTINCT u.user_id, u.name, COUNT(tt2.tag_id) AS tag_count FROM k4_thread_users tu, k4_users u, k4_thread_tags tt1 JOIN k4_thread_tags tt2 USING (thread_id) WHERE u.user_id = tu.user_id AND tt1.tag_id IN(87,93) AND tt1.tag_id <> tt2.tag_id AND tu.thread_id = tt2.thread_id GROUP BY tt2.tag_id ORDER BY u.name ASC

 0.7147 

 2 

 
SELECT o.object_name,o.object_perms,p.perm_grant,p.perm_deny FROM k4_objects o, k4_perms p, k4_roles r, k4_user_roles u WHERE u.user_id=1  AND u.role_id=r.role_id  AND p.role_id=r.role_id  AND o.object_id=p.object_id ORDER BY r.perm_level ASC

 0.7325 

 3