Visited 273 times, 2 Visits today

WordPress database error: [Not unique table/alias: 'm']
SELECT p.ID FROM g5VnS4_posts AS p INNER JOIN g5VnS4_postmeta AS m ON p.ID = m.post_id JOIN g5VnS4_postmeta m ON p.ID=m.post_id AND m.meta_key ='post_city_id' AND FIND_IN_SET( 27162, m.meta_value ) WHERE p.post_type = 'event' AND p.post_status = 'publish' AND (m.meta_key = 'set_st_time' AND (m.meta_key = 'set_st_time' AND CAST(m.meta_value AS CHAR) < '2018-11-20 07:15:48')) AND (m.meta_key = 'set_st_time' AND (m.meta_key = 'set_st_time' AND CAST(m.meta_value AS CHAR) < '2017-09-15 00:00')) GROUP BY p.ID ORDER BY m.meta_value+0 DESC

WordPress database error: [Not unique table/alias: 'm']
SELECT p.ID FROM g5VnS4_posts AS p INNER JOIN g5VnS4_postmeta AS m ON p.ID = m.post_id JOIN g5VnS4_postmeta m ON p.ID=m.post_id AND m.meta_key ='post_city_id' AND FIND_IN_SET( 27162, m.meta_value ) WHERE p.post_type = 'event' AND p.post_status = 'publish' AND (m.meta_key = 'set_st_time' AND (m.meta_key = 'set_st_time' AND CAST(m.meta_value AS CHAR) < '2018-11-20 07:15:48')) AND (m.meta_key = 'set_st_time' AND (m.meta_key = 'set_st_time' AND CAST(m.meta_value AS CHAR) > '2017-09-15 00:00')) GROUP BY p.ID ORDER BY m.meta_value+0 ASC

Add a Review

 

Related Event