I have this SQL query here:

PHP Code:
SELECT wp_posts.*, wp_postmeta.* FROM wp_postswp_postmeta WHERE wp_posts.ID=wp_postmeta.post_id  AND meta_key='image_path'  group by ID desc 
however I would like to get the count total from this how can I do it?