SELECT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, 
                  i.image_keywords, i.image_date, i.image_active, i.image_media_file, 
                  i.image_thumb_file, i.image_download_url, i.image_allow_comments, 
                  i.image_comments, i.image_downloads, i.image_votes, 
                  i.image_rating, i.image_hits, c.cat_name, u.user_name
                  FROM images_images i, images_categories c 
                 LEFT JOIN images_users u 
                       ON (u.user_id = i.user_id) WHERE i.image_active =  1 
                             AND c.cat_id= i.cat_id AND i.cat_id IN ( 0 ,  1 )
                           ORDER BY i.image_date DESC LIMIT  3