Nouveautés
MINI COUNTRYMAN 1.6 D 112CV BVM6 PACK SALT 1 ERE MAIN
OPEL ANTARA 2.2 CDTI 163 COSMO 4X2 1 ERE MAIN BVM6
FORD KUGA 2.0 TDCI 136 CH 4X4 TITANIUM 1 ERE MAIN
HONDA CR-V 4X4 2.2 CTDI 140 ELEGANCE 1 ERE MAIN BVM6
Autostand
 
Accueil   4X4 | Chercher

Nos Offres
 
  VOLKSWAGEN TIGUAN II 2.0 TDI 150 CARAT 4 MOTION 1 ERE MAIN   
Jolie SUV 4 Roues motrices robuste économique, bien équipés avec entretien à jour.... [En savoir plus]
25.000 € / Volkswagen / TIGUAN II
  BMW X3 2.0 D PACK M SPORT 184CV BVA8 VITESSES 1 ÈRE MAIN  
Jolie 4x4 économique robuste, bien équipé full options sauf toit ouvrant.... [En savoir plus]
25.990 € / BMW / X3
  HONDA CR-V 4X4 2.2 CTDI 140 ELEGANCE 1 ERE MAIN BVM6  
Jolie SUV 4X4 robuste bien entretenu avec faible kilométrage et entretien à jour. Garantie total de 6 mois.... [En savoir plus]
10.990 € / Honda / CR-V
  FORD KUGA 2.0 TDCI 136 CH 4X4 TITANIUM 1 ERE MAIN  
Jolie SUV 4X4  peut kilométré bien équipés avec entretien à jour Model 2010. Garantie totale de 6 mois.... [En savoir plus]
10.990 € / Ford / KUGA

© 2020 Vehicules d'occasion Terville Mondial Automobiles
Defiwebdesign Création de sites web en Lorraine.
109 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=14&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=14&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 < '1606664678' ) AND guest = 0 AND gid > 0 ) OR ( ( time < '1606664678' ) 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 = '14'
11 SELECT * FROM jos_autostand_categories WHERE ( ((publish_up >= '0000-00-00' AND publish_up <= '2020-11-29') AND publish_down >= '2020-11-29') OR ((publish_up >= '0000-00-00' AND publish_up <= '2020-11-29' ) AND (publish_down = '0000-00-00' OR publish_down >= '2020-11-29')) OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00') ) AND parent = 14 AND access <= 0 AND publish='1' ORDER BY ordering
12 SELECT count(id) FROM jos_autostand WHERE cat=14 AND ( ((publish_up >= '0000-00-00' AND publish_up <= '2020-11-29') AND publish_down >= '2020-11-29') OR ((publish_up >= '0000-00-00' AND publish_up <= '2020-11-29' ) AND (publish_down = '0000-00-00' OR publish_down >= '2020-11-29')) 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=14 AND ( ((publish_up >= '0000-00-00' AND publish_up <= '2020-11-29') AND publish_down >= '2020-11-29') OR ((publish_up >= '0000-00-00' AND publish_up <= '2020-11-29' ) AND (publish_down = '0000-00-00' OR publish_down >= '2020-11-29')) 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=14 AND ( ((publish_up >= '0000-00-00' AND publish_up <= '2020-11-29') AND publish_down >= '2020-11-29') OR ((publish_up >= '0000-00-00' AND publish_up <= '2020-11-29' ) AND (publish_down = '0000-00-00' OR publish_down >= '2020-11-29')) 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 = 1219 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=1219&lang=fr&task=showEO'
20 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1219&lang=fr&task=showEO'
21 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1219&lang=fr&task=showEO'
22 SELECT title,fname,type,path FROM jos_autostand_images WHERE objid = 1221 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=1221&lang=fr&task=showEO'
24 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1221&lang=fr&task=showEO'
25 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1221&lang=fr&task=showEO'
26 SELECT title,fname,type,path FROM jos_autostand_images WHERE objid = 1224 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=1224&lang=fr&task=showEO'
28 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1224&lang=fr&task=showEO'
29 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1224&lang=fr&task=showEO'
30 SELECT title,fname,type,path FROM jos_autostand_images WHERE objid = 1225 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=1225&lang=fr&task=showEO'
32 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1225&lang=fr&task=showEO'
33 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1225&lang=fr&task=showEO'
34 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'
35 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
36 SELECT m.* FROM jos_menu AS m WHERE menutype = 'topmenu' AND published = 1 ORDER BY parent, ordering
37 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&Itemid=33&lang=fr'
38 SELECT id, cat, verified, price, title, publish, publish_up, publish_down FROM jos_autostand WHERE ( ((publish_up >= '0000-00-00' AND publish_up <= '2020-11-29') AND publish_down >= '2020-11-29') OR ((publish_up >= '0000-00-00' AND publish_up <= '2020-11-29' ) AND (publish_down = '0000-00-00' OR publish_down >= '2020-11-29')) 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
39 SELECT id, path, fname, type, ordering, publish FROM jos_autostand_images WHERE objid='1183' AND ordering=1
40 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1183&lang=fr&task=showEO'
41 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1183&lang=fr&task=showEO'
42 SELECT id, path, fname, type, ordering, publish FROM jos_autostand_images WHERE objid='1203' AND ordering=1
43 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1203&lang=fr&task=showEO'
44 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1203&lang=fr&task=showEO'
45 SELECT id, cat, title, publish, publish_up, publish_down FROM jos_autostand WHERE ( ((publish_up >= '0000-00-00' AND publish_up <= '2020-11-29') AND publish_down >= '2020-11-29') OR ((publish_up >= '0000-00-00' AND publish_up <= '2020-11-29' ) AND (publish_down = '0000-00-00' OR publish_down >= '2020-11-29')) OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00') ) AND publish=1 AND verified=1 ORDER BY id DESC LIMIT 4
46 SELECT id, path, fname, type, ordering, publish FROM jos_autostand_images WHERE objid='1227' AND ordering=1
47 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1227&lang=fr&task=showEO'
48 SELECT id, path, fname, type, ordering, publish FROM jos_autostand_images WHERE objid='1226' AND ordering=1
49 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1226&lang=fr&task=showEO'
50 SELECT id, path, fname, type, ordering, publish FROM jos_autostand_images WHERE objid='1225' AND ordering=1
51 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1225&lang=fr&task=showEO'
52 SELECT id, path, fname, type, ordering, publish FROM jos_autostand_images WHERE objid='1224' AND ordering=1
53 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=object&id=1224&lang=fr&task=showEO'
54 SELECT * FROM jos_autostand_categories WHERE parent=0 ORDER BY ordering ASC
55 SELECT count(*) FROM jos_autostand WHERE cat = 8 AND publish=1 AND verified=1
56 SELECT * FROM jos_autostand_categories WHERE parent = 8
57 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=cat&id=8&lang=fr&task=showCE'
58 SELECT * FROM jos_autostand_categories WHERE parent=8 ORDER BY ordering ASC
59 SELECT count(*) FROM jos_autostand WHERE cat = 17 AND publish=1 AND verified=1
60 SELECT * FROM jos_autostand_categories WHERE parent = 17
61 SELECT count(*) FROM jos_autostand WHERE cat = 4 AND publish=1 AND verified=1
62 SELECT * FROM jos_autostand_categories WHERE parent = 4
63 SELECT count(*) FROM jos_autostand WHERE cat = 21 AND publish=1 AND verified=1
64 SELECT * FROM jos_autostand_categories WHERE parent = 21
65 SELECT count(*) FROM jos_autostand WHERE cat = 14 AND publish=1 AND verified=1
66 SELECT * FROM jos_autostand_categories WHERE parent = 14
67 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=cat&id=14&lang=fr&task=showCE'
68 SELECT * FROM jos_autostand_categories WHERE parent=14 ORDER BY ordering ASC
69 SELECT count(*) FROM jos_autostand WHERE cat = 13 AND publish=1 AND verified=1
70 SELECT * FROM jos_autostand_categories WHERE parent = 13
71 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=cat&id=13&lang=fr&task=showCE'
72 SELECT * FROM jos_autostand_categories WHERE parent=13 ORDER BY ordering ASC
73 SELECT count(*) FROM jos_autostand WHERE cat = 7 AND publish=1 AND verified=1
74 SELECT * FROM jos_autostand_categories WHERE parent = 7
75 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=cat&id=7&lang=fr&task=showCE'
76 SELECT * FROM jos_autostand_categories WHERE parent=7 ORDER BY ordering ASC
77 SELECT count(*) FROM jos_autostand WHERE cat = 15 AND publish=1 AND verified=1
78 SELECT * FROM jos_autostand_categories WHERE parent = 15
79 SELECT count(*) FROM jos_autostand WHERE cat = 11 AND publish=1 AND verified=1
80 SELECT * FROM jos_autostand_categories WHERE parent = 11
81 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=cat&id=11&lang=fr&task=showCE'
82 SELECT * FROM jos_autostand_categories WHERE parent=11 ORDER BY ordering ASC
83 SELECT count(*) FROM jos_autostand WHERE cat = 10 AND publish=1 AND verified=1
84 SELECT * FROM jos_autostand_categories WHERE parent = 10
85 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=cat&id=10&lang=fr&task=showCE'
86 SELECT * FROM jos_autostand_categories WHERE parent=10 ORDER BY ordering ASC
87 SELECT count(*) FROM jos_autostand WHERE cat = 16 AND publish=1 AND verified=1
88 SELECT * FROM jos_autostand_categories WHERE parent = 16
89 SELECT count(*) FROM jos_autostand WHERE cat = 6 AND publish=1 AND verified=1
90 SELECT * FROM jos_autostand_categories WHERE parent = 6
91 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=cat&id=6&lang=fr&task=showCE'
92 SELECT * FROM jos_autostand_categories WHERE parent=6 ORDER BY ordering ASC
93 SELECT count(*) FROM jos_autostand WHERE cat = 1 AND publish=1 AND verified=1
94 SELECT * FROM jos_autostand_categories WHERE parent = 1
95 SELECT count(*) FROM jos_autostand WHERE cat = 5 AND publish=1 AND verified=1
96 SELECT * FROM jos_autostand_categories WHERE parent = 5
97 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=cat&id=5&lang=fr&task=showCE'
98 SELECT * FROM jos_autostand_categories WHERE parent=5 ORDER BY ordering ASC
99 SELECT count(*) FROM jos_autostand WHERE cat = 3 AND publish=1 AND verified=1
100 SELECT * FROM jos_autostand_categories WHERE parent = 3
101 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&act=cat&id=3&lang=fr&task=showCE'
102 SELECT * FROM jos_autostand_categories WHERE parent=3 ORDER BY ordering ASC
103 SELECT count(*) FROM jos_autostand WHERE cat = 2 AND publish=1 AND verified=1
104 SELECT * FROM jos_autostand_categories WHERE parent = 2
105 SELECT count(*) FROM jos_autostand WHERE cat = 9 AND publish=1 AND verified=1
106 SELECT * FROM jos_autostand_categories WHERE parent = 9
107 SELECT id, cat, title, publish, publish_up, publish_down, hot FROM jos_autostand WHERE ( ((publish_up >= '0000-00-00' AND publish_up <= '2020-11-29') AND publish_down >= '2020-11-29') OR ((publish_up >= '0000-00-00' AND publish_up <= '2020-11-29' ) AND (publish_down = '0000-00-00' OR publish_down >= '2020-11-29')) OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00') ) AND hot=1 ORDER BY RAND() LIMIT 2
108 SELECT m.* FROM jos_menu AS m WHERE menutype = 'menu_bas' AND published = 1 AND parent = 0 ORDER BY ordering
109 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_joomap&Itemid=37&lang=fr'