let me just just clarify some things. fist, the query formatted better:
SELECT DISTINCT page_items.name, page_items.url, page_items.html_text, (
SELECT user_images.cleared
FROM user_images
WHERE page_items.url = user_images.image_url
) AS cleared, page_items.text_cleared, (
SELECT...