| 0.0001 |
SELECT cat_id, cat_title
FROM lockmor_idea_cats
|
| 0.0002 |
SELECT id_member
FROM smf_members
WHERE member_name = 'Agar'
|
| 0.0003 |
SELECT `idea_id`, `idea_author`, `idea_type_id`, `idea_parent`, `idea_title`, `idea_text`, `idea_date`, `idea_cond`, `idea_xp`, `member_name`, `ip`
FROM (`lockmor_ideas`)
JOIN `smf_members` ON `id_member` = `idea_author`
WHERE (idea_parent=20 OR idea_type_id=20) AND idea_cond='1'
AND `idea_author` = '105'
ORDER BY `idea_date` DESC
LIMIT 20
|
| 0.0001 |
SELECT id_member FROM smf_members WHERE member_name = 'Agar'
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM (`lockmor_ideas`)
WHERE `idea_cond` = '1'
AND `idea_author` = '105'
|
| 0.0001 |
SELECT `cat_description`, `cat_parent_id`, `cat_count`, `cat_title`, `cat_page_title`, `cat_id`
FROM (`lockmor_idea_cats`)
WHERE `cat_parent_id` = '0'
ORDER BY `cat_title` asc
|
| 0.0000 |
SELECT id_member FROM smf_members WHERE member_name = 'Agar'
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM (`lockmor_ideas`)
WHERE (idea_parent=20 OR idea_type_id=20) AND idea_cond='1'
AND `idea_author` = '105'
|
| 0.0000 |
SELECT id_member FROM smf_members WHERE member_name = 'Agar'
|
| 0.0002 |
SELECT count(*) as total, `idea_parent`
FROM (`lockmor_ideas`)
WHERE `idea_author` = '105'
GROUP BY `idea_parent`
|
| 0.0001 |
SELECT `cat_description`, `cat_parent_id`, `cat_count`, `cat_title`, `cat_page_title`, `cat_id`
FROM (`lockmor_idea_cats`)
WHERE `cat_parent_id` = '4'
ORDER BY `cat_title` asc
|
| 0.0001 |
SELECT `cat_description`, `cat_parent_id`, `cat_count`, `cat_title`, `cat_page_title`, `cat_id`
FROM (`lockmor_idea_cats`)
WHERE `cat_parent_id` = '2'
ORDER BY `cat_title` asc
|
| 0.0001 |
SELECT `cat_description`, `cat_parent_id`, `cat_count`, `cat_title`, `cat_page_title`, `cat_id`
FROM (`lockmor_idea_cats`)
WHERE `cat_parent_id` = '3'
ORDER BY `cat_title` asc
|
| 0.0001 |
SELECT `cat_description`, `cat_parent_id`, `cat_count`, `cat_title`, `cat_page_title`, `cat_id`
FROM (`lockmor_idea_cats`)
WHERE `cat_parent_id` = '1'
ORDER BY `cat_title` asc
|
| 0.0000 |
SELECT `cat_description`, `cat_parent_id`, `cat_count`, `cat_title`, `cat_page_title`, `cat_id`
FROM (`lockmor_idea_cats`)
WHERE `cat_parent_id` = '5'
ORDER BY `cat_title` asc
|
| 0.0021 |
SELECT `idea_id`, `idea_text`, `idea_xp`, `member_name` as username
FROM (`lockmor_ideas`)
JOIN `smf_members` ON `id_member` = `idea_author`
ORDER BY RAND()
LIMIT 1
|
| 0.0001 |
SELECT `banner_link`, `banner_graphic`
FROM (`lockmor_banner`)
ORDER BY RAND()
LIMIT 1
|
| 0.0021 |
SELECT `idea_id`, `idea_text`, `idea_xp`, `member_name` as username
FROM (`lockmor_ideas`)
JOIN `smf_members` ON `id_member` = `idea_author`
ORDER BY RAND()
LIMIT 1
|
New Submissions