MERCEDES A180 CDI 109 (W176) SENSATION BM6 5 P 1 ERE MAIN
Prix: 18500€
RENAULT MEGANE III PHASE 2 1.5 DCI 110 BOSE ECO 2 GPS
Prix: 11000€
NISSAN MICRA VI 1.5 DCI 90 BUSINESS EDITION 5 PORTES 1ERE MAIN
Prix: 14990€
Nouveautés
MERCEDES GLA 200 CDI 7G 136 DCT 4 MATIC BUSI EXECUTIVE EDITIONNESS 1 ERE MAIN
VOLKSWAGEN PASSAT 1.9 TDI 105 TRENDLINE BREAK 1 ERE MAIN
SUZUKI SX4 S-CROSS 1.6 DDIS 120 4X2 1 ERE MAIN TOUTES OPTIONS.
NISSAN QASHQAI 1.5 DCI 106 CONNECT 4X2 1 ERE MAIN
Autostand
 
Accueil   SUV | Chercher

Nos Offres
 
  KIA SPORTAGE 1.7 CRDI 115 ACTIVE BUSINESS 2WD   
Jolie SUV robuste économique bien équipé avec faible kilométrage, garantie constructeur 13/05/2023.... [En savoir plus]
20.990 € / KIA / SPORTAGE
  HYUNDAI KONA 1.0 T GDI 120 EXECUTIVE QUASI NEUF   
Jolie SUV quasi neuf avec 1644 km d'origine, bien équipé sous garantie constructeur.... [En savoir plus]
16.990 € / Hyundai / KONA
  FORD ECOSPORT 1.5 TDCI 95CH TITANIUM 1 ERE MAIN .  
Jolie SUV robuste économique avec des belles options et entretien à jour.... [En savoir plus]
12.500 € / Ford / ECOSPORT
  NISSAN QASHQAI 1.5 DCI 106 CONNECT 4X2 1 ERE MAIN  
Jolie SUV bien équipé avec faible kilométrage et entretien à jour.... [En savoir plus]
8.000 € / Nissan / QASHQAI
  SUZUKI SX4 S-CROSS 1.6 DDIS 120 4X2 1 ERE MAIN TOUTES OPTIONS.  
Jolie SUV bien équipés, robuste économique avec entretien à jour.... [En savoir plus]
13.990 € / Suzuki / SX4 CROSS
  MERCEDES GLA 200 CDI 7G 136 DCT 4 MATIC BUSI EXECUTIVE EDITIONNESS 1 ERE MAIN  
Jolie SUV 4 Roues motrices boite auto 7 vitesses économique robuste avec de belles options . Grand GPS Pack hiver, entretien Mercedes à jour . ... [En savoir plus]
26.990 € / Mercedes / gla

© 2020 Vehicules d'occasion Terville Mondial Automobiles
Defiwebdesign Création de sites web en Lorraine.
116 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_autostand&act=cat&id=7&lang=fr&task=showCE'
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_autostand&act=cat&id=7&lang=fr&task=showCE'
7
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 99999999 )
 ORDER BY menuid DESC
LIMIT 1
8
DELETE FROM jos_session
 WHERE (
 ( time < '1579755823' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1579755823' )
 AND guest = 1
 AND userid = 0
 )
9
SELECT *
 FROM jos_menu
 WHERE published = 1 AND
 link LIKE 'index.php?option=com\_autostand&task=showCE%'
10
SELECT *
 FROM jos_autostand_categories
 WHERE id = '7'
11
SELECT * FROM jos_autostand_categories WHERE (
 ((publish_up >= '0000-00-00' AND publish_up <= '2020-01-23') AND publish_down >= '2020-01-23')
 OR ((publish_up >= '0000-00-00' AND publish_up <= '2020-01-23' ) AND (publish_down = '0000-00-00' OR publish_down >= '2020-01-23'))
 OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00')
 ) AND parent = 7 AND access <= 0 AND publish='1' ORDER BY ordering
12
SELECT count(id) FROM jos_autostand WHERE cat=7 AND ( ((publish_up >= '0000-00-00' AND publish_up <= '2020-01-23') AND publish_down >= '2020-01-23') OR ((publish_up >= '0000-00-00' AND publish_up <= '2020-01-23' ) AND (publish_down = '0000-00-00' OR publish_down >= '2020-01-23')) OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00') ) AND access<=0 AND verified=1 AND publish=1
13
SELECT id, obj_id, type, title, description, rent, km, price, brand, state FROM jos_autostand WHERE cat=7 AND ( ((publish_up >= '0000-00-00' AND publish_up <= '2020-01-23') AND publish_down >= '2020-01-23') OR ((publish_up >= '0000-00-00' AND publish_up <= '2020-01-23' ) AND (publish_down = '0000-00-00' OR publish_down >= '2020-01-23')) OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00') ) AND hot=1 AND access<=0 AND verified=1 AND publish=1 ORDER BY rand() LIMIT 1
14
SELECT id, obj_id, type, title, description, rent,km, yobuilt, power, price, brand, state, hot FROM jos_autostand WHERE cat=7 AND ( ((publish_up >= '0000-00-00' AND publish_up <= '2020-01-23') AND publish_down >= '2020-01-23') OR ((publish_up >= '0000-00-00' AND publish_up <= '2020-01-23' ) AND (publish_down = '0000-00-00' OR publish_down >= '2020-01-23')) OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00') )  AND access<=0 AND verified=1 AND publish=1 ORDER BY id ASC LIMIT 0,25
15
SELECT `id`,`link` FROM jos_menu where ((`menutype`='mainmenu') AND (`published` > 0) AND (`access` <= '0')) ORDER BY parent, ordering
16
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=cat&lang=fr&task=0'
17
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&Itemid=1&act=easearch&lang=fr'
18
SELECT title,fname,type,path FROM jos_autostand_images WHERE objid = 1173 AND (type = '.jpg' OR type = '.gif' OR type = '.png') AND ordering = 1 AND publish = 1
19
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1173&lang=fr&task=showEO'
20
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1173&lang=fr&task=showEO'
21
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1173&lang=fr&task=showEO'
22
SELECT title,fname,type,path FROM jos_autostand_images WHERE objid = 1182 AND (type = '.jpg' OR type = '.gif' OR type = '.png') AND ordering = 1 AND publish = 1
23
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1182&lang=fr&task=showEO'
24
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1182&lang=fr&task=showEO'
25
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1182&lang=fr&task=showEO'
26
SELECT title,fname,type,path FROM jos_autostand_images WHERE objid = 1185 AND (type = '.jpg' OR type = '.gif' OR type = '.png') AND ordering = 1 AND publish = 1
27
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1185&lang=fr&task=showEO'
28
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1185&lang=fr&task=showEO'
29
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1185&lang=fr&task=showEO'
30
SELECT title,fname,type,path FROM jos_autostand_images WHERE objid = 1188 AND (type = '.jpg' OR type = '.gif' OR type = '.png') AND ordering = 1 AND publish = 1
31
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1188&lang=fr&task=showEO'
32
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1188&lang=fr&task=showEO'
33
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1188&lang=fr&task=showEO'
34
SELECT title,fname,type,path FROM jos_autostand_images WHERE objid = 1189 AND (type = '.jpg' OR type = '.gif' OR type = '.png') AND ordering = 1 AND publish = 1
35
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1189&lang=fr&task=showEO'
36
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1189&lang=fr&task=showEO'
37
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1189&lang=fr&task=showEO'
38
SELECT title,fname,type,path FROM jos_autostand_images WHERE objid = 1192 AND (type = '.jpg' OR type = '.gif' OR type = '.png') AND ordering = 1 AND publish = 1
39
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1192&lang=fr&task=showEO'
40
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1192&lang=fr&task=showEO'
41
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1192&lang=fr&task=showEO'
42
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'
43
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 = 99999999 )
 ORDER BY ordering
44
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 ORDER BY parent, ordering
45
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&Itemid=33&lang=fr'
46
SELECT id, cat, verified, price, title, publish, publish_up, publish_down
					FROM jos_autostand 
					WHERE 
 (
 ((publish_up >= '0000-00-00' AND publish_up <= '2020-01-23') AND publish_down >= '2020-01-23')
 OR ((publish_up >= '0000-00-00' AND publish_up <= '2020-01-23' ) AND (publish_down = '0000-00-00' OR publish_down >= '2020-01-23'))
 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
47
SELECT id, path, fname, type, ordering, publish
		FROM jos_autostand_images
		WHERE objid='1155' AND ordering=1
48
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1155&lang=fr&task=showEO'
49
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1155&lang=fr&task=showEO'
50
SELECT id, path, fname, type, ordering, publish
		FROM jos_autostand_images
		WHERE objid='1187' AND ordering=1
51
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1187&lang=fr&task=showEO'
52
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1187&lang=fr&task=showEO'
53
SELECT id, path, fname, type, ordering, publish
		FROM jos_autostand_images
		WHERE objid='1183' AND ordering=1
54
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1183&lang=fr&task=showEO'
55
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1183&lang=fr&task=showEO'
56
SELECT id, cat, title, publish, publish_up, publish_down
				FROM jos_autostand 
				WHERE 
 (
 ((publish_up >= '0000-00-00' AND publish_up <= '2020-01-23') AND publish_down >= '2020-01-23')
 OR ((publish_up >= '0000-00-00' AND publish_up <= '2020-01-23' ) AND (publish_down = '0000-00-00' OR publish_down >= '2020-01-23'))
 OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00')
 ) AND publish=1 AND verified=1 ORDER BY id DESC LIMIT 4
57
SELECT id, path, fname, type, ordering, publish
				FROM jos_autostand_images
				WHERE objid='1192' AND ordering=1
58
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1192&lang=fr&task=showEO'
59
SELECT id, path, fname, type, ordering, publish
				FROM jos_autostand_images
				WHERE objid='1190' AND ordering=1
60
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1190&lang=fr&task=showEO'
61
SELECT id, path, fname, type, ordering, publish
				FROM jos_autostand_images
				WHERE objid='1189' AND ordering=1
62
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1189&lang=fr&task=showEO'
63
SELECT id, path, fname, type, ordering, publish
				FROM jos_autostand_images
				WHERE objid='1188' AND ordering=1
64
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1188&lang=fr&task=showEO'
65
SELECT * FROM jos_autostand_categories WHERE parent=0 ORDER BY ordering ASC
66
SELECT count(*) FROM jos_autostand  WHERE cat = 8 AND publish=1 AND verified=1
67
SELECT * FROM jos_autostand_categories WHERE parent = 8
68
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=cat&id=8&lang=fr&task=showCE'
69
SELECT * FROM jos_autostand_categories WHERE parent=8 ORDER BY ordering ASC
70
SELECT count(*) FROM jos_autostand  WHERE cat = 17 AND publish=1 AND verified=1
71
SELECT * FROM jos_autostand_categories WHERE parent = 17
72
SELECT count(*) FROM jos_autostand  WHERE cat = 4 AND publish=1 AND verified=1
73
SELECT * FROM jos_autostand_categories WHERE parent = 4
74
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=cat&id=4&lang=fr&task=showCE'
75
SELECT * FROM jos_autostand_categories WHERE parent=4 ORDER BY ordering ASC
76
SELECT count(*) FROM jos_autostand  WHERE cat = 21 AND publish=1 AND verified=1
77
SELECT * FROM jos_autostand_categories WHERE parent = 21
78
SELECT count(*) FROM jos_autostand  WHERE cat = 14 AND publish=1 AND verified=1
79
SELECT * FROM jos_autostand_categories WHERE parent = 14
80
SELECT count(*) FROM jos_autostand  WHERE cat = 13 AND publish=1 AND verified=1
81
SELECT * FROM jos_autostand_categories WHERE parent = 13
82
SELECT count(*) FROM jos_autostand  WHERE cat = 7 AND publish=1 AND verified=1
83
SELECT * FROM jos_autostand_categories WHERE parent = 7
84
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=cat&id=7&lang=fr&task=showCE'
85
SELECT * FROM jos_autostand_categories WHERE parent=7 ORDER BY ordering ASC
86
SELECT count(*) FROM jos_autostand  WHERE cat = 15 AND publish=1 AND verified=1
87
SELECT * FROM jos_autostand_categories WHERE parent = 15
88
SELECT count(*) FROM jos_autostand  WHERE cat = 11 AND publish=1 AND verified=1
89
SELECT * FROM jos_autostand_categories WHERE parent = 11
90
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=cat&id=11&lang=fr&task=showCE'
91
SELECT * FROM jos_autostand_categories WHERE parent=11 ORDER BY ordering ASC
92
SELECT count(*) FROM jos_autostand  WHERE cat = 10 AND publish=1 AND verified=1
93
SELECT * FROM jos_autostand_categories WHERE parent = 10
94
SELECT count(*) FROM jos_autostand  WHERE cat = 16 AND publish=1 AND verified=1
95
SELECT * FROM jos_autostand_categories WHERE parent = 16
96
SELECT count(*) FROM jos_autostand  WHERE cat = 6 AND publish=1 AND verified=1
97
SELECT * FROM jos_autostand_categories WHERE parent = 6
98
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=cat&id=6&lang=fr&task=showCE'
99
SELECT * FROM jos_autostand_categories WHERE parent=6 ORDER BY ordering ASC
100
SELECT count(*) FROM jos_autostand  WHERE cat = 1 AND publish=1 AND verified=1
101
SELECT * FROM jos_autostand_categories WHERE parent = 1
102
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=cat&id=1&lang=fr&task=showCE'
103
SELECT * FROM jos_autostand_categories WHERE parent=1 ORDER BY ordering ASC
104
SELECT count(*) FROM jos_autostand  WHERE cat = 5 AND publish=1 AND verified=1
105
SELECT * FROM jos_autostand_categories WHERE parent = 5
106
SELECT count(*) FROM jos_autostand  WHERE cat = 3 AND publish=1 AND verified=1
107
SELECT * FROM jos_autostand_categories WHERE parent = 3
108
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=cat&id=3&lang=fr&task=showCE'
109
SELECT * FROM jos_autostand_categories WHERE parent=3 ORDER BY ordering ASC
110
SELECT count(*) FROM jos_autostand  WHERE cat = 2 AND publish=1 AND verified=1
111
SELECT * FROM jos_autostand_categories WHERE parent = 2
112
SELECT count(*) FROM jos_autostand  WHERE cat = 9 AND publish=1 AND verified=1
113
SELECT * FROM jos_autostand_categories WHERE parent = 9
114
SELECT id, cat, title, publish, publish_up, publish_down, hot
				FROM jos_autostand 
				WHERE 
 (
 ((publish_up >= '0000-00-00' AND publish_up <= '2020-01-23') AND publish_down >= '2020-01-23')
 OR ((publish_up >= '0000-00-00' AND publish_up <= '2020-01-23' ) AND (publish_down = '0000-00-00' OR publish_down >= '2020-01-23'))
 OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00')
 ) AND hot=1 ORDER BY RAND() LIMIT 2
115
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'menu_bas'
 AND published = 1
 AND parent = 0
 ORDER BY ordering
116
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_joomap&Itemid=37&lang=fr'