Blogs

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 ('75763da734dc465bb810b2bb962739eb', 'c56fb43d525078d2aaf85f739d93f298', '0', '1579879490', '', '0', '0', '0', '18.210.24.208', '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 *, COUNT(item_id) AS total
FROM phpfox_tag
WHERE category_id = 'blog' AND tag_url = 'precast+concrete+fence+denver' AND tag_type = 0
GROUP BY tag_id

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_tag AS tag
ON(tag.item_id = blog.blog_id AND tag.category_id = 'blog')
     JOIN phpfox_blog_text AS blog_text
ON(blog_text.blog_id = blog.blog_id)

WHERE blog.is_approved = 1 AND blog.post_status = 1 AND blog.privacy IN(0) AND 0 AND blog.module_id IN ("blog") AND blog.time_stamp >= 1579478400 AND blog.time_stamp <= 1580083199
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_tag AS tag
ON(tag.item_id = blog.blog_id AND tag.category_id = 'blog')
     JOIN phpfox_blog_text AS blog_text
ON(blog_text.blog_id = blog.blog_id)

WHERE blog.is_approved = 1 AND blog.post_status = 1 AND blog.privacy IN(0) AND 0 AND blog.module_id IN ("blog") AND blog.time_stamp >= 1579478400 AND blog.time_stamp <= 1580083199
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 = '4497'
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 = '245'
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 = '4491'
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 = '115'
LIMIT 1

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