WordPress database error: [Unknown column 'wpbp_postmeta.meta_value' in 'field list']
SELECT DISTINCT wpbp_posts.*, MIN(wpbp_postmeta.meta_value) as EventStartDate, MIN(tribe_event_end_date.meta_value) as EventEndDate FROM wpbp_posts LEFT JOIN wpbp_postmeta as tribe_event_end_date ON ( wpbp_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = '_EventEndDate' ) WHERE 1=1 AND wpbp_posts.post_type = 'tribe_events' AND (wpbp_posts.post_status = 'publish' OR wpbp_posts.post_status = 'tribe-ea-success' OR wpbp_posts.post_status = 'tribe-ea-failed' OR wpbp_posts.post_status = 'tribe-ea-schedule' OR wpbp_posts.post_status = 'tribe-ea-pending' OR wpbp_posts.post_status = 'tribe-ea-draft') ORDER BY EventStartDate DESC, wpbp_posts.post_date DESC LIMIT 0, 1

BEGIN:VCALENDAR VERSION:2.0 PRODID:-//NNRMLS Member Site 2019 - ECPv4.9.3.2//NONSGML v1.0//EN CALSCALE:GREGORIAN METHOD:PUBLISH X-WR-CALNAME:NNRMLS Member Site 2019 X-ORIGINAL-URL:https://members.nnrmls.com X-WR-CALDESC:Events for NNRMLS Member Site 2019 BEGIN:VEVENT DTSTART;TZID=America/Los_Angeles:20190605T083000 DTEND;TZID=America/Los_Angeles:20190605T090000 DTSTAMP:20190625T194553 CREATED:20190603T195716Z LAST-MODIFIED:20190603T212241Z UID:9703-1559723400-1559725200@members.nnrmls.com SUMMARY:8 Essential Homesnap Hacks Every Agent Should Know DESCRIPTION:Learn the best hacks that help you boost your productivity in the Homesnap App. During the workshop\, we will cover each hack slowly\, giving everyone enough time for practice. \n URL:https://members.nnrmls.com/event/8-essential-homesnap-hacks-every-agent-should-know/ CATEGORIES:Webinar ATTACH;FMTTYPE=image/jpeg:https://members.nnrmls.com/wp-content/uploads/2019/06/Homesnap-Pro-Hacks-Header.jpg END:VEVENT BEGIN:VEVENT DTSTART;TZID=UTC+0:20190606T100000 DTEND;TZID=UTC+0:20190606T110000 DTSTAMP:20190625T194553 CREATED:20190319T230240Z LAST-MODIFIED:20190319T230240Z UID:9297-1559815200-1559818800@members.nnrmls.com SUMMARY:Down Payment Programs 101: What Every Agent Needs to Know DESCRIPTION:The main reason your buyers postpone their homeownership dream? Saving for a down payment. But there are valuable programs to help today’s buyers. Learn the basics about the three most common types of homeownership programs\, how to find out who offers this help\, and what’s available across the country–and right in your backyard! Join us and take the first step towards educating more of your sidelined buyers about these opportunities. Register and you’ll get a recording of the live webinar\, plus additional materials. \n URL:https://members.nnrmls.com/event/down-payment-programs-101-what-every-agent-needs-to-know-2/ CATEGORIES:Webinar ATTACH;FMTTYPE=image/jpeg:https://members.nnrmls.com/wp-content/uploads/2018/03/DPR.jpg END:VEVENT BEGIN:VEVENT DTSTART;TZID=UTC+0:20190606T110000 DTEND;TZID=UTC+0:20190606T113000 DTSTAMP:20190625T194553 CREATED:20190603T195727Z LAST-MODIFIED:20190603T212421Z UID:9706-1559818800-1559820600@members.nnrmls.com SUMMARY:8 Essential Homesnap Hacks Every Agent Should Know DESCRIPTION:Learn the best hacks that help you boost your productivity in the Homesnap App. During the workshop\, we will cover each hack slowly\, giving everyone enough time for practice. \n URL:https://members.nnrmls.com/event/8-essential-homesnap-hacks-every-agent-should-know-2/ CATEGORIES:Webinar ATTACH;FMTTYPE=image/jpeg:https://members.nnrmls.com/wp-content/uploads/2019/06/Homesnap-Pro-Hacks-Header.jpg END:VEVENT BEGIN:VEVENT DTSTART;TZID=UTC+0:20190617T100000 DTEND;TZID=UTC+0:20190617T110000 DTSTAMP:20190625T194553 CREATED:20190611T222723Z LAST-MODIFIED:20190611T222723Z UID:9826-1560765600-1560769200@members.nnrmls.com SUMMARY:"How to Get Your Next Deal Using Instagram" Webinar DESCRIPTION:You will learn: \n• What type of content you should post to generate more leads\n• How to effectively leverage Instagram Stories to promote your business\n• How to run Instagram Ads to grow your brand reach\n• Which tools you need to get more followers from Instagram \n URL:https://members.nnrmls.com/event/how-to-get-your-next-deal-using-instagram-webinar/ CATEGORIES:Webinar END:VEVENT BEGIN:VEVENT DTSTART;TZID=UTC+0:20190624T100000 DTEND;TZID=UTC+0:20190624T113000 DTSTAMP:20190625T194553 CREATED:20190530T195910Z LAST-MODIFIED:20190530T200039Z UID:9665-1561370400-1561375800@members.nnrmls.com SUMMARY: DESCRIPTION:Join Remine for a chance to get an in-depth training of the Remine Property Intelligence Platform! Remine is a modern real estate platform that makes engaging with your clients easy! You’ll have access to more data than anywhere else. \nDuring these training sessions\, you’ll learn about:\n• Client Invite: Invite your contacts to Remine and provide them with the best search experience in the business. When they register\, you are their default sponsor agent.\n• Saved Search: Get alerts about the latest MLS data for you and your clients.\n• CMA 360: Pull a CMA for your clients in minutes\, without having to leave the Remine platform.\n• Engage CRM: Premium tool that monitors client activity so you can prioritize your efforts.\n• Lead Generation: Quickly find new opportunities through geographical farming.\n• Direct Mail: Send direct mail through Remine using our new integration with Rocket Print & Mail (Postcardmania). \nCLICK ON THE LINK BELOW FOR A QUICK INTRO ON REMINE:\nhttps://remine.wistia.com/medias/n2xau1i0lb \n URL:https://members.nnrmls.com/event/9665/ LOCATION:RSAR\, 5650 Riggins Court\, Reno\, NV\, 89502\, United States CATEGORIES:Webinar ATTACH;FMTTYPE=image/jpeg:https://members.nnrmls.com/wp-content/uploads/2018/04/Remine.jpg END:VEVENT BEGIN:VEVENT DTSTART;TZID=UTC+0:20190624T100000 DTEND;TZID=UTC+0:20190624T113000 DTSTAMP:20190625T194553 CREATED:20190530T210058Z LAST-MODIFIED:20190530T210409Z UID:9668-1561370400-1561375800@members.nnrmls.com SUMMARY:Remine Property Intelligence Platform DESCRIPTION:Join Remine for a chance to get an in-depth training of the Remine Property Intelligence Platform! Remine is a modern real estate platform that makes engaging with your clients easy! You’ll have access to more data than anywhere else. \nDuring these training sessions\, you’ll learn about:\n• Client Invite: Invite your contacts to Remine and provide them with the best search experience in the business. When they register\, you are their default sponsor agent.\n• Saved Search: Get alerts about the latest MLS data for you and your clients.\n• CMA 360: Pull a CMA for your clients in minutes\, without having to leave the Remine platform.\n• Engage CRM: Premium tool that monitors client activity so you can prioritize your efforts.\n• Lead Generation: Quickly find new opportunities through geographical farming.\n• Direct Mail: Send direct mail through Remine using our new integration with Rocket Print & Mail (Postcardmania). \nCLICK ON THE LINK BELOW FOR A QUICK INTRO ON REMINE:\n \n URL:https://members.nnrmls.com/event/remine-property-intelligence-platform/ LOCATION:RSAR\, 5650 Riggins Court\, Reno\, NV\, 89502\, United States CATEGORIES:Webinar END:VEVENT BEGIN:VEVENT DTSTART;TZID=UTC+0:20190625T100000 DTEND;TZID=UTC+0:20190625T113000 DTSTAMP:20190625T194553 CREATED:20190530T210615Z LAST-MODIFIED:20190530T214034Z UID:9672-1561456800-1561462200@members.nnrmls.com SUMMARY:Remine Property Intelligence Platform DESCRIPTION:Join Remine for a chance to get an in-depth training of the Remine Property Intelligence Platform! Remine is a modern real estate platform that makes engaging with your clients easy! You’ll have access to more data than anywhere else. \nDuring these training sessions\, you’ll learn about:\n• Client Invite: Invite your contacts to Remine and provide them with the best search experience in the business. When they register\, you are their default sponsor agent.\n• Saved Search: Get alerts about the latest MLS data for you and your clients.\n• CMA 360: Pull a CMA for your clients in minutes\, without having to leave the Remine platform.\n• Engage CRM: Premium tool that monitors client activity so you can prioritize your efforts.\n• Lead Generation: Quickly find new opportunities through geographical farming.\n• Direct Mail: Send direct mail through Remine using our new integration with Rocket Print & Mail (Postcardmania). \nCLICK ON THE LINK BELOW FOR A QUICK INTRO ON REMINE:\n \n URL:https://members.nnrmls.com/event/remine-property-intelligence-platform-2/ LOCATION:SNR\, 300 S. Curry St #3\, Carson City\, NV\, 89703\, United States CATEGORIES:Webinar END:VEVENT END:VCALENDAR