Main Menu
Home Chapter Leadership Chapter Roster Chapter With A Heart Zumwalt's Blog Courses & Education Chapter Store Chapter Newsletters Chapter Calendar For REALTORS® Home Buyers & Sellers Chapter Member Area National CRS Contact Us Site Help

Event Calendar
May 2013 S M T W T F S 28 29 30 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 1 This month June 2013 S M T W T F S 26 27 28 29 30 31 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 1 2 3 4 5 6 Next month

Mark The Date!
Tue, Jun 18th - CRS 201 Listing Strategies Course with Jackie Leavenworth Mon, Aug 26th - CRS 206 : TECHNOLOGIES TO ADVANCE YOUR BUSINESS

CRS National Sponsors

Home

See Today

See by day See by week See by month See by year See by categories Search

UpComing this month

01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 January February March April May June July August September October November December 2011 2012 2013 2014 2015 2016 2017 2018

OAR Education and Trade Show
by vflexadmin Hits : 765	From Wednesday, October 17 2012 - 8:00am To Thursday, October 18 2012 - 5:00pm Every day
Tulsa Oklahoma Realtors.com

Back

Events v1.1 Copyright © 2003-2004 by Eric Lamette, Dave McDonell

Our Sponsors

Member Login
Username Password Forgotten your password? No account yet? Create one

Chapter With A Heart
.

Chapter Newsletters
Read All About It! Get the latest chapter newsletter, click here.

eLearning Course
CRS Distance Learning

The CRS Store
Visit the CRS Store CRS Quality Tested Products for the Residential Specialist!

Copyright ©2000 - 2013 All logos and trademarks in this site are property of their respective owners. Opinions expressed in articles within this site are those of their owners and may not reflect the opinion of the Oklahoma CRS Chapter.

1
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='0'
2
DELETE FROM mos_session
WHERE (time < 1369135576)
3
SELECT * FROM mos_session WHERE session_id='7f68407902a165c72978fe864dcfcb11'
4
SELECT session_id FROM mos_session WHERE session_id=MD5('fda50f8f64bfbcc771f14a172eee9145')
5
INSERT INTO mos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '48b78687772f455f8dd49e5b99e7958e','1369136476','','0','1' )
6
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_vflexts
WHERE published >= 1 AND access <= 0 AND folder='editors'
ORDER BY ordering
7
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_vflexts
WHERE published >= 1 AND access <= 0 AND folder='editors-xtd'
ORDER BY ordering
8
SELECT access FROM mos_menu WHERE link like 'index.php?option=com_events&task=view_detail%'
9
SELECT id FROM mos_menu WHERE link = 'index.php?option=com_events'
10
SELECT useCatColor FROM mos_events
11
SHOW TABLES
12
SELECT mos_events.* FROM mos_categories AS b, mos_events
            WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND
            mos_events.id = '105' AND mos_events.state = '1'
13
SELECT username, email FROM mos_users WHERE id='1'
14
UPDATE mos_events SET hits=(hits+1) WHERE id='105'
15
SELECT id, title, module, position, content, showtitle, params
FROM mos_modules AS m, mos_modules_menu AS mm
WHERE m.published='1' AND m.access <= '0' AND m.client_id='0'
AND mm.moduleid=m.id
AND (mm.menuid = '0' OR mm.menuid = '0')
ORDER BY ordering
16
SELECT m.* FROM mos_menu AS m
WHERE menutype='mainmenu' AND published='1'
ORDER BY parent,ordering
17
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=232'
18
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=232'
19
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=85'
20
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=85'
21
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=84'
22
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=84'
23
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=126'
24
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=126'
25
SELECT id FROM mos_menu WHERE link = 'index.php?option=com_events'
26
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-05-01 00:00:00' AND publish_up <= '2013-05-01 23:59:59')
	OR (publish_down >= '2013-05-01 00:00:00' AND publish_down <= '2013-05-01 23:59:59')
	OR (publish_up <= '2013-05-01 00:00:00' AND publish_down >= '2013-05-01 23:59:59')) AND state='1'
ORDER BY publish_up ASC
27
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-05-02 00:00:00' AND publish_up <= '2013-05-02 23:59:59')
	OR (publish_down >= '2013-05-02 00:00:00' AND publish_down <= '2013-05-02 23:59:59')
	OR (publish_up <= '2013-05-02 00:00:00' AND publish_down >= '2013-05-02 23:59:59')) AND state='1'
ORDER BY publish_up ASC
28
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-05-03 00:00:00' AND publish_up <= '2013-05-03 23:59:59')
	OR (publish_down >= '2013-05-03 00:00:00' AND publish_down <= '2013-05-03 23:59:59')
	OR (publish_up <= '2013-05-03 00:00:00' AND publish_down >= '2013-05-03 23:59:59')) AND state='1'
ORDER BY publish_up ASC
29
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-05-04 00:00:00' AND publish_up <= '2013-05-04 23:59:59')
	OR (publish_down >= '2013-05-04 00:00:00' AND publish_down <= '2013-05-04 23:59:59')
	OR (publish_up <= '2013-05-04 00:00:00' AND publish_down >= '2013-05-04 23:59:59')) AND state='1'
ORDER BY publish_up ASC
30
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-05-05 00:00:00' AND publish_up <= '2013-05-05 23:59:59')
	OR (publish_down >= '2013-05-05 00:00:00' AND publish_down <= '2013-05-05 23:59:59')
	OR (publish_up <= '2013-05-05 00:00:00' AND publish_down >= '2013-05-05 23:59:59')) AND state='1'
ORDER BY publish_up ASC
31
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-05-06 00:00:00' AND publish_up <= '2013-05-06 23:59:59')
	OR (publish_down >= '2013-05-06 00:00:00' AND publish_down <= '2013-05-06 23:59:59')
	OR (publish_up <= '2013-05-06 00:00:00' AND publish_down >= '2013-05-06 23:59:59')) AND state='1'
ORDER BY publish_up ASC
32
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-05-07 00:00:00' AND publish_up <= '2013-05-07 23:59:59')
	OR (publish_down >= '2013-05-07 00:00:00' AND publish_down <= '2013-05-07 23:59:59')
	OR (publish_up <= '2013-05-07 00:00:00' AND publish_down >= '2013-05-07 23:59:59')) AND state='1'
ORDER BY publish_up ASC
33
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-05-08 00:00:00' AND publish_up <= '2013-05-08 23:59:59')
	OR (publish_down >= '2013-05-08 00:00:00' AND publish_down <= '2013-05-08 23:59:59')
	OR (publish_up <= '2013-05-08 00:00:00' AND publish_down >= '2013-05-08 23:59:59')) AND state='1'
ORDER BY publish_up ASC
34
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-05-09 00:00:00' AND publish_up <= '2013-05-09 23:59:59')
	OR (publish_down >= '2013-05-09 00:00:00' AND publish_down <= '2013-05-09 23:59:59')
	OR (publish_up <= '2013-05-09 00:00:00' AND publish_down >= '2013-05-09 23:59:59')) AND state='1'
ORDER BY publish_up ASC
35
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-05-10 00:00:00' AND publish_up <= '2013-05-10 23:59:59')
	OR (publish_down >= '2013-05-10 00:00:00' AND publish_down <= '2013-05-10 23:59:59')
	OR (publish_up <= '2013-05-10 00:00:00' AND publish_down >= '2013-05-10 23:59:59')) AND state='1'
ORDER BY publish_up ASC
36
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-05-11 00:00:00' AND publish_up <= '2013-05-11 23:59:59')
	OR (publish_down >= '2013-05-11 00:00:00' AND publish_down <= '2013-05-11 23:59:59')
	OR (publish_up <= '2013-05-11 00:00:00' AND publish_down >= '2013-05-11 23:59:59')) AND state='1'
ORDER BY publish_up ASC
37
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-05-12 00:00:00' AND publish_up <= '2013-05-12 23:59:59')
	OR (publish_down >= '2013-05-12 00:00:00' AND publish_down <= '2013-05-12 23:59:59')
	OR (publish_up <= '2013-05-12 00:00:00' AND publish_down >= '2013-05-12 23:59:59')) AND state='1'
ORDER BY publish_up ASC
38
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-05-13 00:00:00' AND publish_up <= '2013-05-13 23:59:59')
	OR (publish_down >= '2013-05-13 00:00:00' AND publish_down <= '2013-05-13 23:59:59')
	OR (publish_up <= '2013-05-13 00:00:00' AND publish_down >= '2013-05-13 23:59:59')) AND state='1'
ORDER BY publish_up ASC
39
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-05-14 00:00:00' AND publish_up <= '2013-05-14 23:59:59')
	OR (publish_down >= '2013-05-14 00:00:00' AND publish_down <= '2013-05-14 23:59:59')
	OR (publish_up <= '2013-05-14 00:00:00' AND publish_down >= '2013-05-14 23:59:59')) AND state='1'
ORDER BY publish_up ASC
40
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-05-15 00:00:00' AND publish_up <= '2013-05-15 23:59:59')
	OR (publish_down >= '2013-05-15 00:00:00' AND publish_down <= '2013-05-15 23:59:59')
	OR (publish_up <= '2013-05-15 00:00:00' AND publish_down >= '2013-05-15 23:59:59')) AND state='1'
ORDER BY publish_up ASC
41
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-05-16 00:00:00' AND publish_up <= '2013-05-16 23:59:59')
	OR (publish_down >= '2013-05-16 00:00:00' AND publish_down <= '2013-05-16 23:59:59')
	OR (publish_up <= '2013-05-16 00:00:00' AND publish_down >= '2013-05-16 23:59:59')) AND state='1'
ORDER BY publish_up ASC
42
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-05-17 00:00:00' AND publish_up <= '2013-05-17 23:59:59')
	OR (publish_down >= '2013-05-17 00:00:00' AND publish_down <= '2013-05-17 23:59:59')
	OR (publish_up <= '2013-05-17 00:00:00' AND publish_down >= '2013-05-17 23:59:59')) AND state='1'
ORDER BY publish_up ASC
43
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-05-18 00:00:00' AND publish_up <= '2013-05-18 23:59:59')
	OR (publish_down >= '2013-05-18 00:00:00' AND publish_down <= '2013-05-18 23:59:59')
	OR (publish_up <= '2013-05-18 00:00:00' AND publish_down >= '2013-05-18 23:59:59')) AND state='1'
ORDER BY publish_up ASC
44
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-05-19 00:00:00' AND publish_up <= '2013-05-19 23:59:59')
	OR (publish_down >= '2013-05-19 00:00:00' AND publish_down <= '2013-05-19 23:59:59')
	OR (publish_up <= '2013-05-19 00:00:00' AND publish_down >= '2013-05-19 23:59:59')) AND state='1'
ORDER BY publish_up ASC
45
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-05-20 00:00:00' AND publish_up <= '2013-05-20 23:59:59')
	OR (publish_down >= '2013-05-20 00:00:00' AND publish_down <= '2013-05-20 23:59:59')
	OR (publish_up <= '2013-05-20 00:00:00' AND publish_down >= '2013-05-20 23:59:59')) AND state='1'
ORDER BY publish_up ASC
46
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-05-21 00:00:00' AND publish_up <= '2013-05-21 23:59:59')
	OR (publish_down >= '2013-05-21 00:00:00' AND publish_down <= '2013-05-21 23:59:59')
	OR (publish_up <= '2013-05-21 00:00:00' AND publish_down >= '2013-05-21 23:59:59')) AND state='1'
ORDER BY publish_up ASC
47
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-05-22 00:00:00' AND publish_up <= '2013-05-22 23:59:59')
	OR (publish_down >= '2013-05-22 00:00:00' AND publish_down <= '2013-05-22 23:59:59')
	OR (publish_up <= '2013-05-22 00:00:00' AND publish_down >= '2013-05-22 23:59:59')) AND state='1'
ORDER BY publish_up ASC
48
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-05-23 00:00:00' AND publish_up <= '2013-05-23 23:59:59')
	OR (publish_down >= '2013-05-23 00:00:00' AND publish_down <= '2013-05-23 23:59:59')
	OR (publish_up <= '2013-05-23 00:00:00' AND publish_down >= '2013-05-23 23:59:59')) AND state='1'
ORDER BY publish_up ASC
49
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-05-24 00:00:00' AND publish_up <= '2013-05-24 23:59:59')
	OR (publish_down >= '2013-05-24 00:00:00' AND publish_down <= '2013-05-24 23:59:59')
	OR (publish_up <= '2013-05-24 00:00:00' AND publish_down >= '2013-05-24 23:59:59')) AND state='1'
ORDER BY publish_up ASC
50
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-05-25 00:00:00' AND publish_up <= '2013-05-25 23:59:59')
	OR (publish_down >= '2013-05-25 00:00:00' AND publish_down <= '2013-05-25 23:59:59')
	OR (publish_up <= '2013-05-25 00:00:00' AND publish_down >= '2013-05-25 23:59:59')) AND state='1'
ORDER BY publish_up ASC
51
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-05-26 00:00:00' AND publish_up <= '2013-05-26 23:59:59')
	OR (publish_down >= '2013-05-26 00:00:00' AND publish_down <= '2013-05-26 23:59:59')
	OR (publish_up <= '2013-05-26 00:00:00' AND publish_down >= '2013-05-26 23:59:59')) AND state='1'
ORDER BY publish_up ASC
52
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-05-27 00:00:00' AND publish_up <= '2013-05-27 23:59:59')
	OR (publish_down >= '2013-05-27 00:00:00' AND publish_down <= '2013-05-27 23:59:59')
	OR (publish_up <= '2013-05-27 00:00:00' AND publish_down >= '2013-05-27 23:59:59')) AND state='1'
ORDER BY publish_up ASC
53
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-05-28 00:00:00' AND publish_up <= '2013-05-28 23:59:59')
	OR (publish_down >= '2013-05-28 00:00:00' AND publish_down <= '2013-05-28 23:59:59')
	OR (publish_up <= '2013-05-28 00:00:00' AND publish_down >= '2013-05-28 23:59:59')) AND state='1'
ORDER BY publish_up ASC
54
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-05-29 00:00:00' AND publish_up <= '2013-05-29 23:59:59')
	OR (publish_down >= '2013-05-29 00:00:00' AND publish_down <= '2013-05-29 23:59:59')
	OR (publish_up <= '2013-05-29 00:00:00' AND publish_down >= '2013-05-29 23:59:59')) AND state='1'
ORDER BY publish_up ASC
55
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-05-30 00:00:00' AND publish_up <= '2013-05-30 23:59:59')
	OR (publish_down >= '2013-05-30 00:00:00' AND publish_down <= '2013-05-30 23:59:59')
	OR (publish_up <= '2013-05-30 00:00:00' AND publish_down >= '2013-05-30 23:59:59')) AND state='1'
ORDER BY publish_up ASC
56
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-05-31 00:00:00' AND publish_up <= '2013-05-31 23:59:59')
	OR (publish_down >= '2013-05-31 00:00:00' AND publish_down <= '2013-05-31 23:59:59')
	OR (publish_up <= '2013-05-31 00:00:00' AND publish_down >= '2013-05-31 23:59:59')) AND state='1'
ORDER BY publish_up ASC
57
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-06-01 00:00:00' AND publish_up <= '2013-06-01 23:59:59')
	OR (publish_down >= '2013-06-01 00:00:00' AND publish_down <= '2013-06-01 23:59:59')
	OR (publish_up <= '2013-06-01 00:00:00' AND publish_down >= '2013-06-01 23:59:59')) AND state='1'
ORDER BY publish_up ASC
58
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-06-02 00:00:00' AND publish_up <= '2013-06-02 23:59:59')
	OR (publish_down >= '2013-06-02 00:00:00' AND publish_down <= '2013-06-02 23:59:59')
	OR (publish_up <= '2013-06-02 00:00:00' AND publish_down >= '2013-06-02 23:59:59')) AND state='1'
ORDER BY publish_up ASC
59
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-06-03 00:00:00' AND publish_up <= '2013-06-03 23:59:59')
	OR (publish_down >= '2013-06-03 00:00:00' AND publish_down <= '2013-06-03 23:59:59')
	OR (publish_up <= '2013-06-03 00:00:00' AND publish_down >= '2013-06-03 23:59:59')) AND state='1'
ORDER BY publish_up ASC
60
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-06-04 00:00:00' AND publish_up <= '2013-06-04 23:59:59')
	OR (publish_down >= '2013-06-04 00:00:00' AND publish_down <= '2013-06-04 23:59:59')
	OR (publish_up <= '2013-06-04 00:00:00' AND publish_down >= '2013-06-04 23:59:59')) AND state='1'
ORDER BY publish_up ASC
61
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-06-05 00:00:00' AND publish_up <= '2013-06-05 23:59:59')
	OR (publish_down >= '2013-06-05 00:00:00' AND publish_down <= '2013-06-05 23:59:59')
	OR (publish_up <= '2013-06-05 00:00:00' AND publish_down >= '2013-06-05 23:59:59')) AND state='1'
ORDER BY publish_up ASC
62
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-06-06 00:00:00' AND publish_up <= '2013-06-06 23:59:59')
	OR (publish_down >= '2013-06-06 00:00:00' AND publish_down <= '2013-06-06 23:59:59')
	OR (publish_up <= '2013-06-06 00:00:00' AND publish_down >= '2013-06-06 23:59:59')) AND state='1'
ORDER BY publish_up ASC
63
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-06-07 00:00:00' AND publish_up <= '2013-06-07 23:59:59')
	OR (publish_down >= '2013-06-07 00:00:00' AND publish_down <= '2013-06-07 23:59:59')
	OR (publish_up <= '2013-06-07 00:00:00' AND publish_down >= '2013-06-07 23:59:59')) AND state='1'
ORDER BY publish_up ASC
64
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-06-08 00:00:00' AND publish_up <= '2013-06-08 23:59:59')
	OR (publish_down >= '2013-06-08 00:00:00' AND publish_down <= '2013-06-08 23:59:59')
	OR (publish_up <= '2013-06-08 00:00:00' AND publish_down >= '2013-06-08 23:59:59')) AND state='1'
ORDER BY publish_up ASC
65
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-06-09 00:00:00' AND publish_up <= '2013-06-09 23:59:59')
	OR (publish_down >= '2013-06-09 00:00:00' AND publish_down <= '2013-06-09 23:59:59')
	OR (publish_up <= '2013-06-09 00:00:00' AND publish_down >= '2013-06-09 23:59:59')) AND state='1'
ORDER BY publish_up ASC
66
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-06-10 00:00:00' AND publish_up <= '2013-06-10 23:59:59')
	OR (publish_down >= '2013-06-10 00:00:00' AND publish_down <= '2013-06-10 23:59:59')
	OR (publish_up <= '2013-06-10 00:00:00' AND publish_down >= '2013-06-10 23:59:59')) AND state='1'
ORDER BY publish_up ASC
67
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-06-11 00:00:00' AND publish_up <= '2013-06-11 23:59:59')
	OR (publish_down >= '2013-06-11 00:00:00' AND publish_down <= '2013-06-11 23:59:59')
	OR (publish_up <= '2013-06-11 00:00:00' AND publish_down >= '2013-06-11 23:59:59')) AND state='1'
ORDER BY publish_up ASC
68
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-06-12 00:00:00' AND publish_up <= '2013-06-12 23:59:59')
	OR (publish_down >= '2013-06-12 00:00:00' AND publish_down <= '2013-06-12 23:59:59')
	OR (publish_up <= '2013-06-12 00:00:00' AND publish_down >= '2013-06-12 23:59:59')) AND state='1'
ORDER BY publish_up ASC
69
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-06-13 00:00:00' AND publish_up <= '2013-06-13 23:59:59')
	OR (publish_down >= '2013-06-13 00:00:00' AND publish_down <= '2013-06-13 23:59:59')
	OR (publish_up <= '2013-06-13 00:00:00' AND publish_down >= '2013-06-13 23:59:59')) AND state='1'
ORDER BY publish_up ASC
70
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-06-14 00:00:00' AND publish_up <= '2013-06-14 23:59:59')
	OR (publish_down >= '2013-06-14 00:00:00' AND publish_down <= '2013-06-14 23:59:59')
	OR (publish_up <= '2013-06-14 00:00:00' AND publish_down >= '2013-06-14 23:59:59')) AND state='1'
ORDER BY publish_up ASC
71
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-06-15 00:00:00' AND publish_up <= '2013-06-15 23:59:59')
	OR (publish_down >= '2013-06-15 00:00:00' AND publish_down <= '2013-06-15 23:59:59')
	OR (publish_up <= '2013-06-15 00:00:00' AND publish_down >= '2013-06-15 23:59:59')) AND state='1'
ORDER BY publish_up ASC
72
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-06-16 00:00:00' AND publish_up <= '2013-06-16 23:59:59')
	OR (publish_down >= '2013-06-16 00:00:00' AND publish_down <= '2013-06-16 23:59:59')
	OR (publish_up <= '2013-06-16 00:00:00' AND publish_down >= '2013-06-16 23:59:59')) AND state='1'
ORDER BY publish_up ASC
73
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-06-17 00:00:00' AND publish_up <= '2013-06-17 23:59:59')
	OR (publish_down >= '2013-06-17 00:00:00' AND publish_down <= '2013-06-17 23:59:59')
	OR (publish_up <= '2013-06-17 00:00:00' AND publish_down >= '2013-06-17 23:59:59')) AND state='1'
ORDER BY publish_up ASC
74
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-06-18 00:00:00' AND publish_up <= '2013-06-18 23:59:59')
	OR (publish_down >= '2013-06-18 00:00:00' AND publish_down <= '2013-06-18 23:59:59')
	OR (publish_up <= '2013-06-18 00:00:00' AND publish_down >= '2013-06-18 23:59:59')) AND state='1'
ORDER BY publish_up ASC
75
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-06-19 00:00:00' AND publish_up <= '2013-06-19 23:59:59')
	OR (publish_down >= '2013-06-19 00:00:00' AND publish_down <= '2013-06-19 23:59:59')
	OR (publish_up <= '2013-06-19 00:00:00' AND publish_down >= '2013-06-19 23:59:59')) AND state='1'
ORDER BY publish_up ASC
76
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-06-20 00:00:00' AND publish_up <= '2013-06-20 23:59:59')
	OR (publish_down >= '2013-06-20 00:00:00' AND publish_down <= '2013-06-20 23:59:59')
	OR (publish_up <= '2013-06-20 00:00:00' AND publish_down >= '2013-06-20 23:59:59')) AND state='1'
ORDER BY publish_up ASC
77
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-06-21 00:00:00' AND publish_up <= '2013-06-21 23:59:59')
	OR (publish_down >= '2013-06-21 00:00:00' AND publish_down <= '2013-06-21 23:59:59')
	OR (publish_up <= '2013-06-21 00:00:00' AND publish_down >= '2013-06-21 23:59:59')) AND state='1'
ORDER BY publish_up ASC
78
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-06-22 00:00:00' AND publish_up <= '2013-06-22 23:59:59')
	OR (publish_down >= '2013-06-22 00:00:00' AND publish_down <= '2013-06-22 23:59:59')
	OR (publish_up <= '2013-06-22 00:00:00' AND publish_down >= '2013-06-22 23:59:59')) AND state='1'
ORDER BY publish_up ASC
79
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-06-23 00:00:00' AND publish_up <= '2013-06-23 23:59:59')
	OR (publish_down >= '2013-06-23 00:00:00' AND publish_down <= '2013-06-23 23:59:59')
	OR (publish_up <= '2013-06-23 00:00:00' AND publish_down >= '2013-06-23 23:59:59')) AND state='1'
ORDER BY publish_up ASC
80
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-06-24 00:00:00' AND publish_up <= '2013-06-24 23:59:59')
	OR (publish_down >= '2013-06-24 00:00:00' AND publish_down <= '2013-06-24 23:59:59')
	OR (publish_up <= '2013-06-24 00:00:00' AND publish_down >= '2013-06-24 23:59:59')) AND state='1'
ORDER BY publish_up ASC
81
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-06-25 00:00:00' AND publish_up <= '2013-06-25 23:59:59')
	OR (publish_down >= '2013-06-25 00:00:00' AND publish_down <= '2013-06-25 23:59:59')
	OR (publish_up <= '2013-06-25 00:00:00' AND publish_down >= '2013-06-25 23:59:59')) AND state='1'
ORDER BY publish_up ASC
82
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-06-26 00:00:00' AND publish_up <= '2013-06-26 23:59:59')
	OR (publish_down >= '2013-06-26 00:00:00' AND publish_down <= '2013-06-26 23:59:59')
	OR (publish_up <= '2013-06-26 00:00:00' AND publish_down >= '2013-06-26 23:59:59')) AND state='1'
ORDER BY publish_up ASC
83
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-06-27 00:00:00' AND publish_up <= '2013-06-27 23:59:59')
	OR (publish_down >= '2013-06-27 00:00:00' AND publish_down <= '2013-06-27 23:59:59')
	OR (publish_up <= '2013-06-27 00:00:00' AND publish_down >= '2013-06-27 23:59:59')) AND state='1'
ORDER BY publish_up ASC
84
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-06-28 00:00:00' AND publish_up <= '2013-06-28 23:59:59')
	OR (publish_down >= '2013-06-28 00:00:00' AND publish_down <= '2013-06-28 23:59:59')
	OR (publish_up <= '2013-06-28 00:00:00' AND publish_down >= '2013-06-28 23:59:59')) AND state='1'
ORDER BY publish_up ASC
85
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-06-29 00:00:00' AND publish_up <= '2013-06-29 23:59:59')
	OR (publish_down >= '2013-06-29 00:00:00' AND publish_down <= '2013-06-29 23:59:59')
	OR (publish_up <= '2013-06-29 00:00:00' AND publish_down >= '2013-06-29 23:59:59')) AND state='1'
ORDER BY publish_up ASC
86
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2013-06-30 00:00:00' AND publish_up <= '2013-06-30 23:59:59')
	OR (publish_down >= '2013-06-30 00:00:00' AND publish_down <= '2013-06-30 23:59:59')
	OR (publish_up <= '2013-06-30 00:00:00' AND publish_down >= '2013-06-30 23:59:59')) AND state='1'
ORDER BY publish_up ASC
87
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0 AND (mos_events.state='1')
	AND ((publish_up <= '2013-05-21 00:00:00%' AND publish_down >= '2013-05-21 00:00:00%')
	OR (publish_up <= '2014-05-21 23:59:59%' AND publish_down >= '2014-05-21 23:59:59%')
   OR (publish_up <= '2014-05-21 23:59:59%' AND publish_up >= '2013-05-21 00:00:00%')
   OR (publish_down <= '2014-05-21 23:59:59%' AND publish_down >= '2013-05-21 00:00:00%'))
ORDER BY publish_up ASC
88
SELECT id FROM mos_menu WHERE link = 'index.php?option=com_events'
89
SELECT id, name FROM mos_categories WHERE section= 'com_events' AND published='1'
90
SELECT id, username, sendEmail, email FROM mos_users WHERE block ='0'
91
SELECT a.id
 FROM mos_content AS a
 INNER JOIN mos_categories AS b ON b.id = a.catid
 WHERE a.state = 1
 AND a.access <= 0
 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-05-21 06:41:16') 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-05-21 06:41:16')
 AND catid='52' 
 ORDER BY a.ordering
 LIMIT 10
92
SELECT id, link
FROM mos_menu
WHERE menutype='mainmenu' AND published='1'
ORDER BY parent, ordering LIMIT 1
93
SELECT id, name, link, parent, type
FROM mos_menu
WHERE published='1'
ORDER BY parent, ordering
94
SELECT count(*) AS numrows FROM mos_banner WHERE showBanner=1
95
SELECT * FROM mos_banner WHERE showBanner=1 
LIMIT 2,1
96
UPDATE mos_banner SET impmade=impmade+1 WHERE bid='4'
97
SELECT name FROM mos_users WHERE id = 0