MERCEDES A180 CDI 109 (W176) SENSATION BM6 5 P 1 ERE MAIN
Prix: 18500€
RENAULT MODUS 1.2 ES 75 CH DYNAMIQUE
Prix: 6990€
Nouveautés
VOLKSWAGEN TIGUAN 2.0 TDI 140 R-LINE 4 MOTION 1 ERE MAIN FULL OPTIONS
KIA SPORTAGE 1.7 CRDI 115 ACTIVE BUSINESS 2WD
RENAULT MODUS 1.2 ES 75 CH DYNAMIQUE
PEUGEOT 207 1.4 VTI URBAN 95CV 3 PORTES 1 ERE MAIN
© 2019 Vehicules d'occasion Terville Mondial Automobiles
Defiwebdesign Création de sites web en Lorraine.
83 queries executed
1
SET sql_mode = 'MYSQL40'
2
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
3
SELECT `id`,`link` FROM jos_menu  WHERE ((`name` LIKE '%component%') AND (`published` > 0))
4
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_joomap&Itemid=37&lang=fr'
5
SELECT `id`,`link` FROM jos_menu where ((`menutype`='mainmenu') AND (`published` > 0) AND (`access` <= '0')) ORDER BY parent, ordering
6
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_joomap&Itemid=37&lang=fr'
7
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 37 )
 ORDER BY menuid DESC
LIMIT 1
8
DELETE FROM jos_session
 WHERE (
 ( time < '1571733009' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1571733009' )
 AND guest = 1
 AND userid = 0
 )
9
SELECT *
 FROM jos_menu
 WHERE id = 37
10
SELECT m.id, m.name, m.parent, m.link, m.type, m.browserNav, m.menutype, m.ordering, m.componentid, m.params, c.name AS component
 FROM jos_menu AS m
 LEFT JOIN jos_components AS c ON c.id=m.componentid
 WHERE m.published='1' AND m.menutype IN ('topmenu','menu_bas','Menu_Services')
 ORDER BY m.menutype,m.parent,m.ordering
11
SELECT a.id, a.title
 FROM jos_content AS a
 WHERE a.catid='15' 
 AND a.state='1'
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-10-22 08:45:09' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-10-22 08:45:09' )
 ORDER BY a.created DESC
12
SELECT `id`,`link` FROM jos_menu where ((`menutype`='mainmenu') AND (`published` > 0) AND (`access` <= '0')) ORDER BY parent, ordering
13
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&Itemid=33&lang=fr'
14
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_joomap&Itemid=37&lang=fr'
15
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'
16
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 = 37 )
 ORDER BY ordering
17
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 ORDER BY parent, ordering
18
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&Itemid=33&lang=fr'
19
SELECT id, cat, verified, price, title, publish, publish_up, publish_down
					FROM jos_autostand 
					WHERE 
 (
 ((publish_up >= '0000-00-00' AND publish_up <= '2019-10-22') AND publish_down >= '2019-10-22')
 OR ((publish_up >= '0000-00-00' AND publish_up <= '2019-10-22' ) AND (publish_down = '0000-00-00' OR publish_down >= '2019-10-22'))
 OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00')
 ) AND publish=1 AND verified=1 AND cat=3 ORDER BY RAND() LIMIT 3
20
SELECT id, path, fname, type, ordering, publish
		FROM jos_autostand_images
		WHERE objid='1155' AND ordering=1
21
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1155&lang=fr&task=showEO'
22
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1155&lang=fr&task=showEO'
23
SELECT id, path, fname, type, ordering, publish
		FROM jos_autostand_images
		WHERE objid='1170' AND ordering=1
24
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1170&lang=fr&task=showEO'
25
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1170&lang=fr&task=showEO'
26
SELECT id, cat, title, publish, publish_up, publish_down
				FROM jos_autostand 
				WHERE 
 (
 ((publish_up >= '0000-00-00' AND publish_up <= '2019-10-22') AND publish_down >= '2019-10-22')
 OR ((publish_up >= '0000-00-00' AND publish_up <= '2019-10-22' ) AND (publish_down = '0000-00-00' OR publish_down >= '2019-10-22'))
 OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00')
 ) AND publish=1 AND verified=1 ORDER BY id DESC LIMIT 4
27
SELECT id, path, fname, type, ordering, publish
				FROM jos_autostand_images
				WHERE objid='1174' AND ordering=1
28
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1174&lang=fr&task=showEO'
29
SELECT id, path, fname, type, ordering, publish
				FROM jos_autostand_images
				WHERE objid='1173' AND ordering=1
30
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1173&lang=fr&task=showEO'
31
SELECT id, path, fname, type, ordering, publish
				FROM jos_autostand_images
				WHERE objid='1170' AND ordering=1
32
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1170&lang=fr&task=showEO'
33
SELECT id, path, fname, type, ordering, publish
				FROM jos_autostand_images
				WHERE objid='1168' AND ordering=1
34
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1168&lang=fr&task=showEO'
35
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'menucontextaccueil'
 AND published = 1
 AND parent = 0
 ORDER BY ordering
36
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_item_link'
 AND published = 1
37
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=13'
38
SELECT * FROM jos_autostand_categories WHERE parent=0 ORDER BY ordering ASC
39
SELECT count(*) FROM jos_autostand  WHERE cat = 8 AND publish=1 AND verified=1
40
SELECT * FROM jos_autostand_categories WHERE parent = 8
41
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=cat&id=8&lang=fr&task=showCE'
42
SELECT * FROM jos_autostand_categories WHERE parent=8 ORDER BY ordering ASC
43
SELECT count(*) FROM jos_autostand  WHERE cat = 17 AND publish=1 AND verified=1
44
SELECT * FROM jos_autostand_categories WHERE parent = 17
45
SELECT count(*) FROM jos_autostand  WHERE cat = 4 AND publish=1 AND verified=1
46
SELECT * FROM jos_autostand_categories WHERE parent = 4
47
SELECT count(*) FROM jos_autostand  WHERE cat = 21 AND publish=1 AND verified=1
48
SELECT * FROM jos_autostand_categories WHERE parent = 21
49
SELECT count(*) FROM jos_autostand  WHERE cat = 14 AND publish=1 AND verified=1
50
SELECT * FROM jos_autostand_categories WHERE parent = 14
51
SELECT count(*) FROM jos_autostand  WHERE cat = 13 AND publish=1 AND verified=1
52
SELECT * FROM jos_autostand_categories WHERE parent = 13
53
SELECT count(*) FROM jos_autostand  WHERE cat = 7 AND publish=1 AND verified=1
54
SELECT * FROM jos_autostand_categories WHERE parent = 7
55
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=cat&id=7&lang=fr&task=showCE'
56
SELECT * FROM jos_autostand_categories WHERE parent=7 ORDER BY ordering ASC
57
SELECT count(*) FROM jos_autostand  WHERE cat = 15 AND publish=1 AND verified=1
58
SELECT * FROM jos_autostand_categories WHERE parent = 15
59
SELECT count(*) FROM jos_autostand  WHERE cat = 11 AND publish=1 AND verified=1
60
SELECT * FROM jos_autostand_categories WHERE parent = 11
61
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=cat&id=11&lang=fr&task=showCE'
62
SELECT * FROM jos_autostand_categories WHERE parent=11 ORDER BY ordering ASC
63
SELECT count(*) FROM jos_autostand  WHERE cat = 10 AND publish=1 AND verified=1
64
SELECT * FROM jos_autostand_categories WHERE parent = 10
65
SELECT count(*) FROM jos_autostand  WHERE cat = 16 AND publish=1 AND verified=1
66
SELECT * FROM jos_autostand_categories WHERE parent = 16
67
SELECT count(*) FROM jos_autostand  WHERE cat = 6 AND publish=1 AND verified=1
68
SELECT * FROM jos_autostand_categories WHERE parent = 6
69
SELECT count(*) FROM jos_autostand  WHERE cat = 1 AND publish=1 AND verified=1
70
SELECT * FROM jos_autostand_categories WHERE parent = 1
71
SELECT count(*) FROM jos_autostand  WHERE cat = 5 AND publish=1 AND verified=1
72
SELECT * FROM jos_autostand_categories WHERE parent = 5
73
SELECT count(*) FROM jos_autostand  WHERE cat = 3 AND publish=1 AND verified=1
74
SELECT * FROM jos_autostand_categories WHERE parent = 3
75
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=cat&id=3&lang=fr&task=showCE'
76
SELECT * FROM jos_autostand_categories WHERE parent=3 ORDER BY ordering ASC
77
SELECT count(*) FROM jos_autostand  WHERE cat = 2 AND publish=1 AND verified=1
78
SELECT * FROM jos_autostand_categories WHERE parent = 2
79
SELECT count(*) FROM jos_autostand  WHERE cat = 9 AND publish=1 AND verified=1
80
SELECT * FROM jos_autostand_categories WHERE parent = 9
81
SELECT id, cat, title, publish, publish_up, publish_down, hot
				FROM jos_autostand 
				WHERE 
 (
 ((publish_up >= '0000-00-00' AND publish_up <= '2019-10-22') AND publish_down >= '2019-10-22')
 OR ((publish_up >= '0000-00-00' AND publish_up <= '2019-10-22' ) AND (publish_down = '0000-00-00' OR publish_down >= '2019-10-22'))
 OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00')
 ) AND hot=1 ORDER BY RAND() LIMIT 2
82
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'menu_bas'
 AND published = 1
 AND parent = 0
 ORDER BY ordering
83
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_joomap&Itemid=37&lang=fr'