Topic: seo friendly website development

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 ('61136059d50b7dd2595b2902404c4242', 'c56fb43d525078d2aaf85f739d93f298', '0', '1575901613', '', '0', '0', '0', '18.205.60.226', '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 = 'seo friendly website development' 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')

WHERE blog.is_approved = 1 AND blog.post_status = 1 AND blog.privacy IN(0) AND (tag.tag_text = 'seo friendly website development' AND tag.tag_type = 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_tag AS tag
ON(tag.item_id = blog.blog_id AND tag.category_id = 'blog')

WHERE blog.is_approved = 1 AND blog.post_status = 1 AND blog.privacy IN(0) AND (tag.tag_text = 'seo friendly website development' AND tag.tag_type = 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 bc.parent_id, bc.category_id, bc.name
FROM phpfox_blog_category_data AS bcd
     JOIN phpfox_blog_category AS bc
ON(bc.category_id = bcd.category_id)

WHERE bcd.blog_id IN (362) AND bc.is_active = 1
ORDER BY bc.parent_id ASC, bc.ordering ASC

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 = '4'
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 = '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

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

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

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