MONDIAL AUTOMOBILES véhicules d'occasion Depuis 1997 03 82 34 28 79 26 route de Verdun 57180 TERVILLE

Accueil Services Nos Occasions Contactez Nous Nouveautés

Plan d'accés Contactez Nous

Votre nouvelle voiture est forcément là ! Depuis 1997 à Terville, MONDIAL AUTOMOBILES vous apporte ses services et trouve la voiture d'occasion que vous recherchez BOSCH CAR SERVICE Du lundi au samedi De 8h30 à 12h et de 14h à 19h (samedi 18h) LES PROMOTIONS : VOIR NOUVEAUX TARIFS SUR LES VEHICULES CONSULTEZ-NOUS NOUVELLES PLAQUES D'IMMATRICULATION Garage agréé SIV Lire la suite...

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 ((`menutype`='mainmenu') AND (`published` > 0) AND (`access` <= '0')) ORDER BY parent, ordering
4
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 1 )
 ORDER BY menuid DESC
LIMIT 1
5
DELETE FROM jos_session
 WHERE (
 ( time < '1566073193' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1566073193' )
 AND guest = 1
 AND userid = 0
 )
6
SELECT *
 FROM jos_menu
 WHERE id = 1
7
SELECT COUNT(a.id)
 FROM jos_content AS a
 INNER JOIN jos_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN jos_categories AS cc ON cc.id = a.catid
 INNER JOIN jos_sections AS s ON s.id = a.sectionid
 LEFT JOIN jos_users AS u ON u.id = a.created_by
 LEFT JOIN jos_groups AS g ON a.access = g.id
 WHERE a.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-08-17 20:34' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-08-17 20:34' )
 AND s.published = 1
 AND cc.published = 1
8
SELECT a.id, a.title, a.title_alias, a.introtext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,
 a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access, a.hits,
 CHAR_LENGTH( a.fulltext ) AS readmore, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
, s.id AS sec_id, cc.id as cat_id
 FROM jos_content AS a
 INNER JOIN jos_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN jos_categories AS cc ON cc.id = a.catid
 INNER JOIN jos_sections AS s ON s.id = a.sectionid
 LEFT JOIN jos_users AS u ON u.id = a.created_by
 LEFT JOIN jos_groups AS g ON a.access = g.id
 WHERE a.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-08-17 20:34' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-08-17 20:34' )
 AND s.published = 1
 AND cc.published = 1
 ORDER BY  f.ordering
LIMIT 4
9
SELECT `id`,`link` FROM jos_menu where ((`menutype`='mainmenu') AND (`published` > 0) AND (`access` <= '0')) ORDER BY parent, ordering
10
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
11
SELECT params
 FROM jos_mambots
 WHERE element = 'mosimage'
 AND folder = 'content'
12
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'
13
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
14
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 ORDER BY parent, ordering
15
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_autostand&Itemid=33&lang=fr'
16
SELECT id, cat, verified, price, title, publish, publish_up, publish_down
					FROM jos_autostand 
					WHERE 
 (
 ((publish_up >= '0000-00-00' AND publish_up <= '2019-08-17') AND publish_down >= '2019-08-17')
 OR ((publish_up >= '0000-00-00' AND publish_up <= '2019-08-17' ) AND (publish_down = '0000-00-00' OR publish_down >= '2019-08-17'))
 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
17
SELECT id, cat, title, publish, publish_up, publish_down
				FROM jos_autostand 
				WHERE 
 (
 ((publish_up >= '0000-00-00' AND publish_up <= '2019-08-17') AND publish_down >= '2019-08-17')
 OR ((publish_up >= '0000-00-00' AND publish_up <= '2019-08-17' ) AND (publish_down = '0000-00-00' OR publish_down >= '2019-08-17'))
 OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00')
 ) AND publish=1 AND verified=1 ORDER BY id DESC LIMIT 4
18
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'menucontextaccueil'
 AND published = 1
 AND parent = 0
 ORDER BY ordering
19
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_item_link'
 AND published = 1
20
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=13'
21
SELECT a.id, a.introtext, a.fulltext , a.images, a.attribs, a.title, a.state
 FROM jos_content AS a
 INNER JOIN jos_categories AS cc ON cc.id = a.catid
 INNER JOIN jos_sections AS s ON s.id = a.sectionid
 WHERE a.state = 1
 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-08-17 20:34' ) 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-08-17 20:34' )
 AND a.catid = 3
 AND cc.published = 1
 AND s.published = 1
 ORDER BY a.ordering
22
SELECT * FROM jos_autostand_categories WHERE parent=0 ORDER BY ordering ASC
23
SELECT count(*) FROM jos_autostand  WHERE cat = 8 AND publish=1 AND verified=1
24
SELECT * FROM jos_autostand_categories WHERE parent = 8
25
SELECT count(*) FROM jos_autostand  WHERE cat = 17 AND publish=1 AND verified=1
26
SELECT * FROM jos_autostand_categories WHERE parent = 17
27
SELECT count(*) FROM jos_autostand  WHERE cat = 4 AND publish=1 AND verified=1
28
SELECT * FROM jos_autostand_categories WHERE parent = 4
29
SELECT count(*) FROM jos_autostand  WHERE cat = 21 AND publish=1 AND verified=1
30
SELECT * FROM jos_autostand_categories WHERE parent = 21
31
SELECT count(*) FROM jos_autostand  WHERE cat = 14 AND publish=1 AND verified=1
32
SELECT * FROM jos_autostand_categories WHERE parent = 14
33
SELECT count(*) FROM jos_autostand  WHERE cat = 13 AND publish=1 AND verified=1
34
SELECT * FROM jos_autostand_categories WHERE parent = 13
35
SELECT count(*) FROM jos_autostand  WHERE cat = 7 AND publish=1 AND verified=1
36
SELECT * FROM jos_autostand_categories WHERE parent = 7
37
SELECT count(*) FROM jos_autostand  WHERE cat = 15 AND publish=1 AND verified=1
38
SELECT * FROM jos_autostand_categories WHERE parent = 15
39
SELECT count(*) FROM jos_autostand  WHERE cat = 11 AND publish=1 AND verified=1
40
SELECT * FROM jos_autostand_categories WHERE parent = 11
41
SELECT count(*) FROM jos_autostand  WHERE cat = 10 AND publish=1 AND verified=1
42
SELECT * FROM jos_autostand_categories WHERE parent = 10
43
SELECT count(*) FROM jos_autostand  WHERE cat = 16 AND publish=1 AND verified=1
44
SELECT * FROM jos_autostand_categories WHERE parent = 16
45
SELECT count(*) FROM jos_autostand  WHERE cat = 6 AND publish=1 AND verified=1
46
SELECT * FROM jos_autostand_categories WHERE parent = 6
47
SELECT count(*) FROM jos_autostand  WHERE cat = 1 AND publish=1 AND verified=1
48
SELECT * FROM jos_autostand_categories WHERE parent = 1
49
SELECT count(*) FROM jos_autostand  WHERE cat = 5 AND publish=1 AND verified=1
50
SELECT * FROM jos_autostand_categories WHERE parent = 5
51
SELECT count(*) FROM jos_autostand  WHERE cat = 3 AND publish=1 AND verified=1
52
SELECT * FROM jos_autostand_categories WHERE parent = 3
53
SELECT count(*) FROM jos_autostand  WHERE cat = 2 AND publish=1 AND verified=1
54
SELECT * FROM jos_autostand_categories WHERE parent = 2
55
SELECT count(*) FROM jos_autostand  WHERE cat = 9 AND publish=1 AND verified=1
56
SELECT * FROM jos_autostand_categories WHERE parent = 9
57
SELECT id, cat, title, publish, publish_up, publish_down, hot
				FROM jos_autostand 
				WHERE 
 (
 ((publish_up >= '0000-00-00' AND publish_up <= '2019-08-17') AND publish_down >= '2019-08-17')
 OR ((publish_up >= '0000-00-00' AND publish_up <= '2019-08-17' ) AND (publish_down = '0000-00-00' OR publish_down >= '2019-08-17'))
 OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00')
 ) AND hot=1 ORDER BY RAND() LIMIT 2
58
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'menu_bas'
 AND published = 1
 AND parent = 0
 ORDER BY ordering
59
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_joomap&Itemid=37&lang=fr'