SELECT count(*) FROM wpvn_posts as p
                LEFT JOIN wpvn_term_relationships ON
                (p.ID = wpvn_term_relationships.object_id)
                LEFT JOIN wpvn_term_taxonomy ON
                (wpvn_term_relationships.term_taxonomy_id = wpvn_term_taxonomy.term_taxonomy_id)
                WHERE p.post_status = 'publish'

                AND wpvn_term_taxonomy.taxonomy = 'category'
                AND p.iStatus = '3'
                AND p.post_type ='post'
                AND wpvn_term_taxonomy.term_id = 4
SELECT p.* FROM wpvn_posts as p LEFT JOIN wpvn_term_relationships ON (p.ID = wpvn_term_relationships.object_id) LEFT JOIN wpvn_term_taxonomy ON (wpvn_term_relationships.term_taxonomy_id = wpvn_term_taxonomy.term_taxonomy_id) WHERE p.post_status = 'publish' AND wpvn_term_taxonomy.taxonomy = 'category' AND p.iStatus = 3 AND p.post_type ='post' AND wpvn_term_taxonomy.term_id = 4 ORDER BY post_date DESC LIMIT 0, 10string(2) "76" Total records 76item per age10