View Mayday Growery Cannabis Products

Sort By Weight:

Price:

No Product Found

phpFox Developers Debug Toggle JavaScript Console

Debug Details

Version:

4.8.7

Product Code Name:

Neutron

Total Time:

0.3338990

PHP General Time:

0.1972515

GZIP:

enabled

Driver Version:

MySQL 8.0.44

SQL Time:

0.1366475

SQL Queries:

184

SQL Memory Usage:

3.43 Mb

SQL Slave Enabled:

SQL Total Slaves:

N/A

SQL Slave Server:

N/A

Database Connection:

0.00057291984558105

Total Memory Usage:

28.78 Mb

Total Memory Usage (Including Debug):

28.78 Mb

Memory Limit:

0.5 b (-1)

Load Balancing Enabled:

Requests From:

208.109.189.212

Server Time Stamp:

December 12, 2025, 2:43 am

PHP Version:

7.4.33

PHP Sapi:

cgi-fcgi

PHP safe_mode:

false

PHP open_basedir:

false

Operating System:

Linux

Cache:

file

SQL Queries

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 ('98b88c32496eacea642017ecbe972e9c', '0d574f7196f9f96e319d05681455513d', '0', '1765529015', '', '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 = 'mayday-growery'

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

WHERE pu.vanity_url = 'mayday-growery' 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 = 'mayday-growery' 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 = 'mayday-growery' 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 = 8892 AND p.item_type = 2

SELECT *
FROM phpfox_pages_type
WHERE type_id = 36

SELECT user_group_id
FROM phpfox_user
WHERE user_id = 9576
LIMIT 1

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

WHERE ugs.name = "can_display_map_header"
LIMIT 1

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

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

SELECT COUNT(*)
FROM phpfox_business_medicine
WHERE page_id = 8892 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 = 8892 AND p.item_type = 2

SELECT *
FROM phpfox_pages_perm
WHERE page_id = 8892

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 = 8892
ORDER BY pw.ordering ASC

SELECT user_group_id
FROM phpfox_user
WHERE user_id = 9576
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 = 8892 AND bcs.page_type = "business"

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 = 8892

SELECT user_group_id
FROM phpfox_user
WHERE user_id = 9576
LIMIT 1

SELECT apps_id
FROM phpfox_apps
WHERE apps_alias='product'
LIMIT 1

SELECT COUNT(*)
FROM phpfox_business_product
WHERE page_id = 8892
LIMIT 1

SELECT *
FROM phpfox_business_product_cat
WHERE parent_id = 0 AND status =1 AND is_cbd = 0

SELECT *
FROM phpfox_business_product_cat
WHERE parent_id = 4 AND status =1

SELECT COUNT(*)
FROM phpfox_business_product AS bp
JOIN phpfox_pages AS p
ON(p.page_id = bp.page_id)

WHERE bp.cat_id IN (4,13,12,14,46,47) AND bp.enable_product = 1 AND p.is_claimed = 1 AND bp.page_id = 8892 AND p.only_for_admin = 0
LIMIT 1

SELECT *
FROM phpfox_business_product_cat
WHERE parent_id = 7 AND status =1

SELECT COUNT(*)
FROM phpfox_business_product AS bp
JOIN phpfox_pages AS p
ON(p.page_id = bp.page_id)

WHERE bp.cat_id IN (7,15,16,17,18,19,20,21,60,127) AND bp.enable_product = 1 AND p.is_claimed = 1 AND bp.page_id = 8892 AND p.only_for_admin = 0
LIMIT 1

SELECT *
FROM phpfox_business_product_cat
WHERE parent_id = 9 AND status =1

SELECT COUNT(*)
FROM phpfox_business_product AS bp
JOIN phpfox_pages AS p
ON(p.page_id = bp.page_id)

WHERE bp.cat_id IN (9,38,39,40,41,42) AND bp.enable_product = 1 AND p.is_claimed = 1 AND bp.page_id = 8892 AND p.only_for_admin = 0
LIMIT 1

SELECT *
FROM phpfox_business_product_cat
WHERE parent_id = 10 AND status =1

SELECT COUNT(*)
FROM phpfox_business_product AS bp
JOIN phpfox_pages AS p
ON(p.page_id = bp.page_id)

WHERE bp.cat_id IN (10,44,22,23,24,25,26,57) AND bp.enable_product = 1 AND p.is_claimed = 1 AND bp.page_id = 8892 AND p.only_for_admin = 0
LIMIT 1

SELECT *
FROM phpfox_business_product_cat
WHERE parent_id = 31 AND status =1

SELECT COUNT(*)
FROM phpfox_business_product AS bp
JOIN phpfox_pages AS p
ON(p.page_id = bp.page_id)

WHERE bp.cat_id IN (31) AND bp.enable_product = 1 AND p.is_claimed = 1 AND bp.page_id = 8892 AND p.only_for_admin = 0
LIMIT 1

SELECT *
FROM phpfox_business_product_cat
WHERE parent_id = 32 AND status =1

SELECT COUNT(*)
FROM phpfox_business_product AS bp
JOIN phpfox_pages AS p
ON(p.page_id = bp.page_id)

WHERE bp.cat_id IN (32,33,34,35,36,37) AND bp.enable_product = 1 AND p.is_claimed = 1 AND bp.page_id = 8892 AND p.only_for_admin = 0
LIMIT 1

SELECT *
FROM phpfox_business_product_cat
WHERE parent_id = 43 AND status =1

SELECT COUNT(*)
FROM phpfox_business_product AS bp
JOIN phpfox_pages AS p
ON(p.page_id = bp.page_id)

WHERE bp.cat_id IN (43) AND bp.enable_product = 1 AND p.is_claimed = 1 AND bp.page_id = 8892 AND p.only_for_admin = 0
LIMIT 1

SELECT *
FROM phpfox_business_product_cat
WHERE parent_id = 48 AND status =1

SELECT COUNT(*)
FROM phpfox_business_product AS bp
JOIN phpfox_pages AS p
ON(p.page_id = bp.page_id)

WHERE bp.cat_id IN (48,49,50,51,52,53,54,55,56,58,59) AND bp.enable_product = 1 AND p.is_claimed = 1 AND bp.page_id = 8892 AND p.only_for_admin = 0
LIMIT 1

SELECT *
FROM phpfox_business_product_cat
WHERE parent_id = 72 AND status =1

SELECT COUNT(*)
FROM phpfox_business_product AS bp
JOIN phpfox_pages AS p
ON(p.page_id = bp.page_id)

WHERE bp.cat_id IN (72) AND bp.enable_product = 1 AND p.is_claimed = 1 AND bp.page_id = 8892 AND p.only_for_admin = 0
LIMIT 1

SELECT *
FROM phpfox_business_product_cat
WHERE parent_id = 68 AND status =1

SELECT COUNT(*)
FROM phpfox_business_product AS bp
JOIN phpfox_pages AS p
ON(p.page_id = bp.page_id)

WHERE bp.cat_id IN (68) AND bp.enable_product = 1 AND p.is_claimed = 1 AND bp.page_id = 8892 AND p.only_for_admin = 0
LIMIT 1

SELECT *
FROM phpfox_business_product_cat
WHERE parent_id = 70 AND status =1

SELECT COUNT(*)
FROM phpfox_business_product AS bp
JOIN phpfox_pages AS p
ON(p.page_id = bp.page_id)

WHERE bp.cat_id IN (70) AND bp.enable_product = 1 AND p.is_claimed = 1 AND bp.page_id = 8892 AND p.only_for_admin = 0
LIMIT 1

SELECT *
FROM phpfox_business_product_cat
WHERE parent_id = 71 AND status =1

SELECT COUNT(*)
FROM phpfox_business_product AS bp
JOIN phpfox_pages AS p
ON(p.page_id = bp.page_id)

WHERE bp.cat_id IN (71) AND bp.enable_product = 1 AND p.is_claimed = 1 AND bp.page_id = 8892 AND p.only_for_admin = 0
LIMIT 1

SELECT *
FROM phpfox_business_product_cat
WHERE parent_id = 114 AND status =1

SELECT COUNT(*)
FROM phpfox_business_product AS bp
JOIN phpfox_pages AS p
ON(p.page_id = bp.page_id)

WHERE bp.cat_id IN (114) AND bp.enable_product = 1 AND p.is_claimed = 1 AND bp.page_id = 8892 AND p.only_for_admin = 0
LIMIT 1

SELECT *
FROM phpfox_business_product_cat
WHERE parent_id = 113 AND status =1

SELECT COUNT(*)
FROM phpfox_business_product AS bp
JOIN phpfox_pages AS p
ON(p.page_id = bp.page_id)

WHERE bp.cat_id IN (113) AND bp.enable_product = 1 AND p.is_claimed = 1 AND bp.page_id = 8892 AND p.only_for_admin = 0
LIMIT 1

SELECT *
FROM phpfox_business_product_cat
WHERE parent_id = 111 AND status =1

SELECT COUNT(*)
FROM phpfox_business_product AS bp
JOIN phpfox_pages AS p
ON(p.page_id = bp.page_id)

WHERE bp.cat_id IN (111,100,101,102,103,104,105,106,107,108,109) AND bp.enable_product = 1 AND p.is_claimed = 1 AND bp.page_id = 8892 AND p.only_for_admin = 0
LIMIT 1

SELECT *
FROM phpfox_business_product_cat
WHERE parent_id = 115 AND status =1

SELECT COUNT(*)
FROM phpfox_business_product AS bp
JOIN phpfox_pages AS p
ON(p.page_id = bp.page_id)

WHERE bp.cat_id IN (115) AND bp.enable_product = 1 AND p.is_claimed = 1 AND bp.page_id = 8892 AND p.only_for_admin = 0
LIMIT 1

SELECT *
FROM phpfox_business_product_cat
WHERE parent_id = 116 AND status =1

SELECT COUNT(*)
FROM phpfox_business_product AS bp
JOIN phpfox_pages AS p
ON(p.page_id = bp.page_id)

WHERE bp.cat_id IN (116) AND bp.enable_product = 1 AND p.is_claimed = 1 AND bp.page_id = 8892 AND p.only_for_admin = 0
LIMIT 1

SELECT *
FROM phpfox_business_product_cat
WHERE parent_id = 117 AND status =1

SELECT COUNT(*)
FROM phpfox_business_product AS bp
JOIN phpfox_pages AS p
ON(p.page_id = bp.page_id)

WHERE bp.cat_id IN (117) AND bp.enable_product = 1 AND p.is_claimed = 1 AND bp.page_id = 8892 AND p.only_for_admin = 0
LIMIT 1

SELECT *
FROM phpfox_business_product_cat
WHERE parent_id = 118 AND status =1

SELECT COUNT(*)
FROM phpfox_business_product AS bp
JOIN phpfox_pages AS p
ON(p.page_id = bp.page_id)

WHERE bp.cat_id IN (118) AND bp.enable_product = 1 AND p.is_claimed = 1 AND bp.page_id = 8892 AND p.only_for_admin = 0
LIMIT 1

SELECT *
FROM phpfox_business_product_cat
WHERE parent_id = 119 AND status =1

SELECT COUNT(*)
FROM phpfox_business_product AS bp
JOIN phpfox_pages AS p
ON(p.page_id = bp.page_id)

WHERE bp.cat_id IN (119) AND bp.enable_product = 1 AND p.is_claimed = 1 AND bp.page_id = 8892 AND p.only_for_admin = 0
LIMIT 1

SELECT *
FROM phpfox_business_product_cat
WHERE parent_id = 128 AND status =1

SELECT COUNT(*)
FROM phpfox_business_product AS bp
JOIN phpfox_pages AS p
ON(p.page_id = bp.page_id)

WHERE bp.cat_id IN (128) AND bp.enable_product = 1 AND p.is_claimed = 1 AND bp.page_id = 8892 AND p.only_for_admin = 0
LIMIT 1

SELECT *
FROM phpfox_business_product_cat
WHERE parent_id = 123 AND status =1

SELECT COUNT(*)
FROM phpfox_business_product AS bp
JOIN phpfox_pages AS p
ON(p.page_id = bp.page_id)

WHERE bp.cat_id IN (123) AND bp.enable_product = 1 AND p.is_claimed = 1 AND bp.page_id = 8892 AND p.only_for_admin = 0
LIMIT 1

SELECT *
FROM phpfox_business_product_cat
WHERE parent_id = 129 AND status =1

SELECT COUNT(*)
FROM phpfox_business_product AS bp
JOIN phpfox_pages AS p
ON(p.page_id = bp.page_id)

WHERE bp.cat_id IN (129) AND bp.enable_product = 1 AND p.is_claimed = 1 AND bp.page_id = 8892 AND p.only_for_admin = 0
LIMIT 1

SELECT *
FROM phpfox_business_product_cat
WHERE parent_id = 130 AND status =1

SELECT COUNT(*)
FROM phpfox_business_product AS bp
JOIN phpfox_pages AS p
ON(p.page_id = bp.page_id)

WHERE bp.cat_id IN (130) AND bp.enable_product = 1 AND p.is_claimed = 1 AND bp.page_id = 8892 AND p.only_for_admin = 0
LIMIT 1

SELECT p.title,p.page_id
FROM phpfox_business_product AS bp
JOIN phpfox_pages AS p
ON(p.page_id = bp.page_id)

WHERE p.type_id = 36 AND p.is_claimed = 1 AND p.only_for_admin = 0
GROUP BY p.page_id

SELECT *
FROM phpfox_business_sms_authorization
WHERE page_id = 8892

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.view"

SELECT COUNT(*)
FROM phpfox_business_product AS m
LEFT JOIN phpfox_business_product_cat AS c
ON(c.cat_id = m.cat_id)
JOIN phpfox_pages AS p
ON(p.page_id = m.page_id)

WHERE m.page_id = 8892 AND (m.enable_product = 1 ) AND p.type_id = 36
LIMIT 1

SELECT m.*,p.user_id as business_user_id,p.product_feature,p.page_feature,c.cat_name,c.med_type,bl.locs_accept_pickup,bl.locs_city,p.title as bus_title,fi.expire_date, 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_product AS m
     JOIN phpfox_pages AS p
ON(p.page_id = m.page_id)
     JOIN phpfox_business_locations AS bl
ON(bl.page_id = p.page_id)
     LEFT JOIN phpfox_business_product_cat AS c
ON(c.cat_id = m.cat_id)
     JOIN phpfox_user AS u
ON(u.user_id = m.user_id)
     LEFT JOIN phpfox_business_product_feature_invoice AS fi
ON(fi.product_id = m.product_id AND fi.invoice_id = (
SELECT MAX(invoice_id)
FROM phpfox_business_product_feature_invoice z
WHERE z.product_id = fi.product_id ))

WHERE m.page_id = 8892 AND (m.enable_product = 1 ) AND p.type_id = 36
GROUP BY m.product_id
ORDER BY m.cat_id
LIMIT 100 OFF SET 0

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