Local Resources

(default) 70 queries took 14 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `resources`23232
2DESCRIBE `resource_types`661
3DESCRIBE `resource_reviews`441
4SELECT `ResourceType`.`id`, `ResourceType`.`parent_id`, `ResourceType`.`name`, `ResourceType`.`created`, `ResourceType`.`modified`, `ResourceType`.`removed` FROM `resource_types` AS `ResourceType` WHERE `removed` = 0 AND `parent_id` = 0 ORDER BY `name` ASC 550
5SELECT `ResourceType`.`id`, `ResourceType`.`parent_id`, `ResourceType`.`name`, `ResourceType`.`created`, `ResourceType`.`modified`, `ResourceType`.`removed` FROM `resource_types` AS `ResourceType` WHERE `removed` = 0 AND `parent_id` = 1 ORDER BY `name` ASC 330
6SELECT `ResourceType`.`id`, `ResourceType`.`parent_id`, `ResourceType`.`name`, `ResourceType`.`created`, `ResourceType`.`modified`, `ResourceType`.`removed` FROM `resource_types` AS `ResourceType` WHERE `removed` = 0 AND `parent_id` = 17 ORDER BY `name` ASC 660
7SELECT `ResourceType`.`id`, `ResourceType`.`parent_id`, `ResourceType`.`name`, `ResourceType`.`created`, `ResourceType`.`modified`, `ResourceType`.`removed` FROM `resource_types` AS `ResourceType` WHERE `removed` = 0 AND `parent_id` = 5 ORDER BY `name` ASC 550
8SELECT `ResourceType`.`id`, `ResourceType`.`parent_id`, `ResourceType`.`name`, `ResourceType`.`created`, `ResourceType`.`modified`, `ResourceType`.`removed` FROM `resource_types` AS `ResourceType` WHERE `removed` = 0 AND `parent_id` = 24 ORDER BY `name` ASC 660
9SELECT `ResourceType`.`id`, `ResourceType`.`parent_id`, `ResourceType`.`name`, `ResourceType`.`created`, `ResourceType`.`modified`, `ResourceType`.`removed` FROM `resource_types` AS `ResourceType` WHERE `removed` = 0 AND `parent_id` = 10 ORDER BY `name` ASC 660
10SELECT `Resources`.`id`, `Resources`.`resource_type_id`, `Resources`.`resource_name`, `Resources`.`seo_name`, `Resources`.`description`, `Resources`.`business_details`, `Resources`.`products_services`, `Resources`.`email_address`, `Resources`.`website_url`, `Resources`.`address_1`, `Resources`.`address_2`, `Resources`.`city`, `Resources`.`state`, `Resources`.`county`, `Resources`.`zip_code`, `Resources`.`main_phone_no`, `Resources`.`secondary_phone_no`, `Resources`.`tags`, `Resources`.`created`, `Resources`.`modified`, `Resources`.`removed`, `Resources`.`top_resource_count`, `Resources`.`deleted`, `ResourceType`.`id`, `ResourceType`.`parent_id`, `ResourceType`.`name`, `ResourceType`.`created`, `ResourceType`.`modified`, `ResourceType`.`removed` FROM `resources` AS `Resources` LEFT JOIN `resource_types` AS `ResourceType` ON (`Resources`.`resource_type_id` = `ResourceType`.`id`) WHERE `Resources`.`removed` = 0 2052051
11SELECT `ResourceReviews`.`id`, `ResourceReviews`.`resource_id`, `ResourceReviews`.`member_id`, `ResourceReviews`.`review` FROM `resource_reviews` AS `ResourceReviews` WHERE `ResourceReviews`.`resource_id` IN (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, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207) 000
12SELECT `Resources`.`id`, `Resources`.`resource_type_id`, `Resources`.`resource_name`, `Resources`.`seo_name`, `Resources`.`description`, `Resources`.`business_details`, `Resources`.`products_services`, `Resources`.`email_address`, `Resources`.`website_url`, `Resources`.`address_1`, `Resources`.`address_2`, `Resources`.`city`, `Resources`.`state`, `Resources`.`county`, `Resources`.`zip_code`, `Resources`.`main_phone_no`, `Resources`.`secondary_phone_no`, `Resources`.`tags`, `Resources`.`created`, `Resources`.`modified`, `Resources`.`removed`, `Resources`.`top_resource_count`, `Resources`.`deleted`, `ResourceType`.`id`, `ResourceType`.`parent_id`, `ResourceType`.`name`, `ResourceType`.`created`, `ResourceType`.`modified`, `ResourceType`.`removed` FROM `resources` AS `Resources` LEFT JOIN `resource_types` AS `ResourceType` ON (`Resources`.`resource_type_id` = `ResourceType`.`id`) WHERE `Resources`.`removed` = 0 ORDER BY `resource_name` ASC LIMIT 1010100
13SELECT `ResourceReviews`.`id`, `ResourceReviews`.`resource_id`, `ResourceReviews`.`member_id`, `ResourceReviews`.`review` FROM `resource_reviews` AS `ResourceReviews` WHERE `ResourceReviews`.`resource_id` IN (184, 48, 26, 54, 98, 82, 6, 74, 123, 162) 000
14SELECT `Resources`.`id`, `Resources`.`seo_name` FROM `resources` AS `Resources` WHERE `Resources`.`removed` = 0 ORDER BY `resource_name` ASC 2052050
15SELECT `Member`.`id`, `Member`.`username`, `Member`.`password`, `Member`.`email`, `Member`.`gender`, `Member`.`zip_code`, `Member`.`relationship_status_id`, `Member`.`registration_key`, `Member`.`verified`, `Member`.`date_of_birth`, `Member`.`sexual_orientation`, `Member`.`story`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`created`, `Member`.`modified`, `Member`.`last_active`, `Member`.`display_name`, `Member`.`super_admin`, `Member`.`deleted` FROM `members` AS `Member` WHERE `Member`.`deleted` = 0 ORDER BY `Member`.`created` DESC LIMIT 4440
16SELECT `Image`.`id`, `Image`.`image_path`, `Image`.`thumbnail_path`, `Image`.`member_id`, `Image`.`profile_image`, `Image`.`album_id`, `Image`.`page_id`, `Image`.`created`, `Image`.`modified` FROM `images` AS `Image` WHERE `Image`.`member_id` = 2350 AND `Image`.`profile_image` = 1 LIMIT 1000
17SELECT `Zipcode`.`id`, `Zipcode`.`zip`, `Zipcode`.`latitude`, `Zipcode`.`longitude`, `Zipcode`.`city`, `Zipcode`.`state`, `Zipcode`.`fullstate`, `Zipcode`.`county`, `Zipcode`.`zipclass` FROM `zipcodes` AS `Zipcode` WHERE `Zipcode`.`zip` = '48706' LIMIT 1110
18SELECT `Image`.`id`, `Image`.`image_path`, `Image`.`thumbnail_path`, `Image`.`member_id`, `Image`.`profile_image`, `Image`.`album_id`, `Image`.`page_id`, `Image`.`created`, `Image`.`modified` FROM `images` AS `Image` WHERE `Image`.`member_id` = 2349 AND `Image`.`profile_image` = 1 LIMIT 1000
19SELECT `Zipcode`.`id`, `Zipcode`.`zip`, `Zipcode`.`latitude`, `Zipcode`.`longitude`, `Zipcode`.`city`, `Zipcode`.`state`, `Zipcode`.`fullstate`, `Zipcode`.`county`, `Zipcode`.`zipclass` FROM `zipcodes` AS `Zipcode` WHERE `Zipcode`.`zip` = '85204' LIMIT 1110
20SELECT `Image`.`id`, `Image`.`image_path`, `Image`.`thumbnail_path`, `Image`.`member_id`, `Image`.`profile_image`, `Image`.`album_id`, `Image`.`page_id`, `Image`.`created`, `Image`.`modified` FROM `images` AS `Image` WHERE `Image`.`member_id` = 2348 AND `Image`.`profile_image` = 1 LIMIT 1000
21SELECT `Zipcode`.`id`, `Zipcode`.`zip`, `Zipcode`.`latitude`, `Zipcode`.`longitude`, `Zipcode`.`city`, `Zipcode`.`state`, `Zipcode`.`fullstate`, `Zipcode`.`county`, `Zipcode`.`zipclass` FROM `zipcodes` AS `Zipcode` WHERE `Zipcode`.`zip` = '90015' LIMIT 1110
22SELECT `Image`.`id`, `Image`.`image_path`, `Image`.`thumbnail_path`, `Image`.`member_id`, `Image`.`profile_image`, `Image`.`album_id`, `Image`.`page_id`, `Image`.`created`, `Image`.`modified` FROM `images` AS `Image` WHERE `Image`.`member_id` = 2347 AND `Image`.`profile_image` = 1 LIMIT 1000
23SELECT `Zipcode`.`id`, `Zipcode`.`zip`, `Zipcode`.`latitude`, `Zipcode`.`longitude`, `Zipcode`.`city`, `Zipcode`.`state`, `Zipcode`.`fullstate`, `Zipcode`.`county`, `Zipcode`.`zipclass` FROM `zipcodes` AS `Zipcode` WHERE `Zipcode`.`zip` = '93726' LIMIT 1110
24SELECT `Member`.`id`, `Member`.`username`, `Member`.`password`, `Member`.`email`, `Member`.`gender`, `Member`.`zip_code`, `Member`.`relationship_status_id`, `Member`.`registration_key`, `Member`.`verified`, `Member`.`date_of_birth`, `Member`.`sexual_orientation`, `Member`.`story`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`created`, `Member`.`modified`, `Member`.`last_active`, `Member`.`display_name`, `Member`.`super_admin`, `Member`.`deleted` FROM `members` AS `Member` WHERE `Member`.`deleted` = 0 ORDER BY `last_active` DESC LIMIT 5550
25SELECT `Image`.`id`, `Image`.`image_path`, `Image`.`thumbnail_path`, `Image`.`member_id`, `Image`.`profile_image`, `Image`.`album_id`, `Image`.`page_id`, `Image`.`created`, `Image`.`modified` FROM `images` AS `Image` WHERE `Image`.`member_id` = 2228 AND `Image`.`profile_image` = 1 LIMIT 1110
26SELECT `Zipcode`.`id`, `Zipcode`.`zip`, `Zipcode`.`latitude`, `Zipcode`.`longitude`, `Zipcode`.`city`, `Zipcode`.`state`, `Zipcode`.`fullstate`, `Zipcode`.`county`, `Zipcode`.`zipclass` FROM `zipcodes` AS `Zipcode` WHERE `Zipcode`.`zip` = '11758' LIMIT 1110
27SELECT `Image`.`id`, `Image`.`image_path`, `Image`.`thumbnail_path`, `Image`.`member_id`, `Image`.`profile_image`, `Image`.`album_id`, `Image`.`page_id`, `Image`.`created`, `Image`.`modified` FROM `images` AS `Image` WHERE `Image`.`member_id` = 2153 AND `Image`.`profile_image` = 1 LIMIT 1110
28SELECT `Zipcode`.`id`, `Zipcode`.`zip`, `Zipcode`.`latitude`, `Zipcode`.`longitude`, `Zipcode`.`city`, `Zipcode`.`state`, `Zipcode`.`fullstate`, `Zipcode`.`county`, `Zipcode`.`zipclass` FROM `zipcodes` AS `Zipcode` WHERE `Zipcode`.`zip` = '44114' LIMIT 1110
29SELECT `Image`.`id`, `Image`.`image_path`, `Image`.`thumbnail_path`, `Image`.`member_id`, `Image`.`profile_image`, `Image`.`album_id`, `Image`.`page_id`, `Image`.`created`, `Image`.`modified` FROM `images` AS `Image` WHERE `Image`.`member_id` = 2344 AND `Image`.`profile_image` = 1 LIMIT 1110
30SELECT `Zipcode`.`id`, `Zipcode`.`zip`, `Zipcode`.`latitude`, `Zipcode`.`longitude`, `Zipcode`.`city`, `Zipcode`.`state`, `Zipcode`.`fullstate`, `Zipcode`.`county`, `Zipcode`.`zipclass` FROM `zipcodes` AS `Zipcode` WHERE `Zipcode`.`zip` = '60458' LIMIT 1110
31SELECT `Image`.`id`, `Image`.`image_path`, `Image`.`thumbnail_path`, `Image`.`member_id`, `Image`.`profile_image`, `Image`.`album_id`, `Image`.`page_id`, `Image`.`created`, `Image`.`modified` FROM `images` AS `Image` WHERE `Image`.`member_id` = 2330 AND `Image`.`profile_image` = 1 LIMIT 1000
32SELECT `Image`.`id`, `Image`.`image_path`, `Image`.`thumbnail_path`, `Image`.`member_id`, `Image`.`profile_image`, `Image`.`album_id`, `Image`.`page_id`, `Image`.`created`, `Image`.`modified` FROM `images` AS `Image` WHERE `Image`.`member_id` = 2340 AND `Image`.`profile_image` = 1 LIMIT 1000
33SELECT `Zipcode`.`id`, `Zipcode`.`zip`, `Zipcode`.`latitude`, `Zipcode`.`longitude`, `Zipcode`.`city`, `Zipcode`.`state`, `Zipcode`.`fullstate`, `Zipcode`.`county`, `Zipcode`.`zipclass` FROM `zipcodes` AS `Zipcode` WHERE `Zipcode`.`zip` = '32304' LIMIT 1110
34SELECT `Blog`.`id`, `Blog`.`external_id`, `Blog`.`member_id`, `Blog`.`title`, `Blog`.`page_seo`, `Blog`.`description`, `Blog`.`tags`, `Blog`.`metatitle`, `Blog`.`metadescription`, `Blog`.`metakeywords`, `Blog`.`featured`, `Blog`.`published`, `Blog`.`original_content`, `Blog`.`content`, `Blog`.`created`, `Blog`.`modified`, `Blog`.`deleted`, `Blog`.`blog_series_id`, `Blog`.`top_count`, `Member`.`id`, `Member`.`username`, `Member`.`password`, `Member`.`email`, `Member`.`gender`, `Member`.`zip_code`, `Member`.`relationship_status_id`, `Member`.`registration_key`, `Member`.`verified`, `Member`.`date_of_birth`, `Member`.`sexual_orientation`, `Member`.`story`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`created`, `Member`.`modified`, `Member`.`last_active`, `Member`.`display_name`, `Member`.`super_admin`, `Member`.`deleted`, `BlogSeries`.`id`, `BlogSeries`.`member_id`, `BlogSeries`.`name`, `BlogSeries`.`description`, `BlogSeries`.`page_seo`, `BlogSeries`.`metatitle`, `BlogSeries`.`metadescription`, `BlogSeries`.`metakeywords`, `BlogSeries`.`featured`, `BlogSeries`.`sponsored`, `BlogSeries`.`sponsor_dn`, `BlogSeries`.`sponsor_name`, `BlogSeries`.`sponsor_message`, `BlogSeries`.`sponsor_url`, `BlogSeries`.`top_count`, `BlogSeries`.`created`, `BlogSeries`.`modified`, `BlogSeries`.`deleted`, `BlogSeries`.`image_id` FROM `blogs` AS `Blog` LEFT JOIN `members` AS `Member` ON (`Blog`.`member_id` = `Member`.`id`) LEFT JOIN `blog_series` AS `BlogSeries` ON (`Blog`.`blog_series_id` = `BlogSeries`.`id`) WHERE 1 = 1 ORDER BY `Blog`.`created` DESC LIMIT 5551
35SELECT `Member`.`id`, `Member`.`username`, `Member`.`password`, `Member`.`email`, `Member`.`gender`, `Member`.`zip_code`, `Member`.`relationship_status_id`, `Member`.`registration_key`, `Member`.`verified`, `Member`.`date_of_birth`, `Member`.`sexual_orientation`, `Member`.`story`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`created`, `Member`.`modified`, `Member`.`last_active`, `Member`.`display_name`, `Member`.`super_admin`, `Member`.`deleted` FROM `members` AS `Member` WHERE `Member`.`id` = 2228 110
36SELECT `ProfileImage`.`id`, `ProfileImage`.`image_path`, `ProfileImage`.`thumbnail_path`, `ProfileImage`.`member_id`, `ProfileImage`.`profile_image`, `ProfileImage`.`album_id`, `ProfileImage`.`page_id`, `ProfileImage`.`created`, `ProfileImage`.`modified` FROM `images` AS `ProfileImage` WHERE `ProfileImage`.`member_id` = 2228 AND `ProfileImage`.`profile_image` = 1 110
37SELECT `Member`.`id`, `Member`.`username`, `Member`.`password`, `Member`.`email`, `Member`.`gender`, `Member`.`zip_code`, `Member`.`relationship_status_id`, `Member`.`registration_key`, `Member`.`verified`, `Member`.`date_of_birth`, `Member`.`sexual_orientation`, `Member`.`story`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`created`, `Member`.`modified`, `Member`.`last_active`, `Member`.`display_name`, `Member`.`super_admin`, `Member`.`deleted` FROM `members` AS `Member` WHERE `Member`.`id` = 2149 110
38SELECT `ProfileImage`.`id`, `ProfileImage`.`image_path`, `ProfileImage`.`thumbnail_path`, `ProfileImage`.`member_id`, `ProfileImage`.`profile_image`, `ProfileImage`.`album_id`, `ProfileImage`.`page_id`, `ProfileImage`.`created`, `ProfileImage`.`modified` FROM `images` AS `ProfileImage` WHERE `ProfileImage`.`member_id` = 2149 AND `ProfileImage`.`profile_image` = 1 110
39SELECT `Member`.`id`, `Member`.`username`, `Member`.`password`, `Member`.`email`, `Member`.`gender`, `Member`.`zip_code`, `Member`.`relationship_status_id`, `Member`.`registration_key`, `Member`.`verified`, `Member`.`date_of_birth`, `Member`.`sexual_orientation`, `Member`.`story`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`created`, `Member`.`modified`, `Member`.`last_active`, `Member`.`display_name`, `Member`.`super_admin`, `Member`.`deleted` FROM `members` AS `Member` WHERE `Member`.`id` = 2181 110
40SELECT `ProfileImage`.`id`, `ProfileImage`.`image_path`, `ProfileImage`.`thumbnail_path`, `ProfileImage`.`member_id`, `ProfileImage`.`profile_image`, `ProfileImage`.`album_id`, `ProfileImage`.`page_id`, `ProfileImage`.`created`, `ProfileImage`.`modified` FROM `images` AS `ProfileImage` WHERE `ProfileImage`.`member_id` = 2181 AND `ProfileImage`.`profile_image` = 1 110
41SELECT `Member`.`id`, `Member`.`username`, `Member`.`password`, `Member`.`email`, `Member`.`gender`, `Member`.`zip_code`, `Member`.`relationship_status_id`, `Member`.`registration_key`, `Member`.`verified`, `Member`.`date_of_birth`, `Member`.`sexual_orientation`, `Member`.`story`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`created`, `Member`.`modified`, `Member`.`last_active`, `Member`.`display_name`, `Member`.`super_admin`, `Member`.`deleted` FROM `members` AS `Member` WHERE `Member`.`id` = 2307 110
42SELECT `ProfileImage`.`id`, `ProfileImage`.`image_path`, `ProfileImage`.`thumbnail_path`, `ProfileImage`.`member_id`, `ProfileImage`.`profile_image`, `ProfileImage`.`album_id`, `ProfileImage`.`page_id`, `ProfileImage`.`created`, `ProfileImage`.`modified` FROM `images` AS `ProfileImage` WHERE `ProfileImage`.`member_id` = 2307 AND `ProfileImage`.`profile_image` = 1 110
43SELECT `Member`.`id`, `Member`.`username`, `Member`.`password`, `Member`.`email`, `Member`.`gender`, `Member`.`zip_code`, `Member`.`relationship_status_id`, `Member`.`registration_key`, `Member`.`verified`, `Member`.`date_of_birth`, `Member`.`sexual_orientation`, `Member`.`story`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`created`, `Member`.`modified`, `Member`.`last_active`, `Member`.`display_name`, `Member`.`super_admin`, `Member`.`deleted` FROM `members` AS `Member` WHERE `Member`.`id` = 2307 110
44SELECT `ProfileImage`.`id`, `ProfileImage`.`image_path`, `ProfileImage`.`thumbnail_path`, `ProfileImage`.`member_id`, `ProfileImage`.`profile_image`, `ProfileImage`.`album_id`, `ProfileImage`.`page_id`, `ProfileImage`.`created`, `ProfileImage`.`modified` FROM `images` AS `ProfileImage` WHERE `ProfileImage`.`member_id` = 2307 AND `ProfileImage`.`profile_image` = 1 110
45SELECT `BlogSeries`.`id`, `BlogSeries`.`member_id`, `BlogSeries`.`name`, `BlogSeries`.`description`, `BlogSeries`.`page_seo`, `BlogSeries`.`metatitle`, `BlogSeries`.`metadescription`, `BlogSeries`.`metakeywords`, `BlogSeries`.`featured`, `BlogSeries`.`sponsored`, `BlogSeries`.`sponsor_dn`, `BlogSeries`.`sponsor_name`, `BlogSeries`.`sponsor_message`, `BlogSeries`.`sponsor_url`, `BlogSeries`.`top_count`, `BlogSeries`.`created`, `BlogSeries`.`modified`, `BlogSeries`.`deleted`, `BlogSeries`.`image_id` FROM `blog_series` AS `BlogSeries` WHERE `BlogSeries`.`id` = 100005 110
46SELECT `Member`.`id`, `Member`.`username`, `Member`.`password`, `Member`.`email`, `Member`.`gender`, `Member`.`zip_code`, `Member`.`relationship_status_id`, `Member`.`registration_key`, `Member`.`verified`, `Member`.`date_of_birth`, `Member`.`sexual_orientation`, `Member`.`story`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`created`, `Member`.`modified`, `Member`.`last_active`, `Member`.`display_name`, `Member`.`super_admin`, `Member`.`deleted` FROM `members` AS `Member` WHERE `Member`.`id` = 2228 110
47SELECT `Image`.`id`, `Image`.`image_path`, `Image`.`thumbnail_path`, `Image`.`member_id`, `Image`.`profile_image`, `Image`.`album_id`, `Image`.`page_id`, `Image`.`created`, `Image`.`modified` FROM `images` AS `Image` WHERE `Image`.`id` = 130 110
48SELECT `BlogSeries`.`id`, `BlogSeries`.`member_id`, `BlogSeries`.`name`, `BlogSeries`.`description`, `BlogSeries`.`page_seo`, `BlogSeries`.`metatitle`, `BlogSeries`.`metadescription`, `BlogSeries`.`metakeywords`, `BlogSeries`.`featured`, `BlogSeries`.`sponsored`, `BlogSeries`.`sponsor_dn`, `BlogSeries`.`sponsor_name`, `BlogSeries`.`sponsor_message`, `BlogSeries`.`sponsor_url`, `BlogSeries`.`top_count`, `BlogSeries`.`created`, `BlogSeries`.`modified`, `BlogSeries`.`deleted`, `BlogSeries`.`image_id` FROM `blog_series` AS `BlogSeries` WHERE `BlogSeries`.`id` = 7 110
49SELECT `Member`.`id`, `Member`.`username`, `Member`.`password`, `Member`.`email`, `Member`.`gender`, `Member`.`zip_code`, `Member`.`relationship_status_id`, `Member`.`registration_key`, `Member`.`verified`, `Member`.`date_of_birth`, `Member`.`sexual_orientation`, `Member`.`story`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`created`, `Member`.`modified`, `Member`.`last_active`, `Member`.`display_name`, `Member`.`super_admin`, `Member`.`deleted` FROM `members` AS `Member` WHERE `Member`.`id` = 2149 110
50SELECT `Image`.`id`, `Image`.`image_path`, `Image`.`thumbnail_path`, `Image`.`member_id`, `Image`.`profile_image`, `Image`.`album_id`, `Image`.`page_id`, `Image`.`created`, `Image`.`modified` FROM `images` AS `Image` WHERE `Image`.`id` = 40 110
51SELECT `BlogSeries`.`id`, `BlogSeries`.`member_id`, `BlogSeries`.`name`, `BlogSeries`.`description`, `BlogSeries`.`page_seo`, `BlogSeries`.`metatitle`, `BlogSeries`.`metadescription`, `BlogSeries`.`metakeywords`, `BlogSeries`.`featured`, `BlogSeries`.`sponsored`, `BlogSeries`.`sponsor_dn`, `BlogSeries`.`sponsor_name`, `BlogSeries`.`sponsor_message`, `BlogSeries`.`sponsor_url`, `BlogSeries`.`top_count`, `BlogSeries`.`created`, `BlogSeries`.`modified`, `BlogSeries`.`deleted`, `BlogSeries`.`image_id` FROM `blog_series` AS `BlogSeries` WHERE `BlogSeries`.`id` = 13 110
52SELECT `Member`.`id`, `Member`.`username`, `Member`.`password`, `Member`.`email`, `Member`.`gender`, `Member`.`zip_code`, `Member`.`relationship_status_id`, `Member`.`registration_key`, `Member`.`verified`, `Member`.`date_of_birth`, `Member`.`sexual_orientation`, `Member`.`story`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`created`, `Member`.`modified`, `Member`.`last_active`, `Member`.`display_name`, `Member`.`super_admin`, `Member`.`deleted` FROM `members` AS `Member` WHERE `Member`.`id` = 2181 110
53SELECT `Image`.`id`, `Image`.`image_path`, `Image`.`thumbnail_path`, `Image`.`member_id`, `Image`.`profile_image`, `Image`.`album_id`, `Image`.`page_id`, `Image`.`created`, `Image`.`modified` FROM `images` AS `Image` WHERE `Image`.`id` = 56 110
54SELECT `BlogSeries`.`id`, `BlogSeries`.`member_id`, `BlogSeries`.`name`, `BlogSeries`.`description`, `BlogSeries`.`page_seo`, `BlogSeries`.`metatitle`, `BlogSeries`.`metadescription`, `BlogSeries`.`metakeywords`, `BlogSeries`.`featured`, `BlogSeries`.`sponsored`, `BlogSeries`.`sponsor_dn`, `BlogSeries`.`sponsor_name`, `BlogSeries`.`sponsor_message`, `BlogSeries`.`sponsor_url`, `BlogSeries`.`top_count`, `BlogSeries`.`created`, `BlogSeries`.`modified`, `BlogSeries`.`deleted`, `BlogSeries`.`image_id` FROM `blog_series` AS `BlogSeries` WHERE `BlogSeries`.`id` = 100014 110
55SELECT `Member`.`id`, `Member`.`username`, `Member`.`password`, `Member`.`email`, `Member`.`gender`, `Member`.`zip_code`, `Member`.`relationship_status_id`, `Member`.`registration_key`, `Member`.`verified`, `Member`.`date_of_birth`, `Member`.`sexual_orientation`, `Member`.`story`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`created`, `Member`.`modified`, `Member`.`last_active`, `Member`.`display_name`, `Member`.`super_admin`, `Member`.`deleted` FROM `members` AS `Member` WHERE `Member`.`id` = 2307 110
56SELECT `Image`.`id`, `Image`.`image_path`, `Image`.`thumbnail_path`, `Image`.`member_id`, `Image`.`profile_image`, `Image`.`album_id`, `Image`.`page_id`, `Image`.`created`, `Image`.`modified` FROM `images` AS `Image` WHERE `Image`.`id` = 195 110
57SELECT `BlogSeries`.`id`, `BlogSeries`.`member_id`, `BlogSeries`.`name`, `BlogSeries`.`description`, `BlogSeries`.`page_seo`, `BlogSeries`.`metatitle`, `BlogSeries`.`metadescription`, `BlogSeries`.`metakeywords`, `BlogSeries`.`featured`, `BlogSeries`.`sponsored`, `BlogSeries`.`sponsor_dn`, `BlogSeries`.`sponsor_name`, `BlogSeries`.`sponsor_message`, `BlogSeries`.`sponsor_url`, `BlogSeries`.`top_count`, `BlogSeries`.`created`, `BlogSeries`.`modified`, `BlogSeries`.`deleted`, `BlogSeries`.`image_id` FROM `blog_series` AS `BlogSeries` WHERE `BlogSeries`.`id` = 100014 110
58SELECT `Member`.`id`, `Member`.`username`, `Member`.`password`, `Member`.`email`, `Member`.`gender`, `Member`.`zip_code`, `Member`.`relationship_status_id`, `Member`.`registration_key`, `Member`.`verified`, `Member`.`date_of_birth`, `Member`.`sexual_orientation`, `Member`.`story`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`created`, `Member`.`modified`, `Member`.`last_active`, `Member`.`display_name`, `Member`.`super_admin`, `Member`.`deleted` FROM `members` AS `Member` WHERE `Member`.`id` = 2307 110
59SELECT `Image`.`id`, `Image`.`image_path`, `Image`.`thumbnail_path`, `Image`.`member_id`, `Image`.`profile_image`, `Image`.`album_id`, `Image`.`page_id`, `Image`.`created`, `Image`.`modified` FROM `images` AS `Image` WHERE `Image`.`id` = 195 110
60SELECT `Tag`.`id`, `Tag`.`tag`, `Tag`.`created`, `Tag`.`modified`, `BlogsTag`.`blog_id`, `BlogsTag`.`tag_id` FROM `tags` AS `Tag` JOIN `blogs_tags` AS `BlogsTag` ON (`BlogsTag`.`blog_id` IN (115, 114, 113, 112, 111) AND `BlogsTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 11110
61SELECT `Events`.`event_id`, `Events`.`creator_member_id`, `Events`.`access_level`, `Events`.`event_name`, `Events`.`start_date`, `Events`.`end_date`, `Events`.`addr1`, `Events`.`addr2`, `Events`.`city`, `Events`.`state`, `Events`.`zip`, `Events`.`description`, `Events`.`created`, `Events`.`modified`, `Events`.`deleted` FROM `events` AS `Events` WHERE `Events`.`start_date` >= 1283313600 AND `Events`.`deleted` = 0 ORDER BY `Events`.`event_name` ASC LIMIT 5000
62SELECT `Page`.`id`, `Page`.`title`, `Page`.`page_seo`, `Page`.`category_id`, `Page`.`subcategory_id`, `Page`.`description`, `Page`.`content`, `Page`.`metatitle`, `Page`.`metadescription`, `Page`.`metakeywords`, `Page`.`tags`, `Page`.`published`, `Page`.`featured`, `Page`.`system`, `Page`.`sitemap`, `Page`.`member_id`, `Page`.`created`, `Page`.`modified`, `Page`.`top_article_count`, `Member`.`id`, `Member`.`username`, `Member`.`password`, `Member`.`email`, `Member`.`gender`, `Member`.`zip_code`, `Member`.`relationship_status_id`, `Member`.`registration_key`, `Member`.`verified`, `Member`.`date_of_birth`, `Member`.`sexual_orientation`, `Member`.`story`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`created`, `Member`.`modified`, `Member`.`last_active`, `Member`.`display_name`, `Member`.`super_admin`, `Member`.`deleted`, `Image`.`id`, `Image`.`image_path`, `Image`.`thumbnail_path`, `Image`.`member_id`, `Image`.`profile_image`, `Image`.`album_id`, `Image`.`page_id`, `Image`.`created`, `Image`.`modified` FROM `pages` AS `Page` LEFT JOIN `members` AS `Member` ON (`Page`.`member_id` = `Member`.`id`) LEFT JOIN `images` AS `Image` ON (`Image`.`page_id` = `Page`.`id`) WHERE `featured` = 1 AND `published` = 1 ORDER BY `Page`.`top_article_count` ASC, `Page`.`created` DESC LIMIT 5447
63SELECT `PagesComment`.`id`, `PagesComment`.`page_id`, `PagesComment`.`member_id`, `PagesComment`.`text`, `PagesComment`.`created`, `PagesComment`.`deleted` FROM `pages_comments` AS `PagesComment` WHERE `PagesComment`.`page_id` IN (100069, 100068, 100071, 100070) ORDER BY `PagesComment`.`created` DESC 000
64SELECT `Tag`.`id`, `Tag`.`tag`, `Tag`.`created`, `Tag`.`modified`, `PagesTag`.`page_id`, `PagesTag`.`tag_id` FROM `tags` AS `Tag` JOIN `pages_tags` AS `PagesTag` ON (`PagesTag`.`page_id` IN (100069, 100068, 100071, 100070) AND `PagesTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 12120
65UPDATE `pages` AS `Page` LEFT JOIN `members` AS `Member` ON (`Page`.`member_id` = `Member`.`id`) SET `Page`.`top_article_count` = 9627 WHERE `Page`.`id` = 10006911
66SELECT COUNT(*) AS `count` FROM `friends` AS `Friend` LEFT JOIN `members` AS `Requestor` ON (`Friend`.`member_id` = `Requestor`.`id`) LEFT JOIN `members` AS `Requestee` ON (`Friend`.`friend_id` = `Requestee`.`id`) WHERE `Friend`.`approved` = 0 AND `Friend`.`rejected` = 0 AND `Friend`.`ignored` = 0 AND `Friend`.`friend_id` IS NULL 110
67SELECT COUNT(*) AS `count` FROM `friends` AS `Friend` LEFT JOIN `members` AS `Requestor` ON (`Friend`.`member_id` = `Requestor`.`id`) LEFT JOIN `members` AS `Requestee` ON (`Friend`.`friend_id` = `Requestee`.`id`) WHERE `Friend`.`approved` = 0 AND `Friend`.`rejected` = 0 AND `Friend`.`ignored` = 0 AND `Friend`.`friend_id` IS NULL AND `Friend`.`viewed` = 0 110
68SELECT `HeSaidSheSaid`.`id`, `HeSaidSheSaid`.`page_seo`, `HeSaidSheSaid`.`question`, `HeSaidSheSaid`.`hesaid_text`, `HeSaidSheSaid`.`shesaid_text`, `HeSaidSheSaid`.`published`, `HeSaidSheSaid`.`created`, `HeSaidSheSaid`.`modified` FROM `he_said_she_saids` AS `HeSaidSheSaid` WHERE 1 = 1 ORDER BY `created` DESC LIMIT 1110
69SELECT COUNT(*) AS `count` FROM `he_said_she_saids_comments` AS `HeSaidSheSaidsComment` LEFT JOIN `he_said_she_saids` AS `HeSaidSheSaid` ON (`HeSaidSheSaidsComment`.`he_said_she_said_id` = `HeSaidSheSaid`.`id`) LEFT JOIN `members` AS `Member` ON (`HeSaidSheSaidsComment`.`member_id` = `Member`.`id`) WHERE `he_said_she_said_id` = 5 AND `comment_type` = 1 110
70SELECT COUNT(*) AS `count` FROM `he_said_she_saids_comments` AS `HeSaidSheSaidsComment` LEFT JOIN `he_said_she_saids` AS `HeSaidSheSaid` ON (`HeSaidSheSaidsComment`.`he_said_she_said_id` = `HeSaidSheSaid`.`id`) LEFT JOIN `members` AS `Member` ON (`HeSaidSheSaidsComment`.`member_id` = `Member`.`id`) WHERE `he_said_she_said_id` = 5 AND `comment_type` = 2 110