Login

browsedealer.gif

Vehicle Search

Price range:-
Vehicle type:-
Make:-
Model:-
Transmission:-
Fuel type:-
Condition:-
Zip/Post Code Area:-
Select Order:-
videotut.gif
Powered By PageCache
Generated in 1.49778 Seconds
54 queries executed
1
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
2
SELECT opt,task,name FROM jos_pagecache_reset_list WHERE pub = 1 AND (opt LIKE '%' OR opt = '')
3
SHOW TABLES LIKE '%sef_config'
4
SHOW TABLES LIKE '%sef_alias'
5
SELECT * FROM jos_sef_alias WHERE published='1'
6
SHOW TABLES LIKE '%sef_redirect'
7
SELECT id FROM jos_components WHERE link='option=com_' AND link<>'' ORDER BY id DESC
8
SELECT id, link
 FROM jos_menu
 WHERE menutype = 'mainmenu'
 AND published = 1
 ORDER BY parent, ordering
LIMIT 1
9
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 1 )
 ORDER BY menuid DESC
LIMIT 1
10
DELETE FROM jos_session
 WHERE (
 ( time < '1246687283' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1246689083' )
 AND guest = 1
 AND userid = 0
 )
11
SELECT id FROM jos_mambots WHERE element = 'bot_UltimatePNGFix' AND folder = 'system'
12
SELECT *
 FROM jos_mambots
 WHERE id = '23'
13
SELECT *
 FROM jos_menu
 WHERE id = 1
14
SELECT value,regex FROM jos_pagecache_no_cache WHERE pub = 1
15
SELECT data, info FROM jos_pagecache_page_store WHERE name = '6666cd76f96956469e7be39d750cc7d9_english' LIMIT 1
16
SELECT `lock` FROM jos_pagecache_page_store WHERE name = '6666cd76f96956469e7be39d750cc7d9_english'
17
UPDATE jos_pagecache_page_store SET `lock` = 1 WHERE name = '6666cd76f96956469e7be39d750cc7d9_english'
18
SELECT m.* FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
19
SELECT m.* FROM jos_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
20
SELECT m.* FROM jos_menu AS m
 WHERE menutype = 'othermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
21
SELECT m.* FROM jos_menu AS m
 WHERE menutype = 'usermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
22
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 = 1 )
 ORDER BY ordering
23
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'
24
SELECT `configValue` FROM `jos_sobi2_config` WHERE (`configKey` = 'itemsInLine' OR `configKey` = 'lineOnSite')
25
SELECT cc.cid AS value, cc.name AS text
 FROM jos_ezautos_catg AS cc WHERE cc.published=1
 ORDER BY cc.ordering
26
SELECT ma.maid as value, ma.make as text FROM jos_ezautos_make AS ma ORDER by ma.make
27
SELECT ma.maid as value, ma.make as text FROM jos_ezautos_make AS ma ORDER by ma.make
28
SELECT mo.moid as value, mo.model as text FROM jos_ezautos_model AS mo ORDER by mo.model
29
SELECT mip.range as value, mip.display as text FROM jos_ezautos_price AS mip ORDER by mip.ordering
30
SELECT mip.range as value, mip.display as text FROM jos_ezautos_price AS mip ORDER by mip.ordering
31
SELECT map.range as value, map.display as text FROM jos_ezautos_price AS map ORDER by map.ordering
32
SELECT map.range as value, map.display as text FROM jos_ezautos_price AS map ORDER by map.ordering
33
SELECT distinct p.pcode as value, p.pcode as text FROM jos_ezautos AS p WHERE p.published = 1 AND p.pcode != '' ORDER by p.pcode ASC
34
SELECT distinct p.pcode as value, p.pcode as text FROM jos_ezautos AS p WHERE p.published = 1 AND p.pcode != '' ORDER by p.pcode ASC
35
SELECT DISTINCT f.fuel as value, f.fuel as text FROM jos_ezautos AS f WHERE f.published = 1 AND f.fuel != '' ORDER by f.fuel
36
SELECT DISTINCT f.fuel as value, f.fuel as text FROM jos_ezautos AS f WHERE f.published = 1 AND f.fuel != '' ORDER by f.fuel
37
SELECT b.* from jos_menu AS b
 WHERE b.link = 'index.php?option=com_ezautos'
38
SELECT i.itemid, i.title, i.icon, i.image
			FROM jos_sobi2_fields_data AS fd
			INNER JOIN  jos_sobi2_item AS i 
			USING (itemid)
			WHERE (i.published = '1'
			AND i.approved = '1'
			AND (i.publish_down > '09-07-04 02:46:23' OR i.publish_down = '0000-00-00 00:00:00'))
			AND fd.fieldid=17 AND fd.data_txt='1' 
			ORDER BY RAND()
39
SELECT id
			FROM jos_menu
			WHERE link LIKE '%index.php?option=com_sobi2%'
			AND type = 'components'
			AND published = '1' LIMIT 1
40
SELECT `title` FROM `jos_sobi2_item` WHERE (`itemid`=1 AND `published` = 1)
41
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
42
SELECT b.* from jos_menu AS b
 WHERE b.link = 'index.php?option=com_ezautos'
43
SELECT a.*, ma.make as makename, mo.model as modelname
 FROM jos_ezautos AS a
 LEFT JOIN jos_ezautos_make as ma ON ma.maid=a.make
 LEFT JOIN jos_ezautos_model as mo ON mo.moid=a.model
 WHERE a.published = '1' AND a.featured = 1 AND a.expdate>1246680000 ORDER BY RAND() LIMIT 12
44
SELECT id FROM jos_menu WHERE link = 'index.php?option=com_comprofiler' AND published=1
45
SELECT template FROM jos_templates_menu where client_id ='0'
46
select gid from jos_users where id=0
47
select gid from jos_users where id=0
48
SELECT u.id, ifnull(u.username, 'Guest') as username, ifnull(u.name,'Guest') as name,   fb.subject, fb.id as fbid, fb.catid, from_unixtime(fb.time) as date,    fb.hits, fb.locked,fb.topic_emoticon, fb.parent, sc.name as catname  FROM jos_fb_messages AS fb  LEFT JOIN jos_users AS u ON u.id = fb.userid INNER JOIN jos_fb_categories sc on sc.id = fb.catid  WHERE 1=1   AND (sc.pub_access<=0)   AND (sc.published=1) GROUP BY fb.subject ORDER BY fb.time DESC LIMIT 6
49
SELECT m.subject AS subject, c.name AS catname FROM jos_fb_messages AS m LEFT JOIN jos_fb_categories AS c ON m.catid=c.id WHERE m.id='29'
50
SELECT m.subject AS subject, c.name AS catname FROM jos_fb_messages AS m LEFT JOIN jos_fb_categories AS c ON m.catid=c.id WHERE m.id='28'
51
SELECT m.subject AS subject, c.name AS catname FROM jos_fb_messages AS m LEFT JOIN jos_fb_categories AS c ON m.catid=c.id WHERE m.id='27'
52
SELECT m.subject AS subject, c.name AS catname FROM jos_fb_messages AS m LEFT JOIN jos_fb_categories AS c ON m.catid=c.id WHERE m.id='26'
53
SELECT m.subject AS subject, c.name AS catname FROM jos_fb_messages AS m LEFT JOIN jos_fb_categories AS c ON m.catid=c.id WHERE m.id='25'
54
SELECT m.subject AS subject, c.name AS catname FROM jos_fb_messages AS m LEFT JOIN jos_fb_categories AS c ON m.catid=c.id WHERE m.id='24'