Selecting A Heathrow Taxi Service Provider

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 ('47276764b8952cd7395203564bab2275', 'c56fb43d525078d2aaf85f739d93f298', '0', '1575901525', '', '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 blog_track.item_id AS is_viewed, f.friend_id AS is_friend, l.like_id AS is_liked, blog.*, 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
FROM phpfox_blog AS blog
     LEFT JOIN phpfox_track AS blog_track
ON(blog_track.item_id = blog.blog_id AND type_id='blog' AND blog_track.ip_address = '18.205.60.226')
     LEFT JOIN phpfox_friend AS f
ON(f.user_id = blog.user_id AND f.friend_user_id = 0)
     LEFT JOIN phpfox_like AS l
ON(l.type_id = 'blog' AND l.item_id = blog.blog_id AND l.user_id = 0)
     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)

WHERE blog.blog_id = 382

INSERT INTO phpfox_track (type_id, item_id, ip_address, user_id, time_stamp) VALUES ('blog', '382', '18.205.60.226', '0', '1575901525')

UPDATE phpfox_blog SET total_view = total_view + 1 WHERE blog_id = '382'

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 (382) AND bc.is_active = 1
ORDER BY bc.parent_id ASC, bc.ordering ASC

SELECT tag_id, item_id, tag_text, tag_url
FROM phpfox_tag
WHERE tag_type =0 AND item_id = 382 AND category_id = 'blog'
LIMIT 10

SELECT tag_id, item_id, tag_text, tag_url
FROM phpfox_tag
WHERE tag_type =0 AND item_id = 382 AND category_id = 'blog'
LIMIT 10

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(*)
FROM phpfox_feed AS f
WHERE parent_module_id='blog' AND parent_feed_id=382
LIMIT 1

SELECT l.*, 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, a.time_stamp as action_time_stamp, f.friend_id AS is_friend
FROM phpfox_like AS l
     JOIN phpfox_user AS u
ON(u.user_id = l.user_id)
     LEFT JOIN phpfox_action AS a
ON(a.item_id = l.item_id AND a.user_id = l.user_id AND a.item_type_id = 'blog')
     LEFT JOIN phpfox_friend AS f
ON(f.friend_user_id = l.user_id AND f.user_id = 0)

WHERE (l.type_id = 'blog' OR l.type_id = 'blog') AND l.item_id = 382 AND l.user_id != 0
GROUP BY u.user_id, l.like_id, action_time_stamp
ORDER BY is_friend DESC , l.time_stamp DESC
LIMIT 2

SELECT COUNT(*)
FROM phpfox_feed AS f
WHERE parent_module_id='blog' AND parent_feed_id=382
LIMIT 1

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 (382) AND bc.is_active = 1
ORDER BY bc.parent_id ASC, bc.ordering ASC