Nouveautés
NISSAN MICRA 1.5 DCI 90 CONNECT EDITION 1 ÈRE MAIN 5 PORTES
VOLKSWAGEN GOLF SPORTSVAN 1.6 TDI 110 CONFORTLINE 1 ÈRE MAIN
SKODA YETI II 2.0 TDI 140 DSG 6 ELEGANCE 4X4 1 ÈRE MAIN
VOLKSWAGEN NEW BEETLE II 2.0 TDI 140 DESIGN 1 ÈRE 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
  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
  AUDI Q 3 2.0 TDI 140 AMBITION LUXE 1 ERE MAIN 4X2  
Jolie SUV robuste économique avec de nombreuses options, entretien à jour dans le réseau AUDI, Garantie totale .... [En savoir plus]
16.990 € / Audi / Q3
  AUDI Q 3 2.0 TDI QUATTRO 177 CV AMBITION LUXE SUV 1 ERE MAIN  

Jolie SUV économique robuste puissante, riches en équipements, entretien à jour.

Garantie totale. 

... [En savoir plus]
20.500 € / Audi / AUDI Q3
  RENAULT CAPTUR 1.5 DCI 90 INTENCE SUV COMPACT 1 ÈRE MAIN  

Jolie SUV compact robuste économique peut kilométré avec de nombreuses options.

Entretien à jour.

Garantie totale. 

... [En savoir plus]
12.000 € / Renault / CAPTUR
  SKODA YETI II 2.0 TDI 140 DSG 6 ELEGANCE 4X4 1 ÈRE MAIN  

Jolie SUV bien équipé 4 roue motrice en boite automatique très robuste et économique avec entretien à jour.

Garantie totale. 

 

... [En savoir plus]
17.500 € / Skoda / YETI

© 2020 Vehicules d'occasion Terville Mondial Automobiles
Defiwebdesign Création de sites web en Lorraine.
126 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 < '1585607400' ) AND guest = 0 AND gid > 0 ) OR ( ( time < '1585607400' ) 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-03-30') AND publish_down >= '2020-03-30') OR ((publish_up >= '0000-00-00' AND publish_up <= '2020-03-30' ) AND (publish_down = '0000-00-00' OR publish_down >= '2020-03-30')) 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-03-30') AND publish_down >= '2020-03-30') OR ((publish_up >= '0000-00-00' AND publish_up <= '2020-03-30' ) AND (publish_down = '0000-00-00' OR publish_down >= '2020-03-30')) 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-03-30') AND publish_down >= '2020-03-30') OR ((publish_up >= '0000-00-00' AND publish_up <= '2020-03-30' ) AND (publish_down = '0000-00-00' OR publish_down >= '2020-03-30')) 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-03-30') AND publish_down >= '2020-03-30') OR ((publish_up >= '0000-00-00' AND publish_up <= '2020-03-30' ) AND (publish_down = '0000-00-00' OR publish_down >= '2020-03-30')) 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 = 1192 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=1192&lang=fr&task=showEO'
32 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1192&lang=fr&task=showEO'
33 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1192&lang=fr&task=showEO'
34 SELECT title,fname,type,path FROM jos_autostand_images WHERE objid = 1193 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=1193&lang=fr&task=showEO'
36 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1193&lang=fr&task=showEO'
37 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1193&lang=fr&task=showEO'
38 SELECT title,fname,type,path FROM jos_autostand_images WHERE objid = 1194 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=1194&lang=fr&task=showEO'
40 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1194&lang=fr&task=showEO'
41 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1194&lang=fr&task=showEO'
42 SELECT title,fname,type,path FROM jos_autostand_images WHERE objid = 1197 AND (type = '.jpg' OR type = '.gif' OR type = '.png') AND ordering = 1 AND publish = 1
43 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1197&lang=fr&task=showEO'
44 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1197&lang=fr&task=showEO'
45 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1197&lang=fr&task=showEO'
46 SELECT title,fname,type,path FROM jos_autostand_images WHERE objid = 1199 AND (type = '.jpg' OR type = '.gif' OR type = '.png') AND ordering = 1 AND publish = 1
47 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1199&lang=fr&task=showEO'
48 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1199&lang=fr&task=showEO'
49 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1199&lang=fr&task=showEO'
50 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'
51 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
52 SELECT m.* FROM jos_menu AS m WHERE menutype = 'topmenu' AND published = 1 ORDER BY parent, ordering
53 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&Itemid=33&lang=fr'
54 SELECT id, cat, verified, price, title, publish, publish_up, publish_down FROM jos_autostand WHERE ( ((publish_up >= '0000-00-00' AND publish_up <= '2020-03-30') AND publish_down >= '2020-03-30') OR ((publish_up >= '0000-00-00' AND publish_up <= '2020-03-30' ) AND (publish_down = '0000-00-00' OR publish_down >= '2020-03-30')) 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
55 SELECT id, path, fname, type, ordering, publish FROM jos_autostand_images WHERE objid='1183' AND ordering=1
56 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1183&lang=fr&task=showEO'
57 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1183&lang=fr&task=showEO'
58 SELECT id, path, fname, type, ordering, publish FROM jos_autostand_images WHERE objid='1155' AND ordering=1
59 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1155&lang=fr&task=showEO'
60 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1155&lang=fr&task=showEO'
61 SELECT id, path, fname, type, ordering, publish FROM jos_autostand_images WHERE objid='1187' AND ordering=1
62 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1187&lang=fr&task=showEO'
63 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1187&lang=fr&task=showEO'
64 SELECT id, cat, title, publish, publish_up, publish_down FROM jos_autostand WHERE ( ((publish_up >= '0000-00-00' AND publish_up <= '2020-03-30') AND publish_down >= '2020-03-30') OR ((publish_up >= '0000-00-00' AND publish_up <= '2020-03-30' ) AND (publish_down = '0000-00-00' OR publish_down >= '2020-03-30')) OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00') ) AND publish=1 AND verified=1 ORDER BY id DESC LIMIT 4
65 SELECT id, path, fname, type, ordering, publish FROM jos_autostand_images WHERE objid='1201' AND ordering=1
66 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1201&lang=fr&task=showEO'
67 SELECT id, path, fname, type, ordering, publish FROM jos_autostand_images WHERE objid='1200' AND ordering=1
68 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1200&lang=fr&task=showEO'
69 SELECT id, path, fname, type, ordering, publish FROM jos_autostand_images WHERE objid='1199' AND ordering=1
70 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1199&lang=fr&task=showEO'
71 SELECT id, path, fname, type, ordering, publish FROM jos_autostand_images WHERE objid='1198' AND ordering=1
72 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1198&lang=fr&task=showEO'
73 SELECT * FROM jos_autostand_categories WHERE parent=0 ORDER BY ordering ASC
74 SELECT count(*) FROM jos_autostand WHERE cat = 8 AND publish=1 AND verified=1
75 SELECT * FROM jos_autostand_categories WHERE parent = 8
76 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=cat&id=8&lang=fr&task=showCE'
77 SELECT * FROM jos_autostand_categories WHERE parent=8 ORDER BY ordering ASC
78 SELECT count(*) FROM jos_autostand WHERE cat = 17 AND publish=1 AND verified=1
79 SELECT * FROM jos_autostand_categories WHERE parent = 17
80 SELECT count(*) FROM jos_autostand WHERE cat = 4 AND publish=1 AND verified=1
81 SELECT * FROM jos_autostand_categories WHERE parent = 4
82 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=cat&id=4&lang=fr&task=showCE'
83 SELECT * FROM jos_autostand_categories WHERE parent=4 ORDER BY ordering ASC
84 SELECT count(*) FROM jos_autostand WHERE cat = 21 AND publish=1 AND verified=1
85 SELECT * FROM jos_autostand_categories WHERE parent = 21
86 SELECT count(*) FROM jos_autostand WHERE cat = 14 AND publish=1 AND verified=1
87 SELECT * FROM jos_autostand_categories WHERE parent = 14
88 SELECT count(*) FROM jos_autostand WHERE cat = 13 AND publish=1 AND verified=1
89 SELECT * FROM jos_autostand_categories WHERE parent = 13
90 SELECT count(*) FROM jos_autostand WHERE cat = 7 AND publish=1 AND verified=1
91 SELECT * FROM jos_autostand_categories WHERE parent = 7
92 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=cat&id=7&lang=fr&task=showCE'
93 SELECT * FROM jos_autostand_categories WHERE parent=7 ORDER BY ordering ASC
94 SELECT count(*) FROM jos_autostand WHERE cat = 15 AND publish=1 AND verified=1
95 SELECT * FROM jos_autostand_categories WHERE parent = 15
96 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=cat&id=15&lang=fr&task=showCE'
97 SELECT * FROM jos_autostand_categories WHERE parent=15 ORDER BY ordering ASC
98 SELECT count(*) FROM jos_autostand WHERE cat = 11 AND publish=1 AND verified=1
99 SELECT * FROM jos_autostand_categories WHERE parent = 11
100 SELECT count(*) FROM jos_autostand WHERE cat = 10 AND publish=1 AND verified=1
101 SELECT * FROM jos_autostand_categories WHERE parent = 10
102 SELECT count(*) FROM jos_autostand WHERE cat = 16 AND publish=1 AND verified=1
103 SELECT * FROM jos_autostand_categories WHERE parent = 16
104 SELECT count(*) FROM jos_autostand WHERE cat = 6 AND publish=1 AND verified=1
105 SELECT * FROM jos_autostand_categories WHERE parent = 6
106 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=cat&id=6&lang=fr&task=showCE'
107 SELECT * FROM jos_autostand_categories WHERE parent=6 ORDER BY ordering ASC
108 SELECT count(*) FROM jos_autostand WHERE cat = 1 AND publish=1 AND verified=1
109 SELECT * FROM jos_autostand_categories WHERE parent = 1
110 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=cat&id=1&lang=fr&task=showCE'
111 SELECT * FROM jos_autostand_categories WHERE parent=1 ORDER BY ordering ASC
112 SELECT count(*) FROM jos_autostand WHERE cat = 5 AND publish=1 AND verified=1
113 SELECT * FROM jos_autostand_categories WHERE parent = 5
114 SELECT count(*) FROM jos_autostand WHERE cat = 3 AND publish=1 AND verified=1
115 SELECT * FROM jos_autostand_categories WHERE parent = 3
116 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=cat&id=3&lang=fr&task=showCE'
117 SELECT * FROM jos_autostand_categories WHERE parent=3 ORDER BY ordering ASC
118 SELECT count(*) FROM jos_autostand WHERE cat = 2 AND publish=1 AND verified=1
119 SELECT * FROM jos_autostand_categories WHERE parent = 2
120 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=cat&id=2&lang=fr&task=showCE'
121 SELECT * FROM jos_autostand_categories WHERE parent=2 ORDER BY ordering ASC
122 SELECT count(*) FROM jos_autostand WHERE cat = 9 AND publish=1 AND verified=1
123 SELECT * FROM jos_autostand_categories WHERE parent = 9
124 SELECT id, cat, title, publish, publish_up, publish_down, hot FROM jos_autostand WHERE ( ((publish_up >= '0000-00-00' AND publish_up <= '2020-03-30') AND publish_down >= '2020-03-30') OR ((publish_up >= '0000-00-00' AND publish_up <= '2020-03-30' ) AND (publish_down = '0000-00-00' OR publish_down >= '2020-03-30')) OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00') ) AND hot=1 ORDER BY RAND() LIMIT 2
125 SELECT m.* FROM jos_menu AS m WHERE menutype = 'menu_bas' AND published = 1 AND parent = 0 ORDER BY ordering
126 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_joomap&Itemid=37&lang=fr'