I run this query I broke something
SELECT aiki_users.userid as id, aiki_users.username as username,
set_title, set_list_contents.date_added,
ocal_files.filename as filename,
set_list_contents.image_id
FROM ocal_files, set_list_titles, aiki_users, set_list_contents
WHERE aiki_users.userid = set_list_titles.userid AND
ocal_files.upload_user = set_list_titles.userid AND
ocal_files.id = (SELECT image_id
FROM set_list_contents
WHERE set_list_id = set_list_titles.userid)
ORDER BY set_list_titles.date_added DESC
_______________________________________________
Mailing list: https://launchpad.net/~aikiframework-devel
Post to : [email protected]
Unsubscribe : https://launchpad.net/~aikiframework-devel
More help : https://help.launchpad.net/ListHelp
