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

Latest Products

Philosophical and Ideological Voices in Educatio
Philosophical and Ideological Voices in Educatio
Added By: Lancekobel
About 2 years ago
(0)
Writing Young Adult Fiction For Dummies
Writing Young Adult Fiction For Dummies
Added By: Lancekobel
About 2 years ago
(0)
Science Fiction, Imperialism and the Third World: Essays on Postcolonial Literature and Film
Science Fiction, Imperialism and the Third World: Essays on Postcolonial Literature and Film
Added By: Lancekobel
About 2 years ago
(0)
Betty Crocker's Picture Cookbook [Facsimile] [Ring-bound]
Betty Crocker's Picture Cookbook [Facsimile] [Ring-bound]
Added By: altheabrown
About 2 years ago
(0)
Dell Inspiron 560
Dell Inspiron 560
Added By: Donellala
About 2 years ago
(0)
Lenovo IdeaCentre B305 40311PU
Lenovo IdeaCentre B305 40311PU
Added By: afanadorse
About 2 years ago
(0)
Apple iPad (32GB)
Apple iPad (32GB)
Added By: Lenoresit
About 2 years ago
(0)
Alienware M18x
Alienware M18x
Added By: earlenesigg
About 2 years ago
(0)
Wipeout In the Zone
Wipeout In the Zone
Added By: Lancekobel
About 2 years ago
(0)
Let's Draw!
Let's Draw!
Added By: bulowkent
About 2 years ago
(0)
Sonic's Ultimate Genesis Collection
Sonic's Ultimate Genesis Collection
Added By: tiawedge
About 2 years ago
(0)
Zumba Fitness: Join the Party
Zumba Fitness: Join the Party
Added By: earlenesigg
About 2 years ago
(0)
Philips 46PFL5706/F7
Philips 46PFL5706/F7
Added By: Reginia
About 2 years ago
(0)
Philips 40PFL5706/F7
Philips 40PFL5706/F7
Added By: Reginia
About 2 years ago
(0)
Sharp Elite PRO-70X5FD
Sharp Elite PRO-70X5FD
Added By: Halleya
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) 103 queries took 110 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 111
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 (2883, 2865, 2860, 1598) AND `Listing`.`status` = 1 ORDER BY `Listing`.`created` DESC LIMIT 4441
7SELECT `EavRecord`.`id`, `EavRecord`.`entity_id` FROM `eav_records` AS `EavRecord` WHERE `EavRecord`.`entity` = 'Listing' AND `EavRecord`.`entity_id` IN (2865, 1598) 221
8SELECT `EavValuesInt`.`id`, `EavValuesInt`.`field`, `EavValuesInt`.`value`, `EavValuesInt`.`eav_record_id` FROM `eav_values_int` AS `EavValuesInt` WHERE `EavValuesInt`.`eav_record_id` IN (2072, 3344) 110
9SELECT `EavValuesString`.`id`, `EavValuesString`.`field`, `EavValuesString`.`value`, `EavValuesString`.`eav_record_id` FROM `eav_values_string` AS `EavValuesString` WHERE `EavValuesString`.`eav_record_id` IN (2072, 3344) 440
10SELECT `EavValuesDatetime`.`id`, `EavValuesDatetime`.`field`, `EavValuesDatetime`.`value`, `EavValuesDatetime`.`eav_record_id` FROM `eav_values_datetime` AS `EavValuesDatetime` WHERE `EavValuesDatetime`.`eav_record_id` IN (2072, 3344) 000
11SELECT `EavValuesArray`.`id`, `EavValuesArray`.`field`, `EavValuesArray`.`eav_record_id` FROM `eav_values_array` AS `EavValuesArray` WHERE `EavValuesArray`.`eav_record_id` IN (2072, 3344) 000
12SELECT `EavValuesBoolean`.`id`, `EavValuesBoolean`.`field`, `EavValuesBoolean`.`value`, `EavValuesBoolean`.`eav_record_id` FROM `eav_values_boolean` AS `EavValuesBoolean` WHERE `EavValuesBoolean`.`eav_record_id` IN (2072, 3344) 000
13SELECT `EavValuesText`.`id`, `EavValuesText`.`field`, `EavValuesText`.`value`, `EavValuesText`.`eav_record_id` FROM `eav_values_text` AS `EavValuesText` WHERE `EavValuesText`.`eav_record_id` IN (2072, 3344) 000
14SELECT `EavValuesFloat`.`id`, `EavValuesFloat`.`field`, `EavValuesFloat`.`value`, `EavValuesFloat`.`eav_record_id` FROM `eav_values_float` AS `EavValuesFloat` WHERE `EavValuesFloat`.`eav_record_id` IN (2072, 3344) 220
15SELECT `EavValuesDate`.`id`, `EavValuesDate`.`field`, `EavValuesDate`.`value`, `EavValuesDate`.`eav_record_id` FROM `eav_values_date` AS `EavValuesDate` WHERE `EavValuesDate`.`eav_record_id` IN (2072, 3344) 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 `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
18SELECT COUNT(*) AS `count` FROM `listings` AS `Listing` WHERE `Listing`.`list_category_id` IN (130, 131, 135, 138, 139) AND `Listing`.`status` = 1 111
19SELECT `Listing`.`id` FROM `listings` AS `Listing` WHERE `Listing`.`list_category_id` IN (130, 131, 135, 138, 139) ORDER BY `Listing`.`created` DESC LIMIT 2242242241
20SELECT `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 (526, 454, 386, 381) AND `Listing`.`status` = 1 ORDER BY `Listing`.`created` DESC LIMIT 4440
21SELECT `EavRecord`.`id`, `EavRecord`.`entity_id` FROM `eav_records` AS `EavRecord` WHERE `EavRecord`.`entity` = 'Listing' AND `EavRecord`.`entity_id` IN (526, 454, 386, 381) 446
22SELECT `EavValuesInt`.`id`, `EavValuesInt`.`field`, `EavValuesInt`.`value`, `EavValuesInt`.`eav_record_id` FROM `eav_values_int` AS `EavValuesInt` WHERE `EavValuesInt`.`eav_record_id` IN (468, 473, 542, 640) 662
23SELECT `EavValuesString`.`id`, `EavValuesString`.`field`, `EavValuesString`.`value`, `EavValuesString`.`eav_record_id` FROM `eav_values_string` AS `EavValuesString` WHERE `EavValuesString`.`eav_record_id` IN (468, 473, 542, 640) 272723
24SELECT `EavValuesDatetime`.`id`, `EavValuesDatetime`.`field`, `EavValuesDatetime`.`value`, `EavValuesDatetime`.`eav_record_id` FROM `eav_values_datetime` AS `EavValuesDatetime` WHERE `EavValuesDatetime`.`eav_record_id` IN (468, 473, 542, 640) 000
25SELECT `EavValuesArray`.`id`, `EavValuesArray`.`field`, `EavValuesArray`.`eav_record_id` FROM `eav_values_array` AS `EavValuesArray` WHERE `EavValuesArray`.`eav_record_id` IN (468, 473, 542, 640) 115
26SELECT `EavValuesArrayElement`.`id`, `EavValuesArrayElement`.`value`, `EavValuesArrayElement`.`eav_values_array_id` FROM `eav_values_array_elements` AS `EavValuesArrayElement` WHERE `EavValuesArrayElement`.`eav_values_array_id` = (818) 2210
27SELECT `EavValuesBoolean`.`id`, `EavValuesBoolean`.`field`, `EavValuesBoolean`.`value`, `EavValuesBoolean`.`eav_record_id` FROM `eav_values_boolean` AS `EavValuesBoolean` WHERE `EavValuesBoolean`.`eav_record_id` IN (468, 473, 542, 640) 000
28SELECT `EavValuesText`.`id`, `EavValuesText`.`field`, `EavValuesText`.`value`, `EavValuesText`.`eav_record_id` FROM `eav_values_text` AS `EavValuesText` WHERE `EavValuesText`.`eav_record_id` IN (468, 473, 542, 640) 000
29SELECT `EavValuesFloat`.`id`, `EavValuesFloat`.`field`, `EavValuesFloat`.`value`, `EavValuesFloat`.`eav_record_id` FROM `eav_values_float` AS `EavValuesFloat` WHERE `EavValuesFloat`.`eav_record_id` IN (468, 473, 542, 640) 442
30SELECT `EavValuesDate`.`id`, `EavValuesDate`.`field`, `EavValuesDate`.`value`, `EavValuesDate`.`eav_record_id` FROM `eav_values_date` AS `EavValuesDate` WHERE `EavValuesDate`.`eav_record_id` IN (468, 473, 542, 640) 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` = 17 LIMIT 1110
32SELECT `ListCategory`.`listing_type_id` FROM `list_categories` AS `ListCategory` WHERE `ListCategory`.`id` = 138 ORDER BY `ListCategory`.`order` asc, `ListCategory`.`name` asc LIMIT 1110
33SELECT `ListingTypeFieldset`.`id`, `ListingTypeFieldset`.`fieldset_id` FROM `listing_type_fieldsets` AS `ListingTypeFieldset` WHERE `listing_type_id` = 29 ORDER BY `field_order` ASC 556
34SELECT `Fieldset`.`id`, `Fieldset`.`name`, `Fieldset`.`label`, `Fieldset`.`show_label`, `Fieldset`.`entity`, `Fieldset`.`status`, `Fieldset`.`created` FROM `fieldsets` AS `Fieldset` WHERE `id` IN (25, 35, 36, 51, 34) AND `entity` = 'Listing' ORDER BY FIELD(id,25,35,36,51,34) ASC 440
35SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`label`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`tooltip`, `CustomField`.`options`, `CustomField`.`order`, `CustomField`.`fieldset_id`, `CustomField`.`group`, `CustomField`.`index`, `CustomField`.`edit`, `CustomField`.`advanced_search`, `CustomField`.`other_information` FROM `custom_fields` AS `CustomField` WHERE `fieldset_id` = 35 ORDER BY `CustomField`.`order` ASC 330
36SELECT `CustomField`.`name`, `CustomField`.`id` FROM `custom_fields` AS `CustomField` WHERE `fieldset_id` = 35 330
37SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`label`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`tooltip`, `CustomField`.`options`, `CustomField`.`order`, `CustomField`.`fieldset_id`, `CustomField`.`group`, `CustomField`.`index`, `CustomField`.`edit`, `CustomField`.`advanced_search`, `CustomField`.`other_information` FROM `custom_fields` AS `CustomField` WHERE `fieldset_id` = 36 ORDER BY `CustomField`.`order` ASC 660
38SELECT `CustomField`.`name`, `CustomField`.`id` FROM `custom_fields` AS `CustomField` WHERE `fieldset_id` = 36 660
39SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`label`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`tooltip`, `CustomField`.`options`, `CustomField`.`order`, `CustomField`.`fieldset_id`, `CustomField`.`group`, `CustomField`.`index`, `CustomField`.`edit`, `CustomField`.`advanced_search`, `CustomField`.`other_information` FROM `custom_fields` AS `CustomField` WHERE `fieldset_id` = 51 ORDER BY `CustomField`.`order` ASC 220
40SELECT `CustomField`.`name`, `CustomField`.`id` FROM `custom_fields` AS `CustomField` WHERE `fieldset_id` = 51 220
41SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`label`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`tooltip`, `CustomField`.`options`, `CustomField`.`order`, `CustomField`.`fieldset_id`, `CustomField`.`group`, `CustomField`.`index`, `CustomField`.`edit`, `CustomField`.`advanced_search`, `CustomField`.`other_information` FROM `custom_fields` AS `CustomField` WHERE `fieldset_id` = 34 ORDER BY `CustomField`.`order` ASC 110
42SELECT `CustomField`.`name`, `CustomField`.`id` FROM `custom_fields` AS `CustomField` WHERE `fieldset_id` = 34 110
43SELECT `ListCategory`.`listing_type_id` FROM `list_categories` AS `ListCategory` WHERE `ListCategory`.`id` = 138 ORDER BY `ListCategory`.`order` asc, `ListCategory`.`name` asc LIMIT 1110
44SELECT `ListingTypeFieldset`.`id`, `ListingTypeFieldset`.`fieldset_id` FROM `listing_type_fieldsets` AS `ListingTypeFieldset` WHERE `listing_type_id` = 29 ORDER BY `field_order` ASC 550
45SELECT `Fieldset`.`id`, `Fieldset`.`name`, `Fieldset`.`label`, `Fieldset`.`show_label`, `Fieldset`.`entity`, `Fieldset`.`status`, `Fieldset`.`created` FROM `fieldsets` AS `Fieldset` WHERE `id` IN (25, 35, 36, 51, 34) AND `entity` = 'Review' ORDER BY FIELD(id,25,35,36,51,34) ASC 110
46SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`label`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`tooltip`, `CustomField`.`options`, `CustomField`.`order`, `CustomField`.`fieldset_id`, `CustomField`.`group`, `CustomField`.`index`, `CustomField`.`edit`, `CustomField`.`advanced_search`, `CustomField`.`other_information` FROM `custom_fields` AS `CustomField` WHERE `fieldset_id` = 25 ORDER BY `CustomField`.`order` ASC 220
47SELECT `CustomField`.`name`, `CustomField`.`id` FROM `custom_fields` AS `CustomField` WHERE `fieldset_id` = 25 220
48SELECT `RateableField`.`id`, `RateableField`.`name`, `RateableField`.`is_required`, `RateableField`.`weight`, `RateableField`.`tooltip`, `RateableField`.`listing_type_id` FROM `rateable_fields` AS `RateableField` WHERE `listing_type_id` = 29 110
49SELECT `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` = 22 LIMIT 1110
50SELECT `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 1111
51SELECT `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` = 8 LIMIT 1110
52SELECT `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
53SELECT COUNT(*) AS `count` FROM `listings` AS `Listing` WHERE `Listing`.`list_category_id` IN (13, 124, 126, 129) AND `Listing`.`status` = 1 111
54SELECT `Listing`.`id` FROM `listings` AS `Listing` WHERE `Listing`.`list_category_id` IN (13, 124, 126, 129) ORDER BY `Listing`.`created` DESC LIMIT 1061061061
55SELECT `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 (1783, 1458, 1375, 648) AND `Listing`.`status` = 1 ORDER BY `Listing`.`created` DESC LIMIT 4445
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` = 23 LIMIT 1111
57SELECT `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
58SELECT COUNT(*) AS `count` FROM `listings` AS `Listing` WHERE `Listing`.`list_category_id` IN (143, 156, 147) AND `Listing`.`status` = 1 111
59SELECT `Listing`.`id` FROM `listings` AS `Listing` WHERE `Listing`.`list_category_id` IN (143, 156, 147) ORDER BY `Listing`.`created` DESC LIMIT 2152152151
60SELECT `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 (3842, 416, 414, 149) AND `Listing`.`status` = 1 ORDER BY `Listing`.`created` DESC LIMIT 4330
61SELECT `EavRecord`.`id`, `EavRecord`.`entity_id` FROM `eav_records` AS `EavRecord` WHERE `EavRecord`.`entity` = 'Listing' AND `EavRecord`.`entity_id` IN (416, 414) 220
62SELECT `EavValuesInt`.`id`, `EavValuesInt`.`field`, `EavValuesInt`.`value`, `EavValuesInt`.`eav_record_id` FROM `eav_values_int` AS `EavValuesInt` WHERE `EavValuesInt`.`eav_record_id` IN (502, 504) 221
63SELECT `EavValuesString`.`id`, `EavValuesString`.`field`, `EavValuesString`.`value`, `EavValuesString`.`eav_record_id` FROM `eav_values_string` AS `EavValuesString` WHERE `EavValuesString`.`eav_record_id` IN (502, 504) 12120
64SELECT `EavValuesDatetime`.`id`, `EavValuesDatetime`.`field`, `EavValuesDatetime`.`value`, `EavValuesDatetime`.`eav_record_id` FROM `eav_values_datetime` AS `EavValuesDatetime` WHERE `EavValuesDatetime`.`eav_record_id` IN (502, 504) 000
65SELECT `EavValuesArray`.`id`, `EavValuesArray`.`field`, `EavValuesArray`.`eav_record_id` FROM `eav_values_array` AS `EavValuesArray` WHERE `EavValuesArray`.`eav_record_id` IN (502, 504) 220
66SELECT `EavValuesArrayElement`.`id`, `EavValuesArrayElement`.`value`, `EavValuesArrayElement`.`eav_values_array_id` FROM `eav_values_array_elements` AS `EavValuesArrayElement` WHERE `EavValuesArrayElement`.`eav_values_array_id` IN (836, 838) 880
67SELECT `EavValuesBoolean`.`id`, `EavValuesBoolean`.`field`, `EavValuesBoolean`.`value`, `EavValuesBoolean`.`eav_record_id` FROM `eav_values_boolean` AS `EavValuesBoolean` WHERE `EavValuesBoolean`.`eav_record_id` IN (502, 504) 000
68SELECT `EavValuesText`.`id`, `EavValuesText`.`field`, `EavValuesText`.`value`, `EavValuesText`.`eav_record_id` FROM `eav_values_text` AS `EavValuesText` WHERE `EavValuesText`.`eav_record_id` IN (502, 504) 000
69SELECT `EavValuesFloat`.`id`, `EavValuesFloat`.`field`, `EavValuesFloat`.`value`, `EavValuesFloat`.`eav_record_id` FROM `eav_values_float` AS `EavValuesFloat` WHERE `EavValuesFloat`.`eav_record_id` IN (502, 504) 220
70SELECT `EavValuesDate`.`id`, `EavValuesDate`.`field`, `EavValuesDate`.`value`, `EavValuesDate`.`eav_record_id` FROM `eav_values_date` AS `EavValuesDate` WHERE `EavValuesDate`.`eav_record_id` IN (502, 504) 000
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` = 13 LIMIT 1111
72SELECT COUNT(*) AS `count` FROM `reviews` AS `Review` LEFT JOIN `listings` AS `Listing` ON (`Review`.`listing_id` = `Listing`.`id`) WHERE `Review`.`status` = 1 1117
73SELECT `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 5552
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 115
76SELECT COUNT(*) AS `count` FROM `reviews` AS `Review` WHERE `Review`.`id` = 490 110
77UPDATE `reviews` SET `listing_asset_count` = 0 WHERE `reviews`.`id` = 49000
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 1112
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 119
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 110
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 1110
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 111
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