Society

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 ('9fb9b69410660c5768fdea5acc90b3ec', 'c56fb43d525078d2aaf85f739d93f298', '0', '1579404082', '', '0', '0', '0', '3.233.219.101', '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 COUNT(blog_id)
FROM phpfox_blog
WHERE user_id = 0
LIMIT 1

SELECT COUNT(*)
FROM phpfox_blog
WHERE user_id = 0 AND post_status = 2
LIMIT 1

SELECT bc.*, bc2.name AS parent_name
FROM phpfox_blog_category AS bc
     LEFT JOIN phpfox_blog_category AS bc2
ON(bc2.category_id = bc.parent_id)

WHERE bc.category_id = '8' AND bc.is_active = '1'

SELECT blog_text.text_parsed AS text, 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, blog.*
FROM (
( SELECT blog.*
FROM phpfox_blog AS blog
INNER      JOIN phpfox_blog_category_data AS blog_category_data
ON(blog_category_data.blog_id = blog.blog_id)
INNER      JOIN phpfox_blog_category AS blog_category
ON(blog_category.category_id = blog_category_data.category_id)

WHERE blog.is_approved = 1 AND blog.post_status = 1 AND blog.privacy IN(0) AND blog_category.category_id = 8 AND blog_category.user_id = 0 AND blog.module_id IN ("blog")
ORDER BY blog.time_stamp DESC
LIMIT 12

)) AS blog
     JOIN phpfox_blog_text AS blog_text
ON(blog_text.blog_id = blog.blog_id)
     JOIN phpfox_user AS u
ON(u.user_id = blog.user_id)

ORDER BY blog.time_stamp DESC
LIMIT 12

SELECT count(*) as total_rows FROM (
( SELECT blog.*
FROM phpfox_blog AS blog
INNER      JOIN phpfox_blog_category_data AS blog_category_data
ON(blog_category_data.blog_id = blog.blog_id)
INNER      JOIN phpfox_blog_category AS blog_category
ON(blog_category.category_id = blog_category_data.category_id)

WHERE blog.is_approved = 1 AND blog.post_status = 1 AND blog.privacy IN(0) AND blog_category.category_id = 8 AND blog_category.user_id = 0 AND blog.module_id IN ("blog")
ORDER BY blog.time_stamp DESC
LIMIT 12

)) AS blog
     JOIN phpfox_blog_text AS blog_text
ON(blog_text.blog_id = blog.blog_id)
     JOIN phpfox_user AS u
ON(u.user_id = blog.user_id)

SELECT b.blog_id
FROM phpfox_blog AS b
WHERE b.is_featured = 1 AND b.module_id IN ("blog")
LIMIT 100

SELECT b.blog_id
FROM phpfox_blog AS b
WHERE b.is_sponsor = 1 AND b.module_id IN ("blog")
LIMIT 100

SELECT cover_photo
FROM phpfox_user_field
WHERE user_id = '117'
LIMIT 1

SELECT cover_photo
FROM phpfox_user_field
WHERE user_id = '242'
LIMIT 1

SELECT cover_photo
FROM phpfox_user_field
WHERE user_id = '234'
LIMIT 1

SELECT cover_photo
FROM phpfox_user_field
WHERE user_id = '82'
LIMIT 1

SELECT cover_photo
FROM phpfox_user_field
WHERE user_id = '4'
LIMIT 1

SELECT cover_photo
FROM phpfox_user_field
WHERE user_id = '245'
LIMIT 1

SELECT cover_photo
FROM phpfox_user_field
WHERE user_id = '80'
LIMIT 1

SELECT cover_photo
FROM phpfox_user_field
WHERE user_id = '42'
LIMIT 1

SELECT cover_photo
FROM phpfox_user_field
WHERE user_id = '115'
LIMIT 1

SELECT cover_photo
FROM phpfox_user_field
WHERE user_id = '27'
LIMIT 1