as-mesitiki.gr

Πάνω

Κιλκής & Αγ.Σοφίας Ref. 63 (Ενοικιάσεις) Γκαρσονιέρα δίχωρη 30 τ.μ. 5 ορόφου Σε άριστη κατάσταση κεντρική θέρμανση Αμοιβή: 250.00 EUR -

Κιλκής & Αγ.Σοφίας Ref. 62 (Πωλήσεις) Γκαρσονιέρα δίχωρη 30 τ.μ. 5 ορόφου Σε άριστη κατάσταση κεντρική θέρμανση... Αμοιβή: 30,000.00 EUR -

Αντίρριo Ref. 61 (Πωλήσεις) Χαρακτηριστικά Ακινήτου Επιπλέον Χαρακτηριστικά Πρόσοψης, Γωνιακό ... Αμοιβή: 10,000,000.00 EUR -

Εργατικές κατοικίες της Εγλυκάδος Ref. 60 (Ενοικιάσεις) Διαμέρισμα 80 τ.μ. διαμπερές και προσόψεως 1ου ορόφου . Στις εργατικές κατοικίες της Εγλυκάδο... Αμοιβή: 300.00 EUR -

Εργατικές κατοικίες της Εγλυκάδος Ref. 59 (Πωλήσεις) Διαμέρισμα 80 τ.μ. διαμπερές και προσόψεως 1ου ορόφου . Στις εργατικές κατοικίες της Ε... Αμοιβή: 75,000.00 EUR -

Copyright © 2008-2012

1
SELECT * FROM elx_core_acl_access_lists

2
SELECT id, link FROM elx_menu WHERE menutype='mainmenu' AND published='1'
 AND ((language IS NULL) OR (language LIKE '%greek%')) ORDER BY parent, ordering

3
SELECT template, params FROM elx_templates_menu WHERE client_id='0' AND menuid='8'

4
SELECT template, params FROM elx_templates_menu WHERE client_id='0' AND menuid='0'

5
DELETE FROM elx_session WHERE (time < 1337586024)

6
SELECT * FROM elx_session WHERE session_id='564527bab6f193ee22eaa644bc6638e2'

7
SELECT session_id FROM elx_session WHERE session_id='dbe7e61bcc6c32370fdd2279cf4f8d11'

8
INSERT INTO elx_session ( `session_id`,`time`,`username`,`gid`,`allowed`,`guest`,`ip` ) VALUES ( 'f319e1db56cdfdb0cf361a09b481a8cb','1337595024',NULL,'29','29','1','38.107.179.207' )

9
SELECT folder, element, published, CONCAT(folder,'/',element) AS lookup
 FROM elx_mambots
 WHERE published > 0 AND access IN (29) AND folder='editors' ORDER BY ordering

10
SELECT folder, element, published, CONCAT(folder,'/',element) AS lookup
 FROM elx_mambots
 WHERE published > 0 AND access IN (29) AND folder='editors-xtd' ORDER BY ordering

11
SELECT access FROM elx_menu WHERE id='8'

12
SELECT name FROM elx_core_acl_aro_groups WHERE group_id='29'

13
SELECT * FROM elx_menu WHERE id='8'

14
SELECT a.*, ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count, u.name AS author, u.usertype,
 cc.name AS category, cc.seotitle AS catseotitle, s.name AS section, s.seotitle AS secseotitle, g.name AS groups
 FROM elx_content a
 INNER JOIN elx_content_frontpage f ON f.content_id = a.id
 INNER JOIN elx_categories cc ON cc.id = a.catid
 INNER JOIN elx_sections s ON s.id = a.sectionid
 LEFT JOIN elx_users u ON u.id = a.created_by
 LEFT JOIN elx_content_rating v ON a.id = v.content_id
 LEFT JOIN elx_core_acl_aro_groups g ON a.access = g.group_id
 WHERE a.state = '1'
 AND s.published = '1'
 AND cc.published = '1'
 AND ((a.language IS NULL) OR (a.language LIKE '%greek%'))
 AND ((cc.language IS NULL) OR (cc.language LIKE '%greek%'))
 AND ((s.language IS NULL) OR (s.language LIKE '%greek%'))
 AND a.access IN (29)
 AND ( publish_up = '1979-12-19 00:00:00' OR publish_up <= '2012-05-21 13:10:24' )
 AND ( publish_down = '2060-01-01 00:00:00' OR publish_down >= '2012-05-21 13:10:24' )
 ORDER BY f.ordering

15
SELECT COUNT( m.id ) FROM elx_content i
 LEFT JOIN elx_sections s ON i.sectionid=s.id
 LEFT JOIN elx_menu m ON m.componentid=s.id 
 WHERE m.type='content_blog_section' AND m.published='1'

16
SELECT COUNT( m.id ) FROM elx_content i
 LEFT JOIN elx_categories c ON i.catid=c.id
 LEFT JOIN elx_menu m ON m.componentid=c.id 
 WHERE m.type='content_blog_category' AND m.published='1'

17
SELECT COUNT( id ) FROM elx_menu WHERE type='content_blog_section' AND published='1' AND componentid=0

18
SELECT folder, element, published, CONCAT(folder,'/',element) AS lookup
 FROM elx_mambots
 WHERE published > 0 AND access IN (29) AND folder='content' ORDER BY ordering

19
SELECT m.id FROM elx_menu m
 LEFT JOIN elx_categories c ON m.componentid=c.id
 WHERE m.type='content_category' AND m.published='1' AND c.id='25'

20
SELECT m.id FROM elx_menu m
 LEFT JOIN elx_sections s ON m.componentid=s.id
 WHERE m.type='content_section' AND m.published='1' AND s.id='25'

21
SELECT id FROM elx_menu
 WHERE type='content_blog_category' AND published='1' AND componentid='0'

22
SELECT id FROM elx_components WHERE name = 'Syndicate'

23
SELECT * FROM elx_components WHERE id='17'

24
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, m.language
 FROM elx_modules m, elx_modules_menu mm
 WHERE m.published='1' AND m.access IN (29) AND m.client_id='0'
 AND ((m.language IS NULL) OR (m.language LIKE '%greek%'))
 AND mm.moduleid=m.id
 AND ((mm.menuid = '0') OR (mm.menuid = '8'))
 ORDER BY m.ordering

25
SELECT * FROM elx_menu
 WHERE menutype='topmenu' AND published='1' AND parent='0'
 AND access IN (29)
 AND ((language IS NULL) OR (language LIKE '%greek%'))
 ORDER BY ordering

26
SELECT id, title, module, position, content, showtitle, params, language FROM elx_modules
 WHERE module='mod_search' AND published='1' AND access IN (29) AND client_id='0'
 AND ((language IS NULL) OR (language LIKE '%greek%'))

27
SELECT COUNT(*) FROM elx_banner WHERE showbanner = '1'

28
SELECT * FROM elx_banner WHERE showbanner = '1'
 ORDER BY rand()

29
UPDATE elx_banner SET impmade = impmade + 1 WHERE bid = '9'

30
UPDATE elx_banner SET impmade = impmade + 1 WHERE bid = '10'

31
SELECT sdvalue FROM elx_softdisk WHERE sdname='eibmultitransition_rotator_itemsgreek'

32
UPDATE elx_softdisk SET sdvalue='Δείτε περισσότεραAS ΜεσιτικήΕνοικιάσειςhttp://www.as-mesitiki.gr/component/option,com_marketplace/page,show_category/catid,3/Itemid,30/_selfΔιαμερίσματα-Γκαρσονιέρες-Μεζονέτες-Καταστήματαenoikiazetai_house.jpgAS ΜεσιτικήΠωλήσειςhttp://www.as-mesitiki.gr/component/option,com_marketplace/page,show_category/catid,2/Itemid,30/_selfΌλων των ειδών τα ακίνηταdreamhouse.jpgAS ΜεσιτικήΕκτιμήσειςhttp://www.as-mesitiki.gr_selfΕκτιμήσεις όλων των ακινήτων από εξειδικευμένο προσωπικόdiakosmisi_house.jpg_selfAS ΜεσιτικήΔάνειαhttp://www.as-mesitiki.gr/yperesies/daneia/trapezika-stegastika-daneia.html_selfΔιεκπεραίωση του στεγαστικού σας δανείουloan_house.jpeg', lastmodified = '1337595024' WHERE sdname='eibmultitransition_rotator_itemsgreek'

33
SELECT sdvalue FROM elx_softdisk WHERE sdname='eibmultitransition_rotator_itemsgreek'

34
SELECT * FROM elx_menu
 WHERE menutype='mainmenu' AND published='1'
 AND access IN (29)
 AND ((language IS NULL) OR (language LIKE '%greek%'))
 ORDER BY parent,ordering

35
SELECT * FROM elx_menu
 WHERE menutype='Εργαλεία' AND published='1' AND parent='0'
 AND access IN (29)
 AND ((language IS NULL) OR (language LIKE '%greek%'))
 ORDER BY ordering

36
SELECT id FROM elx_menu WHERE type='content_typed'
 AND published='1' AND link='index.php?option=com_content&task=view&id=26'

37
SELECT id FROM elx_menu WHERE type='content_item_link'
 AND published='1' AND link='index.php?option=com_content&task=view&id=26'

38
SELECT id FROM elx_menu WHERE type='content_typed'
 AND published='1' AND link='index.php?option=com_content&task=view&id=27'

39
SELECT id FROM elx_menu WHERE type='content_item_link'
 AND published='1' AND link='index.php?option=com_content&task=view&id=27'

40
SELECT id FROM elx_menu WHERE link='index.php?option=com_registration&task=lostPassword'
 AND published='1' AND ((language IS NULL) OR (language LIKE '%greek%'))

41
SELECT id FROM elx_menu WHERE link='index.php?option=com_registration&task=register'
 AND published='1' AND ((language IS NULL) OR (language LIKE '%greek%'))

42
SELECT a.id, a.title, a.seotitle, a.sectionid, a.catid, cc.seotitle AS seocat, s.seotitle AS seosec
 FROM elx_content a
 LEFT JOIN elx_content_frontpage f ON f.content_id = a.id
 INNER JOIN elx_categories cc ON cc.id = a.catid
 INNER JOIN elx_sections s ON s.id = a.sectionid
 WHERE a.state = '1' AND a.sectionid > '0'
 AND ( a.publish_up = '1979-12-19 00:00:00' OR a.publish_up <= '2012-05-21 13:10:24' )
 AND ( a.publish_down = '2060-01-01 00:00:00' OR a.publish_down >= '2012-05-21 13:10:24' )
 AND ((a.language IS NULL) OR (a.language LIKE '%greek%'))
 AND ((cc.language IS NULL) OR (cc.language LIKE '%greek%'))
 AND ((s.language IS NULL) OR (s.language LIKE '%greek%'))
 AND a.access IN (29)
 AND cc.access IN (29)
 AND s.access IN (29)
 AND f.content_id IS NULL
 AND cc.published = '1'
 AND s.published = '1'
 ORDER BY a.hits DESC

43
SELECT COUNT( m.id ) FROM elx_content i
 LEFT JOIN elx_sections s ON i.sectionid=s.id
 LEFT JOIN elx_menu m ON m.componentid=s.id 
 WHERE m.type='content_blog_section' AND m.published='1'

44
SELECT COUNT( m.id ) FROM elx_content i
 LEFT JOIN elx_categories c ON i.catid=c.id
 LEFT JOIN elx_menu m ON m.componentid=c.id 
 WHERE m.type='content_blog_category' AND m.published='1'

45
SELECT COUNT( id ) FROM elx_menu WHERE type='content_blog_section' AND published='1' AND componentid=0

46
SELECT m.id FROM elx_menu m
 LEFT JOIN elx_categories c ON m.componentid=c.id
 WHERE m.type='content_category' AND m.published='1' AND c.id='27'

47
SELECT m.id FROM elx_menu m
 LEFT JOIN elx_sections s ON m.componentid=s.id
 WHERE m.type='content_section' AND m.published='1' AND s.id='27'

48
SELECT id FROM elx_menu
 WHERE type='content_blog_category' AND published='1' AND componentid='0'

49
SELECT m.id FROM elx_menu m
 LEFT JOIN elx_categories c ON m.componentid=c.id
 WHERE m.type='content_category' AND m.published='1' AND c.id='26'

50
SELECT m.id FROM elx_menu m
 LEFT JOIN elx_sections s ON m.componentid=s.id
 WHERE m.type='content_section' AND m.published='1' AND s.id='26'

51
SELECT id FROM elx_menu
 WHERE type='content_blog_category' AND published='1' AND componentid='0'

52
SELECT m.id FROM elx_menu m
 LEFT JOIN elx_categories c ON m.componentid=c.id
 WHERE m.type='content_category' AND m.published='1' AND c.id='14'

53
SELECT m.id FROM elx_menu m
 LEFT JOIN elx_sections s ON m.componentid=s.id
 WHERE m.type='content_section' AND m.published='1' AND s.id='14'

54
SELECT id FROM elx_menu
 WHERE type='content_blog_category' AND published='1' AND componentid='0'

55
SELECT a.id, a.introtext, a.maintext, a.images, a.attribs, a.title, a.seotitle,
 a.state, cc.seotitle AS catseotitle, s.seotitle AS secseotitle
 FROM elx_content a
 INNER JOIN elx_categories cc ON cc.id = a.catid
 INNER JOIN elx_sections s ON s.id = a.sectionid
 WHERE a.state = '1'
 AND a.access IN (29) AND cc.access IN (29) AND s.access IN (29)
 AND (a.publish_up = '1979-12-19 00:00:00' OR a.publish_up <= '2012-05-21 13:10:24') 
 AND (a.publish_down = '2060-01-01 00:00:00' OR a.publish_down >= '2012-05-21 13:10:24')
 AND ((a.language IS NULL) OR (a.language LIKE '%greek%'))
 AND ((cc.language IS NULL) OR (cc.language LIKE '%greek%'))
 AND ((s.language IS NULL) OR (s.language LIKE '%greek%'))
 AND a.catid='1'
 AND cc.published = '1'
 AND s.published = '1'
 ORDER BY rand()

56
SELECT use_price, use_negotiation, dialect1, dialect2, dialect3, dialect4 FROM elx_marketplace_config LIMIT 1

57
SELECT id FROM elx_menu WHERE link LIKE '%com_marketplace%' AND published='1'

58
SELECT a.id, a.category, a.ad_headline, a.ad_text, a.ad_price, a.ad_currency, a.ad_negotiation, a.ad_type, a.ad_image, a.flag_top, a.flag_featured, a.flag_commercial, date_format( a.date_created, '%d.%m.%Y' ) AS af_date, b.namedialect1, b.namedialect2, b.namedialect3, b.namedialect4 FROM elx_marketplace_ads AS a, elx_marketplace_categories AS b WHERE a.ad_image > 0 AND b.published = '1' AND a.category = b.id AND a.published = '1' ORDER BY a.id DESC LIMIT 5

59
SELECT COUNT(session_id) FROM elx_session WHERE gid='29'

60
SELECT COUNT(DISTINCT username) FROM elx_session WHERE userid<>'0' AND gid <> '29'

61
SELECT DISTINCT username, userid, gid FROM elx_session WHERE userid <> '0'

62
SELECT use_price, use_negotiation, dialect1, dialect2, dialect3, dialect4 FROM elx_marketplace_config LIMIT 1

63
SELECT id FROM elx_menu WHERE link LIKE '%com_marketplace%' AND published='1'

64
SELECT a.id, a.category, a.ad_headline, a.ad_text, a.ad_price, a.ad_currency, a.ad_negotiation, a.ad_type, a.ad_image, a.flag_top, a.flag_featured, a.flag_commercial, date_format( a.date_created, '%d.%m.%Y' ) AS af_date, b.namedialect1, b.namedialect2, b.namedialect3, b.namedialect4 FROM elx_marketplace_ads AS a, elx_marketplace_categories AS b WHERE a.ad_image > 0 AND b.published = '1' AND a.category = b.id AND a.published = '1' ORDER BY a.id DESC LIMIT 5