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 Chapter With A Heart

Chapter With A Heart

CLICK HERE FOR A LIST OF CHAPTER WITH A HEART DONORS (1.66 MB) Oklahoma Chapter with a Heart is in our 8th year supporting the Armed Forces YMCA. All of the funding is used to help new military families which are stationed in Lawton, Oklahoma. Not only do they have an educational Day Care, but they also help the young families in getting set up with household goods and clothing for free. New families start out with very little pay from the military and appreciate all of the help given to them on a daily basis. The AFYMCA also steps in to give all kinds of support and help to military personnel who are sent directly to Iraq and Afganistan after training. When you have the chance to go and see the operation, it will bring tears to your eyes and will open your hearts for giving a donation. Our leadership part of the chapter understands that there are so many foundations that need help, but we decided not to abandon the AFYMCA when they need us the most. Please help us support the AFYMCA today by sending in a $25.00 donation and we will make sure you are recognized with a Heart by your picture, in our yearly Oklahoma Chapter CRS Who’s Who.  Donate through our Chapter Store here. We are a 501(c)3 organization and your contributions are deductible on your federal income taxes. Thank You for your support. Your Oklahoma Chapter Leadership of 2013 Oklahoma CRS supports Armed Service YMCA of Lawton. Enter the raffle today for a chance to win the following prizes. Drawing will be held at the OAR Conference in September. $25 for three raffle tickets and a pink ribbon in the CRS Directory, $10 for one raffle ticket. All do-nations are forwarded to the Armed Services YMCA, an organization that helps the families of our military stationed overseas.   Click Here for complete Flyer and Information (146.50 KB)

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
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='186' LIMIT 1
3
DELETE FROM mos_session
WHERE (time < 1368904069)
4
SELECT * FROM mos_session WHERE session_id='e9499501679b24a5b519d3edd00e262e'
5
SELECT session_id FROM mos_session WHERE session_id=MD5('b74fa9e3a28d4a81057f555b81076899')
6
INSERT INTO mos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '0c5c60595e5fb000753529fbc7d002f2','1368904969','','0','1' )
7
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
8
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
9
SELECT access FROM mos_menu WHERE id='186'
10
SELECT a.*, ROUND(v.rating_sum/v.rating_count) AS rating, v.rating_count, u.name AS author, u.usertype, cc.name AS category, s.name AS section, g.name AS groups
 FROM mos_content AS a
 LEFT JOIN mos_categories AS cc ON cc.id = a.catid
 LEFT JOIN mos_sections AS s ON s.id = cc.section AND s.scope='content'
 LEFT JOIN mos_users AS u ON u.id = a.created_by
 LEFT JOIN mos_content_rating AS v ON a.id = v.content_id
 LEFT JOIN mos_groups AS g ON a.access = g.id
 WHERE a.id='232' AND (a.state = '1' OR a.state = '-1')
	AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2013-05-18 14:22:49')
	AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2013-05-18 14:22:49')
 AND a.access <= 0
11
UPDATE mos_content SET hits=(hits+1) WHERE id='232'
12
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_vflexts
WHERE published >= 1 AND access <= 0 AND folder='content'
ORDER BY ordering
13
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 = '186' OR mm.menuid = '0')
ORDER BY ordering
14
SELECT m.* FROM mos_menu AS m
WHERE menutype='mainmenu' AND published='1'
ORDER BY parent,ordering
15
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=232'
16
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=232'
17
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=85'
18
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=85'
19
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=84'
20
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=84'
21
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=126'
22
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=126'
23
SELECT id FROM mos_menu WHERE link = 'index.php?option=com_events'
24
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
25
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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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 (mos_events.state='1')
	AND ((publish_up <= '2013-05-18 00:00:00%' AND publish_down >= '2013-05-18 00:00:00%')
	OR (publish_up <= '2014-05-18 23:59:59%' AND publish_down >= '2014-05-18 23:59:59%')
   OR (publish_up <= '2014-05-18 23:59:59%' AND publish_up >= '2013-05-18 00:00:00%')
   OR (publish_down <= '2014-05-18 23:59:59%' AND publish_down >= '2013-05-18 00:00:00%'))
ORDER BY publish_up ASC
86
SELECT id FROM mos_menu WHERE link = 'index.php?option=com_events'
87
SELECT id, name FROM mos_categories WHERE section= 'com_events' AND published='1'
88
SELECT id, username, sendEmail, email FROM mos_users WHERE block ='0'
89
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-18 14:22:49') 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-05-18 14:22:49')
 AND catid='52' 
 ORDER BY a.ordering
 LIMIT 10
90
SELECT id, link
FROM mos_menu
WHERE menutype='mainmenu' AND published='1'
ORDER BY parent, ordering LIMIT 1
91
SELECT id, name, link, parent, type
FROM mos_menu
WHERE published='1'
ORDER BY parent, ordering
92
SELECT count(*) AS numrows FROM mos_banner WHERE showBanner=1
93
SELECT * FROM mos_banner WHERE showBanner=1 
LIMIT 1,1
94
UPDATE mos_banner SET impmade=impmade+1 WHERE bid='3'
95
SELECT name FROM mos_users WHERE id = 0