Hi. Me thinks these empty results can occur when the tables, or portions thereof, are emptied but the text_content directory still contains files, and visa versa, and then things get out of sync. If deleting things, it may be best to just do it from the admin panel or follow
this thread. Also,
this thread may be of interest, especially the second page of the thread.