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 < '1268315005' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1268315005' )
 AND guest = 1
 AND userid = 0
 )
4
SELECT *
 FROM jos_session
 WHERE session_id = 'e676786606df45053e2065c16153ae75'
5
SELECT session_id
 FROM jos_session
 WHERE session_id = '02310a16d0f6a01d121f611f1a50d860'
6
INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '02310a16d0f6a01d121f611f1a50d860','1268315905','','0','1' )
7
SELECT *
 FROM jos_menu
 WHERE published = 1 AND
 link LIKE 'index.php?option=com_estateagent&task=0%'
8
SELECT * FROM jos_estateagent_categories  WHERE parent=0 AND access<=0 AND ( ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-11') AND publish_down >= '2010-03-11') OR ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-11' ) AND (publish_down = '0000-00-00' OR publish_down >= '2010-03-11')) OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00') ) AND publish=1 ORDER BY ordering ASC
9
SELECT count(*) FROM jos_estateagent WHERE cat = 5 AND ( ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-11') AND publish_down >= '2010-03-11') OR ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-11' ) AND (publish_down = '0000-00-00' OR publish_down >= '2010-03-11')) OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00') ) AND access <= 0 AND verified=1 AND publish=1
10
SELECT count(*) FROM jos_estateagent WHERE cat = 3 AND ( ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-11') AND publish_down >= '2010-03-11') OR ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-11' ) AND (publish_down = '0000-00-00' OR publish_down >= '2010-03-11')) OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00') ) AND access <= 0 AND verified=1 AND publish=1
11
SELECT count(*) FROM jos_estateagent WHERE cat = 2 AND ( ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-11') AND publish_down >= '2010-03-11') OR ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-11' ) AND (publish_down = '0000-00-00' OR publish_down >= '2010-03-11')) OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00') ) AND access <= 0 AND verified=1 AND publish=1
12
SELECT count(*) FROM jos_estateagent WHERE cat = 1 AND ( ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-11') AND publish_down >= '2010-03-11') OR ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-11' ) AND (publish_down = '0000-00-00' OR publish_down >= '2010-03-11')) OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00') ) AND access <= 0 AND verified=1 AND publish=1
13
SELECT count(*) FROM jos_estateagent WHERE cat = 4 AND ( ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-11') AND publish_down >= '2010-03-11') OR ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-11' ) AND (publish_down = '0000-00-00' OR publish_down >= '2010-03-11')) OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00') ) AND access <= 0 AND verified=1 AND publish=1
14
SELECT *
 FROM jos_estateagent_categories
 WHERE id = '5'
15
SELECT * FROM jos_estateagent_categories WHERE (
 ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-11') AND publish_down >= '2010-03-11')
 OR ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-11' ) AND (publish_down = '0000-00-00' OR publish_down >= '2010-03-11'))
 OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00')
 ) AND parent = 5 AND access <= 1000 AND publish='1' ORDER BY ordering
16
SELECT *
 FROM jos_estateagent_categories
 WHERE id = '3'
17
SELECT * FROM jos_estateagent_categories WHERE (
 ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-11') AND publish_down >= '2010-03-11')
 OR ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-11' ) AND (publish_down = '0000-00-00' OR publish_down >= '2010-03-11'))
 OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00')
 ) AND parent = 3 AND access <= 1000 AND publish='1' ORDER BY ordering
18
SELECT *
 FROM jos_estateagent_categories
 WHERE id = '2'
19
SELECT * FROM jos_estateagent_categories WHERE (
 ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-11') AND publish_down >= '2010-03-11')
 OR ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-11' ) AND (publish_down = '0000-00-00' OR publish_down >= '2010-03-11'))
 OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00')
 ) AND parent = 2 AND access <= 1000 AND publish='1' ORDER BY ordering
20
SELECT *
 FROM jos_estateagent_categories
 WHERE id = '1'
21
SELECT * FROM jos_estateagent_categories WHERE (
 ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-11') AND publish_down >= '2010-03-11')
 OR ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-11' ) AND (publish_down = '0000-00-00' OR publish_down >= '2010-03-11'))
 OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00')
 ) AND parent = 1 AND access <= 1000 AND publish='1' ORDER BY ordering
22
SELECT *
 FROM jos_estateagent_categories
 WHERE id = '4'
23
SELECT * FROM jos_estateagent_categories WHERE (
 ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-11') AND publish_down >= '2010-03-11')
 OR ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-11' ) AND (publish_down = '0000-00-00' OR publish_down >= '2010-03-11'))
 OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00')
 ) AND parent = 4 AND access <= 1000 AND publish='1' ORDER BY ordering
24
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'
25
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
26
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
27
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
28
SELECT id, cat, title, publish, publish_up, publish_down
					FROM jos_estateagent 
					WHERE 
 (
 ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-11') AND publish_down >= '2010-03-11')
 OR ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-11' ) AND (publish_down = '0000-00-00' OR publish_down >= '2010-03-11'))
 OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00')
 ) AND publish=1 ORDER BY id DESC LIMIT 5
29
SELECT id, path, fname, type, ordering, publish
		FROM jos_estateagent_images
		WHERE objid='72' AND ordering=1
30
SELECT id, path, fname, type, ordering, publish
		FROM jos_estateagent_images
		WHERE objid='71' AND ordering=1
31
SELECT id, path, fname, type, ordering, publish
		FROM jos_estateagent_images
		WHERE objid='70' AND ordering=1
32
SELECT id, path, fname, type, ordering, publish
		FROM jos_estateagent_images
		WHERE objid='69' AND ordering=1
33
SELECT id, path, fname, type, ordering, publish
		FROM jos_estateagent_images
		WHERE objid='68' AND ordering=1
34
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
35
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_item_link'
 AND published = 1
36
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=12'
37
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=20'
38
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=21'
39
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=26'
40
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'Other Services'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
41
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=15'
42
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=14'
43
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=13'
44
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_typed'
 AND published = 1
45
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=25'
46
SELECT id, name, link, parent, type, menutype, access
 FROM jos_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering