Home Saturday, 28 January 2012     L e a r n Home Rotating Gurus Guest Columnist Features News and Articles Viral Advertising - - - - - - - D i s c o v e r Agency Credentials Briefing Process Media 101 Digital Marketing Solutions - - - - - - - I n t e r a c t Contact Core Downloads - - - - - - - Most Read Media Planning Can Direct Marketing Have a 'Big Idea'? Public Relations Direct Marketing 57 varieties of AFA accreditation S e a r c h www Core Marketing   top (C) 2012 Core Marketing Group, Perth Advertising & Marketing Agency, Digital, Direct, Brand, Perth, Western Australia Joomla! is Free Software released under the GNU/GPL License.

1
SELECT folder, element, published, params
 FROM mos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
2
SELECT id, link
 FROM mos_menu
 WHERE menutype = 'mainmenu'
 AND published = 1
 ORDER BY parent, ordering LIMIT 1
3
SELECT template
 FROM mos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 1 )
 ORDER BY menuid DESC
 LIMIT 1
4
DELETE FROM mos_session
 WHERE ( time < '1327774379' )
5
SELECT * FROM mos_session WHERE session_id='539738d9c56aeeb51501d6be110e546e'
6
SELECT session_id
 FROM mos_session
 WHERE session_id = MD5( '7f1b1d436dc01e0cc0788fb6f62836b7' )
7
INSERT INTO mos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( 'ab09190db327866752666b43f73a3b83','1327783379','','0','1' )
8
SELECT COUNT(*)
 FROM mos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 0
9
UPDATE mos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 0
10
SELECT COUNT(*)
 FROM mos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 1
11
UPDATE mos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 1
12
SELECT COUNT(*)
 FROM mos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 2
13
UPDATE mos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 2
14
SELECT folder, element, published, params
 FROM mos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'editors-xtd'
 ORDER BY ordering
15
SELECT access
 FROM mos_menu
 WHERE id = 1
16
SELECT * FROM mos_menu WHERE id='1'
17
SELECT a.id
 FROM mos_components AS a
 WHERE a.name = 'Syndicate'
18
SELECT id, name, link, parent, type
 FROM mos_menu
 WHERE menutype = 'mainmenu'
 AND published = 1
 ORDER BY parent, ordering
 LIMIT 1
19
SELECT id, name, link, parent, type
 FROM mos_menu
 WHERE published = 1
 ORDER BY parent, ordering
20
SELECT id, title, module, position, content, showtitle, params
 FROM mos_modules AS m, mos_modules_menu AS mm
 WHERE m.published = 1
 AND m.access <= '0'
 AND m.client_id != 1
 AND mm.moduleid = m.id
 AND ( mm.menuid = '1' OR mm.menuid = 0 )
 ORDER BY ordering
21
SELECT m.*
 FROM mos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
22
SELECT m.*
 FROM mos_menu AS m
 WHERE menutype = 'discover'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
23
SELECT m.*
 FROM mos_menu AS m
 WHERE menutype = 'learn'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
24
SELECT a.id, a.title, a.sectionid, a.catid
 FROM mos_content AS a
 LEFT JOIN mos_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN mos_categories AS cc ON cc.id = a.catid
 INNER JOIN mos_sections AS s ON s.id = a.sectionid
 WHERE ( a.state = 1 AND a.checked_out = 0 AND a.sectionid > 0 )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-01-28 20:43:09' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-01-28 20:43:09' )
 AND a.access <= 0
 AND s.published = 1
 AND cc.published = 1
 ORDER BY a.hits DESC
 LIMIT 5
25
SELECT COUNT( m.id )
 FROM mos_content AS i
 LEFT JOIN mos_sections AS s ON i.sectionid = s.id
 LEFT JOIN mos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_blog_section'
 AND m.published = 1
26
SELECT COUNT( m.id )
 FROM mos_content AS i
 LEFT JOIN mos_categories AS c ON i.catid = c.id
 LEFT JOIN mos_menu AS m ON m.componentid = c.id 
 WHERE m.type = 'content_blog_category'
 AND m.published = 1
27
SELECT COUNT( id )
 FROM mos_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
28
SELECT m.id 
 FROM mos_content AS i
 LEFT JOIN mos_sections AS s ON i.sectionid = s.id
 LEFT JOIN mos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 146
29
SELECT m.id 
 FROM mos_content AS i
 LEFT JOIN mos_categories AS cc ON i.catid = cc.id
 LEFT JOIN mos_menu AS m ON m.componentid = cc.id 
 WHERE m.type = 'content_category'
 AND m.published = 1
 AND i.id = 146
30
SELECT m.id 
 FROM mos_content AS i
 LEFT JOIN mos_sections AS s ON i.sectionid = s.id
 LEFT JOIN mos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 168
31
SELECT m.id 
 FROM mos_content AS i
 LEFT JOIN mos_categories AS cc ON i.catid = cc.id
 LEFT JOIN mos_menu AS m ON m.componentid = cc.id 
 WHERE m.type = 'content_category'
 AND m.published = 1
 AND i.id = 168
32
SELECT m.id 
 FROM mos_content AS i
 LEFT JOIN mos_sections AS s ON i.sectionid = s.id
 LEFT JOIN mos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 161
33
SELECT m.id 
 FROM mos_content AS i
 LEFT JOIN mos_categories AS cc ON i.catid = cc.id
 LEFT JOIN mos_menu AS m ON m.componentid = cc.id 
 WHERE m.type = 'content_category'
 AND m.published = 1
 AND i.id = 161
34
SELECT m.id 
 FROM mos_content AS i
 LEFT JOIN mos_sections AS s ON i.sectionid = s.id
 LEFT JOIN mos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 148
35
SELECT m.id 
 FROM mos_content AS i
 LEFT JOIN mos_categories AS cc ON i.catid = cc.id
 LEFT JOIN mos_menu AS m ON m.componentid = cc.id 
 WHERE m.type = 'content_category'
 AND m.published = 1
 AND i.id = 148
36
SELECT m.id 
 FROM mos_content AS i
 LEFT JOIN mos_sections AS s ON i.sectionid = s.id
 LEFT JOIN mos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 248
37
SELECT m.id 
 FROM mos_content AS i
 LEFT JOIN mos_categories AS cc ON i.catid = cc.id
 LEFT JOIN mos_menu AS m ON m.componentid = cc.id 
 WHERE m.type = 'content_category'
 AND m.published = 1
 AND i.id = 248