Bulgarian Property Services Contact Us Bulgarian Property For Sale   Properties For Sale Our Services Property Services Property Management Property For Sale Rivendell Personnel Buying & Renovating Ski Properties Ski Borovets Contact Us Roperty for Rent Other Services Welcome Services Rental Services Cleaning Services Useful Links Affiliate Links Property-Database   Home   Rural Areas-Veliko Tarnavo | Search Sort By Rent Price Town District Ascending Descending 5 10 15 20 25 30 50 Our Current Offers     Veliko Tarnovo 3 Bed cottage   ... [More] 23 € / gradishte / gradishte   Veliko Tarnovo - Agatovo 4 bedroom property   ... [More] 20.000 € / Agatovo / sevlievo   Veliko Tarnovo - Gredishte   ... [More] 25.000 € / Gredishte village / Sevlievo   Veliko Tarnovo - Gredishte   ... [More] 25.000 € / Gredishte village / Sevlievo   Veliko Tarnovo - Gredishte church cottage   ... [More] 25.000 € / Gredishte village / Sevlievo   Veliko Tarnovo - Malak Varshets large property   ... [More] 35.000 € / Malak Varshets / Sevlievo   Renaissance style house in Kotel   ... [More] 40.000 € / Kotel / Sliven Buying and Renovation

1
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
2
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 99999999 )
 ORDER BY menuid DESC
LIMIT 1
3
DELETE FROM jos_session
 WHERE (
 ( time < '1268991870' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1268991870' )
 AND guest = 1
 AND userid = 0
 )
4
SELECT *
 FROM jos_session
 WHERE session_id = '7f91a036706446d5b932b77fb07e113a'
5
SELECT session_id
 FROM jos_session
 WHERE session_id = '3006e0a1df4e35ea94e8b9159804a18d'
6
INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '3006e0a1df4e35ea94e8b9159804a18d','1268992770','','0','1' )
7
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 0
8
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 0
9
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 1
10
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 1
11
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 2
12
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 2
13
SELECT *
 FROM jos_menu
 WHERE published = 1 AND
 link LIKE 'index.php?option=com_estateagent&task=showCE%'
14
SELECT *
 FROM jos_estateagent_categories
 WHERE id = '3'
15
SELECT * FROM jos_estateagent_categories WHERE (
 ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-19') AND publish_down >= '2010-03-19')
 OR ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-19' ) AND (publish_down = '0000-00-00' OR publish_down >= '2010-03-19'))
 OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00')
 ) AND parent = 3 AND access <= 0 AND publish='1' ORDER BY ordering
16
SELECT count(id) FROM jos_estateagent WHERE cat=3 AND ( ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-19') AND publish_down >= '2010-03-19') OR ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-19' ) AND (publish_down = '0000-00-00' OR publish_down >= '2010-03-19')) OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00') ) AND access<=0 AND verified=1 AND publish=1
17
SELECT id, obj_id, type, title, description, rent, price, country, state, town, district, hot FROM jos_estateagent WHERE cat=3 AND ( ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-19') AND publish_down >= '2010-03-19') OR ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-19' ) AND (publish_down = '0000-00-00' OR publish_down >= '2010-03-19')) 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
18
SELECT title,fname,type,path FROM jos_estateagent_images WHERE objid = 3 AND (type = '.jpg' OR type = '.gif' OR type = '.png') AND ordering = 1 AND publish = 1
19
SELECT title,fname,type,path FROM jos_estateagent_images WHERE objid = 10 AND (type = '.jpg' OR type = '.gif' OR type = '.png') AND ordering = 1 AND publish = 1
20
SELECT title,fname,type,path FROM jos_estateagent_images WHERE objid = 20 AND (type = '.jpg' OR type = '.gif' OR type = '.png') AND ordering = 1 AND publish = 1
21
SELECT title,fname,type,path FROM jos_estateagent_images WHERE objid = 21 AND (type = '.jpg' OR type = '.gif' OR type = '.png') AND ordering = 1 AND publish = 1
22
SELECT title,fname,type,path FROM jos_estateagent_images WHERE objid = 22 AND (type = '.jpg' OR type = '.gif' OR type = '.png') AND ordering = 1 AND publish = 1
23
SELECT title,fname,type,path FROM jos_estateagent_images WHERE objid = 23 AND (type = '.jpg' OR type = '.gif' OR type = '.png') AND ordering = 1 AND publish = 1
24
SELECT title,fname,type,path FROM jos_estateagent_images WHERE objid = 58 AND (type = '.jpg' OR type = '.gif' OR type = '.png') AND ordering = 1 AND publish = 1
25
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'
26
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
27
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
28
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
29
SELECT id, cat, title, publish, publish_up, publish_down
					FROM jos_estateagent 
					WHERE 
 (
 ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-19') AND publish_down >= '2010-03-19')
 OR ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-19' ) AND (publish_down = '0000-00-00' OR publish_down >= '2010-03-19'))
 OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00')
 ) AND publish=1 ORDER BY id DESC LIMIT 5
30
SELECT id, path, fname, type, ordering, publish
		FROM jos_estateagent_images
		WHERE objid='72' AND ordering=1
31
SELECT id, path, fname, type, ordering, publish
		FROM jos_estateagent_images
		WHERE objid='71' AND ordering=1
32
SELECT id, path, fname, type, ordering, publish
		FROM jos_estateagent_images
		WHERE objid='70' AND ordering=1
33
SELECT id, path, fname, type, ordering, publish
		FROM jos_estateagent_images
		WHERE objid='69' AND ordering=1
34
SELECT id, path, fname, type, ordering, publish
		FROM jos_estateagent_images
		WHERE objid='68' AND ordering=1
35
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, 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=12'
38
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=20'
39
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=21'
40
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=26'
41
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'Other Services'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
42
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=15'
43
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=14'
44
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=13'
45
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_typed'
 AND published = 1
46
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=25'
47
SELECT id, name, link, parent, type, menutype, access
 FROM jos_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering