IT Blog

  • Blog
  • Technology
    • Technology
    • Architecture
    • CMS
    • CRM
    • Web
    • DotNET
    • Python
    • Database
    • BI
    • Program Language
  • Users
    • Login
    • Register
    • Forgot Password?
  • ENEN
    • 中文中文
    • ENEN
Experience IT
In a World of Technology, People Make the Difference.
  1. Home
  2. Technology
  3. CMS
  4. Wordpress
  5. Plugin
  6. Get event list with feature image

Get event list with feature image

2018-08-27 701 Views 0 Like 0 Comments

Plugin: The Events Calendar By Modern Tribe, Inc.

The event data is stored on multiple rows in two tables: wp_posts and wp_postmeta.

SELECT `post_title`,`post_content`,post_name,
 (SELECT meta_value FROM `wp_postmeta` WHERE post_id=p.id and meta_key='_EventStartDate') Start,
 (SELECT meta_value End FROM `wp_postmeta` WHERE post_id=p.id and meta_key='_EventEndDate') End,
 (select p1.guid from wp_posts p1 join
 (select po.id,m.meta_value from wp_posts po join wp_postmeta m on po.id=m.post_id and meta_key='_thumbnail_id' where post_status='publish') m on p1.id=m.meta_value where m.id=p.id) featureimage
FROM `wp_posts` p WHERE post_type='tribe_events' and post_status='publish'

event list

event List Feature Images

Reference project: https://vincentkempp.com

 1,807 total views,  4 views today

error
fb-share-icon
Tweet
fb-share-icon
IT Team
Author: IT Team

Tags: None
Last updated:2021-01-02

IT Team

This person is lazy and left nothing

Like
< Previous
Next >

Comments

Cancel reply
Chinese (Simplified) Chinese (Simplified) Chinese (Traditional) Chinese (Traditional) English English French French German German Japanese Japanese Korean Korean Russian Russian
Newest Hotspots Random
Newest Hotspots Random
Rich editor not working Making web page scroll down automatically Getting data from Dapper result All Unicode Chars How to keep and display contact form 7 data Common Regular Expressions
SQL Server Database Backup - 3 Methods CSS Tricks Add further reading list after post Set up DKIM to prevent email spoofing on GSuite Extend some useful string functions in C# Audio Symbols
Categories
  • Architecture
  • BI
  • C#
  • CSS
  • Database
  • DotNET
  • Hosting
  • HTML
  • JavaScript
  • PHP
  • Program Language
  • Python
  • Security
  • SEO
  • Technology
  • Web
  • Wordpress

COPYRIGHT © 2021 Hostlike IT Blog. All rights reserved.

This site is supported by Hostlike.com