Shopping & Sell Free | Free Classifieds | Breaking News | Business Reviews | Dating | Domain Registar & Hosting |

Latest Products

Special Education: Contemporary Perspectives for School Professionals (with MyEducationLab) (3rd Edition) (Pearson Custom Education)
Special Education: Contemporary Perspectives for School Professionals (with MyEducationLab) (3rd Edition) (Pearson Custom Education)
Added By: altheabrown
About 2 years ago
(0)
The Magazine of Fantasy & Science Fiction November/December 2010 [Kindle Edition]
The Magazine of Fantasy & Science Fiction November/December 2010 [Kindle Edition]
Added By: altheabrown
About 2 years ago
(0)
The Rest of Her Life CD [Audiobook, Unabridged] [Audio CD]
The Rest of Her Life CD [Audiobook, Unabridged] [Audio CD]
Added By: altheabrown
About 2 years ago
(0)
Counseling the Culturally Diverse: Theory and Practice [Hardcover]
Counseling the Culturally Diverse: Theory and Practice [Hardcover]
Added By: Lenoresit
About 2 years ago
(0)
HP TouchSmart 310-1020 All-in-One Desktop PC - Black
HP TouchSmart 310-1020 All-in-One Desktop PC - Black
Added By: Halleya
About 2 years ago
(0)
Hello Kitty 10.2" Universal Sleeve For Netbooks, Tablets, E-Readers, and Similar Devices
Hello Kitty 10.2" Universal Sleeve For Netbooks, Tablets, E-Readers, and Similar Devices
Added By: AllieKephart
About 2 years ago
(0)
HP Pavilion dv6t-6000
HP Pavilion dv6t-6000
Added By: Donellala
About 2 years ago
(0)
Asus U46E-BAL6
Asus U46E-BAL6
Added By: earlenesigg
About 2 years ago
(0)
Disney Princess: Magical Jewels
Disney Princess: Magical Jewels
Added By: bulowkent
About 2 years ago
(0)
Captain America: Super Soldier
Captain America: Super Soldier
Added By: earlenesigg
About 2 years ago
(0)
L.A. Noire: The Complete Edition
L.A. Noire: The Complete Edition
Added By: earlenesigg
About 2 years ago
(0)
X-Men: Destiny (Wii)
X-Men: Destiny (Wii)
Added By: Halleya
About 2 years ago
(0)
Samsung PN51D550 51-Inch 1080p 600 Hz 3D Plasma HDTV
Samsung PN51D550 51-Inch 1080p 600 Hz 3D Plasma HDTV
Added By: Lenoresit
About 2 years ago
(0)
Ocean Blue Silver Black Vines Hard Snap-on Case Cover for Lg Optimus Slider Q Enlighten Phone Accessory
Ocean Blue Silver Black Vines Hard Snap-on Case Cover for Lg Optimus Slider Q Enlighten Phone Accessory
Added By: Lancekobel
About 2 years ago
(0)
Samsung Gem SCH-i100 (U.S. Cellular)
Samsung Gem SCH-i100 (U.S. Cellular)
Added By: AllieKephart
About 2 years ago
(0)
T-Mobile MyTouch 4G Slide - khaki
T-Mobile MyTouch 4G Slide - khaki
Added By: Karinalamo
About 2 years ago
(0)

Review categories

Latest CWEB Reviews

Awesome!!
Awesome!!
Written By: JohhnQ
Mario always has been among my best game which i have played since my childhood. With improvement in game technologies its...

Was this review helpful?
Read Full Comments (0)   Written By: JohhnQ
Very nice and thick.
I must say this mascara is the best I have used, it makes my eyes look very beautiful.

Was this review helpful?
Read Full Comments (0)   Written By: shriti
Very Nice product
I really like this product. It's easy to apply and looks very beautiful once applied.

Was this review helpful?
Read Full Comments (0)   Written By: BrookLeff
Really Nice
Really Nice
Written By: Shriti
I must say it's one of the best games available. I kept on playing it whole night, it's so addicting.

Was this review helpful?
Read Full Comments (0)   Written By: Shriti 
Disneyland XBOX Game
Great game. Really like it. Very good price.

Was this review helpful?
Read Full Comments (0)   Written By: caseylee
(default) 109 queries took 350 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `MetaInformation`.`id`, `MetaInformation`.`page_name`, `MetaInformation`.`entity`, `MetaInformation`.`entity_id`, `MetaInformation`.`pageTitle`, `MetaInformation`.`metaDescription`, `MetaInformation`.`metaTags` FROM `meta_information` AS `MetaInformation` WHERE `page_name` = 'homepage' LIMIT 1000
2DESCRIBE `content_scopes`771
3SELECT `ContentScope`.`id`, `ContentScope`.`title`, `ContentScope`.`model`, `ContentScope`.`conditions`, `ContentScope`.`order_by`, `ContentScope`.`sort_order`, `ContentScope`.`randomize` FROM `content_scopes` AS `ContentScope` WHERE `ContentScope`.`id` = 3 LIMIT 1110
4SELECT COUNT(*) AS `count` FROM `listings` AS `Listing` WHERE `Listing`.`list_category_id` IN (25, 20, 22, 23, 24, 19) AND `Listing`.`status` = 1 1153
5SELECT `Listing`.`id` FROM `listings` AS `Listing` WHERE `Listing`.`list_category_id` IN (25, 20, 22, 23, 24, 19) ORDER BY `Listing`.`created` DESC LIMIT 1111111111
6SELECT `Listing`.`id`, `Listing`.`title`, `Listing`.`image`, `Listing`.`description`, `Listing`.`status`, `Listing`.`slug`, `Listing`.`user_id`, `Listing`.`created`, `Listing`.`list_category_id`, `Listing`.`ip`, `Listing`.`summary`, `Listing`.`is_editorial`, `Listing`.`is_featured`, `Listing`.`featured_date`, `Listing`.`review_count`, `Listing`.`views_count`, `Listing`.`meta_keywords`, `Listing`.`meta_description`, `Listing`.`userAvg`, `Listing`.`editorialAvg`, `Listing`.`lat`, `Listing`.`lng`, `Listing`.`location_search_cache`, `Listing`.`owner_id`, `Listing`.`owner_candidate_id` FROM `listings` AS `Listing` WHERE `Listing`.`id` IN (1670, 1641, 1567, 776) AND `Listing`.`status` = 1 ORDER BY `Listing`.`created` DESC LIMIT 4440
7SELECT `EavRecord`.`id`, `EavRecord`.`entity_id` FROM `eav_records` AS `EavRecord` WHERE `EavRecord`.`entity` = 'Listing' AND `EavRecord`.`entity_id` IN (1567, 776) 2215
8SELECT `EavValuesInt`.`id`, `EavValuesInt`.`field`, `EavValuesInt`.`value`, `EavValuesInt`.`eav_record_id` FROM `eav_values_int` AS `EavValuesInt` WHERE `EavValuesInt`.`eav_record_id` IN (1250, 2041) 006
9SELECT `EavValuesString`.`id`, `EavValuesString`.`field`, `EavValuesString`.`value`, `EavValuesString`.`eav_record_id` FROM `eav_values_string` AS `EavValuesString` WHERE `EavValuesString`.`eav_record_id` IN (1250, 2041) 4432
10SELECT `EavValuesDatetime`.`id`, `EavValuesDatetime`.`field`, `EavValuesDatetime`.`value`, `EavValuesDatetime`.`eav_record_id` FROM `eav_values_datetime` AS `EavValuesDatetime` WHERE `EavValuesDatetime`.`eav_record_id` IN (1250, 2041) 000
11SELECT `EavValuesArray`.`id`, `EavValuesArray`.`field`, `EavValuesArray`.`eav_record_id` FROM `eav_values_array` AS `EavValuesArray` WHERE `EavValuesArray`.`eav_record_id` IN (1250, 2041) 000
12SELECT `EavValuesBoolean`.`id`, `EavValuesBoolean`.`field`, `EavValuesBoolean`.`value`, `EavValuesBoolean`.`eav_record_id` FROM `eav_values_boolean` AS `EavValuesBoolean` WHERE `EavValuesBoolean`.`eav_record_id` IN (1250, 2041) 000
13SELECT `EavValuesText`.`id`, `EavValuesText`.`field`, `EavValuesText`.`value`, `EavValuesText`.`eav_record_id` FROM `eav_values_text` AS `EavValuesText` WHERE `EavValuesText`.`eav_record_id` IN (1250, 2041) 000
14SELECT `EavValuesFloat`.`id`, `EavValuesFloat`.`field`, `EavValuesFloat`.`value`, `EavValuesFloat`.`eav_record_id` FROM `eav_values_float` AS `EavValuesFloat` WHERE `EavValuesFloat`.`eav_record_id` IN (1250, 2041) 2211
15SELECT `EavValuesDate`.`id`, `EavValuesDate`.`field`, `EavValuesDate`.`value`, `EavValuesDate`.`eav_record_id` FROM `eav_values_date` AS `EavValuesDate` WHERE `EavValuesDate`.`eav_record_id` IN (1250, 2041) 000
16SELECT `User`.`id`, `User`.`slug`, `User`.`userType`, `User`.`username`, `User`.`email`, `User`.`password`, `User`.`city`, `User`.`state`, `User`.`country`, `User`.`postal_code`, `User`.`created`, `User`.`lastLoginIpAddr`, `User`.`status`, `User`.`emailVerified`, `User`.`avatar`, `User`.`validateCode`, `User`.`last_login_date`, `User`.`first_name`, `User`.`last_name`, `User`.`is_editor`, `User`.`review_count`, `User`.`listing_count`, `User`.`listing_asset_count`, `User`.`review_comment_count`, `User`.`is_deactivated`, `User`.`onAddedListingApproval`, `User`.`onAddedReviewApproval`, `User`.`onReviewLiked`, `User`.`onPhotoGetComment`, `User`.`onCommentedPhotoComment`, `User`.`onReviewedListingReview`, `User`.`onFavListingReviewed`, `User`.`onAddedReviewGetComment`, `User`.`onCommentedReviewGetComment`, `User`.`business_information` FROM `users` AS `User` WHERE `User`.`id` = 21 LIMIT 1117
17SELECT `User`.`id`, `User`.`slug`, `User`.`userType`, `User`.`username`, `User`.`email`, `User`.`password`, `User`.`city`, `User`.`state`, `User`.`country`, `User`.`postal_code`, `User`.`created`, `User`.`lastLoginIpAddr`, `User`.`status`, `User`.`emailVerified`, `User`.`avatar`, `User`.`validateCode`, `User`.`last_login_date`, `User`.`first_name`, `User`.`last_name`, `User`.`is_editor`, `User`.`review_count`, `User`.`listing_count`, `User`.`listing_asset_count`, `User`.`review_comment_count`, `User`.`is_deactivated`, `User`.`onAddedListingApproval`, `User`.`onAddedReviewApproval`, `User`.`onReviewLiked`, `User`.`onPhotoGetComment`, `User`.`onCommentedPhotoComment`, `User`.`onReviewedListingReview`, `User`.`onFavListingReviewed`, `User`.`onAddedReviewGetComment`, `User`.`onCommentedReviewGetComment`, `User`.`business_information` FROM `users` AS `User` WHERE `User`.`id` = 9 LIMIT 1110
18SELECT `ContentScope`.`id`, `ContentScope`.`title`, `ContentScope`.`model`, `ContentScope`.`conditions`, `ContentScope`.`order_by`, `ContentScope`.`sort_order`, `ContentScope`.`randomize` FROM `content_scopes` AS `ContentScope` WHERE `ContentScope`.`id` = 4 LIMIT 1110
19SELECT COUNT(*) AS `count` FROM `listings` AS `Listing` WHERE `Listing`.`list_category_id` IN (130, 131, 135, 138, 139) AND `Listing`.`status` = 1 1152
20SELECT `Listing`.`id` FROM `listings` AS `Listing` WHERE `Listing`.`list_category_id` IN (130, 131, 135, 138, 139) ORDER BY `Listing`.`created` DESC LIMIT 2242242241
21SELECT `Listing`.`id`, `Listing`.`title`, `Listing`.`image`, `Listing`.`description`, `Listing`.`status`, `Listing`.`slug`, `Listing`.`user_id`, `Listing`.`created`, `Listing`.`list_category_id`, `Listing`.`ip`, `Listing`.`summary`, `Listing`.`is_editorial`, `Listing`.`is_featured`, `Listing`.`featured_date`, `Listing`.`review_count`, `Listing`.`views_count`, `Listing`.`meta_keywords`, `Listing`.`meta_description`, `Listing`.`userAvg`, `Listing`.`editorialAvg`, `Listing`.`lat`, `Listing`.`lng`, `Listing`.`location_search_cache`, `Listing`.`owner_id`, `Listing`.`owner_candidate_id` FROM `listings` AS `Listing` WHERE `Listing`.`id` IN (1692, 1287, 551, 331) AND `Listing`.`status` = 1 ORDER BY `Listing`.`created` DESC LIMIT 4441
22SELECT `EavRecord`.`id`, `EavRecord`.`entity_id` FROM `eav_records` AS `EavRecord` WHERE `EavRecord`.`entity` = 'Listing' AND `EavRecord`.`entity_id` IN (1692, 551) 221
23SELECT `EavValuesInt`.`id`, `EavValuesInt`.`field`, `EavValuesInt`.`value`, `EavValuesInt`.`eav_record_id` FROM `eav_values_int` AS `EavValuesInt` WHERE `EavValuesInt`.`eav_record_id` IN (665, 2166) 2219
24SELECT `EavValuesString`.`id`, `EavValuesString`.`field`, `EavValuesString`.`value`, `EavValuesString`.`eav_record_id` FROM `eav_values_string` AS `EavValuesString` WHERE `EavValuesString`.`eav_record_id` IN (665, 2166) 9914
25SELECT `EavValuesDatetime`.`id`, `EavValuesDatetime`.`field`, `EavValuesDatetime`.`value`, `EavValuesDatetime`.`eav_record_id` FROM `eav_values_datetime` AS `EavValuesDatetime` WHERE `EavValuesDatetime`.`eav_record_id` IN (665, 2166) 000
26SELECT `EavValuesArray`.`id`, `EavValuesArray`.`field`, `EavValuesArray`.`eav_record_id` FROM `eav_values_array` AS `EavValuesArray` WHERE `EavValuesArray`.`eav_record_id` IN (665, 2166) 000
27SELECT `EavValuesBoolean`.`id`, `EavValuesBoolean`.`field`, `EavValuesBoolean`.`value`, `EavValuesBoolean`.`eav_record_id` FROM `eav_values_boolean` AS `EavValuesBoolean` WHERE `EavValuesBoolean`.`eav_record_id` IN (665, 2166) 000
28SELECT `EavValuesText`.`id`, `EavValuesText`.`field`, `EavValuesText`.`value`, `EavValuesText`.`eav_record_id` FROM `eav_values_text` AS `EavValuesText` WHERE `EavValuesText`.`eav_record_id` IN (665, 2166) 000
29SELECT `EavValuesFloat`.`id`, `EavValuesFloat`.`field`, `EavValuesFloat`.`value`, `EavValuesFloat`.`eav_record_id` FROM `eav_values_float` AS `EavValuesFloat` WHERE `EavValuesFloat`.`eav_record_id` IN (665, 2166) 220
30SELECT `EavValuesDate`.`id`, `EavValuesDate`.`field`, `EavValuesDate`.`value`, `EavValuesDate`.`eav_record_id` FROM `eav_values_date` AS `EavValuesDate` WHERE `EavValuesDate`.`eav_record_id` IN (665, 2166) 000
31SELECT `User`.`id`, `User`.`slug`, `User`.`userType`, `User`.`username`, `User`.`email`, `User`.`password`, `User`.`city`, `User`.`state`, `User`.`country`, `User`.`postal_code`, `User`.`created`, `User`.`lastLoginIpAddr`, `User`.`status`, `User`.`emailVerified`, `User`.`avatar`, `User`.`validateCode`, `User`.`last_login_date`, `User`.`first_name`, `User`.`last_name`, `User`.`is_editor`, `User`.`review_count`, `User`.`listing_count`, `User`.`listing_asset_count`, `User`.`review_comment_count`, `User`.`is_deactivated`, `User`.`onAddedListingApproval`, `User`.`onAddedReviewApproval`, `User`.`onReviewLiked`, `User`.`onPhotoGetComment`, `User`.`onCommentedPhotoComment`, `User`.`onReviewedListingReview`, `User`.`onFavListingReviewed`, `User`.`onAddedReviewGetComment`, `User`.`onCommentedReviewGetComment`, `User`.`business_information` FROM `users` AS `User` WHERE `User`.`id` = 13 LIMIT 1111
32SELECT `User`.`id`, `User`.`slug`, `User`.`userType`, `User`.`username`, `User`.`email`, `User`.`password`, `User`.`city`, `User`.`state`, `User`.`country`, `User`.`postal_code`, `User`.`created`, `User`.`lastLoginIpAddr`, `User`.`status`, `User`.`emailVerified`, `User`.`avatar`, `User`.`validateCode`, `User`.`last_login_date`, `User`.`first_name`, `User`.`last_name`, `User`.`is_editor`, `User`.`review_count`, `User`.`listing_count`, `User`.`listing_asset_count`, `User`.`review_comment_count`, `User`.`is_deactivated`, `User`.`onAddedListingApproval`, `User`.`onAddedReviewApproval`, `User`.`onReviewLiked`, `User`.`onPhotoGetComment`, `User`.`onCommentedPhotoComment`, `User`.`onReviewedListingReview`, `User`.`onFavListingReviewed`, `User`.`onAddedReviewGetComment`, `User`.`onCommentedReviewGetComment`, `User`.`business_information` FROM `users` AS `User` WHERE `User`.`id` = 17 LIMIT 1111
33SELECT `ContentScope`.`id`, `ContentScope`.`title`, `ContentScope`.`model`, `ContentScope`.`conditions`, `ContentScope`.`order_by`, `ContentScope`.`sort_order`, `ContentScope`.`randomize` FROM `content_scopes` AS `ContentScope` WHERE `ContentScope`.`id` = 5 LIMIT 1111
34SELECT COUNT(*) AS `count` FROM `listings` AS `Listing` WHERE `Listing`.`list_category_id` IN (13, 124, 126, 129) AND `Listing`.`status` = 1 1115
35SELECT `Listing`.`id` FROM `listings` AS `Listing` WHERE `Listing`.`list_category_id` IN (13, 124, 126, 129) ORDER BY `Listing`.`created` DESC LIMIT 1061061061
36SELECT `Listing`.`id`, `Listing`.`title`, `Listing`.`image`, `Listing`.`description`, `Listing`.`status`, `Listing`.`slug`, `Listing`.`user_id`, `Listing`.`created`, `Listing`.`list_category_id`, `Listing`.`ip`, `Listing`.`summary`, `Listing`.`is_editorial`, `Listing`.`is_featured`, `Listing`.`featured_date`, `Listing`.`review_count`, `Listing`.`views_count`, `Listing`.`meta_keywords`, `Listing`.`meta_description`, `Listing`.`userAvg`, `Listing`.`editorialAvg`, `Listing`.`lat`, `Listing`.`lng`, `Listing`.`location_search_cache`, `Listing`.`owner_id`, `Listing`.`owner_candidate_id` FROM `listings` AS `Listing` WHERE `Listing`.`id` IN (1457, 606, 520, 277) AND `Listing`.`status` = 1 ORDER BY `Listing`.`created` DESC LIMIT 4440
37SELECT `EavRecord`.`id`, `EavRecord`.`entity_id` FROM `eav_records` AS `EavRecord` WHERE `EavRecord`.`entity` = 'Listing' AND `EavRecord`.`entity_id` = (277) 117
38SELECT `EavValuesInt`.`id`, `EavValuesInt`.`field`, `EavValuesInt`.`value`, `EavValuesInt`.`eav_record_id` FROM `eav_values_int` AS `EavValuesInt` WHERE `EavValuesInt`.`eav_record_id` = (364) 1118
39SELECT `EavValuesString`.`id`, `EavValuesString`.`field`, `EavValuesString`.`value`, `EavValuesString`.`eav_record_id` FROM `eav_values_string` AS `EavValuesString` WHERE `EavValuesString`.`eav_record_id` = (364) 662
40SELECT `EavValuesDatetime`.`id`, `EavValuesDatetime`.`field`, `EavValuesDatetime`.`value`, `EavValuesDatetime`.`eav_record_id` FROM `eav_values_datetime` AS `EavValuesDatetime` WHERE `EavValuesDatetime`.`eav_record_id` = (364) 000
41SELECT `EavValuesArray`.`id`, `EavValuesArray`.`field`, `EavValuesArray`.`eav_record_id` FROM `eav_values_array` AS `EavValuesArray` WHERE `EavValuesArray`.`eav_record_id` = (364) 118
42SELECT `EavValuesArrayElement`.`id`, `EavValuesArrayElement`.`value`, `EavValuesArrayElement`.`eav_values_array_id` FROM `eav_values_array_elements` AS `EavValuesArrayElement` WHERE `EavValuesArrayElement`.`eav_values_array_id` = (706) 1110
43SELECT `EavValuesBoolean`.`id`, `EavValuesBoolean`.`field`, `EavValuesBoolean`.`value`, `EavValuesBoolean`.`eav_record_id` FROM `eav_values_boolean` AS `EavValuesBoolean` WHERE `EavValuesBoolean`.`eav_record_id` = (364) 000
44SELECT `EavValuesText`.`id`, `EavValuesText`.`field`, `EavValuesText`.`value`, `EavValuesText`.`eav_record_id` FROM `eav_values_text` AS `EavValuesText` WHERE `EavValuesText`.`eav_record_id` = (364) 000
45SELECT `EavValuesFloat`.`id`, `EavValuesFloat`.`field`, `EavValuesFloat`.`value`, `EavValuesFloat`.`eav_record_id` FROM `eav_values_float` AS `EavValuesFloat` WHERE `EavValuesFloat`.`eav_record_id` = (364) 110
46SELECT `EavValuesDate`.`id`, `EavValuesDate`.`field`, `EavValuesDate`.`value`, `EavValuesDate`.`eav_record_id` FROM `eav_values_date` AS `EavValuesDate` WHERE `EavValuesDate`.`eav_record_id` = (364) 000
47SELECT `ContentScope`.`id`, `ContentScope`.`title`, `ContentScope`.`model`, `ContentScope`.`conditions`, `ContentScope`.`order_by`, `ContentScope`.`sort_order`, `ContentScope`.`randomize` FROM `content_scopes` AS `ContentScope` WHERE `ContentScope`.`id` = 6 LIMIT 1110
48SELECT COUNT(*) AS `count` FROM `listings` AS `Listing` WHERE `Listing`.`list_category_id` IN (143, 156, 147) AND `Listing`.`status` = 1 1115
49SELECT `Listing`.`id` FROM `listings` AS `Listing` WHERE `Listing`.`list_category_id` IN (143, 156, 147) ORDER BY `Listing`.`created` DESC LIMIT 2152152151
50SELECT `Listing`.`id`, `Listing`.`title`, `Listing`.`image`, `Listing`.`description`, `Listing`.`status`, `Listing`.`slug`, `Listing`.`user_id`, `Listing`.`created`, `Listing`.`list_category_id`, `Listing`.`ip`, `Listing`.`summary`, `Listing`.`is_editorial`, `Listing`.`is_featured`, `Listing`.`featured_date`, `Listing`.`review_count`, `Listing`.`views_count`, `Listing`.`meta_keywords`, `Listing`.`meta_description`, `Listing`.`userAvg`, `Listing`.`editorialAvg`, `Listing`.`lat`, `Listing`.`lng`, `Listing`.`location_search_cache`, `Listing`.`owner_id`, `Listing`.`owner_candidate_id` FROM `listings` AS `Listing` WHERE `Listing`.`id` IN (3252, 3218, 300, 166) AND `Listing`.`status` = 1 ORDER BY `Listing`.`created` DESC LIMIT 4441
51SELECT `EavRecord`.`id`, `EavRecord`.`entity_id` FROM `eav_records` AS `EavRecord` WHERE `EavRecord`.`entity` = 'Listing' AND `EavRecord`.`entity_id` = (3218) 111
52SELECT `EavValuesInt`.`id`, `EavValuesInt`.`field`, `EavValuesInt`.`value`, `EavValuesInt`.`eav_record_id` FROM `eav_values_int` AS `EavValuesInt` WHERE `EavValuesInt`.`eav_record_id` = (3700) 441
53SELECT `EavValuesString`.`id`, `EavValuesString`.`field`, `EavValuesString`.`value`, `EavValuesString`.`eav_record_id` FROM `eav_values_string` AS `EavValuesString` WHERE `EavValuesString`.`eav_record_id` = (3700) 880
54SELECT `EavValuesDatetime`.`id`, `EavValuesDatetime`.`field`, `EavValuesDatetime`.`value`, `EavValuesDatetime`.`eav_record_id` FROM `eav_values_datetime` AS `EavValuesDatetime` WHERE `EavValuesDatetime`.`eav_record_id` = (3700) 000
55SELECT `EavValuesArray`.`id`, `EavValuesArray`.`field`, `EavValuesArray`.`eav_record_id` FROM `eav_values_array` AS `EavValuesArray` WHERE `EavValuesArray`.`eav_record_id` = (3700) 000
56SELECT `EavValuesBoolean`.`id`, `EavValuesBoolean`.`field`, `EavValuesBoolean`.`value`, `EavValuesBoolean`.`eav_record_id` FROM `eav_values_boolean` AS `EavValuesBoolean` WHERE `EavValuesBoolean`.`eav_record_id` = (3700) 000
57SELECT `EavValuesText`.`id`, `EavValuesText`.`field`, `EavValuesText`.`value`, `EavValuesText`.`eav_record_id` FROM `eav_values_text` AS `EavValuesText` WHERE `EavValuesText`.`eav_record_id` = (3700) 000
58SELECT `EavValuesFloat`.`id`, `EavValuesFloat`.`field`, `EavValuesFloat`.`value`, `EavValuesFloat`.`eav_record_id` FROM `eav_values_float` AS `EavValuesFloat` WHERE `EavValuesFloat`.`eav_record_id` = (3700) 220
59SELECT `EavValuesDate`.`id`, `EavValuesDate`.`field`, `EavValuesDate`.`value`, `EavValuesDate`.`eav_record_id` FROM `eav_values_date` AS `EavValuesDate` WHERE `EavValuesDate`.`eav_record_id` = (3700) 000
60SELECT `User`.`id`, `User`.`slug`, `User`.`userType`, `User`.`username`, `User`.`email`, `User`.`password`, `User`.`city`, `User`.`state`, `User`.`country`, `User`.`postal_code`, `User`.`created`, `User`.`lastLoginIpAddr`, `User`.`status`, `User`.`emailVerified`, `User`.`avatar`, `User`.`validateCode`, `User`.`last_login_date`, `User`.`first_name`, `User`.`last_name`, `User`.`is_editor`, `User`.`review_count`, `User`.`listing_count`, `User`.`listing_asset_count`, `User`.`review_comment_count`, `User`.`is_deactivated`, `User`.`onAddedListingApproval`, `User`.`onAddedReviewApproval`, `User`.`onReviewLiked`, `User`.`onPhotoGetComment`, `User`.`onCommentedPhotoComment`, `User`.`onReviewedListingReview`, `User`.`onFavListingReviewed`, `User`.`onAddedReviewGetComment`, `User`.`onCommentedReviewGetComment`, `User`.`business_information` FROM `users` AS `User` WHERE `User`.`id` = 6 LIMIT 1110
61SELECT `User`.`id`, `User`.`slug`, `User`.`userType`, `User`.`username`, `User`.`email`, `User`.`password`, `User`.`city`, `User`.`state`, `User`.`country`, `User`.`postal_code`, `User`.`created`, `User`.`lastLoginIpAddr`, `User`.`status`, `User`.`emailVerified`, `User`.`avatar`, `User`.`validateCode`, `User`.`last_login_date`, `User`.`first_name`, `User`.`last_name`, `User`.`is_editor`, `User`.`review_count`, `User`.`listing_count`, `User`.`listing_asset_count`, `User`.`review_comment_count`, `User`.`is_deactivated`, `User`.`onAddedListingApproval`, `User`.`onAddedReviewApproval`, `User`.`onReviewLiked`, `User`.`onPhotoGetComment`, `User`.`onCommentedPhotoComment`, `User`.`onReviewedListingReview`, `User`.`onFavListingReviewed`, `User`.`onAddedReviewGetComment`, `User`.`onCommentedReviewGetComment`, `User`.`business_information` FROM `users` AS `User` WHERE `User`.`id` = 14 LIMIT 1110
62SELECT `ListCategory`.`id`, `ListCategory`.`parent_id`, `ListCategory`.`lft`, `ListCategory`.`rght`, `ListCategory`.`name`, `ListCategory`.`slug`, `ListCategory`.`icon`, `ListCategory`.`description`, `ListCategory`.`listing_type_id`, `ListCategory`.`listing_count`, `ListCategory`.`childrenCount`, `ListCategory`.`order`, `ListCategory`.`parent_node_name` FROM `list_categories` AS `ListCategory` WHERE `parent_id` IS NULL ORDER BY `ListCategory`.`order` asc, `ListCategory`.`name` asc 14141
63SELECT COUNT(*) AS `count` FROM `reviews` AS `Review` LEFT JOIN `listings` AS `Listing` ON (`Review`.`listing_id` = `Listing`.`id`) WHERE `Review`.`status` = 1 119
64SELECT `Review`.`id`, `Review`.`title`, `Review`.`listing_id`, `Review`.`type`, `Review`.`body`, `Review`.`user_id`, `Review`.`ip`, `Review`.`is_editorial`, `Review`.`rating`, `Review`.`is_featured`, `Review`.`featured_date`, `Review`.`status`, `Review`.`created`, `Review`.`avg_score`, `Review`.`list_category_id`, `Review`.`review_comment_count`, `Review`.`views_count`, `Review`.`guest_id`, `Review`.`vote_count`, `Review`.`listing_asset_count`, `Review`.`published_email_sent`, `Listing`.`id`, `Listing`.`title`, `Listing`.`image`, `Listing`.`description`, `Listing`.`status`, `Listing`.`slug`, `Listing`.`user_id`, `Listing`.`created`, `Listing`.`list_category_id`, `Listing`.`ip`, `Listing`.`summary`, `Listing`.`is_editorial`, `Listing`.`is_featured`, `Listing`.`featured_date`, `Listing`.`review_count`, `Listing`.`views_count`, `Listing`.`meta_keywords`, `Listing`.`meta_description`, `Listing`.`userAvg`, `Listing`.`editorialAvg`, `Listing`.`lat`, `Listing`.`lng`, `Listing`.`location_search_cache`, `Listing`.`owner_id`, `Listing`.`owner_candidate_id` FROM `reviews` AS `Review` LEFT JOIN `listings` AS `Listing` ON (`Review`.`listing_id` = `Listing`.`id`) WHERE `Review`.`status` = 1 ORDER BY `Review`.`created` DESC LIMIT 5551
65SELECT `EavRecord`.`id`, `EavRecord`.`entity_id` FROM `eav_records` AS `EavRecord` WHERE `EavRecord`.`entity` = 'Review' AND `EavRecord`.`entity_id` = (490) 111
66SELECT `EavValuesInt`.`id`, `EavValuesInt`.`field`, `EavValuesInt`.`value`, `EavValuesInt`.`eav_record_id` FROM `eav_values_int` AS `EavValuesInt` WHERE `EavValuesInt`.`eav_record_id` = (4336) 110
67SELECT `EavValuesString`.`id`, `EavValuesString`.`field`, `EavValuesString`.`value`, `EavValuesString`.`eav_record_id` FROM `eav_values_string` AS `EavValuesString` WHERE `EavValuesString`.`eav_record_id` = (4336) 000
68SELECT `EavValuesDatetime`.`id`, `EavValuesDatetime`.`field`, `EavValuesDatetime`.`value`, `EavValuesDatetime`.`eav_record_id` FROM `eav_values_datetime` AS `EavValuesDatetime` WHERE `EavValuesDatetime`.`eav_record_id` = (4336) 000
69SELECT `EavValuesArray`.`id`, `EavValuesArray`.`field`, `EavValuesArray`.`eav_record_id` FROM `eav_values_array` AS `EavValuesArray` WHERE `EavValuesArray`.`eav_record_id` = (4336) 000
70SELECT `EavValuesBoolean`.`id`, `EavValuesBoolean`.`field`, `EavValuesBoolean`.`value`, `EavValuesBoolean`.`eav_record_id` FROM `eav_values_boolean` AS `EavValuesBoolean` WHERE `EavValuesBoolean`.`eav_record_id` = (4336) 000
71SELECT `EavValuesText`.`id`, `EavValuesText`.`field`, `EavValuesText`.`value`, `EavValuesText`.`eav_record_id` FROM `eav_values_text` AS `EavValuesText` WHERE `EavValuesText`.`eav_record_id` = (4336) 000
72SELECT `EavValuesFloat`.`id`, `EavValuesFloat`.`field`, `EavValuesFloat`.`value`, `EavValuesFloat`.`eav_record_id` FROM `eav_values_float` AS `EavValuesFloat` WHERE `EavValuesFloat`.`eav_record_id` = (4336) 000
73SELECT `EavValuesDate`.`id`, `EavValuesDate`.`field`, `EavValuesDate`.`value`, `EavValuesDate`.`eav_record_id` FROM `eav_values_date` AS `EavValuesDate` WHERE `EavValuesDate`.`eav_record_id` = (4336) 000
74SELECT `User`.`id`, `User`.`slug`, `User`.`userType`, `User`.`username`, `User`.`email`, `User`.`password`, `User`.`city`, `User`.`state`, `User`.`country`, `User`.`postal_code`, `User`.`created`, `User`.`lastLoginIpAddr`, `User`.`status`, `User`.`emailVerified`, `User`.`avatar`, `User`.`validateCode`, `User`.`last_login_date`, `User`.`first_name`, `User`.`last_name`, `User`.`is_editor`, `User`.`review_count`, `User`.`listing_count`, `User`.`listing_asset_count`, `User`.`review_comment_count`, `User`.`is_deactivated`, `User`.`onAddedListingApproval`, `User`.`onAddedReviewApproval`, `User`.`onReviewLiked`, `User`.`onPhotoGetComment`, `User`.`onCommentedPhotoComment`, `User`.`onReviewedListingReview`, `User`.`onFavListingReviewed`, `User`.`onAddedReviewGetComment`, `User`.`onCommentedReviewGetComment`, `User`.`business_information` FROM `users` AS `User` WHERE `User`.`id` = 32 LIMIT 1110
75SELECT COUNT(*) AS `count` FROM `listing_assets` AS `ListingAsset` WHERE `user_id` = 32 AND `listing_id` = 273 AND `status` = 1 111
76SELECT COUNT(*) AS `count` FROM `reviews` AS `Review` WHERE `Review`.`id` = 490 110
77UPDATE `reviews` SET `listing_asset_count` = 0 WHERE `reviews`.`id` = 49007
78SELECT `Review`.`listing_id`, `Review`.`id` FROM `reviews` AS `Review` LEFT JOIN `listings` AS `Listing` ON (`Review`.`listing_id` = `Listing`.`id`) WHERE `Review`.`id` = 490 AND `Review`.`status` = 1 LIMIT 1110
79SELECT COUNT(*) AS `count` FROM `reviews` AS `Review` LEFT JOIN `listings` AS `Listing` ON (`Review`.`listing_id` = `Listing`.`id`) WHERE `Review`.`status` = 1 AND NOT (`Review`.`is_editorial` = 1) AND `Review`.`listing_id` = 273 AND `Review`.`status` = 1 110
80UPDATE `listings` AS `Listing` LEFT JOIN `list_categories` AS `ListCategory` ON (`Listing`.`list_category_id` = `ListCategory`.`id`) LEFT JOIN `users` AS `User` ON (`Listing`.`user_id` = `User`.`id`) SET `Listing`.`review_count` = 1 WHERE `Listing`.`id` = 27300
81SELECT `User`.`id`, `User`.`slug`, `User`.`userType`, `User`.`username`, `User`.`email`, `User`.`password`, `User`.`city`, `User`.`state`, `User`.`country`, `User`.`postal_code`, `User`.`created`, `User`.`lastLoginIpAddr`, `User`.`status`, `User`.`emailVerified`, `User`.`avatar`, `User`.`validateCode`, `User`.`last_login_date`, `User`.`first_name`, `User`.`last_name`, `User`.`is_editor`, `User`.`review_count`, `User`.`listing_count`, `User`.`listing_asset_count`, `User`.`review_comment_count`, `User`.`is_deactivated`, `User`.`onAddedListingApproval`, `User`.`onAddedReviewApproval`, `User`.`onReviewLiked`, `User`.`onPhotoGetComment`, `User`.`onCommentedPhotoComment`, `User`.`onReviewedListingReview`, `User`.`onFavListingReviewed`, `User`.`onAddedReviewGetComment`, `User`.`onCommentedReviewGetComment`, `User`.`business_information` FROM `users` AS `User` WHERE `User`.`id` = 36 LIMIT 1110
82SELECT COUNT(*) AS `count` FROM `listing_assets` AS `ListingAsset` WHERE `user_id` = 36 AND `listing_id` = 2673 AND `status` = 1 1118
83SELECT COUNT(*) AS `count` FROM `reviews` AS `Review` WHERE `Review`.`id` = 476 110
84UPDATE `reviews` SET `listing_asset_count` = 0 WHERE `reviews`.`id` = 47600
85SELECT `Review`.`listing_id`, `Review`.`id` FROM `reviews` AS `Review` LEFT JOIN `listings` AS `Listing` ON (`Review`.`listing_id` = `Listing`.`id`) WHERE `Review`.`id` = 476 AND `Review`.`status` = 1 LIMIT 1110
86SELECT COUNT(*) AS `count` FROM `reviews` AS `Review` LEFT JOIN `listings` AS `Listing` ON (`Review`.`listing_id` = `Listing`.`id`) WHERE `Review`.`status` = 1 AND NOT (`Review`.`is_editorial` = 1) AND `Review`.`listing_id` = 2673 AND `Review`.`status` = 1 110
87UPDATE `listings` AS `Listing` LEFT JOIN `list_categories` AS `ListCategory` ON (`Listing`.`list_category_id` = `ListCategory`.`id`) LEFT JOIN `users` AS `User` ON (`Listing`.`user_id` = `User`.`id`) SET `Listing`.`review_count` = 2 WHERE `Listing`.`id` = 267300
88SELECT `User`.`id`, `User`.`slug`, `User`.`userType`, `User`.`username`, `User`.`email`, `User`.`password`, `User`.`city`, `User`.`state`, `User`.`country`, `User`.`postal_code`, `User`.`created`, `User`.`lastLoginIpAddr`, `User`.`status`, `User`.`emailVerified`, `User`.`avatar`, `User`.`validateCode`, `User`.`last_login_date`, `User`.`first_name`, `User`.`last_name`, `User`.`is_editor`, `User`.`review_count`, `User`.`listing_count`, `User`.`listing_asset_count`, `User`.`review_comment_count`, `User`.`is_deactivated`, `User`.`onAddedListingApproval`, `User`.`onAddedReviewApproval`, `User`.`onReviewLiked`, `User`.`onPhotoGetComment`, `User`.`onCommentedPhotoComment`, `User`.`onReviewedListingReview`, `User`.`onFavListingReviewed`, `User`.`onAddedReviewGetComment`, `User`.`onCommentedReviewGetComment`, `User`.`business_information` FROM `users` AS `User` WHERE `User`.`id` = 1 LIMIT 1110
89SELECT COUNT(*) AS `count` FROM `listing_assets` AS `ListingAsset` WHERE `user_id` = 1 AND `listing_id` = 2673 AND `status` = 1 118
90SELECT COUNT(*) AS `count` FROM `reviews` AS `Review` WHERE `Review`.`id` = 453 110
91UPDATE `reviews` SET `listing_asset_count` = 0 WHERE `reviews`.`id` = 45300
92SELECT `Review`.`listing_id`, `Review`.`id` FROM `reviews` AS `Review` LEFT JOIN `listings` AS `Listing` ON (`Review`.`listing_id` = `Listing`.`id`) WHERE `Review`.`id` = 453 AND `Review`.`status` = 1 LIMIT 1110
93SELECT COUNT(*) AS `count` FROM `reviews` AS `Review` LEFT JOIN `listings` AS `Listing` ON (`Review`.`listing_id` = `Listing`.`id`) WHERE `Review`.`status` = 1 AND NOT (`Review`.`is_editorial` = 1) AND `Review`.`listing_id` = 2673 AND `Review`.`status` = 1 110
94UPDATE `listings` AS `Listing` LEFT JOIN `list_categories` AS `ListCategory` ON (`Listing`.`list_category_id` = `ListCategory`.`id`) LEFT JOIN `users` AS `User` ON (`Listing`.`user_id` = `User`.`id`) SET `Listing`.`review_count` = 2 WHERE `Listing`.`id` = 267300
95SELECT `Guest`.`id`, `Guest`.`name`, `Guest`.`email` FROM `guests` AS `Guest` WHERE `Guest`.`id` = 16 LIMIT 1116
96SELECT `Listing`.`image` FROM `listings` AS `Listing` WHERE `Listing`.`id` = 1770 LIMIT 1110
97SELECT `User`.`id`, `User`.`slug`, `User`.`userType`, `User`.`username`, `User`.`email`, `User`.`password`, `User`.`city`, `User`.`state`, `User`.`country`, `User`.`postal_code`, `User`.`created`, `User`.`lastLoginIpAddr`, `User`.`status`, `User`.`emailVerified`, `User`.`avatar`, `User`.`validateCode`, `User`.`last_login_date`, `User`.`first_name`, `User`.`last_name`, `User`.`is_editor`, `User`.`review_count`, `User`.`listing_count`, `User`.`listing_asset_count`, `User`.`review_comment_count`, `User`.`is_deactivated`, `User`.`onAddedListingApproval`, `User`.`onAddedReviewApproval`, `User`.`onReviewLiked`, `User`.`onPhotoGetComment`, `User`.`onCommentedPhotoComment`, `User`.`onReviewedListingReview`, `User`.`onFavListingReviewed`, `User`.`onAddedReviewGetComment`, `User`.`onCommentedReviewGetComment`, `User`.`business_information` FROM `users` AS `User` WHERE `User`.`id` = 28 LIMIT 1110
98SELECT COUNT(*) AS `count` FROM `listing_assets` AS `ListingAsset` WHERE `user_id` = 28 AND `listing_id` = 1770 AND `status` = 1 110
99SELECT COUNT(*) AS `count` FROM `reviews` AS `Review` WHERE `Review`.`id` = 451 110
100UPDATE `reviews` SET `listing_asset_count` = 0 WHERE `reviews`.`id` = 45100
101SELECT `Review`.`listing_id`, `Review`.`id` FROM `reviews` AS `Review` LEFT JOIN `listings` AS `Listing` ON (`Review`.`listing_id` = `Listing`.`id`) WHERE `Review`.`id` = 451 AND `Review`.`status` = 1 LIMIT 1110
102SELECT COUNT(*) AS `count` FROM `reviews` AS `Review` LEFT JOIN `listings` AS `Listing` ON (`Review`.`listing_id` = `Listing`.`id`) WHERE `Review`.`status` = 1 AND NOT (`Review`.`is_editorial` = 1) AND `Review`.`listing_id` = 1770 AND `Review`.`status` = 1 110
103UPDATE `listings` AS `Listing` LEFT JOIN `list_categories` AS `ListCategory` ON (`Listing`.`list_category_id` = `ListCategory`.`id`) LEFT JOIN `users` AS `User` ON (`Listing`.`user_id` = `User`.`id`) SET `Listing`.`review_count` = 2 WHERE `Listing`.`id` = 177000
104SELECT `ListCategory`.`listing_type_id` FROM `list_categories` AS `ListCategory` WHERE `ListCategory`.`id` = 13 ORDER BY `ListCategory`.`order` asc, `ListCategory`.`name` asc LIMIT 1110
105SELECT `ListingTypeFieldset`.`id`, `ListingTypeFieldset`.`fieldset_id` FROM `listing_type_fieldsets` AS `ListingTypeFieldset` WHERE `listing_type_id` = 36 ORDER BY `field_order` ASC 330
106SELECT `Fieldset`.`id`, `Fieldset`.`name`, `Fieldset`.`label`, `Fieldset`.`show_label`, `Fieldset`.`entity`, `Fieldset`.`status`, `Fieldset`.`created` FROM `fieldsets` AS `Fieldset` WHERE `id` IN (49, 50, 34) AND `entity` = 'Review' ORDER BY FIELD(id,49,50,34) ASC 001
107SELECT `RateableField`.`id`, `RateableField`.`name`, `RateableField`.`is_required`, `RateableField`.`weight`, `RateableField`.`tooltip`, `RateableField`.`listing_type_id` FROM `rateable_fields` AS `RateableField` WHERE `listing_type_id` = 36 110
108SELECT COUNT(*) AS `count` FROM `votes` AS `Vote` LEFT JOIN `reviews` AS `Review` ON (`Vote`.`item_id` = `Review`.`id`) WHERE `Vote`.`type` = 'Review' AND `Vote`.`item_id` = 490 AND `Vote`.`score` = 1 110
109SELECT COUNT(*) AS `count` FROM `votes` AS `Vote` LEFT JOIN `reviews` AS `Review` ON (`Vote`.`item_id` = `Review`.`id`) WHERE `Vote`.`type` = 'Review' AND `Vote`.`item_id` = 490 AND `Vote`.`score` = -1 110