MORE
more
Check out our most popular categories.
+Show More
Filter
Login
request
child_id
selectedLocation
locationId
location
cat_ids
cityname
city
category
parent_cat_id
today_date
banner_images
business_banner_image
childCategories
categoryId
__env
app
globelSetting
errors
select * from `categories` where `type` = 'business' and `slug` = 'community-organizations' limit 1
select * from `images` where (`status` = 1 and `payment_status` = 1 and `type` = 'category_banner' and `parent_category_id` = 9) and date(`expired_at`) >= '2025-05-07' limit 1
select * from `businesses` where `pricing_option` = '1' and `is_published` = '1' and `parent_category_id` = 9 limit 1
select * from `locations` where `slug` = 'emerald-coast' limit 1
select `id`, `name` from `pricing_options` where `pricing_options`.`name` in ('Exclusive', 'Gold')
select count(*) as aggregate from `categories` where `parent_id` = 9 and `image` != ''
select * from `categories` where `parent_id` = 9 and `image` != '' order by RAND() limit 12 offset 0
select * from `categories` where `type` = 'business' and `parent_id` is null and `deleted_at` is null order by `name` asc, `created_at` desc
select * from `categories` where `deleted_at` is null and `categories`.`parent_id` in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33) order by RAND()
select `name`, `id` from `categories` where `parent_id` = 9 order by `name` asc
select `cities`.`name` as `city_name` from `cities` inner join `locations` on `cities`.`location_id` = `locations`.`id` order by `city_name` asc
select * from `businesses` where (`location` = 1 and (`sub_category_id` = 113 and `pricing_option` in (1, 10, 11)) or exists (select * from `listings` where `businesses`.`id` = `listings`.`business_id` and `sub_category_id` = 113 and `pricing_option` in (1, 10, 11))) and `is_published` = 1 limit 1
select * from `businesses` where (`location` = 1 and (`sub_category_id` = 113 and `pricing_option` in (2, 6, 8, 9)) or exists (select * from `listings` where `businesses`.`id` = `listings`.`business_id` and `sub_category_id` = 113 and `pricing_option` in (2, 6, 8, 9))) and `is_published` = 1 limit 2
select * from `businesses` where (`location` = 1 and (`sub_category_id` = 118 and `pricing_option` in (1, 10, 11)) or exists (select * from `listings` where `businesses`.`id` = `listings`.`business_id` and `sub_category_id` = 118 and `pricing_option` in (1, 10, 11))) and `is_published` = 1 limit 1
select * from `businesses` where (`location` = 1 and (`sub_category_id` = 118 and `pricing_option` in (2, 6, 8, 9)) or exists (select * from `listings` where `businesses`.`id` = `listings`.`business_id` and `sub_category_id` = 118 and `pricing_option` in (2, 6, 8, 9))) and `is_published` = 1 limit 2
select * from `businesses` where (`location` = 1 and (`sub_category_id` = 115 and `pricing_option` in (1, 10, 11)) or exists (select * from `listings` where `businesses`.`id` = `listings`.`business_id` and `sub_category_id` = 115 and `pricing_option` in (1, 10, 11))) and `is_published` = 1 limit 1
select * from `businesses` where (`location` = 1 and (`sub_category_id` = 115 and `pricing_option` in (2, 6, 8, 9)) or exists (select * from `listings` where `businesses`.`id` = `listings`.`business_id` and `sub_category_id` = 115 and `pricing_option` in (2, 6, 8, 9))) and `is_published` = 1 limit 2
select * from `businesses` where (`location` = 1 and (`sub_category_id` = 506 and `pricing_option` in (1, 10, 11)) or exists (select * from `listings` where `businesses`.`id` = `listings`.`business_id` and `sub_category_id` = 506 and `pricing_option` in (1, 10, 11))) and `is_published` = 1 limit 1
select * from `businesses` where (`location` = 1 and (`sub_category_id` = 506 and `pricing_option` in (2, 6, 8, 9)) or exists (select * from `listings` where `businesses`.`id` = `listings`.`business_id` and `sub_category_id` = 506 and `pricing_option` in (2, 6, 8, 9))) and `is_published` = 1 limit 2
select * from `businesses` where (`location` = 1 and (`sub_category_id` = 121 and `pricing_option` in (1, 10, 11)) or exists (select * from `listings` where `businesses`.`id` = `listings`.`business_id` and `sub_category_id` = 121 and `pricing_option` in (1, 10, 11))) and `is_published` = 1 limit 1
select * from `businesses` where (`location` = 1 and (`sub_category_id` = 121 and `pricing_option` in (2, 6, 8, 9)) or exists (select * from `listings` where `businesses`.`id` = `listings`.`business_id` and `sub_category_id` = 121 and `pricing_option` in (2, 6, 8, 9))) and `is_published` = 1 limit 2
select * from `businesses` where (`location` = 1 and (`sub_category_id` = 117 and `pricing_option` in (1, 10, 11)) or exists (select * from `listings` where `businesses`.`id` = `listings`.`business_id` and `sub_category_id` = 117 and `pricing_option` in (1, 10, 11))) and `is_published` = 1 limit 1
select * from `businesses` where (`location` = 1 and (`sub_category_id` = 117 and `pricing_option` in (2, 6, 8, 9)) or exists (select * from `listings` where `businesses`.`id` = `listings`.`business_id` and `sub_category_id` = 117 and `pricing_option` in (2, 6, 8, 9))) and `is_published` = 1 limit 2
select * from `businesses` where (`location` = 1 and (`sub_category_id` = 116 and `pricing_option` in (1, 10, 11)) or exists (select * from `listings` where `businesses`.`id` = `listings`.`business_id` and `sub_category_id` = 116 and `pricing_option` in (1, 10, 11))) and `is_published` = 1 limit 1
select * from `businesses` where (`location` = 1 and (`sub_category_id` = 116 and `pricing_option` in (2, 6, 8, 9)) or exists (select * from `listings` where `businesses`.`id` = `listings`.`business_id` and `sub_category_id` = 116 and `pricing_option` in (2, 6, 8, 9))) and `is_published` = 1 limit 2
select * from `businesses` where (`location` = 1 and (`sub_category_id` = 110 and `pricing_option` in (1, 10, 11)) or exists (select * from `listings` where `businesses`.`id` = `listings`.`business_id` and `sub_category_id` = 110 and `pricing_option` in (1, 10, 11))) and `is_published` = 1 limit 1
select * from `businesses` where (`location` = 1 and (`sub_category_id` = 110 and `pricing_option` in (2, 6, 8, 9)) or exists (select * from `listings` where `businesses`.`id` = `listings`.`business_id` and `sub_category_id` = 110 and `pricing_option` in (2, 6, 8, 9))) and `is_published` = 1 limit 2
select * from `businesses` where (`location` = 1 and (`sub_category_id` = 114 and `pricing_option` in (1, 10, 11)) or exists (select * from `listings` where `businesses`.`id` = `listings`.`business_id` and `sub_category_id` = 114 and `pricing_option` in (1, 10, 11))) and `is_published` = 1 limit 1
select * from `businesses` where (`location` = 1 and (`sub_category_id` = 114 and `pricing_option` in (2, 6, 8, 9)) or exists (select * from `listings` where `businesses`.`id` = `listings`.`business_id` and `sub_category_id` = 114 and `pricing_option` in (2, 6, 8, 9))) and `is_published` = 1 limit 2
select * from `businesses` where (`location` = 1 and (`sub_category_id` = 505 and `pricing_option` in (1, 10, 11)) or exists (select * from `listings` where `businesses`.`id` = `listings`.`business_id` and `sub_category_id` = 505 and `pricing_option` in (1, 10, 11))) and `is_published` = 1 limit 1
select * from `businesses` where (`location` = 1 and (`sub_category_id` = 505 and `pricing_option` in (2, 6, 8, 9)) or exists (select * from `listings` where `businesses`.`id` = `listings`.`business_id` and `sub_category_id` = 505 and `pricing_option` in (2, 6, 8, 9))) and `is_published` = 1 limit 2
select * from `businesses` where (`location` = 1 and (`sub_category_id` = 120 and `pricing_option` in (1, 10, 11)) or exists (select * from `listings` where `businesses`.`id` = `listings`.`business_id` and `sub_category_id` = 120 and `pricing_option` in (1, 10, 11))) and `is_published` = 1 limit 1
select * from `businesses` where (`location` = 1 and (`sub_category_id` = 120 and `pricing_option` in (2, 6, 8, 9)) or exists (select * from `listings` where `businesses`.`id` = `listings`.`business_id` and `sub_category_id` = 120 and `pricing_option` in (2, 6, 8, 9))) and `is_published` = 1 limit 2
select * from `businesses` where (`location` = 1 and (`sub_category_id` = 111 and `pricing_option` in (1, 10, 11)) or exists (select * from `listings` where `businesses`.`id` = `listings`.`business_id` and `sub_category_id` = 111 and `pricing_option` in (1, 10, 11))) and `is_published` = 1 limit 1
select * from `businesses` where (`location` = 1 and (`sub_category_id` = 111 and `pricing_option` in (2, 6, 8, 9)) or exists (select * from `listings` where `businesses`.`id` = `listings`.`business_id` and `sub_category_id` = 111 and `pricing_option` in (2, 6, 8, 9))) and `is_published` = 1 limit 2
select * from `locations` where `status` = 'active'
200
[]
0 of 0 array:16 [▼ "accept" => array:1 [▶ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "accept-encoding" => array:1 [▶ 0 => "gzip, deflate, br, zstd" ] "content-length" => array:1 [▶ 0 => "0" ] "host" => array:1 [▶ 0 => "demo.parentlivingplus.com" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "sec-ch-ua" => array:1 [▶ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "sec-fetch-site" => array:1 [▶ 0 => "none" ] "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "priority" => array:1 [▶ 0 => "u=0, i" ] ]
0 of 0 array:81 [▼ "LSPHP_ENABLE_USER_INI" => "on" "PATH" => "/usr/local/bin:/usr/bin:/bin" "TEMP" => "/tmp" "TMP" => "/tmp" "TMPDIR" => "/tmp" "PWD" => "/" "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "CONTENT_LENGTH" => "0" "HTTP_HOST" => "demo.parentlivingplus.com" "HTTP_PRAGMA" => "no-cache" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_SEC_CH_UA" => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_SEC_FETCH_SITE" => "none" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_PRIORITY" => "u=0, i" "REDIRECT_REDIRECT_UNIQUE_ID" => "aBwugm-Gx57BZYwndvmG3AABZC8" "REDIRECT_REDIRECT_QS_ConnectionId" => "174667737855443383335072" "REDIRECT_REDIRECT_HTTPS" => "on" "REDIRECT_REDIRECT_SSL_TLS_SNI" => "demo.parentlivingplus.com" "REDIRECT_REDIRECT_HTTP2" => "on" "REDIRECT_REDIRECT_H2PUSH" => "off" "REDIRECT_REDIRECT_H2_PUSH" => "off" "REDIRECT_REDIRECT_H2_PUSHED" => "" "REDIRECT_REDIRECT_H2_PUSHED_ON" => "" "REDIRECT_REDIRECT_H2_STREAM_ID" => "1" "REDIRECT_REDIRECT_H2_STREAM_TAG" => "335072-1345-1" "REDIRECT_REDIRECT_STATUS" => "200" "REDIRECT_UNIQUE_ID" => "aBwugm-Gx57BZYwndvmG3AABZC8" "REDIRECT_QS_ConnectionId" => "174667737855443383335072" "REDIRECT_HTTPS" => "on" "REDIRECT_SSL_TLS_SNI" => "demo.parentlivingplus.com" "REDIRECT_HTTP2" => "on" "REDIRECT_H2PUSH" => "off" "REDIRECT_H2_PUSH" => "off" "REDIRECT_H2_PUSHED" => "" "REDIRECT_H2_PUSHED_ON" => "" "REDIRECT_H2_STREAM_ID" => "1" "REDIRECT_H2_STREAM_TAG" => "335072-1345-1" "REDIRECT_STATUS" => "200" "UNIQUE_ID" => "aBwugm-Gx57BZYwndvmG3AABZC8" "QS_ConnectionId" => "174667737855443383335072" "HTTPS" => "on" "SSL_TLS_SNI" => "demo.parentlivingplus.com" "HTTP2" => "on" "H2PUSH" => "off" "H2_PUSH" => "off" "H2_PUSHED" => "" "H2_PUSHED_ON" => "" "H2_STREAM_ID" => "1" "H2_STREAM_TAG" => "335072-1345-1" "SERVER_SIGNATURE" => "" "SERVER_SOFTWARE" => "Apache" "SERVER_NAME" => "demo.parentlivingplus.com" "SERVER_ADDR" => "162.241.248.17" "SERVER_PORT" => "443" "REMOTE_ADDR" => "18.188.150.86" "DOCUMENT_ROOT" => "/home3/itsyoux2/demo.parentlivingplus.com" "REQUEST_SCHEME" => "https" "CONTEXT_PREFIX" => "" "CONTEXT_DOCUMENT_ROOT" => "/home3/itsyoux2/demo.parentlivingplus.com" "SERVER_ADMIN" => "webmaster@demo.parentlivingplus.com" "SCRIPT_FILENAME" => "/home3/itsyoux2/demo.parentlivingplus.com/public/index.php" "REMOTE_PORT" => "47608" "REDIRECT_URL" => "/public/category/community-organizations" "SERVER_PROTOCOL" => "HTTP/2.0" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/category/community-organizations" "SCRIPT_NAME" => "/public/index.php" "PHP_SELF" => "/public/index.php" "REQUEST_TIME_FLOAT" => 1746677378.5642 "REQUEST_TIME" => 1746677378 "argv" => [] "argc" => 0 ]
0 of 0 array:5 [▼ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Thu, 08 May 2025 04:09:38 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Ijh3VFAvSGhneFNvNW5rdWpCQWY1MlE9PSIsInZhbHVlIjoiamU5MjJqYWZmTlJ3cWkzSE1abFNOVXFXaFBqcno3c0ZJM0VYQ0xuZnp4MWtaS2pmUWcwdUxuRGJ3SkpDcERyTEVUSTNsRXgrbGw2RGlCSTR2SVJiZnJLMjYvSUxsblZQY0NtN3QwMnd5WEtnaXV0K3BiSFQ0cmQzRXNJTm5TWlEiLCJtYWMiOiIwN2ZiYWFhMmZhMzRjZjhjZmU3ODRjZDViNmU0Yzg3ODA0N2Y5YTI2NzdhNjg5OTEyNDc1NWYyMzgyYjc5NzhiIiwidGFnIjoiIn0%3D; expires=Thu, 15-May-2025 04:09:44 GMT; Max-Age=604800; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Ijh3VFAvSGhneFNvNW5rdWpCQWY1MlE9PSIsInZhbHVlIjoiamU5MjJqYWZmTlJ3cWkzSE1abFNOVXFXaFBqcno3c0ZJM0VYQ0xuZnp4MWtaS2pmUWcwdUxuRGJ3SkpDcERyTEVUSTNsR ▶" 1 => "parent_living_plus_session=eyJpdiI6IkFLL1Q5TERPc0VIbzZPZys2TnNlWUE9PSIsInZhbHVlIjoiQ2VCTlNaeVd6b09kUzh1MHgrNXF4SWc3NlVwR1AvM1ZOU3QxOC9uWjhUYVIyU0FCbEhTOGwvd0JKNG5SdmpVTDdEeEtoYU5Qei9RYWQ3ajJVS2pVbVYyUFdmOFRyYW5jbDZMWEh2SkxMUy9mSVc4SU9MalFaUjU5TG9zMlpRV1EiLCJtYWMiOiJjNGYyNmI0ZWU3MGJkZmZmMzVmNTM2MjdjY2Q5NWVjZDFkOTcyZTkxZTFjYjUxNjM5ODc3OTQ3NDg3OTQyYzMzIiwidGFnIjoiIn0%3D; expires=Thu, 15-May-2025 04:09:44 GMT; Max-Age=604800; path=/; httponly; samesite=lax ◀parent_living_plus_session=eyJpdiI6IkFLL1Q5TERPc0VIbzZPZys2TnNlWUE9PSIsInZhbHVlIjoiQ2VCTlNaeVd6b09kUzh1MHgrNXF4SWc3NlVwR1AvM1ZOU3QxOC9uWjhUYVIyU0FCbEhTOGwvd0JKN ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Ijh3VFAvSGhneFNvNW5rdWpCQWY1MlE9PSIsInZhbHVlIjoiamU5MjJqYWZmTlJ3cWkzSE1abFNOVXFXaFBqcno3c0ZJM0VYQ0xuZnp4MWtaS2pmUWcwdUxuRGJ3SkpDcERyTEVUSTNsRXgrbGw2RGlCSTR2SVJiZnJLMjYvSUxsblZQY0NtN3QwMnd5WEtnaXV0K3BiSFQ0cmQzRXNJTm5TWlEiLCJtYWMiOiIwN2ZiYWFhMmZhMzRjZjhjZmU3ODRjZDViNmU0Yzg3ODA0N2Y5YTI2NzdhNjg5OTEyNDc1NWYyMzgyYjc5NzhiIiwidGFnIjoiIn0%3D; expires=Thu, 15-May-2025 04:09:44 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Ijh3VFAvSGhneFNvNW5rdWpCQWY1MlE9PSIsInZhbHVlIjoiamU5MjJqYWZmTlJ3cWkzSE1abFNOVXFXaFBqcno3c0ZJM0VYQ0xuZnp4MWtaS2pmUWcwdUxuRGJ3SkpDcERyTEVUSTNsR ▶" 1 => "parent_living_plus_session=eyJpdiI6IkFLL1Q5TERPc0VIbzZPZys2TnNlWUE9PSIsInZhbHVlIjoiQ2VCTlNaeVd6b09kUzh1MHgrNXF4SWc3NlVwR1AvM1ZOU3QxOC9uWjhUYVIyU0FCbEhTOGwvd0JKNG5SdmpVTDdEeEtoYU5Qei9RYWQ3ajJVS2pVbVYyUFdmOFRyYW5jbDZMWEh2SkxMUy9mSVc4SU9MalFaUjU5TG9zMlpRV1EiLCJtYWMiOiJjNGYyNmI0ZWU3MGJkZmZmMzVmNTM2MjdjY2Q5NWVjZDFkOTcyZTkxZTFjYjUxNjM5ODc3OTQ3NDg3OTQyYzMzIiwidGFnIjoiIn0%3D; expires=Thu, 15-May-2025 04:09:44 GMT; path=/; httponly ◀parent_living_plus_session=eyJpdiI6IkFLL1Q5TERPc0VIbzZPZys2TnNlWUE9PSIsInZhbHVlIjoiQ2VCTlNaeVd6b09kUzh1MHgrNXF4SWc3NlVwR1AvM1ZOU3QxOC9uWjhUYVIyU0FCbEhTOGwvd0JKN ▶" ] ]
0 of 0 array:6 [▼ "_token" => "ZzAruShXzMPXzbEMvJsVH7VrksuP1OMsoPRTjdjw" "city" => null "category" => 9 "_previous" => array:1 [▶ "url" => "https://demo.parentlivingplus.com/category/community-organizations" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
