Hyde N-Bar

SELECT COUNT(*)
FROM phpfox_block
WHERE m_connection = "ynblog.index"
LIMIT 1

SELECT COUNT(*)
FROM phpfox_block
WHERE m_connection = "ynblog.view"
LIMIT 1

SELECT COUNT(*)
FROM phpfox_block
WHERE m_connection = "ynblog.following"
LIMIT 1

DELETE FROM phpfox_log_session WHERE id_hash = '0d574f7196f9f96e319d05681455513d'

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 ('d0c805f885ab3276661abb2cc2049f16', '0d574f7196f9f96e319d05681455513d', '0', '1765536542', '', '0', '0', '0', '216.73.216.156', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.')

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.photo_id as cover_photo_exists, u.*, user_space.*, user_field.*, user_activity.*, ls.user_id AS is_online, ts.style_id AS designer_style_id, ts.folder AS designer_style_folder, t.folder AS designer_theme_folder, t.total_column, ts.l_width, ts.c_width, ts.r_width, t.parent_id AS theme_parent_id, ug.prefix, ug.suffix, ug.icon_ext, ug.title, uf.user_id as is_featured
FROM phpfox_user AS u
     JOIN phpfox_user_group AS ug
ON(ug.user_group_id = u.user_group_id)
     JOIN phpfox_user_space AS user_space
ON(user_space.user_id = u.user_id)
     JOIN phpfox_user_field AS user_field
ON(user_field.user_id = u.user_id)
     JOIN phpfox_user_activity AS user_activity
ON(user_activity.user_id = u.user_id)
     LEFT JOIN phpfox_theme_style AS ts
ON(ts.style_id = user_field.designer_style_id AND ts.is_active = 1)
     LEFT JOIN phpfox_theme AS t
ON(t.theme_id = ts.theme_id)
     LEFT JOIN phpfox_user_featured AS uf
ON(uf.user_id = u.user_id)
     LEFT JOIN phpfox_log_session AS ls
ON(ls.user_id = u.user_id AND ls.im_hide = 0)
     LEFT JOIN phpfox_photo AS p
ON(p.photo_id = user_field.cover_photo)

WHERE u.user_name = 'capital-dank-vape'

SELECT pu.*
FROM phpfox_pages_url AS pu
     JOIN phpfox_pages AS p
ON(p.page_id = pu.page_id)

WHERE pu.vanity_url = 'capital-dank-vape' AND p.item_type = 0

SELECT pu.*
FROM phpfox_pages_url AS pu
     JOIN phpfox_pages AS p
ON(p.page_id = pu.page_id)

WHERE pu.vanity_url = 'capital-dank-vape' AND p.item_type = 1

SELECT pu.*
FROM phpfox_pages_url AS pu
     JOIN phpfox_pages AS p
ON(p.page_id = pu.page_id)

WHERE pu.vanity_url = 'capital-dank-vape' AND p.item_type = 2

SELECT f.friend_id AS is_friend, p.*, u.user_image as image_path, p.image_path as pages_image_path, u.user_id as page_user_id, p.use_timeline, pc.claim_id, pc.enable_pos, pu.vanity_url, pg.name AS category_name, p_type.type_id as parent_category_id, pg.page_type, pt.text, pt.text_parsed, u.full_name, ts.style_id AS designer_style_id, ts.folder AS designer_style_folder, t.folder AS designer_theme_folder, t.total_column, ts.l_width, ts.c_width, ts.r_width, t.parent_id AS theme_parent_id,bl.locs_id, bl.locs_user_id, bl.locs_name, bl.locs_text, bl.locs_default, bl.locs_country_id, bl.country_iso, bl.country_child_id, bl.locs_state, bl.locs_city_id, bl.locs_city, bl.locs_zip, bl.locs_street, bl.locs_phone, bl.locs_fax, bl.locs_email, bl.locs_hr_mon_op, bl.locs_hr_mon_cl, bl.locs_hr_tue_op, bl.locs_hr_tue_cl, bl.locs_hr_wed_op, bl.locs_hr_wed_cl, bl.locs_hr_thu_op, bl.locs_hr_thu_cl, bl.locs_hr_fri_op, bl.locs_hr_fri_cl, bl.locs_hr_sat_op, bl.locs_hr_sat_cl, bl.locs_hr_sun_op, bl.locs_hr_sun_cl, bl.locs_mon_status, bl.locs_tue_status, bl.locs_wed_status, bl.locs_thu_status, bl.locs_fri_status, bl.locs_sat_status, bl.locs_sun_status, bl.locs_zone, bl.locs_zone_offsethrs, bl.locs_zone_offsetsecs, bl.locs_holiday_hours, bl.locs_views, bl.locs_comments, bl.locs_rating, bl.locs_ratings, bl.locs_can_rate, bl.locs_can_comment, bl.locs_user_list, bl.locs_gallery_album, bl.locs_hours_status, bl.locs_url_name, bl.locs_lon, bl.locs_lon_int, bl.locs_lat, bl.locs_lat_int, bl.locs_checkins, bl.locs_mobile, bl.locs_wheelchair, bl.locs_veteran ,bl.info_website,bl.locs_is_atm,bl.locs_accept_pickup,locs_accept_curbside,locs_accept_delivery,locs_provides,bl.locs_cash_type,bl.locs_enable_rating,bl.seo_title,bl.seo_keywords,bl.seo_description, p_type.name AS parent_category_name, u2.user_id AS owner_user_id, u2.profile_page_id AS owner_profile_page_id, u2.server_id AS owner_server_id, u2.user_name AS owner_user_name, u2.full_name AS owner_full_name, u2.gender AS owner_gender, u2.user_image AS owner_user_image, u2.is_invisible AS owner_is_invisible, u2.user_group_id AS owner_user_group_id, u2.language_id AS owner_language_id, u2.birthday AS owner_birthday, u2.country_iso AS owner_country_iso
FROM phpfox_pages AS p
     LEFT JOIN phpfox_friend AS f
ON(f.user_id = p.user_id AND f.friend_user_id = 8145)
     JOIN phpfox_pages_text AS pt
ON(pt.page_id = p.page_id)
     JOIN phpfox_user AS u
ON(u.profile_page_id = p.page_id)
     JOIN phpfox_user AS u2
ON(u2.user_id = p.user_id)
     LEFT JOIN phpfox_pages_url AS pu
ON(pu.page_id = p.page_id)
     LEFT JOIN phpfox_business_locations AS bl
ON(bl.page_id = p.page_id and bl.locs_name != "")
     LEFT JOIN phpfox_pages_category AS pg
ON(pg.category_id = p.category_id)
     LEFT JOIN phpfox_pages_type AS p_type
ON(p_type.type_id = pg.type_id)
     LEFT JOIN phpfox_theme_style AS ts
ON(ts.style_id = p.designer_style_id)
     LEFT JOIN phpfox_theme AS t
ON(t.theme_id = ts.theme_id)
     LEFT JOIN phpfox_pages_claim AS pc
ON(pc.page_id = p.page_id)

WHERE p.page_id = 8850 AND p.item_type = 2

SELECT *
FROM phpfox_pages_type
WHERE type_id = 33

SELECT user_group_id
FROM phpfox_user
WHERE user_id = 21126
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "can_display_map_header"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "can_view_street_address"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "can_view_phone"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "pf_group_add_cover_photo"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "hide_cover_image_area"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "can_upload_banner"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "can_view_website"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "business_show_hours"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "business_atm_on_premises"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "business_accept_pickups"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "business_accept_curbside"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "business_accept_delivery"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "business_wheel_chair_accesiable"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "business_show_vetaran"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "can_send_pm"
LIMIT 1

SELECT *
FROM phpfox_business_contact_page_settings
WHERE page_id = 8850 AND page_type = "business"

SELECT *
FROM phpfox_business_contact_page_settings
WHERE page_id = 8850 AND page_type = "business"

SELECT COUNT(*)
FROM phpfox_business_medicine
WHERE page_id = 8850 AND business_type IN (0,2) AND is_delete = 0
LIMIT 1

SELECT l.like_id AS is_liked, p.*, pu.vanity_url, pg.name AS category_name, pg.page_type
FROM phpfox_pages AS p
     LEFT JOIN phpfox_like AS l
ON(l.type_id = 'business' AND l.item_id = p.page_id AND l.user_id = 0)
     LEFT JOIN phpfox_pages_url AS pu
ON(pu.page_id = p.page_id)
     LEFT JOIN phpfox_pages_category AS pg
ON(pg.category_id = p.category_id)

WHERE p.page_id = 8850 AND p.item_type = 2

SELECT l.like_id AS is_liked, p.*, pu.vanity_url, pg.name AS category_name, pg.page_type
FROM phpfox_pages AS p
     LEFT JOIN phpfox_like AS l
ON(l.type_id = 'business' AND l.item_id = p.page_id AND l.user_id = 0)
     LEFT JOIN phpfox_pages_url AS pu
ON(pu.page_id = p.page_id)
     LEFT JOIN phpfox_pages_category AS pg
ON(pg.category_id = p.category_id)

WHERE p.page_id = 8850 AND p.item_type = 2

SELECT *
FROM phpfox_pages_perm
WHERE page_id = 8850

SELECT pw.*, pwt.text_parsed AS text
FROM phpfox_pages_widget AS pw
     JOIN phpfox_pages_widget_text AS pwt
ON(pwt.widget_id = pw.widget_id)

WHERE pw.page_id = 8850
ORDER BY pw.ordering ASC

SELECT user_group_id
FROM phpfox_user
WHERE user_id = 21126
LIMIT 1

SELECT ps.*,bcs.*,p.title as page_title,p.image_path as med_image
FROM phpfox_business_contact_settings AS bcs
     LEFT JOIN phpfox_business_contact_page_settings AS ps
ON(ps.contact_id = bcs.contact_id)
     LEFT JOIN phpfox_pages AS p
ON(p.page_id = bcs.page_id)

WHERE bcs.page_id = 8850 AND bcs.page_type = "business"

SELECT l.like_id AS is_liked, p.*, pu.vanity_url, pg.name AS category_name, pg.page_type
FROM phpfox_pages AS p
     LEFT JOIN phpfox_like AS l
ON(l.type_id = 'business' AND l.item_id = p.page_id AND l.user_id = 0)
     LEFT JOIN phpfox_pages_url AS pu
ON(pu.page_id = p.page_id)
     LEFT JOIN phpfox_pages_category AS pg
ON(pg.category_id = p.category_id)

WHERE p.page_id = 8850 AND p.item_type = 2

SELECT l.like_id AS is_liked, p.*, pu.vanity_url, pg.name AS category_name, pg.page_type
FROM phpfox_pages AS p
     LEFT JOIN phpfox_like AS l
ON(l.type_id = 'business' AND l.item_id = p.page_id AND l.user_id = 0)
     LEFT JOIN phpfox_pages_url AS pu
ON(pu.page_id = p.page_id)
     LEFT JOIN phpfox_pages_category AS pg
ON(pg.category_id = p.category_id)

WHERE p.page_id = 8850 AND p.item_type = 2

SELECT l.*,u.full_name,u.email as user_email
FROM phpfox_business_locations AS l
     JOIN phpfox_pages AS p
ON(p.page_id = l.page_id)
     JOIN phpfox_user AS u
ON(u.user_id = p.user_id)

WHERE l.page_id = 8850

SELECT ps.*,bcs.*,p.title as page_title,p.image_path as med_image
FROM phpfox_business_contact_settings AS bcs
     LEFT JOIN phpfox_business_contact_page_settings AS ps
ON(ps.contact_id = bcs.contact_id)
     LEFT JOIN phpfox_pages AS p
ON(p.page_id = bcs.page_id)

WHERE bcs.page_id = 8850 AND bcs.page_type = "inventory"

SELECT l.like_id AS is_liked, p.*, pu.vanity_url, pg.name AS category_name, pg.page_type
FROM phpfox_pages AS p
     LEFT JOIN phpfox_like AS l
ON(l.type_id = 'business' AND l.item_id = p.page_id AND l.user_id = 0)
     LEFT JOIN phpfox_pages_url AS pu
ON(pu.page_id = p.page_id)
     LEFT JOIN phpfox_pages_category AS pg
ON(pg.category_id = p.category_id)

WHERE p.page_id = 8850 AND p.item_type = 2

SELECT l.like_id AS is_liked, p.*, pu.vanity_url, pg.name AS category_name, pg.page_type
FROM phpfox_pages AS p
     LEFT JOIN phpfox_like AS l
ON(l.type_id = 'business' AND l.item_id = p.page_id AND l.user_id = 0)
     LEFT JOIN phpfox_pages_url AS pu
ON(pu.page_id = p.page_id)
     LEFT JOIN phpfox_pages_category AS pg
ON(pg.category_id = p.category_id)

WHERE p.page_id = 8850 AND p.item_type = 2

SELECT l.*,u.full_name,u.email as user_email
FROM phpfox_business_locations AS l
     JOIN phpfox_pages AS p
ON(p.page_id = l.page_id)
     JOIN phpfox_user AS u
ON(u.user_id = p.user_id)

WHERE l.page_id = 8850

SELECT l.like_id AS is_liked, p.*, pu.vanity_url, pg.name AS category_name, pg.page_type
FROM phpfox_pages AS p
     LEFT JOIN phpfox_like AS l
ON(l.type_id = 'business' AND l.item_id = p.page_id AND l.user_id = 0)
     LEFT JOIN phpfox_pages_url AS pu
ON(pu.page_id = p.page_id)
     LEFT JOIN phpfox_pages_category AS pg
ON(pg.category_id = p.category_id)

WHERE p.page_id = 8850 AND p.item_type = 2

SELECT user_group_id
FROM phpfox_user
WHERE user_id = 21126
LIMIT 1

SELECT med_id
FROM phpfox_business_medicine
WHERE page_id = 8850 AND name_url = "hyde-n-bar3205"
LIMIT 1

SELECT p.*,c.med_type,pages.title,pages.image_path as pages_image_path, pu.vanity_url,bl.locs_id, bl.locs_user_id, bl.locs_name, bl.locs_text, bl.locs_default, bl.locs_country_id, bl.country_iso, bl.country_child_id, bl.locs_state, bl.locs_city_id, bl.locs_city, bl.locs_zip, bl.locs_street, bl.locs_phone,bl.locs_wheelchair, bl.locs_veteran,bl.info_website,bl.locs_is_atm,bl.locs_accept_pickup,bl.locs_country_id, bl.country_iso, bl.country_child_id, bl.locs_state, bl.locs_city_id, bl.locs_city, bl.locs_zip, bl.locs_street, bl.locs_phone, bl.locs_fax, bl.locs_email,c.cat_name
FROM phpfox_business_medicine AS p
     LEFT JOIN phpfox_business_medicine_cat AS c
ON(c.cat_id = p.cat_id)
     JOIN phpfox_pages AS pages
ON(pages.page_id = p.page_id)
     LEFT JOIN phpfox_pages_url AS pu
ON(pu.page_id = p.page_id)
     JOIN phpfox_business_locations AS bl
ON(bl.page_id = p.page_id and bl.locs_name != "")

WHERE p.med_id = 2581

SELECT user_group_id
FROM phpfox_user
WHERE user_id = 21126
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "can_display_map_header"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "can_view_street_address"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "can_view_phone"
LIMIT 1

SELECT l.like_id AS is_liked, p.*, pu.vanity_url, pg.name AS category_name, pg.page_type
FROM phpfox_pages AS p
     LEFT JOIN phpfox_like AS l
ON(l.type_id = 'business' AND l.item_id = p.page_id AND l.user_id = 0)
     LEFT JOIN phpfox_pages_url AS pu
ON(pu.page_id = p.page_id)
     LEFT JOIN phpfox_pages_category AS pg
ON(pg.category_id = p.category_id)

WHERE p.page_id = 8850 AND p.item_type = 2

SELECT page_id
FROM phpfox_business_product
WHERE product_id = 3205
LIMIT 1

SELECT f.friend_id AS is_friend, p.*, u.user_image as image_path, p.image_path as pages_image_path, u.user_id as page_user_id, p.use_timeline, pc.claim_id, pc.enable_pos, pu.vanity_url, pg.name AS category_name, p_type.type_id as parent_category_id, pg.page_type, pt.text, pt.text_parsed, u.full_name, ts.style_id AS designer_style_id, ts.folder AS designer_style_folder, t.folder AS designer_theme_folder, t.total_column, ts.l_width, ts.c_width, ts.r_width, t.parent_id AS theme_parent_id,bl.locs_id, bl.locs_user_id, bl.locs_name, bl.locs_text, bl.locs_default, bl.locs_country_id, bl.country_iso, bl.country_child_id, bl.locs_state, bl.locs_city_id, bl.locs_city, bl.locs_zip, bl.locs_street, bl.locs_phone, bl.locs_fax, bl.locs_email, bl.locs_hr_mon_op, bl.locs_hr_mon_cl, bl.locs_hr_tue_op, bl.locs_hr_tue_cl, bl.locs_hr_wed_op, bl.locs_hr_wed_cl, bl.locs_hr_thu_op, bl.locs_hr_thu_cl, bl.locs_hr_fri_op, bl.locs_hr_fri_cl, bl.locs_hr_sat_op, bl.locs_hr_sat_cl, bl.locs_hr_sun_op, bl.locs_hr_sun_cl, bl.locs_mon_status, bl.locs_tue_status, bl.locs_wed_status, bl.locs_thu_status, bl.locs_fri_status, bl.locs_sat_status, bl.locs_sun_status, bl.locs_zone, bl.locs_zone_offsethrs, bl.locs_zone_offsetsecs, bl.locs_holiday_hours, bl.locs_views, bl.locs_comments, bl.locs_rating, bl.locs_ratings, bl.locs_can_rate, bl.locs_can_comment, bl.locs_user_list, bl.locs_gallery_album, bl.locs_hours_status, bl.locs_url_name, bl.locs_lon, bl.locs_lon_int, bl.locs_lat, bl.locs_lat_int, bl.locs_checkins, bl.locs_mobile, bl.locs_wheelchair, bl.locs_veteran ,bl.info_website,bl.locs_is_atm,bl.locs_accept_pickup,locs_accept_curbside,locs_accept_delivery,locs_provides,bl.locs_cash_type,bl.locs_enable_rating,bl.seo_title,bl.seo_keywords,bl.seo_description, p_type.name AS parent_category_name, u2.user_id AS owner_user_id, u2.profile_page_id AS owner_profile_page_id, u2.server_id AS owner_server_id, u2.user_name AS owner_user_name, u2.full_name AS owner_full_name, u2.gender AS owner_gender, u2.user_image AS owner_user_image, u2.is_invisible AS owner_is_invisible, u2.user_group_id AS owner_user_group_id, u2.language_id AS owner_language_id, u2.birthday AS owner_birthday, u2.country_iso AS owner_country_iso
FROM phpfox_pages AS p
     LEFT JOIN phpfox_friend AS f
ON(f.user_id = p.user_id AND f.friend_user_id = 8145)
     JOIN phpfox_pages_text AS pt
ON(pt.page_id = p.page_id)
     JOIN phpfox_user AS u
ON(u.profile_page_id = p.page_id)
     JOIN phpfox_user AS u2
ON(u2.user_id = p.user_id)
     LEFT JOIN phpfox_pages_url AS pu
ON(pu.page_id = p.page_id)
     LEFT JOIN phpfox_business_locations AS bl
ON(bl.page_id = p.page_id and bl.locs_name != "")
     LEFT JOIN phpfox_pages_category AS pg
ON(pg.category_id = p.category_id)
     LEFT JOIN phpfox_pages_type AS p_type
ON(p_type.type_id = pg.type_id)
     LEFT JOIN phpfox_theme_style AS ts
ON(ts.style_id = p.designer_style_id)
     LEFT JOIN phpfox_theme AS t
ON(t.theme_id = ts.theme_id)
     LEFT JOIN phpfox_pages_claim AS pc
ON(pc.page_id = p.page_id)

WHERE p.page_id = 8850 AND p.item_type = 2

SELECT user_group_id
FROM phpfox_user
WHERE user_id = 21126
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "can_display_map_header"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "can_view_street_address"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "can_view_phone"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "pf_group_add_cover_photo"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "hide_cover_image_area"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "can_upload_banner"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "can_view_website"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "business_show_hours"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "business_atm_on_premises"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "business_accept_pickups"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "business_accept_curbside"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "business_accept_delivery"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "business_wheel_chair_accesiable"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "business_show_vetaran"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "can_send_pm"
LIMIT 1

SELECT *
FROM phpfox_business_contact_page_settings
WHERE page_id = 8850 AND page_type = "business"

SELECT *
FROM phpfox_business_contact_page_settings
WHERE page_id = 8850 AND page_type = "business"

SELECT COUNT(*)
FROM phpfox_business_medicine
WHERE page_id = 8850 AND business_type IN (0,2) AND is_delete = 0
LIMIT 1

SELECT l.like_id AS is_liked, p.*, pu.vanity_url, pg.name AS category_name, pg.page_type
FROM phpfox_pages AS p
     LEFT JOIN phpfox_like AS l
ON(l.type_id = 'business' AND l.item_id = p.page_id AND l.user_id = 0)
     LEFT JOIN phpfox_pages_url AS pu
ON(pu.page_id = p.page_id)
     LEFT JOIN phpfox_pages_category AS pg
ON(pg.category_id = p.category_id)

WHERE p.page_id = 8850 AND p.item_type = 2

SELECT f.friend_id AS is_friend, p.*, u.user_image as image_path, p.image_path as pages_image_path, u.user_id as page_user_id, p.use_timeline, pc.claim_id, pc.enable_pos, pu.vanity_url, pg.name AS category_name, p_type.type_id as parent_category_id, pg.page_type, pt.text, pt.text_parsed, u.full_name, ts.style_id AS designer_style_id, ts.folder AS designer_style_folder, t.folder AS designer_theme_folder, t.total_column, ts.l_width, ts.c_width, ts.r_width, t.parent_id AS theme_parent_id,bl.locs_id, bl.locs_user_id, bl.locs_name, bl.locs_text, bl.locs_default, bl.locs_country_id, bl.country_iso, bl.country_child_id, bl.locs_state, bl.locs_city_id, bl.locs_city, bl.locs_zip, bl.locs_street, bl.locs_phone, bl.locs_fax, bl.locs_email, bl.locs_hr_mon_op, bl.locs_hr_mon_cl, bl.locs_hr_tue_op, bl.locs_hr_tue_cl, bl.locs_hr_wed_op, bl.locs_hr_wed_cl, bl.locs_hr_thu_op, bl.locs_hr_thu_cl, bl.locs_hr_fri_op, bl.locs_hr_fri_cl, bl.locs_hr_sat_op, bl.locs_hr_sat_cl, bl.locs_hr_sun_op, bl.locs_hr_sun_cl, bl.locs_mon_status, bl.locs_tue_status, bl.locs_wed_status, bl.locs_thu_status, bl.locs_fri_status, bl.locs_sat_status, bl.locs_sun_status, bl.locs_zone, bl.locs_zone_offsethrs, bl.locs_zone_offsetsecs, bl.locs_holiday_hours, bl.locs_views, bl.locs_comments, bl.locs_rating, bl.locs_ratings, bl.locs_can_rate, bl.locs_can_comment, bl.locs_user_list, bl.locs_gallery_album, bl.locs_hours_status, bl.locs_url_name, bl.locs_lon, bl.locs_lon_int, bl.locs_lat, bl.locs_lat_int, bl.locs_checkins, bl.locs_mobile, bl.locs_wheelchair, bl.locs_veteran ,bl.info_website,bl.locs_is_atm,bl.locs_accept_pickup,locs_accept_curbside,locs_accept_delivery,locs_provides,bl.locs_cash_type,bl.locs_enable_rating,bl.seo_title,bl.seo_keywords,bl.seo_description, p_type.name AS parent_category_name, u2.user_id AS owner_user_id, u2.profile_page_id AS owner_profile_page_id, u2.server_id AS owner_server_id, u2.user_name AS owner_user_name, u2.full_name AS owner_full_name, u2.gender AS owner_gender, u2.user_image AS owner_user_image, u2.is_invisible AS owner_is_invisible, u2.user_group_id AS owner_user_group_id, u2.language_id AS owner_language_id, u2.birthday AS owner_birthday, u2.country_iso AS owner_country_iso
FROM phpfox_pages AS p
     LEFT JOIN phpfox_friend AS f
ON(f.user_id = p.user_id AND f.friend_user_id = 8145)
     JOIN phpfox_pages_text AS pt
ON(pt.page_id = p.page_id)
     JOIN phpfox_user AS u
ON(u.profile_page_id = p.page_id)
     JOIN phpfox_user AS u2
ON(u2.user_id = p.user_id)
     LEFT JOIN phpfox_pages_url AS pu
ON(pu.page_id = p.page_id)
     LEFT JOIN phpfox_business_locations AS bl
ON(bl.page_id = p.page_id and bl.locs_name != "")
     LEFT JOIN phpfox_pages_category AS pg
ON(pg.category_id = p.category_id)
     LEFT JOIN phpfox_pages_type AS p_type
ON(p_type.type_id = pg.type_id)
     LEFT JOIN phpfox_theme_style AS ts
ON(ts.style_id = p.designer_style_id)
     LEFT JOIN phpfox_theme AS t
ON(t.theme_id = ts.theme_id)
     LEFT JOIN phpfox_pages_claim AS pc
ON(pc.page_id = p.page_id)

WHERE p.page_id = 8850 AND p.item_type = 2

SELECT user_group_id
FROM phpfox_user
WHERE user_id = 21126
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "can_display_map_header"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "can_view_street_address"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "can_view_phone"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "pf_group_add_cover_photo"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "hide_cover_image_area"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "can_upload_banner"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "can_view_website"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "business_show_hours"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "business_atm_on_premises"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "business_accept_pickups"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "business_accept_curbside"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "business_accept_delivery"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "business_wheel_chair_accesiable"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "business_show_vetaran"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "can_send_pm"
LIMIT 1

SELECT *
FROM phpfox_business_contact_page_settings
WHERE page_id = 8850 AND page_type = "business"

SELECT *
FROM phpfox_business_contact_page_settings
WHERE page_id = 8850 AND page_type = "business"

SELECT COUNT(*)
FROM phpfox_business_medicine
WHERE page_id = 8850 AND business_type IN (0,2) AND is_delete = 0
LIMIT 1

SELECT l.like_id AS is_liked, p.*, pu.vanity_url, pg.name AS category_name, pg.page_type
FROM phpfox_pages AS p
     LEFT JOIN phpfox_like AS l
ON(l.type_id = 'business' AND l.item_id = p.page_id AND l.user_id = 0)
     LEFT JOIN phpfox_pages_url AS pu
ON(pu.page_id = p.page_id)
     LEFT JOIN phpfox_pages_category AS pg
ON(pg.category_id = p.category_id)

WHERE p.page_id = 8850 AND p.item_type = 2

SELECT *
FROM phpfox_business_medicine_cat
WHERE status = 1 AND business_type IN (1,2) AND is_cbd = 0
ORDER BY cat_name ASC

SELECT m.*,p.user_id as business_user_id,p.medicine_feature,bmc.cat_name,bmc.med_type,fi.expire_date
FROM phpfox_business_medicine AS m
     JOIN phpfox_pages AS p
ON(p.page_id = m.page_id)
     LEFT JOIN phpfox_business_medicine_cat AS bmc
ON(bmc.cat_id = m.cat_id)
     LEFT JOIN phpfox_business_medicine_feature_invoice AS fi
ON(fi.med_id = m.med_id AND fi.invoice_id = (
SELECT MAX(invoice_id)
FROM phpfox_business_medicine_feature_invoice z
WHERE z.med_id = fi.med_id ))

WHERE m.page_id = 8850 AND m.is_active = 1 AND m.cat_id =50 AND m.business_type = 0
GROUP BY m.med_id
ORDER BY m.name ASC

SELECT m.*,p.user_id as business_user_id,p.medicine_feature,bmc.cat_name,bmc.med_type,fi.expire_date
FROM phpfox_business_medicine AS m
     JOIN phpfox_pages AS p
ON(p.page_id = m.page_id)
     LEFT JOIN phpfox_business_medicine_cat AS bmc
ON(bmc.cat_id = m.cat_id)
     LEFT JOIN phpfox_business_medicine_feature_invoice AS fi
ON(fi.med_id = m.med_id AND fi.invoice_id = (
SELECT MAX(invoice_id)
FROM phpfox_business_medicine_feature_invoice z
WHERE z.med_id = fi.med_id ))

WHERE m.page_id = 8850 AND m.is_active = 1 AND m.cat_id =76 AND m.business_type = 0
GROUP BY m.med_id
ORDER BY m.name ASC

SELECT m.*,p.user_id as business_user_id,p.medicine_feature,bmc.cat_name,bmc.med_type,fi.expire_date
FROM phpfox_business_medicine AS m
     JOIN phpfox_pages AS p
ON(p.page_id = m.page_id)
     LEFT JOIN phpfox_business_medicine_cat AS bmc
ON(bmc.cat_id = m.cat_id)
     LEFT JOIN phpfox_business_medicine_feature_invoice AS fi
ON(fi.med_id = m.med_id AND fi.invoice_id = (
SELECT MAX(invoice_id)
FROM phpfox_business_medicine_feature_invoice z
WHERE z.med_id = fi.med_id ))

WHERE m.page_id = 8850 AND m.is_active = 1 AND m.cat_id =74 AND m.business_type = 0
GROUP BY m.med_id
ORDER BY m.name ASC

SELECT m.*,p.user_id as business_user_id,p.medicine_feature,bmc.cat_name,bmc.med_type,fi.expire_date
FROM phpfox_business_medicine AS m
     JOIN phpfox_pages AS p
ON(p.page_id = m.page_id)
     LEFT JOIN phpfox_business_medicine_cat AS bmc
ON(bmc.cat_id = m.cat_id)
     LEFT JOIN phpfox_business_medicine_feature_invoice AS fi
ON(fi.med_id = m.med_id AND fi.invoice_id = (
SELECT MAX(invoice_id)
FROM phpfox_business_medicine_feature_invoice z
WHERE z.med_id = fi.med_id ))

WHERE m.page_id = 8850 AND m.is_active = 1 AND m.cat_id =78 AND m.business_type = 0
GROUP BY m.med_id
ORDER BY m.name ASC

SELECT m.*,p.user_id as business_user_id,p.medicine_feature,bmc.cat_name,bmc.med_type,fi.expire_date
FROM phpfox_business_medicine AS m
     JOIN phpfox_pages AS p
ON(p.page_id = m.page_id)
     LEFT JOIN phpfox_business_medicine_cat AS bmc
ON(bmc.cat_id = m.cat_id)
     LEFT JOIN phpfox_business_medicine_feature_invoice AS fi
ON(fi.med_id = m.med_id AND fi.invoice_id = (
SELECT MAX(invoice_id)
FROM phpfox_business_medicine_feature_invoice z
WHERE z.med_id = fi.med_id ))

WHERE m.page_id = 8850 AND m.is_active = 1 AND m.cat_id =9 AND m.business_type = 0
GROUP BY m.med_id
ORDER BY m.name ASC

SELECT m.*,p.user_id as business_user_id,p.medicine_feature,bmc.cat_name,bmc.med_type,fi.expire_date
FROM phpfox_business_medicine AS m
     JOIN phpfox_pages AS p
ON(p.page_id = m.page_id)
     LEFT JOIN phpfox_business_medicine_cat AS bmc
ON(bmc.cat_id = m.cat_id)
     LEFT JOIN phpfox_business_medicine_feature_invoice AS fi
ON(fi.med_id = m.med_id AND fi.invoice_id = (
SELECT MAX(invoice_id)
FROM phpfox_business_medicine_feature_invoice z
WHERE z.med_id = fi.med_id ))

WHERE m.page_id = 8850 AND m.is_active = 1 AND m.cat_id =73 AND m.business_type = 0
GROUP BY m.med_id
ORDER BY m.name ASC

SELECT m.*,p.user_id as business_user_id,p.medicine_feature,bmc.cat_name,bmc.med_type,fi.expire_date
FROM phpfox_business_medicine AS m
     JOIN phpfox_pages AS p
ON(p.page_id = m.page_id)
     LEFT JOIN phpfox_business_medicine_cat AS bmc
ON(bmc.cat_id = m.cat_id)
     LEFT JOIN phpfox_business_medicine_feature_invoice AS fi
ON(fi.med_id = m.med_id AND fi.invoice_id = (
SELECT MAX(invoice_id)
FROM phpfox_business_medicine_feature_invoice z
WHERE z.med_id = fi.med_id ))

WHERE m.page_id = 8850 AND m.is_active = 1 AND m.cat_id =42 AND m.business_type = 0
GROUP BY m.med_id
ORDER BY m.name ASC

SELECT m.*,p.user_id as business_user_id,p.medicine_feature,bmc.cat_name,bmc.med_type,fi.expire_date
FROM phpfox_business_medicine AS m
     JOIN phpfox_pages AS p
ON(p.page_id = m.page_id)
     LEFT JOIN phpfox_business_medicine_cat AS bmc
ON(bmc.cat_id = m.cat_id)
     LEFT JOIN phpfox_business_medicine_feature_invoice AS fi
ON(fi.med_id = m.med_id AND fi.invoice_id = (
SELECT MAX(invoice_id)
FROM phpfox_business_medicine_feature_invoice z
WHERE z.med_id = fi.med_id ))

WHERE m.page_id = 8850 AND m.is_active = 1 AND m.cat_id =47 AND m.business_type = 0
GROUP BY m.med_id
ORDER BY m.name ASC

SELECT m.*,p.user_id as business_user_id,p.medicine_feature,bmc.cat_name,bmc.med_type,fi.expire_date
FROM phpfox_business_medicine AS m
     JOIN phpfox_pages AS p
ON(p.page_id = m.page_id)
     LEFT JOIN phpfox_business_medicine_cat AS bmc
ON(bmc.cat_id = m.cat_id)
     LEFT JOIN phpfox_business_medicine_feature_invoice AS fi
ON(fi.med_id = m.med_id AND fi.invoice_id = (
SELECT MAX(invoice_id)
FROM phpfox_business_medicine_feature_invoice z
WHERE z.med_id = fi.med_id ))

WHERE m.page_id = 8850 AND m.is_active = 1 AND m.cat_id =55 AND m.business_type = 0
GROUP BY m.med_id
ORDER BY m.name ASC

SELECT m.*,p.user_id as business_user_id,p.medicine_feature,bmc.cat_name,bmc.med_type,fi.expire_date
FROM phpfox_business_medicine AS m
     JOIN phpfox_pages AS p
ON(p.page_id = m.page_id)
     LEFT JOIN phpfox_business_medicine_cat AS bmc
ON(bmc.cat_id = m.cat_id)
     LEFT JOIN phpfox_business_medicine_feature_invoice AS fi
ON(fi.med_id = m.med_id AND fi.invoice_id = (
SELECT MAX(invoice_id)
FROM phpfox_business_medicine_feature_invoice z
WHERE z.med_id = fi.med_id ))

WHERE m.page_id = 8850 AND m.is_active = 1 AND m.cat_id =53 AND m.business_type = 0
GROUP BY m.med_id
ORDER BY m.name ASC

SELECT m.*,p.user_id as business_user_id,p.medicine_feature,bmc.cat_name,bmc.med_type,fi.expire_date
FROM phpfox_business_medicine AS m
     JOIN phpfox_pages AS p
ON(p.page_id = m.page_id)
     LEFT JOIN phpfox_business_medicine_cat AS bmc
ON(bmc.cat_id = m.cat_id)
     LEFT JOIN phpfox_business_medicine_feature_invoice AS fi
ON(fi.med_id = m.med_id AND fi.invoice_id = (
SELECT MAX(invoice_id)
FROM phpfox_business_medicine_feature_invoice z
WHERE z.med_id = fi.med_id ))

WHERE m.page_id = 8850 AND m.is_active = 1 AND m.cat_id =52 AND m.business_type = 0
GROUP BY m.med_id
ORDER BY m.name ASC

SELECT m.*,p.user_id as business_user_id,p.medicine_feature,bmc.cat_name,bmc.med_type,fi.expire_date
FROM phpfox_business_medicine AS m
     JOIN phpfox_pages AS p
ON(p.page_id = m.page_id)
     LEFT JOIN phpfox_business_medicine_cat AS bmc
ON(bmc.cat_id = m.cat_id)
     LEFT JOIN phpfox_business_medicine_feature_invoice AS fi
ON(fi.med_id = m.med_id AND fi.invoice_id = (
SELECT MAX(invoice_id)
FROM phpfox_business_medicine_feature_invoice z
WHERE z.med_id = fi.med_id ))

WHERE m.page_id = 8850 AND m.is_active = 1 AND m.cat_id =49 AND m.business_type = 0
GROUP BY m.med_id
ORDER BY m.name ASC

SELECT m.*,p.user_id as business_user_id,p.medicine_feature,bmc.cat_name,bmc.med_type,fi.expire_date
FROM phpfox_business_medicine AS m
     JOIN phpfox_pages AS p
ON(p.page_id = m.page_id)
     LEFT JOIN phpfox_business_medicine_cat AS bmc
ON(bmc.cat_id = m.cat_id)
     LEFT JOIN phpfox_business_medicine_feature_invoice AS fi
ON(fi.med_id = m.med_id AND fi.invoice_id = (
SELECT MAX(invoice_id)
FROM phpfox_business_medicine_feature_invoice z
WHERE z.med_id = fi.med_id ))

WHERE m.page_id = 8850 AND m.is_active = 1 AND m.cat_id =54 AND m.business_type = 0
GROUP BY m.med_id
ORDER BY m.name ASC

SELECT m.*,p.user_id as business_user_id,p.medicine_feature,bmc.cat_name,bmc.med_type,fi.expire_date
FROM phpfox_business_medicine AS m
     JOIN phpfox_pages AS p
ON(p.page_id = m.page_id)
     LEFT JOIN phpfox_business_medicine_cat AS bmc
ON(bmc.cat_id = m.cat_id)
     LEFT JOIN phpfox_business_medicine_feature_invoice AS fi
ON(fi.med_id = m.med_id AND fi.invoice_id = (
SELECT MAX(invoice_id)
FROM phpfox_business_medicine_feature_invoice z
WHERE z.med_id = fi.med_id ))

WHERE m.page_id = 8850 AND m.is_active = 1 AND m.cat_id =46 AND m.business_type = 0
GROUP BY m.med_id
ORDER BY m.name ASC

SELECT m.*,p.user_id as business_user_id,p.medicine_feature,bmc.cat_name,bmc.med_type,fi.expire_date
FROM phpfox_business_medicine AS m
     JOIN phpfox_pages AS p
ON(p.page_id = m.page_id)
     LEFT JOIN phpfox_business_medicine_cat AS bmc
ON(bmc.cat_id = m.cat_id)
     LEFT JOIN phpfox_business_medicine_feature_invoice AS fi
ON(fi.med_id = m.med_id AND fi.invoice_id = (
SELECT MAX(invoice_id)
FROM phpfox_business_medicine_feature_invoice z
WHERE z.med_id = fi.med_id ))

WHERE m.page_id = 8850 AND m.is_active = 1 AND m.cat_id =75 AND m.business_type = 0
GROUP BY m.med_id
ORDER BY m.name ASC

SELECT m.*,p.user_id as business_user_id,p.medicine_feature,bmc.cat_name,bmc.med_type,fi.expire_date
FROM phpfox_business_medicine AS m
     JOIN phpfox_pages AS p
ON(p.page_id = m.page_id)
     LEFT JOIN phpfox_business_medicine_cat AS bmc
ON(bmc.cat_id = m.cat_id)
     LEFT JOIN phpfox_business_medicine_feature_invoice AS fi
ON(fi.med_id = m.med_id AND fi.invoice_id = (
SELECT MAX(invoice_id)
FROM phpfox_business_medicine_feature_invoice z
WHERE z.med_id = fi.med_id ))

WHERE m.page_id = 8850 AND m.is_active = 1 AND m.cat_id =45 AND m.business_type = 0
GROUP BY m.med_id
ORDER BY m.name ASC

SELECT m.*,p.user_id as business_user_id,p.medicine_feature,bmc.cat_name,bmc.med_type,fi.expire_date
FROM phpfox_business_medicine AS m
     JOIN phpfox_pages AS p
ON(p.page_id = m.page_id)
     LEFT JOIN phpfox_business_medicine_cat AS bmc
ON(bmc.cat_id = m.cat_id)
     LEFT JOIN phpfox_business_medicine_feature_invoice AS fi
ON(fi.med_id = m.med_id AND fi.invoice_id = (
SELECT MAX(invoice_id)
FROM phpfox_business_medicine_feature_invoice z
WHERE z.med_id = fi.med_id ))

WHERE m.page_id = 8850 AND m.is_active = 1 AND m.cat_id =51 AND m.business_type = 0
GROUP BY m.med_id
ORDER BY m.name ASC

SELECT bmo.*
FROM phpfox_business_med_main_order AS bmo
WHERE bmo.user_id = 0 AND bmo.ip_addr = "61ec621d1973df90e007176a405a43c1" AND bmo.order_complete = 0

SELECT ps.*,bcs.*,p.title as page_title,p.image_path as med_image
FROM phpfox_business_contact_settings AS bcs
     LEFT JOIN phpfox_business_contact_page_settings AS ps
ON(ps.contact_id = bcs.contact_id)
     LEFT JOIN phpfox_pages AS p
ON(p.page_id = bcs.page_id)

WHERE bcs.page_id = 8850 AND bcs.page_type = "business"

SELECT l.like_id AS is_liked, p.*, pu.vanity_url, pg.name AS category_name, pg.page_type
FROM phpfox_pages AS p
     LEFT JOIN phpfox_like AS l
ON(l.type_id = 'business' AND l.item_id = p.page_id AND l.user_id = 0)
     LEFT JOIN phpfox_pages_url AS pu
ON(pu.page_id = p.page_id)
     LEFT JOIN phpfox_pages_category AS pg
ON(pg.category_id = p.category_id)

WHERE p.page_id = 8850 AND p.item_type = 2

SELECT l.like_id AS is_liked, p.*, pu.vanity_url, pg.name AS category_name, pg.page_type
FROM phpfox_pages AS p
     LEFT JOIN phpfox_like AS l
ON(l.type_id = 'business' AND l.item_id = p.page_id AND l.user_id = 0)
     LEFT JOIN phpfox_pages_url AS pu
ON(pu.page_id = p.page_id)
     LEFT JOIN phpfox_pages_category AS pg
ON(pg.category_id = p.category_id)

WHERE p.page_id = 8850 AND p.item_type = 2

SELECT l.*,u.full_name,u.email as user_email
FROM phpfox_business_locations AS l
     JOIN phpfox_pages AS p
ON(p.page_id = l.page_id)
     JOIN phpfox_user AS u
ON(u.user_id = p.user_id)

WHERE l.page_id = 8850

SELECT r.ratingId, r.med_id, r.user_id, r.ratingNumber, r.title, r.comments, r.created, r.modified,r.approved, 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_business_medicine_rating AS r
     JOIN phpfox_user AS u
ON(u.user_id = r.user_id)

WHERE r.med_id = 2581
ORDER BY r.ratingId DESC

SELECT r.*, 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_business_medicine_rating AS r
     JOIN phpfox_user AS u
ON(u.user_id = r.user_id)

WHERE r.med_id = 2581 AND r.user_id = 0

SELECT *
FROM phpfox_business_sms_authorization
WHERE page_id = 8850

SELECT r.url, r.replacement, r.rewrite_id
FROM phpfox_rewrite AS r
ORDER BY rewrite_id DESC

SELECT s.*
FROM phpfox_ynadvmenusys_global_settings AS s
WHERE 1=1

SELECT s.*
FROM phpfox_ynadvmenusys_global_settings AS s
WHERE 1=1

SELECT sa.*
FROM phpfox_business_seo_datas AS sa
WHERE sa.page_type = "business.medview"

SELECT s.*
FROM phpfox_ynadvmenusys_global_settings AS s
WHERE 1=1

SELECT s.*
FROM phpfox_ynadvmenusys_mini_menu_setting AS s
WHERE 1=1

SELECT COUNT(*)
FROM phpfox_pages AS p
WHERE p.user_id = 0
LIMIT 1

SELECT p.*,bl.locs_city, pt.name as type_name, pc.name as category_name,ptext.text, ptext.text_parsed, ph.destination as cover_image_path, ph.server_id as cover_image_server_id, pu.vanity_url, u.server_id,pcl.enable_pos, 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_pages AS p
     JOIN phpfox_user AS u
ON(u.user_id = p.user_id)
     JOIN phpfox_pages_text AS ptext
ON(ptext.page_id = p.page_id)
     LEFT JOIN phpfox_business_locations AS bl
ON(bl.page_id = p.page_id)
     LEFT JOIN phpfox_pages_url AS pu
ON(pu.page_id = p.page_id)
     LEFT JOIN phpfox_photo AS ph
ON(ph.photo_id = p.cover_photo_id)
     LEFT JOIN phpfox_pages_type AS pt
ON(p.type_id = pt.type_id)
     LEFT JOIN phpfox_pages_category AS pc
ON(p.category_id = pc.category_id)
     LEFT JOIN phpfox_pages_claim AS pcl
ON(pcl.page_id = p.page_id)

WHERE p.user_id = 0
GROUP BY p.page_id
ORDER BY p.time_stamp DESC
LIMIT 50

SELECT COUNT(*)
FROM phpfox_business_pos_settings AS pos
     JOIN phpfox_pages AS p
ON(p.page_id = pos.page_id)

WHERE pos.user_id = 0
LIMIT 1

SELECT pos.employee_id,p.*,bl.locs_city, pt.name as type_name, pc.name as category_name,ptext.text, ptext.text_parsed, ph.destination as cover_image_path, ph.server_id as cover_image_server_id, pu.vanity_url, u.server_id, 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_business_pos_settings AS pos
     JOIN phpfox_pages AS p
ON(p.page_id = pos.page_id)
     JOIN phpfox_user AS u
ON(u.user_id = p.user_id)
     JOIN phpfox_pages_text AS ptext
ON(ptext.page_id = p.page_id)
     LEFT JOIN phpfox_business_locations AS bl
ON(bl.page_id = p.page_id)
     LEFT JOIN phpfox_pages_url AS pu
ON(pu.page_id = p.page_id)
     LEFT JOIN phpfox_photo AS ph
ON(ph.photo_id = p.cover_photo_id)
     LEFT JOIN phpfox_pages_type AS pt
ON(p.type_id = pt.type_id)
     LEFT JOIN phpfox_pages_category AS pc
ON(p.category_id = pc.category_id)

WHERE pos.user_id = 0 AND p.user_id != 0
LIMIT 1 OFF SET 0

SELECT COUNT(*)
FROM phpfox_pages_claim AS pc
     JOIN phpfox_pages AS p1
ON(p1.page_id = pc.page_id AND p1.item_type = 2)

WHERE pc.status_id = 1
LIMIT 1

SELECT p.*
FROM phpfox_pages AS p
WHERE p.is_claimed = 1 AND p.enable_mypurchase_page= 1 AND p.user_id = 0
ORDER BY p.page_id ASC
LIMIT 1

SELECT p.*
FROM phpfox_pages AS p
WHERE p.is_claimed = 1 AND p.enable_catalog_page= 1 AND p.user_id = 0
ORDER BY p.page_id ASC
LIMIT 1

SELECT p.*
FROM phpfox_pages AS p
WHERE p.is_claimed = 1 AND p.user_id = 0
ORDER BY p.page_id ASC
LIMIT 1

SELECT bus.*
FROM phpfox_business_contact_user_inventory_settings AS bus
     JOIN phpfox_pages AS p
ON(p.page_id = bus.page_id)

WHERE p.is_claimed = 1 AND bus.can_access_contact_management = 1 AND bus.user_id = 0
ORDER BY bus.settings_id ASC
LIMIT 1

SELECT bus.*
FROM phpfox_business_contact_user_inventory_settings AS bus
     JOIN phpfox_pages AS p
ON(p.page_id = bus.page_id)

WHERE p.is_claimed = 1 AND bus.dashboard = 1 AND bus.user_id = 0
ORDER BY bus.settings_id ASC
LIMIT 1

SELECT user_group_id
FROM phpfox_user
WHERE user_id = 0
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "can_view_catalog_page"
LIMIT 1

SELECT bmo.*
FROM phpfox_business_med_main_order AS bmo
WHERE bmo.user_id = 0 AND bmo.ip_addr = "61ec621d1973df90e007176a405a43c1" AND bmo.order_complete = 0

SELECT s.*
FROM phpfox_ynadvmenusys_global_settings AS s
WHERE 1=1

SELECT COUNT(*)
FROM phpfox_pages AS p
WHERE p.user_id = 0
LIMIT 1

SELECT p.*,bl.locs_city, pt.name as type_name, pc.name as category_name,ptext.text, ptext.text_parsed, ph.destination as cover_image_path, ph.server_id as cover_image_server_id, pu.vanity_url, u.server_id,pcl.enable_pos, 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_pages AS p
     JOIN phpfox_user AS u
ON(u.user_id = p.user_id)
     JOIN phpfox_pages_text AS ptext
ON(ptext.page_id = p.page_id)
     LEFT JOIN phpfox_business_locations AS bl
ON(bl.page_id = p.page_id)
     LEFT JOIN phpfox_pages_url AS pu
ON(pu.page_id = p.page_id)
     LEFT JOIN phpfox_photo AS ph
ON(ph.photo_id = p.cover_photo_id)
     LEFT JOIN phpfox_pages_type AS pt
ON(p.type_id = pt.type_id)
     LEFT JOIN phpfox_pages_category AS pc
ON(p.category_id = pc.category_id)
     LEFT JOIN phpfox_pages_claim AS pcl
ON(pcl.page_id = p.page_id)

WHERE p.user_id = 0
GROUP BY p.page_id
ORDER BY p.time_stamp DESC
LIMIT 50

SELECT COUNT(*)
FROM phpfox_business_pos_settings AS pos
     JOIN phpfox_pages AS p
ON(p.page_id = pos.page_id)

WHERE pos.user_id = 0
LIMIT 1

SELECT pos.employee_id,p.*,bl.locs_city, pt.name as type_name, pc.name as category_name,ptext.text, ptext.text_parsed, ph.destination as cover_image_path, ph.server_id as cover_image_server_id, pu.vanity_url, u.server_id, 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_business_pos_settings AS pos
     JOIN phpfox_pages AS p
ON(p.page_id = pos.page_id)
     JOIN phpfox_user AS u
ON(u.user_id = p.user_id)
     JOIN phpfox_pages_text AS ptext
ON(ptext.page_id = p.page_id)
     LEFT JOIN phpfox_business_locations AS bl
ON(bl.page_id = p.page_id)
     LEFT JOIN phpfox_pages_url AS pu
ON(pu.page_id = p.page_id)
     LEFT JOIN phpfox_photo AS ph
ON(ph.photo_id = p.cover_photo_id)
     LEFT JOIN phpfox_pages_type AS pt
ON(p.type_id = pt.type_id)
     LEFT JOIN phpfox_pages_category AS pc
ON(p.category_id = pc.category_id)

WHERE pos.user_id = 0 AND p.user_id != 0
LIMIT 1 OFF SET 0

SELECT COUNT(*)
FROM phpfox_pages_claim AS pc
     JOIN phpfox_pages AS p1
ON(p1.page_id = pc.page_id AND p1.item_type = 2)

WHERE pc.status_id = 1
LIMIT 1

SELECT p.*
FROM phpfox_pages AS p
WHERE p.is_claimed = 1 AND p.enable_mypurchase_page= 1 AND p.user_id = 0
ORDER BY p.page_id ASC
LIMIT 1

SELECT p.*
FROM phpfox_pages AS p
WHERE p.is_claimed = 1 AND p.enable_catalog_page= 1 AND p.user_id = 0
ORDER BY p.page_id ASC
LIMIT 1

SELECT p.*
FROM phpfox_pages AS p
WHERE p.is_claimed = 1 AND p.user_id = 0
ORDER BY p.page_id ASC
LIMIT 1

SELECT bus.*
FROM phpfox_business_contact_user_inventory_settings AS bus
     JOIN phpfox_pages AS p
ON(p.page_id = bus.page_id)

WHERE p.is_claimed = 1 AND bus.can_access_contact_management = 1 AND bus.user_id = 0
ORDER BY bus.settings_id ASC
LIMIT 1

SELECT bus.*
FROM phpfox_business_contact_user_inventory_settings AS bus
     JOIN phpfox_pages AS p
ON(p.page_id = bus.page_id)

WHERE p.is_claimed = 1 AND bus.dashboard = 1 AND bus.user_id = 0
ORDER BY bus.settings_id ASC
LIMIT 1

SELECT user_group_id
FROM phpfox_user
WHERE user_id = 0
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "can_view_catalog_page"
LIMIT 1

SELECT bmo.*
FROM phpfox_business_med_main_order AS bmo
WHERE bmo.user_id = 0 AND bmo.ip_addr = "61ec621d1973df90e007176a405a43c1" AND bmo.order_complete = 0

SELECT ts.*, t.folder AS theme_folder
FROM phpfox_theme_style AS ts
     JOIN phpfox_theme AS t
ON(t.theme_id = ts.theme_id AND t.is_active = 1)

WHERE ts.is_default = 1

SELECT s.*
FROM phpfox_ynadvmenusys_global_settings AS s
WHERE 1=1

SELECT s.*
FROM phpfox_ynadvmenusys_global_settings AS s
WHERE 1=1

SELECT ym.*
FROM phpfox_ynadvmenusys_menu AS ym
WHERE ym.parent_menu_id = 0 AND ym.is_enabled = 1
ORDER BY order_menu

SELECT ym.*
FROM phpfox_ynadvmenusys_menu AS ym
WHERE ym.parent_menu_id = 1 AND ym.is_enabled = 1
ORDER BY order_menu

SELECT ym.*
FROM phpfox_ynadvmenusys_menu AS ym
WHERE ym.parent_menu_id = 2 AND ym.is_enabled = 1
ORDER BY order_menu

SELECT ym.*
FROM phpfox_ynadvmenusys_menu AS ym
WHERE ym.parent_menu_id = 45 AND ym.is_enabled = 1
ORDER BY order_menu

SELECT ymc.*,ym.title as menu_title,ym.level_menu
FROM phpfox_ynadvmenusys_menu_content AS ymc
     JOIN phpfox_ynadvmenusys_menu AS ym
ON(ym.menu_id = ymc.menu_id)

WHERE ymc.menu_id = 3 AND ymc.is_enabled = 1
ORDER BY ymc.order_content ASC
LIMIT 10

SELECT ym.*
FROM phpfox_ynadvmenusys_menu AS ym
WHERE ym.parent_menu_id = 3 AND ym.is_enabled = 1
ORDER BY order_menu

SELECT ym.*
FROM phpfox_ynadvmenusys_menu AS ym
WHERE ym.parent_menu_id = 54 AND ym.is_enabled = 1
ORDER BY order_menu

SELECT ym.*
FROM phpfox_ynadvmenusys_menu AS ym
WHERE ym.parent_menu_id = 55 AND ym.is_enabled = 1
ORDER BY order_menu

SELECT ym.*
FROM phpfox_ynadvmenusys_menu AS ym
WHERE ym.parent_menu_id = 56 AND ym.is_enabled = 1
ORDER BY order_menu

SELECT ym.*
FROM phpfox_ynadvmenusys_menu AS ym
WHERE ym.parent_menu_id = 24 AND ym.is_enabled = 1
ORDER BY order_menu

SELECT ym.*
FROM phpfox_ynadvmenusys_menu AS ym
WHERE ym.parent_menu_id = 20 AND ym.is_enabled = 1
ORDER BY order_menu

SELECT ym.*
FROM phpfox_ynadvmenusys_menu AS ym
WHERE ym.parent_menu_id = 49 AND ym.is_enabled = 1
ORDER BY order_menu

SELECT ym.*
FROM phpfox_ynadvmenusys_menu AS ym
WHERE ym.parent_menu_id = 50 AND ym.is_enabled = 1
ORDER BY order_menu

SELECT ym.*
FROM phpfox_ynadvmenusys_menu AS ym
WHERE ym.parent_menu_id = 51 AND ym.is_enabled = 1
ORDER BY order_menu

SELECT ym.*
FROM phpfox_ynadvmenusys_menu AS ym
WHERE ym.parent_menu_id = 48 AND ym.is_enabled = 1
ORDER BY order_menu

SELECT ym.*
FROM phpfox_ynadvmenusys_menu AS ym
WHERE ym.parent_menu_id = 52 AND ym.is_enabled = 1
ORDER BY order_menu

SELECT user_group_id
FROM phpfox_user
WHERE user_id = 21126
LIMIT 1

SELECT l.like_id AS is_liked, p.*, pu.vanity_url, pg.name AS category_name, pg.page_type
FROM phpfox_pages AS p
     LEFT JOIN phpfox_like AS l
ON(l.type_id = 'business' AND l.item_id = p.page_id AND l.user_id = 0)
     LEFT JOIN phpfox_pages_url AS pu
ON(pu.page_id = p.page_id)
     LEFT JOIN phpfox_pages_category AS pg
ON(pg.category_id = p.category_id)

WHERE p.page_id = 8850 AND p.item_type = 2

SELECT l.like_id AS is_liked, p.*, pu.vanity_url, pg.name AS category_name, pg.page_type
FROM phpfox_pages AS p
     LEFT JOIN phpfox_like AS l
ON(l.type_id = 'business' AND l.item_id = p.page_id AND l.user_id = 0)
     LEFT JOIN phpfox_pages_url AS pu
ON(pu.page_id = p.page_id)
     LEFT JOIN phpfox_pages_category AS pg
ON(pg.category_id = p.category_id)

WHERE p.page_id = 8850 AND p.item_type = 2

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "integrate_video_with_business"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "can_view_medicine"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "business_can_add_cbd"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "can_add_document"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "business_doctor_appointment_form"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "can_view_product"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "can_view_product"
LIMIT 1

SELECT user_group_id
FROM phpfox_user
WHERE user_id = 21126
LIMIT 1

SELECT pu.*
FROM phpfox_pages_url AS pu
     JOIN phpfox_pages AS p
ON(p.page_id = pu.page_id)

WHERE pu.vanity_url = 'capital-dank-vape' AND p.item_type = 2

SELECT lik.like_id AS is_liked, f.friend_id AS is_friend, 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, p.*, pi.*, pa.name AS album_url, pa.name AS album_title, pa.profile_id AS album_profile_id, pa.cover_id AS album_cover_id, pa.timeline_id AS album_timeline_id
FROM phpfox_photo AS p
     LEFT JOIN phpfox_like AS lik
ON(lik.type_id = 'photo' AND lik.item_id = p.photo_id AND lik.user_id = 0)
     LEFT JOIN phpfox_friend AS f
ON(f.user_id = p.user_id AND f.friend_user_id = 0)
     JOIN phpfox_user AS u
ON(u.user_id = p.user_id)
     LEFT JOIN phpfox_photo_info AS pi
ON(pi.photo_id = p.photo_id)
     LEFT JOIN phpfox_photo_album AS pa
ON(pa.album_id = p.album_id)

WHERE p.photo_id = 2018

SELECT tag.tag_id, tag.item_id, tag.tag_text, tag.tag_url
FROM phpfox_tag AS tag
WHERE tag.item_id = '2018' AND tag.category_id = 'photo' AND tag.tag_type = '0'
LIMIT 10

SELECT pc.parent_id, pc.category_id, pc.name
FROM phpfox_photo_category_data AS pcd
     JOIN phpfox_photo_category AS pc
ON(pc.category_id = pcd.category_id)

WHERE pcd.photo_id = 2018 AND pc.is_active = 1
ORDER BY pc.parent_id ASC, pc.ordering ASC

SELECT feed_id
FROM phpfox_feed
WHERE type_id="photo" AND item_id=2018
LIMIT 1

SELECT user_group_id
FROM phpfox_user
WHERE user_id = 21126
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "business_page_feature_amount_tier_1"
LIMIT 1

SELECT *
FROM phpfox_business_contact_user_inventory_settings
WHERE user_id = 0 AND page_id = 8850

SELECT upload_profile_image
FROM phpfox_business_contact_user_business_settings
WHERE user_id = 0 AND page_id = 8850
LIMIT 1

SELECT p.*, pu.vanity_url, pt.text, pc.page_type, p_type.item_type,bl.locs_lon, bl.locs_lat, bl.locs_id,bl.locs_name, bl.country_iso,bl.locs_city, bl.locs_zip, bl.locs_street,bl.country_child_id,bl.locs_accept_pickup,bl.locs_accept_curbside,bl.locs_accept_delivery,bl.locs_provides,bl.locs_hr_mon_op, bl.locs_hr_mon_cl, bl.locs_hr_tue_op, bl.locs_hr_tue_cl, bl.locs_hr_wed_op, bl.locs_hr_wed_cl, bl.locs_hr_thu_op, bl.locs_hr_thu_cl, bl.locs_hr_fri_op, bl.locs_hr_fri_cl, bl.locs_hr_sat_op, bl.locs_hr_sat_cl, bl.locs_hr_sun_op, bl.locs_hr_sun_cl, bl.locs_mon_status, bl.locs_tue_status, bl.locs_wed_status, bl.locs_thu_status, bl.locs_fri_status, bl.locs_sat_status, bl.locs_sun_status, bl.locs_zone,bl.locs_phone,bl.locs_wheelchair, bl.locs_veteran ,bl.info_website,bl.locs_is_atm,bl.locs_hours_status,u.user_group_id, u.full_name
FROM phpfox_pages AS p
     JOIN phpfox_pages_text AS pt
ON(pt.page_id = p.page_id)
     JOIN phpfox_user AS u
ON(u.user_id = p.user_id)
     LEFT JOIN phpfox_pages_category AS pc
ON(p.category_id = pc.category_id)
     LEFT JOIN phpfox_pages_type AS p_type
ON(p_type.type_id = pc.type_id)
     LEFT JOIN phpfox_pages_url AS pu
ON(pu.page_id = p.page_id)
     JOIN phpfox_business_locations AS bl
ON(bl.page_id = p.page_id and bl.locs_name != "")

WHERE p.page_id = 8850

SELECT user_group_id
FROM phpfox_mapping
WHERE cat = 33 AND sub_cat LIKE "%0%"
LIMIT 1

SELECT user_group_id
FROM phpfox_user
WHERE user_id = 21126
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "can_display_map_header"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "can_view_street_address"
LIMIT 1

SELECT us.value_actual
FROM phpfox_user_group_setting AS ugs
     JOIN phpfox_user_setting AS us
ON(us.user_group_id = '37' AND us.setting_id = ugs.setting_id)

WHERE ugs.name = "can_view_phone"
LIMIT 1

SELECT r.ratingId, r.page_id, r.user_id, r.ratingNumber, r.title, r.comments, r.created, r.modified, 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_business_rating AS r
     JOIN phpfox_user AS u
ON(u.user_id = r.user_id)

WHERE r.page_id = 8850

SELECT COUNT(*)
FROM phpfox_business_medicine
WHERE page_id = 8850 AND business_type IN (0,2) AND is_delete = 0
LIMIT 1

SELECT *
FROM phpfox_business_contact_page_settings
WHERE page_id = 8850 AND page_type = "business"

SELECT COUNT(*)
FROM phpfox_map_purchase
WHERE status = 1 AND user_id = 21126
LIMIT 1

SELECT image_path
FROM phpfox_maps
WHERE user_group_id =37
LIMIT 1

SELECT upload_cover_image
FROM phpfox_business_contact_user_business_settings
WHERE user_id = 0 AND page_id = 8850
LIMIT 1

SELECT *
FROM phpfox_advancedfooter_menu
WHERE parent_id = 0 AND is_active = 1 AND category_id <> 0
ORDER BY ordering ASC

SELECT *
FROM phpfox_advancedfooter_menu
WHERE parent_id = 1 AND is_active = 1 AND category_id <> 0
ORDER BY ordering ASC

SELECT *
FROM phpfox_advancedfooter_menu
WHERE parent_id = 3 AND is_active = 1 AND category_id <> 0
ORDER BY ordering ASC

SELECT *
FROM phpfox_advancedfooter_menu
WHERE parent_id = 4 AND is_active = 1 AND category_id <> 0
ORDER BY ordering ASC

SELECT *
FROM phpfox_advancedfooter_menu
WHERE parent_id = 5 AND is_active = 1 AND category_id <> 0
ORDER BY ordering ASC

SELECT *
FROM phpfox_advancedfooter_menu
WHERE parent_id = 6 AND is_active = 1 AND category_id <> 0
ORDER BY ordering ASC

SELECT *
FROM phpfox_advancedfooter_menu
WHERE parent_id = 7 AND is_active = 1 AND category_id <> 0
ORDER BY ordering ASC

SELECT *
FROM phpfox_advancedfooter_menu
WHERE parent_id = 8 AND is_active = 1 AND category_id <> 0
ORDER BY ordering ASC

SELECT *
FROM phpfox_advancedfooter_menu
WHERE parent_id = 2 AND is_active = 1 AND category_id <> 0
ORDER BY ordering ASC

SELECT *
FROM phpfox_advancedfooter_category
WHERE is_active = 1
ORDER BY ordering ASC

SELECT u.*,uf.total_view,uf.total_friend
FROM phpfox_user_field AS uf
     JOIN phpfox_user AS u
ON(u.user_id = uf.user_id)

WHERE u.status_id = 0 AND u.view_id = 0
ORDER BY u.user_id DESC
LIMIT 15