Página Principal

Publicidade

Anúncios Mais Recentes

nopic
Vendo Celular vivi baby
( / Celulares)
29/11/2008

Classificados

Bem Vindo ao  Classificados WebTB.

Escolha uma categoria

Inserir anúncio | Todos os Anúncios | Meus dados | Meus Anúncios | Termos de Uso


Links Patrocinados

40 pedidos executados
1
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
2
SELECT id, link
 FROM jos_menu
 WHERE menutype = 'mainmenu'
 AND published = 1
 ORDER BY parent, ordering
LIMIT 1
3
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 27 )
 ORDER BY menuid DESC
LIMIT 1
4
DELETE FROM jos_session
 WHERE (
 ( time < '1228255133' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1228255133' )
 AND guest = 1
 AND userid = 0
 )
5
SELECT * FROM `jos_jstats_configuration`
6
SELECT exclude, type, tld, id FROM jos_jstats_ipaddresses WHERE ip = '38.103.63.59' AND useragent = 'ccbot/1.0 (+http://www.commoncrawl.org/bot.html)'
7
SELECT country_code2 FROM jos_jstats_iptocountry WHERE inet_aton('38.103.63.59') >= ip_from AND inet_aton('38.103.63.59') <= ip_to
8
INSERT INTO jos_jstats_iptocountry (ip_from, ip_to, country_code2) VALUES (637534208, 654311423, 'US')
9
SELECT LENGTH(browser_string) AS strlen, browser_string, browser_fullname FROM jos_jstats_browsers ORDER BY strlen DESC
10
SELECT LENGTH(bot_string) AS strlen, bot_string,bot_fullname FROM jos_jstats_bots ORDER BY strlen DESC
11
SELECT LENGTH(sys_string) AS strlen, sys_string, sys_fullname FROM jos_jstats_systems ORDER BY strlen DESC
12
INSERT INTO jos_jstats_ipaddresses (ip, nslookup, useragent, tld, system, browser, type) VALUES ('38.103.63.59', '38.103.63.59', 'ccbot/1.0 (+http://www.commoncrawl.org/bot.html)', 'us', '', 'Unknown robot (identified by crawl)', 2)
13
SELECT id
 FROM jos_jstats_ipaddresses
 WHERE ip = '38.103.63.59'
 AND useragent = 'ccbot/1.0 (+http://www.commoncrawl.org/bot.html)'
14
SELECT id
 FROM jos_jstats_visits
 WHERE month = MONTH(DATE_ADD(NOW(), INTERVAL -1 HOUR))
 AND year = YEAR(DATE_ADD(NOW(), INTERVAL -1 HOUR))
 AND ip_id = '12'
 AND time >= DATE_ADD(DATE_ADD(NOW(), INTERVAL -1 HOUR), INTERVAL -15 MINUTE)
15
INSERT INTO jos_jstats_visits (ip_id, hour, day, month, year, time, userid)
 VALUES (12, HOUR(DATE_ADD(NOW(), INTERVAL -1 HOUR)), DAYOFMONTH(DATE_ADD(NOW(), INTERVAL -1 HOUR)), MONTH(DATE_ADD(NOW(), INTERVAL -1 HOUR)), YEAR(DATE_ADD(NOW(), INTERVAL -1 HOUR)), DATE_ADD(NOW(), INTERVAL -1 HOUR), '0')
16
SELECT page_id, page_title
 FROM jos_jstats_pages
 WHERE page = '/classificados/'
17
INSERT INTO jos_jstats_page_request (page_id, hour, day, month, year, ip_id)
 VALUES (1, HOUR(DATE_ADD(NOW(), INTERVAL -1 HOUR)), DAYOFMONTH(DATE_ADD(NOW(), INTERVAL -1 HOUR)), MONTH(DATE_ADD(NOW(), INTERVAL -1 HOUR)), YEAR(DATE_ADD(NOW(), INTERVAL -1 HOUR)), 34)
18
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 0
19
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 0
20
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Desconhecido'
 AND type = 1
21
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Desconhecido'
 AND type = 1
22
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 2
23
INSERT INTO jos_stats_agents
 ( agent, type )
 VALUES ( 'Unknown', 2 )
24
SELECT *
 FROM jos_menu
 WHERE id = 27
25
SELECT c.*, count(*) as num_ads,a.id as not_empty FROM jos_adsmanager_categories as c LEFT JOIN jos_adsmanager_ads as a ON a.category = c.id WHERE c.published = 1 GROUP BY c.id ORDER BY c.parent,c.ordering
26
SELECT * FROM jos_adsmanager_config
27
SELECT a.id, a.ad_headline, a.category, a.date_created,p.id as parentid,p.name as parent,c.id as catid, c.name as cat FROM jos_adsmanager_ads as a LEFT JOIN jos_adsmanager_categories as c ON a.category = c.id LEFT JOIN jos_adsmanager_categories as p ON c.parent = p.id WHERE c.published = 1 and a.published = 1 ORDER BY a.date_created DESC ,a.id DESC LIMIT 0, 3
28
SELECT id, title, module, position, content, showtitle, params
 FROM jos_modules AS m
 INNER JOIN jos_modules_menu AS mm ON mm.moduleid = m.id
 WHERE m.published = 1
 AND m.access <= 0
 AND m.client_id != 1
 AND ( mm.menuid = 0 OR mm.menuid = 27 )
 ORDER BY ordering
29
SELECT a.*
 FROM jos_components AS a
 WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' )
 AND a.option = 'com_syndicate'
30
SELECT c.* FROM jos_adsmanager_categories as c WHERE c.published = 1 ORDER BY c.parent,c.ordering
31
SELECT m.*, count(p.parent) as cnt
FROM jos_menu AS m
LEFT JOIN jos_menu AS p ON p.parent = m.id
WHERE m.menutype='mainmenu' AND m.published='1'
GROUP BY m.id ORDER BY m.parent, m.ordering
32
SELECT m.* FROM jos_menu AS m
WHERE menutype='mainmenu' AND m.published='1'
33
SELECT id, name, link, parent, type, menutype, access
 FROM jos_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
34
SELECT c.*, count(*) as num_ads,a.id as not_empty FROM jos_adsmanager_categories as c LEFT JOIN jos_adsmanager_ads as a ON a.category = c.id WHERE c.published = 1 GROUP BY c.id ORDER BY c.parent,c.ordering
35
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND parent = 0
 ORDER BY ordering
36
SELECT p.id, p.title
 FROM jos_polls AS p
 INNER JOIN jos_poll_menu AS pm ON  pm.pollid = p.id
 WHERE ( pm.menuid = 27 OR pm.menuid = 0 )
 AND p.published = 1
37
SELECT id
 FROM jos_menu
 WHERE type = 'components'
 AND published = 1
 AND link = 'index.php?option=com_poll'
38
SELECT id, text
 FROM jos_poll_data
 WHERE pollid = 14
 AND text != ''
 ORDER BY id
39
SELECT a.id, a.ad_headline, a.category, a.date_created,p.id as parentid,p.name as parent,c.id as catid, c.name as cat FROM jos_adsmanager_ads as a LEFT JOIN jos_adsmanager_categories as c ON a.category = c.id LEFT JOIN jos_adsmanager_categories as p ON c.parent = p.id WHERE  c.published = 1 and a.published = 1 ORDER BY a.views DESC,a.date_created DESC ,a.id DESC  LIMIT 0, 5
40
SELECT * FROM jos_adsmanager_config