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 | Search Rental Property (7) Rural Areas-Veliko Tarnavo (7) Beach Resorts-Vlas, Topola (1)   Ski Resorts-Borovets, Bansko, (35)   Land (11)     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 < '1268860496' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1268860496' )
 AND guest = 1
 AND userid = 0
 )
4
SELECT *
 FROM jos_session
 WHERE session_id = '0797182d6384dad587049fd71ea063d7'
5
SELECT session_id
 FROM jos_session
 WHERE session_id = '3144b65816a0fa87f2aa2635baadc7ed'
6
INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '3144b65816a0fa87f2aa2635baadc7ed','1268861396','','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=0%'
14
SELECT * FROM jos_estateagent_categories  WHERE parent=0 AND access<=0 AND ( ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-17') AND publish_down >= '2010-03-17') OR ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-17' ) AND (publish_down = '0000-00-00' OR publish_down >= '2010-03-17')) OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00') ) AND publish=1 ORDER BY ordering ASC
15
SELECT count(*) FROM jos_estateagent WHERE cat = 5 AND ( ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-17') AND publish_down >= '2010-03-17') OR ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-17' ) AND (publish_down = '0000-00-00' OR publish_down >= '2010-03-17')) OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00') ) AND access <= 0 AND verified=1 AND publish=1
16
SELECT count(*) FROM jos_estateagent WHERE cat = 3 AND ( ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-17') AND publish_down >= '2010-03-17') OR ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-17' ) AND (publish_down = '0000-00-00' OR publish_down >= '2010-03-17')) OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00') ) AND access <= 0 AND verified=1 AND publish=1
17
SELECT count(*) FROM jos_estateagent WHERE cat = 2 AND ( ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-17') AND publish_down >= '2010-03-17') OR ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-17' ) AND (publish_down = '0000-00-00' OR publish_down >= '2010-03-17')) OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00') ) AND access <= 0 AND verified=1 AND publish=1
18
SELECT count(*) FROM jos_estateagent WHERE cat = 1 AND ( ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-17') AND publish_down >= '2010-03-17') OR ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-17' ) AND (publish_down = '0000-00-00' OR publish_down >= '2010-03-17')) OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00') ) AND access <= 0 AND verified=1 AND publish=1
19
SELECT count(*) FROM jos_estateagent WHERE cat = 4 AND ( ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-17') AND publish_down >= '2010-03-17') OR ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-17' ) AND (publish_down = '0000-00-00' OR publish_down >= '2010-03-17')) OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00') ) AND access <= 0 AND verified=1 AND publish=1
20
SELECT *
 FROM jos_estateagent_categories
 WHERE id = '5'
21
SELECT * FROM jos_estateagent_categories WHERE (
 ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-17') AND publish_down >= '2010-03-17')
 OR ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-17' ) AND (publish_down = '0000-00-00' OR publish_down >= '2010-03-17'))
 OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00')
 ) AND parent = 5 AND access <= 1000 AND publish='1' ORDER BY ordering
22
SELECT *
 FROM jos_estateagent_categories
 WHERE id = '3'
23
SELECT * FROM jos_estateagent_categories WHERE (
 ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-17') AND publish_down >= '2010-03-17')
 OR ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-17' ) AND (publish_down = '0000-00-00' OR publish_down >= '2010-03-17'))
 OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00')
 ) AND parent = 3 AND access <= 1000 AND publish='1' ORDER BY ordering
24
SELECT *
 FROM jos_estateagent_categories
 WHERE id = '2'
25
SELECT * FROM jos_estateagent_categories WHERE (
 ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-17') AND publish_down >= '2010-03-17')
 OR ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-17' ) AND (publish_down = '0000-00-00' OR publish_down >= '2010-03-17'))
 OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00')
 ) AND parent = 2 AND access <= 1000 AND publish='1' ORDER BY ordering
26
SELECT *
 FROM jos_estateagent_categories
 WHERE id = '1'
27
SELECT * FROM jos_estateagent_categories WHERE (
 ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-17') AND publish_down >= '2010-03-17')
 OR ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-17' ) AND (publish_down = '0000-00-00' OR publish_down >= '2010-03-17'))
 OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00')
 ) AND parent = 1 AND access <= 1000 AND publish='1' ORDER BY ordering
28
SELECT *
 FROM jos_estateagent_categories
 WHERE id = '4'
29
SELECT * FROM jos_estateagent_categories WHERE (
 ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-17') AND publish_down >= '2010-03-17')
 OR ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-17' ) AND (publish_down = '0000-00-00' OR publish_down >= '2010-03-17'))
 OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00')
 ) AND parent = 4 AND access <= 1000 AND publish='1' ORDER BY ordering
30
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'
31
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
32
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
33
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
34
SELECT id, cat, title, publish, publish_up, publish_down
					FROM jos_estateagent 
					WHERE 
 (
 ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-17') AND publish_down >= '2010-03-17')
 OR ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-17' ) AND (publish_down = '0000-00-00' OR publish_down >= '2010-03-17'))
 OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00')
 ) AND publish=1 ORDER BY id DESC LIMIT 5
35
SELECT id, path, fname, type, ordering, publish
		FROM jos_estateagent_images
		WHERE objid='72' AND ordering=1
36
SELECT id, path, fname, type, ordering, publish
		FROM jos_estateagent_images
		WHERE objid='71' AND ordering=1
37
SELECT id, path, fname, type, ordering, publish
		FROM jos_estateagent_images
		WHERE objid='70' AND ordering=1
38
SELECT id, path, fname, type, ordering, publish
		FROM jos_estateagent_images
		WHERE objid='69' AND ordering=1
39
SELECT id, path, fname, type, ordering, publish
		FROM jos_estateagent_images
		WHERE objid='68' AND ordering=1
40
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
41
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_item_link'
 AND published = 1
42
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=12'
43
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=20'
44
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=21'
45
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=26'
46
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'Other Services'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
47
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=15'
48
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=14'
49
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=13'
50
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_typed'
 AND published = 1
51
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=25'
52
SELECT id, name, link, parent, type, menutype, access
 FROM jos_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering