Find a Certified Practitioner

WordPress database error: [Disk full (/var/lib/mysql/tmp/#sql_4255_2.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT wpdl_posts.* FROM wpdl_posts LEFT JOIN wpdl_term_relationships ON (wpdl_posts.ID = wpdl_term_relationships.object_id) WHERE 1=1 AND ( wpdl_term_relationships.term_taxonomy_id IN (769) ) AND wpdl_posts.post_type = 'w2dc_listing' AND ((wpdl_posts.post_status = 'publish')) AND wpdl_posts.ID NOT IN ( SELECT ID FROM wpdl_posts WHERE post_type IN ('post','page','attachment','w2dc_listing','mm_practitio_dir_ltg','practitioner_dir_ltg','product','wpcw_certificates','wpcw_course','course_unit','dt_portfolio','dt_testimonials','dt_team','dt_slideshow','dt_gallery','esign') AND ID IN ( SELECT post_id FROM wpdl_postmeta pm WHERE pm.meta_key = 'groups-read' AND pm.meta_value NOT IN ('') AND post_id NOT IN ( SELECT post_id FROM wpdl_postmeta pm WHERE pm.meta_key = 'groups-read' AND pm.meta_value IN ('') ) ) ) GROUP BY wpdl_posts.ID ORDER BY wpdl_posts.post_date DESC