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 What's a CRS? Why use a CRS? Find a CRS... Buying & Selling Q & A Buyer's Guide Seller's Guide Calculators Other Resources Glossary 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 Home Buyers & Sellers

Resources for Home Buying & Selling

Buying or Selling a Home in Oklahoma? Interested in working with a CRS in your area? Contact our chapter for more information, we'll be glad to assist! When you trust the most crucial financial transaction of your life to a Certified Residential Specialist, you'll be assured that: You are working with an agent who subscribes to the REALTOR® Code of Ethics. Your agent is a specialist in buying and selling residential real estate. Your agent has access to the latest technology. Your agent is a specialist in maximizing profits and minimizing costs. We invite you to utilize the tools and resources that we've provided in this section of our website for home buyers and sellers.

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='52' LIMIT 1
3
DELETE FROM mos_session
WHERE (time < 1369073643)
4
SELECT * FROM mos_session WHERE session_id='dcd484ca3b80542aa979e60f088c1a02'
5
SELECT session_id FROM mos_session WHERE session_id=MD5('e8b784ea384aab1feb20e960db41aa22')
6
INSERT INTO mos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '4ece84569cd54c74c16bca5a5d2649dc','1369074543','','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='52'
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='76' AND (a.state = '1' OR a.state = '-1')
	AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2013-05-20 13:29:03')
	AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2013-05-20 13:29:03')
 AND a.access <= 0
11
UPDATE mos_content SET hits=(hits+1) WHERE id='76'
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 = '52' 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=92'
20
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=92'
21
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=81'
22
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=81'
23
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=95'
24
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=95'
25
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=82'
26
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=82'
27
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=84'
28
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=84'
29
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=126'
30
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=126'
31
SELECT id FROM mos_menu WHERE link = 'index.php?option=com_events'
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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-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
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 ((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
88
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
89
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
90
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
91
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
92
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
93
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-20 00:00:00%' AND publish_down >= '2013-05-20 00:00:00%')
	OR (publish_up <= '2014-05-20 23:59:59%' AND publish_down >= '2014-05-20 23:59:59%')
   OR (publish_up <= '2014-05-20 23:59:59%' AND publish_up >= '2013-05-20 00:00:00%')
   OR (publish_down <= '2014-05-20 23:59:59%' AND publish_down >= '2013-05-20 00:00:00%'))
ORDER BY publish_up ASC
94
SELECT id FROM mos_menu WHERE link = 'index.php?option=com_events'
95
SELECT id, name FROM mos_categories WHERE section= 'com_events' AND published='1'
96
SELECT id, username, sendEmail, email FROM mos_users WHERE block ='0'
97
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-20 13:29:03') 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-05-20 13:29:03')
 AND catid='52' 
 ORDER BY a.ordering
 LIMIT 10
98
SELECT id, link
FROM mos_menu
WHERE menutype='mainmenu' AND published='1'
ORDER BY parent, ordering LIMIT 1
99
SELECT id, name, link, parent, type
FROM mos_menu
WHERE published='1'
ORDER BY parent, ordering
100
SELECT count(*) AS numrows FROM mos_banner WHERE showBanner=1
101
SELECT * FROM mos_banner WHERE showBanner=1 
LIMIT 0,1
102
UPDATE mos_banner SET impmade=impmade+1 WHERE bid='2'
103
SELECT name FROM mos_users WHERE id = 0