Advanced Search

Return to Snippet

Revision: 1010
at August 28, 2006 11:45 by drdamour
Updated Code 
SELECT RECENT_POSTS.*, wp_users.display_name as AUTHOR FROM 
   (SELECT ALL_POSTS.* FROM 
       (SELECT POSTS.*, post_author as author_id FROM wp_2_posts POSTS where post_status = ‘publish’ and post_type=’post’ 
        UNION
        SELECT POSTS.*, post_author as author_id FROM wp_3_posts POSTS where post_status = ‘publish’ and post_type=’post’) ALL_POSTS
    ORDER BY post_modified DESC LIMIT 0,20)
RECENT_POSTS LEFT JOIN wp_users ON RECENT_POSTS.author_id = wp_users.ID

Revision: 1009
at August 28, 2006 10:38 by drdamour
Initial Code 
SELECT RECENT_POSTS.*, wp_users.display_name as AUTHOR FROM (SELECT ALL_POSTS.* FROM (SELECT POSTS.*, post_author as author_id FROM wp_2_posts POSTS where post_status = ‘publish’ and post_type=’post’ UNION SELECT POSTS.*, post_author as author_id FROM wp_3_posts POSTS where post_status = ‘publish’ and post_type=’post’) ALL_POSTS ORDER BY post_modified DESC LIMIT 0,20) RECENT_POSTS LEFT JOIN wp_users ON RECENT_POSTS.author_id = wp_users.ID
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Select from WordpressMU Posts

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
wordpress

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL