我在我的wordpress bdd上做了一个take all posts的请求，post类型='tribe\u events'，post状态='publish'，并用一些左键连接另一个数据（比如开始日期，结束日期等），但是我的请求只显示155行，或者如果我做一个简单的请求，比如

SELECT * FROM `wp_4_posts` WHERE post_type = "tribe_events" AND post_status = 'publish'

我有189行，所以34行不在这里。
这是我的要求：

SELECT pm1.meta_value _EventVenueID
 , p1.post_title event_type
 , p2.post_title organiser
 , p3.post_title venues
 , pm2.meta_value _EventStartDate
 , pm3.meta_value _EventEndDate
 , pm4.meta_value _EventOrganizerID
 , p10.guid
 , p20.ID
 , wp_4_terms.name

 FROM wp_4_posts p1 
 JOIN wp_4_postmeta pm1 
   ON p1.ID = pm1.post_id 
  AND pm1.meta_key = '_EventVenueID'

 LEFT
 JOIN wp_4_posts p3
   ON p3.id = pm1.meta_value

 LEFT 
 JOIN wp_4_postmeta pm2 
   ON p1.ID = pm2.post_id 
  AND pm2.meta_key = '_EventStartDate'

 LEFT 
 JOIN wp_4_postmeta pm3 
   ON p1.ID = pm3.post_id 
  AND pm3.meta_key = '_EventEndDate'

 LEFT 
 JOIN wp_4_postmeta pm4 
   ON p1.ID = pm4.post_id 
  AND pm4.meta_key = '_EventOrganizerID'

 LEFT
 JOIN wp_4_posts p2
   ON p2.id = pm4.meta_value 

 LEFT
 JOIN wp_4_posts p10
   ON p10.id = p1.id

 LEFT
 JOIN wp_4_posts p20
   ON p20.id = p1.id

  LEFT JOIN wp_4_term_relationships 
  ON p1.ID = wp_4_term_relationships.object_id 

  LEFT 
  JOIN wp_4_term_taxonomy 
  ON
wp_4_term_taxonomy.term_taxonomy_id=wp_4_term_relationships.term_taxonomy_id 
 LEFT JOIN wp_4_terms ON  wp_4_terms.term_id = wp_4_term_taxonomy.term_id 

WHERE p1.post_type = 'tribe_events' 
AND p1.post_status = 'publish'

我不明白为什么我只有155行，你有办法吗？
非常感谢你的帮助！