All Albums

SELECT *
FROM phpfox_apps
WHERE is_active=1

DELETE FROM phpfox_log_session WHERE id_hash = 'c56fb43d525078d2aaf85f739d93f298'

INSERT INTO phpfox_log_session (session_hash, id_hash, user_id, last_activity, location, is_forum, forum_id, im_hide, ip_address, user_agent) VALUES ('53aff6df1ce81dfcd549afdf9883756e', 'c56fb43d525078d2aaf85f739d93f298', '0', '1580304178', '', '0', '0', '0', '18.232.51.247', 'CCBot/2.0 (https://commoncrawl.org/faq/)')

SELECT sp.*
FROM phpfox_subscribe_purchase AS sp
     JOIN phpfox_user_field AS uf
ON(uf.subscribe_id=sp.purchase_id)

WHERE sp.user_id=0

SELECT p.destination, p.server_id, p.mature, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.birthday, u.country_iso, pa.*
FROM (
( SELECT pa.*
FROM phpfox_photo_album AS pa
     LEFT JOIN phpfox_like AS l
ON(l.type_id = 'photo_album' AND l.item_id = pa.album_id AND l.user_id = 0)

WHERE pa.view_id = 0 AND pa.total_photo > 0 AND pa.module_id is NULL AND pa.privacy IN(0) AND pa.profile_id = 0 AND pa.cover_id = 0 AND pa.timeline_id = 0

)) AS pa
     LEFT JOIN phpfox_photo AS p
ON(p.album_id = pa.album_id AND pa.view_id = 0 AND p.is_cover = 1)
     JOIN phpfox_user AS u
ON(u.user_id = pa.user_id)

ORDER BY pa.time_stamp DESC
LIMIT 9

SELECT count(*) as total_rows FROM (
( SELECT pa.*
FROM phpfox_photo_album AS pa
     LEFT JOIN phpfox_like AS l
ON(l.type_id = 'photo_album' AND l.item_id = pa.album_id AND l.user_id = 0)

WHERE pa.view_id = 0 AND pa.total_photo > 0 AND pa.module_id is NULL AND pa.privacy IN(0) AND pa.profile_id = 0 AND pa.cover_id = 0 AND pa.timeline_id = 0

)) AS pa
     LEFT JOIN phpfox_photo AS p
ON(p.album_id = pa.album_id AND pa.view_id = 0 AND p.is_cover = 1)
     JOIN phpfox_user AS u
ON(u.user_id = pa.user_id)

SELECT COUNT(*)
FROM phpfox_photo
WHERE (type_id = 0 OR (type_id = 1 AND (parent_user_id = 0 OR group_id))) AND user_id = 0 AND is_profile_photo IN (0) AND is_cover_photo IN (0) AND (type_id = 0 OR (type_id = 1 AND group_id != 0))
LIMIT 1

SELECT COUNT(*)
FROM phpfox_photo_album
WHERE user_id = 0 AND (((profile_id > 0 OR cover_id > 0 OR timeline_id > 0) AND total_photo > 0) OR (profile_id = 0 AND cover_id = 0 AND timeline_id = 0))
LIMIT 1

SELECT pa.album_id
FROM phpfox_photo_album AS pa
     JOIN phpfox_user AS u
ON(u.user_id = pa.user_id)
     JOIN phpfox_better_ads_sponsor AS s
ON(s.item_id = pa.album_id)

WHERE pa.view_id = 0 AND pa.is_sponsor = 1 AND pa.total_photo > 0 AND s.module_id = "photo_album" AND s.is_active = 1 AND s.is_custom = 3 AND pa.module_id is NULL
ORDER BY rand()
LIMIT 100

SELECT pa.album_id
FROM phpfox_photo_album AS pa
     JOIN phpfox_user AS u
ON(u.user_id = pa.user_id)

WHERE pa.view_id = 0 AND pa.is_featured = 1 AND pa.total_photo > 0 AND pa.module_id is NULL
ORDER BY rand()
LIMIT 100