SELECT *
FROM jos_session
WHERE session_id = 'nf18neruqrirugfiahv9bjnrr5'
DELETE
FROM jos_session
WHERE ( TIME < '1329972121' )
SELECT *
FROM jos_session
WHERE session_id = 'nf18neruqrirugfiahv9bjnrr5'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( 'nf18neruqrirugfiahv9bjnrr5','1329973921','','0','1','0' )
SELECT *
FROM jos_components
WHERE parent = 0
SELECT folder AS TYPE, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
SELECT oldurl, newurl
FROM jos_redirection
WHERE oldurl = 'local-news/'
ORDER BY rank ASC
LIMIT 1
UPDATE jos_redirection
SET cpt=(cpt+1)
WHERE `newurl` = 'index.php?option=com_content&Itemid=110&id=16&lang=en&layout=blog&view=category'
AND `oldurl` = 'local-news/'
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 110)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT *
FROM jos_acctexp_config
WHERE id = '1'
SHOW TABLES
SELECT `id`
FROM jos_acctexp_temptoken
WHERE `token` = 'ee60d6f33b7d4b7ff586a8d7f331acf6'
SELECT `id`
FROM jos_acctexp_temptoken
WHERE `ip` = '38.107.179.217'
DELETE
FROM `jos_acctexp_temptoken`
WHERE id = ''
SELECT *
FROM jos_acctexp_temptoken
WHERE id = '0'
SELECT *
FROM jos_jcomments_settings
SELECT c.*, s.id AS sectionid, s.title AS sectiontitle, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS slug
FROM jos_categories AS c
INNER JOIN jos_sections AS s
ON s.id = c.SECTION
WHERE c.id = 16
LIMIT 0, 1
SELECT cc.title AS category, a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.attribs, a.hits, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email
FROM jos_content AS a
LEFT JOIN jos_categories AS cc
ON a.catid = cc.id
LEFT JOIN jos_users AS u
ON u.id = a.created_by
LEFT JOIN jos_groups AS g
ON a.access = g.id
WHERE 1
AND a.catid = 16
AND a.state = 1
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2012-02-23 05:12:02' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2012-02-23 05:12:02' )
ORDER BY a.created DESC, a.created DESC
LIMIT 0, 10
SELECT cc.title AS category, a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.attribs, a.hits, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email
FROM jos_content AS a
LEFT JOIN jos_categories AS cc
ON a.catid = cc.id
LEFT JOIN jos_users AS u
ON u.id = a.created_by
LEFT JOIN jos_groups AS g
ON a.access = g.id
WHERE 1
AND a.catid = 16
AND a.state = 1
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2012-02-23 05:12:02' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2012-02-23 05:12:02' )
ORDER BY a.created DESC, a.created DESC
SELECT title,id
FROM jos_hdflvplayerupload
SELECT title,id
FROM jos_hdflvplayerupload
SELECT COUNT(*)
FROM jos_jcomments
WHERE object_id = 164238
AND object_group = 'com_content'
AND published = 1
SELECT title,id
FROM jos_hdflvplayerupload
SELECT COUNT(*)
FROM jos_jcomments
WHERE object_id = 164239
AND object_group = 'com_content'
AND published = 1
SELECT title,id
FROM jos_hdflvplayerupload
SELECT COUNT(*)
FROM jos_jcomments
WHERE object_id = 164219
AND object_group = 'com_content'
AND published = 1
SELECT title,id
FROM jos_hdflvplayerupload
SELECT COUNT(*)
FROM jos_jcomments
WHERE object_id = 164234
AND object_group = 'com_content'
AND published = 1
SELECT title,id
FROM jos_hdflvplayerupload
SELECT COUNT(*)
FROM jos_jcomments
WHERE object_id = 164224
AND object_group = 'com_content'
AND published = 1
SELECT title,id
FROM jos_hdflvplayerupload
SELECT COUNT(*)
FROM jos_jcomments
WHERE object_id = 164217
AND object_group = 'com_content'
AND published = 1
SELECT title,id
FROM jos_hdflvplayerupload
SELECT COUNT(*)
FROM jos_jcomments
WHERE object_id = 164221
AND object_group = 'com_content'
AND published = 1
SELECT title,id
FROM jos_hdflvplayerupload
SELECT COUNT(*)
FROM jos_jcomments
WHERE object_id = 164222
AND object_group = 'com_content'
AND published = 1
SELECT title,id
FROM jos_hdflvplayerupload
SELECT COUNT(*)
FROM jos_jcomments
WHERE object_id = 164216
AND object_group = 'com_content'
AND published = 1
SELECT title,id
FROM jos_hdflvplayerupload
SELECT COUNT(*)
FROM jos_jcomments
WHERE object_id = 164237
AND object_group = 'com_content'
AND published = 1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=110&id=16&lang=en&layout=blog&limit=10&limitstart=770&view=category'
SELECT id, title, module, POSITION, content, showtitle, control, params
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id = 0
AND ( mm.menuid = 110 OR mm.menuid = 0 )
ORDER BY POSITION, ordering
SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-23 05:12:02' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-23 05:12:02' )
AND a.introtext LIKE "%<img%"
AND s.id > 0
AND (cc.id=26 OR cc.id=35 OR cc.id=37 OR cc.id=38 OR cc.id=39 OR cc.id=40)
AND (s.id=6)
AND s.published = 1
AND cc.published = 1
ORDER BY a.created DESC
LIMIT 0, 1
SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-23 05:12:02' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-23 05:12:02' )
AND a.introtext LIKE "%<img%"
AND s.id > 0
AND (cc.id=17 OR cc.id=18)
AND (s.id=6)
AND s.published = 1
AND cc.published = 1
ORDER BY a.created DESC
LIMIT 0, 1
SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-23 05:12:02' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-23 05:12:02' )
AND a.introtext LIKE "%<img%"
AND s.id > 0
AND (cc.id=20)
AND (s.id=6)
AND s.published = 1
AND cc.published = 1
ORDER BY a.created DESC
LIMIT 0, 1
SELECT id
FROM jos_menu
WHERE link LIKE 'index.php?option=com_comprofiler&task=registers%'
AND published=1
AND access = 0
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=100201&lang=en'
SELECT name, link,id
FROM jos_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT name, link,id
FROM jos_menu
WHERE id = 100201
AND published='1'
SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-23 05:12:02' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-23 05:12:02' )
AND a.introtext LIKE "%<img%"
AND s.id > 0
AND (cc.id=17 OR cc.id=18)
AND (s.id=6)
AND s.published = 1
AND cc.published = 1
ORDER BY a.created DESC
LIMIT 0, 3
A shopper exits the Northlands Co-op on Tuesday. Northlands Co-op food store and gas bar are celebrating their 10th anniversary today. Festivities will run from 10 a.m. until 7 p.m., with giveaways, prize draws, food samples, store specials and 10-cent coffee all say.
It may have started out as the Bank of Alberta more than 25 years ago but with branches now stretching from Winnipeg to Victoria, Canadian Western Bank needed a name to match its territory.
