Home About us Information Products Services Gallery Contact us Back

1
SELECT * FROM elx_core_acl_access_lists

2
SELECT seotitle FROM elx_sections WHERE scope='content' AND ((seotitle != '') OR (seotitle IS NOT NULL))

3
SELECT id FROM elx_sections WHERE seotitle='products' AND scope='content' AND published='1'

4
SELECT id FROM elx_menu WHERE published='1'
 AND link='index.php?option=com_content&task=section&id=23'
 AND ((language IS NULL) OR (language LIKE '%english%'))

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

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

7
DELETE FROM elx_session WHERE (time < 1329908348)

8
SELECT * FROM elx_session WHERE session_id='0646168b48d8477f88a2107757734f9f'

9
SELECT session_id FROM elx_session WHERE session_id='ccf3df11a7369caecad83f8806eb8348'

10
INSERT INTO elx_session ( `session_id`,`time`,`username`,`gid`,`allowed`,`guest`,`ip` ) VALUES ( '9b30189a90ad4789948d4d3bcd545919','1329962348',NULL,'29','29','1','38.107.179.237' )

11
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

12
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

13
SELECT access FROM elx_menu WHERE id='186'

14
SELECT name FROM elx_core_acl_aro_groups WHERE group_id='29'

15
SELECT * FROM elx_menu WHERE id='186'

16
SELECT * FROM elx_sections WHERE id='23'

17
SELECT a.*, COUNT( b.id ) AS numitems FROM elx_categories a
 LEFT JOIN elx_content b ON b.catid = a.id
 AND a.published = '1' AND b.state = '1'
 AND ( b.publish_up = '1979-12-19 00:00:00' OR b.publish_up <= '2012-02-23 05:29:08' )
 AND ( b.publish_down = '2060-01-01 00:00:00' OR b.publish_down >= '2012-02-23 05:29:08' )
 AND ((a.language IS NULL) OR (a.language LIKE '%english%'))
 AND ((b.language IS NULL) OR (b.language LIKE '%english%'))
 AND a.access IN (29) AND b.access IN (29)
 WHERE a.section = '23'
 GROUP BY a.id
 HAVING COUNT( b.id ) > 0
 ORDER BY a.ordering

18
SELECT id FROM elx_components WHERE name = 'Syndicate'

19
SELECT * FROM elx_components WHERE id='17'

20
SELECT id FROM elx_components WHERE name = 'Syndicate'

21
SELECT * FROM elx_components WHERE id='17'

22
SELECT a.*, u.name AS author, u.usertype
 FROM elx_content a
 LEFT JOIN elx_users u ON u.id = a.created_by
 WHERE a.state = '1' AND a.access = '29'
 AND ( a.publish_up = '1979-12-19 00:00:00' OR a.publish_up <= '2012-02-23 05:29:08' )
 AND ( a.publish_down = '2060-01-01 00:00:00' OR a.publish_down >= '2012-02-23 05:29:08' )
 AND ((a.language IS NULL) OR (a.language LIKE '%english%'))
 ORDER BY a.created DESC

23
SELECT b.id, b.title, b.seotitle, b.blogid, b.blogtext, s.seotitle AS seoblog FROM elx_eblog b
 LEFT JOIN elx_eblog_settings s ON s.blogid = b.blogid
 WHERE s.published = '1'
 AND ((b.language IS NULL) OR (b.language LIKE '%english%'))
 ORDER BY b.dateadded DESC

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 '%english%'))
 AND mm.moduleid=m.id
 AND ((mm.menuid = '0') OR (mm.menuid = '186'))
 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 '%english%'))
 ORDER BY ordering

26
SELECT seotitle  FROM  elx_sections
 WHERE id = '21' AND published='1'

27
SELECT seotitle  FROM  elx_sections
 WHERE id = '22' AND published='1'

28
SELECT seotitle  FROM  elx_sections
 WHERE id = '23' AND published='1'

29
SELECT seotitle  FROM  elx_sections
 WHERE id = '24' AND published='1'

30
SELECT d.seotitle AS seoitem, c.seotitle AS seocat FROM elx_contact_details d
 LEFT JOIN elx_categories c ON c.id=d.catid
 WHERE d.id='8' AND d.published='1'
 AND c.published='1'

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

32
SELECT id, language FROM elx_menu WHERE id='186'

33
SELECT seotitle  FROM  elx_sections
 WHERE id = '23' AND published='1'