How to display post by category on page in wordpress

Query to display post by category using Joins.

<?php
global $wpdb, $post;

  $slug = get_post( $post )->post_name;

    $query = "SELECT * FROM wp_posts p LEFT OUTER JOIN wp_term_relationships r ON r.object_id = p.ID LEFT OUTER JOIN wp_term_taxonomy x ON x.term_taxonomy_id = r.term_taxonomy_id LEFT OUTER JOIN wp_terms t ON t.term_id = x.term_id WHERE p.post_status = 'publish' AND p.post_type = 'post' AND t.slug = '$slug' order by ID Desc limit 8";
?>

How to add and delete div using j query

1. Copy this script in Head section

2. Copy This code in body Section.

Other costs (name them)









    

How To Integrate google translator In any site

1. Copy this Code in section

2. Copy this Code in section

   
     Google Translate           
        
    

Note :- Set dive style according to your choice thanks.