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

Latest Products

Mastering CSS for Web Developers (Smashing eBook Series) [Kindle Edition]
Mastering CSS for Web Developers (Smashing eBook Series) [Kindle Edition]
Added By: altheabrown
About 2 years ago
(0)
Great Classic Family Favorites: Unabridged Stories [Audiobook, CD] [Audio CD]
Great Classic Family Favorites: Unabridged Stories [Audiobook, CD] [Audio CD]
Added By: altheabrown
About 2 years ago
(0)
Cost Accounting
Cost Accounting
Added By: Karinalamo
About 2 years ago
(0)
The Cook's Illustrated Cookbook: 2,000 Recipes from 20 Years of America's Most Trusted Cooking Magazine 
The Cook's Illustrated Cookbook: 2,000 Recipes from 20 Years of America's Most Trusted Cooking Magazine 
Added By: Lenoresit
About 2 years ago
(0)
Sony PRS-T1 6 Digital E-Ink Pearl eReader with Wi-Fi (Black)
Sony PRS-T1 6 Digital E-Ink Pearl eReader with Wi-Fi (Black)
Added By: tiawedge
About 2 years ago
(0)
Dell Computer Corp Inspiron 560 Desktop PC with 23" LCD Monitor - i560-3505NBK
Dell Computer Corp Inspiron 560 Desktop PC with 23" LCD Monitor - i560-3505NBK
Added By: Halleya
About 2 years ago
(0)
Amazon Kindle Fire Tablet PU Leather Case Cover Executive Folio Journal Book with Pocket (Black)
Amazon Kindle Fire Tablet PU Leather Case Cover Executive Folio Journal Book with Pocket (Black)
Added By: AllieKephart
About 2 years ago
(0)
Lenovo IdeaPad U260
Lenovo IdeaPad U260
Added By: Reginia
About 2 years ago
(0)
Dungeon Siege III
Dungeon Siege III
Added By: earlenesigg
About 2 years ago
(0)
Dead Island (Xbox 360)
Dead Island (Xbox 360)
Added By: earlenesigg
About 2 years ago
(0)
Call of Duty: Modern Warfare 3
Call of Duty: Modern Warfare 3
Added By: earlenesigg
About 2 years ago
(0)
WWE '12 (Xbox 360)
WWE '12 (Xbox 360)
Added By: Halleya
About 2 years ago
(0)
HTC Radar 4G
HTC Radar 4G
Added By: tiawedge
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)
Design Hard Protector Skin Cover Cell Phone Case for Samsung Galaxy Prevail M820 Boost Mobile - Leopard
Design Hard Protector Skin Cover Cell Phone Case for Samsung Galaxy Prevail M820 Boost Mobile - Leopard
Added By: earlenesigg
About 2 years ago
(0)
LG Thrill 4G (AT&T)
LG Thrill 4G (AT&T)
Added By: AgripinaRig
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) 86 queries took 99 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 1118
4SELECT COUNT(*) AS `count` FROM `listings` AS `Listing` WHERE `Listing`.`list_category_id` IN (25, 20, 22, 23, 24, 19) AND `Listing`.`status` = 1 1125
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 (1634, 1571, 1226, 753) 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` = (753) 110
8SELECT `EavValuesInt`.`id`, `EavValuesInt`.`field`, `EavValuesInt`.`value`, `EavValuesInt`.`eav_record_id` FROM `eav_values_int` AS `EavValuesInt` WHERE `EavValuesInt`.`eav_record_id` = (1227) 000
9SELECT `EavValuesString`.`id`, `EavValuesString`.`field`, `EavValuesString`.`value`, `EavValuesString`.`eav_record_id` FROM `eav_values_string` AS `EavValuesString` WHERE `EavValuesString`.`eav_record_id` = (1227) 229
10SELECT `EavValuesDatetime`.`id`, `EavValuesDatetime`.`field`, `EavValuesDatetime`.`value`, `EavValuesDatetime`.`eav_record_id` FROM `eav_values_datetime` AS `EavValuesDatetime` WHERE `EavValuesDatetime`.`eav_record_id` = (1227) 000
11SELECT `EavValuesArray`.`id`, `EavValuesArray`.`field`, `EavValuesArray`.`eav_record_id` FROM `eav_values_array` AS `EavValuesArray` WHERE `EavValuesArray`.`eav_record_id` = (1227) 000
12SELECT `EavValuesBoolean`.`id`, `EavValuesBoolean`.`field`, `EavValuesBoolean`.`value`, `EavValuesBoolean`.`eav_record_id` FROM `eav_values_boolean` AS `EavValuesBoolean` WHERE `EavValuesBoolean`.`eav_record_id` = (1227) 000
13SELECT `EavValuesText`.`id`, `EavValuesText`.`field`, `EavValuesText`.`value`, `EavValuesText`.`eav_record_id` FROM `eav_values_text` AS `EavValuesText` WHERE `EavValuesText`.`eav_record_id` = (1227) 000
14SELECT `EavValuesFloat`.`id`, `EavValuesFloat`.`field`, `EavValuesFloat`.`value`, `EavValuesFloat`.`eav_record_id` FROM `eav_values_float` AS `EavValuesFloat` WHERE `EavValuesFloat`.`eav_record_id` = (1227) 115
15SELECT `EavValuesDate`.`id`, `EavValuesDate`.`field`, `EavValuesDate`.`value`, `EavValuesDate`.`eav_record_id` FROM `eav_values_date` AS `EavValuesDate` WHERE `EavValuesDate`.`eav_record_id` = (1227) 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 1110
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` = 14 LIMIT 1110
18SELECT `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
19SELECT `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
20SELECT COUNT(*) AS `count` FROM `listings` AS `Listing` WHERE `Listing`.`list_category_id` IN (130, 131, 135, 138, 139) AND `Listing`.`status` = 1 1123
21SELECT `Listing`.`id` FROM `listings` AS `Listing` WHERE `Listing`.`list_category_id` IN (130, 131, 135, 138, 139) ORDER BY `Listing`.`created` DESC LIMIT 2242242241
22SELECT `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 (3467, 1683, 1282, 632) AND `Listing`.`status` = 1 ORDER BY `Listing`.`created` DESC LIMIT 4448
23SELECT `EavRecord`.`id`, `EavRecord`.`entity_id` FROM `eav_records` AS `EavRecord` WHERE `EavRecord`.`entity` = 'Listing' AND `EavRecord`.`entity_id` = (1282) 110
24SELECT `EavValuesInt`.`id`, `EavValuesInt`.`field`, `EavValuesInt`.`value`, `EavValuesInt`.`eav_record_id` FROM `eav_values_int` AS `EavValuesInt` WHERE `EavValuesInt`.`eav_record_id` = (1756) 000
25SELECT `EavValuesString`.`id`, `EavValuesString`.`field`, `EavValuesString`.`value`, `EavValuesString`.`eav_record_id` FROM `eav_values_string` AS `EavValuesString` WHERE `EavValuesString`.`eav_record_id` = (1756) 228
26SELECT `EavValuesDatetime`.`id`, `EavValuesDatetime`.`field`, `EavValuesDatetime`.`value`, `EavValuesDatetime`.`eav_record_id` FROM `eav_values_datetime` AS `EavValuesDatetime` WHERE `EavValuesDatetime`.`eav_record_id` = (1756) 000
27SELECT `EavValuesArray`.`id`, `EavValuesArray`.`field`, `EavValuesArray`.`eav_record_id` FROM `eav_values_array` AS `EavValuesArray` WHERE `EavValuesArray`.`eav_record_id` = (1756) 000
28SELECT `EavValuesBoolean`.`id`, `EavValuesBoolean`.`field`, `EavValuesBoolean`.`value`, `EavValuesBoolean`.`eav_record_id` FROM `eav_values_boolean` AS `EavValuesBoolean` WHERE `EavValuesBoolean`.`eav_record_id` = (1756) 000
29SELECT `EavValuesText`.`id`, `EavValuesText`.`field`, `EavValuesText`.`value`, `EavValuesText`.`eav_record_id` FROM `eav_values_text` AS `EavValuesText` WHERE `EavValuesText`.`eav_record_id` = (1756) 000
30SELECT `EavValuesFloat`.`id`, `EavValuesFloat`.`field`, `EavValuesFloat`.`value`, `EavValuesFloat`.`eav_record_id` FROM `eav_values_float` AS `EavValuesFloat` WHERE `EavValuesFloat`.`eav_record_id` = (1756) 113
31SELECT `EavValuesDate`.`id`, `EavValuesDate`.`field`, `EavValuesDate`.`value`, `EavValuesDate`.`eav_record_id` FROM `eav_values_date` AS `EavValuesDate` WHERE `EavValuesDate`.`eav_record_id` = (1756) 000
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` = 23 LIMIT 1110
33SELECT `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 1110
34SELECT `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` = 20 LIMIT 1110
35SELECT `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` = 19 LIMIT 1110
36SELECT `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 1110
37SELECT COUNT(*) AS `count` FROM `listings` AS `Listing` WHERE `Listing`.`list_category_id` IN (13, 124, 126, 129) AND `Listing`.`status` = 1 111
38SELECT `Listing`.`id` FROM `listings` AS `Listing` WHERE `Listing`.`list_category_id` IN (13, 124, 126, 129) ORDER BY `Listing`.`created` DESC LIMIT 1061061061
39SELECT `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 (654, 639, 524, 295) AND `Listing`.`status` = 1 ORDER BY `Listing`.`created` DESC LIMIT 4440
40SELECT `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
41SELECT COUNT(*) AS `count` FROM `listings` AS `Listing` WHERE `Listing`.`list_category_id` IN (143, 156, 147) AND `Listing`.`status` = 1 111
42SELECT `Listing`.`id` FROM `listings` AS `Listing` WHERE `Listing`.`list_category_id` IN (143, 156, 147) ORDER BY `Listing`.`created` DESC LIMIT 2152152151
43SELECT `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 (3423, 3252, 1880, 109) AND `Listing`.`status` = 1 ORDER BY `Listing`.`created` DESC LIMIT 4441
44SELECT `EavRecord`.`id`, `EavRecord`.`entity_id` FROM `eav_records` AS `EavRecord` WHERE `EavRecord`.`entity` = 'Listing' AND `EavRecord`.`entity_id` = (3252) 110
45SELECT `EavValuesInt`.`id`, `EavValuesInt`.`field`, `EavValuesInt`.`value`, `EavValuesInt`.`eav_record_id` FROM `eav_values_int` AS `EavValuesInt` WHERE `EavValuesInt`.`eav_record_id` = (3734) 000
46SELECT `EavValuesString`.`id`, `EavValuesString`.`field`, `EavValuesString`.`value`, `EavValuesString`.`eav_record_id` FROM `eav_values_string` AS `EavValuesString` WHERE `EavValuesString`.`eav_record_id` = (3734) 880
47SELECT `EavValuesDatetime`.`id`, `EavValuesDatetime`.`field`, `EavValuesDatetime`.`value`, `EavValuesDatetime`.`eav_record_id` FROM `eav_values_datetime` AS `EavValuesDatetime` WHERE `EavValuesDatetime`.`eav_record_id` = (3734) 000
48SELECT `EavValuesArray`.`id`, `EavValuesArray`.`field`, `EavValuesArray`.`eav_record_id` FROM `eav_values_array` AS `EavValuesArray` WHERE `EavValuesArray`.`eav_record_id` = (3734) 220
49SELECT `EavValuesArrayElement`.`id`, `EavValuesArrayElement`.`value`, `EavValuesArrayElement`.`eav_values_array_id` FROM `eav_values_array_elements` AS `EavValuesArrayElement` WHERE `EavValuesArrayElement`.`eav_values_array_id` IN (1119, 1120) 220
50SELECT `EavValuesBoolean`.`id`, `EavValuesBoolean`.`field`, `EavValuesBoolean`.`value`, `EavValuesBoolean`.`eav_record_id` FROM `eav_values_boolean` AS `EavValuesBoolean` WHERE `EavValuesBoolean`.`eav_record_id` = (3734) 000
51SELECT `EavValuesText`.`id`, `EavValuesText`.`field`, `EavValuesText`.`value`, `EavValuesText`.`eav_record_id` FROM `eav_values_text` AS `EavValuesText` WHERE `EavValuesText`.`eav_record_id` = (3734) 000
52SELECT `EavValuesFloat`.`id`, `EavValuesFloat`.`field`, `EavValuesFloat`.`value`, `EavValuesFloat`.`eav_record_id` FROM `eav_values_float` AS `EavValuesFloat` WHERE `EavValuesFloat`.`eav_record_id` = (3734) 220
53SELECT `EavValuesDate`.`id`, `EavValuesDate`.`field`, `EavValuesDate`.`value`, `EavValuesDate`.`eav_record_id` FROM `eav_values_date` AS `EavValuesDate` WHERE `EavValuesDate`.`eav_record_id` = (3734) 000
54SELECT COUNT(*) AS `count` FROM `reviews` AS `Review` LEFT JOIN `listings` AS `Listing` ON (`Review`.`listing_id` = `Listing`.`id`) WHERE `Review`.`status` = 1 111
55SELECT `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
56SELECT `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` = 11 LIMIT 1110
57SELECT `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
58SELECT COUNT(*) AS `count` FROM `listing_assets` AS `ListingAsset` WHERE `user_id` = 32 AND `listing_id` = 273 AND `status` = 1 110
59SELECT COUNT(*) AS `count` FROM `reviews` AS `Review` WHERE `Review`.`id` = 490 110
60UPDATE `reviews` SET `listing_asset_count` = 0 WHERE `reviews`.`id` = 49000
61SELECT `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
62SELECT 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
63UPDATE `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
64SELECT `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
65SELECT COUNT(*) AS `count` FROM `listing_assets` AS `ListingAsset` WHERE `user_id` = 36 AND `listing_id` = 2673 AND `status` = 1 110
66SELECT COUNT(*) AS `count` FROM `reviews` AS `Review` WHERE `Review`.`id` = 476 110
67UPDATE `reviews` SET `listing_asset_count` = 0 WHERE `reviews`.`id` = 47600
68SELECT `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
69SELECT 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
70UPDATE `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
71SELECT `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
72SELECT COUNT(*) AS `count` FROM `listing_assets` AS `ListingAsset` WHERE `user_id` = 1 AND `listing_id` = 2673 AND `status` = 1 110
73SELECT COUNT(*) AS `count` FROM `reviews` AS `Review` WHERE `Review`.`id` = 453 110
74UPDATE `reviews` SET `listing_asset_count` = 0 WHERE `reviews`.`id` = 45300
75SELECT `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
76SELECT 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
77UPDATE `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
78SELECT `Guest`.`id`, `Guest`.`name`, `Guest`.`email` FROM `guests` AS `Guest` WHERE `Guest`.`id` = 16 LIMIT 1110
79SELECT `Listing`.`image` FROM `listings` AS `Listing` WHERE `Listing`.`id` = 1770 LIMIT 1110
80SELECT `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
81SELECT COUNT(*) AS `count` FROM `listing_assets` AS `ListingAsset` WHERE `user_id` = 28 AND `listing_id` = 1770 AND `status` = 1 110
82SELECT COUNT(*) AS `count` FROM `reviews` AS `Review` WHERE `Review`.`id` = 451 110
83UPDATE `reviews` SET `listing_asset_count` = 0 WHERE `reviews`.`id` = 45100
84SELECT `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
85SELECT 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
86UPDATE `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