Untitled query #62622

SQL

#DESCRIBE logging;
#SELECT log_type, log_action, log_params FROM logging GROUP BY log_type, log_action;
#SELECT * FROM logging WHERE log_type = "patrol" AND log_action = "patrol" ORDER BY log_timestamp DESC LIMIT 10;
#SELECT DISTINCT log_type, log_action FROM logging ORDER BY log_type, log_action;
#SELECT DISTINCT log_action FROM logging ORDER BY log_action;
#SELECT p.page_title, co.content_address FROM revision rv
#LEFT JOIN page p ON p.page_id = rv.rev_page
#LEFT JOIN actor ac ON ac.actor_id = rv.rev_actor
#LEFT JOIN user usr ON usr.user_id = ac.actor_user
#LEFT JOIN slots sl ON sl.slot_revision_id = rv.rev_id
#LEFT JOIN content co ON co.content_id = sl.slot_content_id
#WHERE rv.rev_parent_id = 0 AND usr.user_name = 'עפולה'
#ORDER BY rv.rev_timestamp ASC
#LIMIT 10;
SELECT DISTINCT log_type, log_action FROM logging ORDER BY log_type, log_action;
SQL

Checking query status...
