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

Search

Latest Products

Fix-It and Forget-It Big Cookbook: 1400 Best Slow Cooker Recipes!
Fix-It and Forget-It Big Cookbook: 1400 Best Slow Cooker Recipes!
Added By: Lancekobel
About 1 year ago
(0)
Stories: An Audio Collection
Stories: An Audio Collection
Added By: Lancekobel
About 1 year ago
(0)
501 Quilting Motifs: Designs for Hand or Machine Quilting (That Patchwork Place) [Hardcover-spiral]
501 Quilting Motifs: Designs for Hand or Machine Quilting (That Patchwork Place) [Hardcover-spiral]
Added By: altheabrown
About 1 year ago
(0)
Betty Crocker's Picture Cookbook [Facsimile] [Ring-bound]
Betty Crocker's Picture Cookbook [Facsimile] [Ring-bound]
Added By: altheabrown
About 1 year ago
(0)
Sturdy High-Grade Kensington Laptop Lock For Apple 13-Inch, 15-Inch & 17-Inch MacBook Pro
Sturdy High-Grade Kensington Laptop Lock For Apple 13-Inch, 15-Inch & 17-Inch MacBook Pro
Added By: bulowkent
About 1 year ago
(0)
Lenovo ThinkPad Edge E220s
Lenovo ThinkPad Edge E220s
Added By: Donellala
About 1 year ago
(0)
HP TouchSmart 600
HP TouchSmart 600
Added By: afanadorse
About 1 year ago
(0)
COBY Kyros 10in 4G Internet Tablet
COBY Kyros 10in 4G Internet Tablet
Added By: Lenoresit
About 1 year ago
(0)
Crysis 2
Crysis 2
Added By: bulowkent
About 1 year ago
(0)
Zumba Fitness: Join the Party
Zumba Fitness: Join the Party
Added By: earlenesigg
About 1 year ago
(0)
Bodycount
Bodycount
Added By: earlenesigg
About 1 year ago
(0)
NASCAR 2011: The Game
NASCAR 2011: The Game
Added By: Halleya
About 1 year ago
(0)
Bicycle Smart Phone Stem Mount Bag for Blackberry, HTC, Droid Phone
Bicycle Smart Phone Stem Mount Bag for Blackberry, HTC, Droid Phone
Added By: Lancekobel
About 1 year ago
(0)
HTC Inspire 4G 4-G Desire HD Cell Phone Full Diamond Crystals Bling Protective Case Cover Black with White and Pink Streaming Love Hearts Design
HTC Inspire 4G 4-G Desire HD Cell Phone Full Diamond Crystals Bling Protective Case Cover Black with White and Pink Streaming Love Hearts Design
Added By: Lancekobel
About 1 year ago
(0)
Home Travel Wall Charger + Rapid Cell Phone Car Charger + USB Data Sync Charge Cable for Samsung T659 / Intensity U450 / Rogue U960 / Smooth U350 / Gravity 2 T469
Home Travel Wall Charger + Rapid Cell Phone Car Charger + USB Data Sync Charge Cable for Samsung T659 / Intensity U450 / Rogue U960 / Smooth U350 / Gravity 2 T469
Added By: Lancekobel
About 1 year ago
(0)
Snap-on Rubber Coated Case for Apple® iPhone® 4 4S 4GS 4G AT&T / Verizon, Hot Pink / Black
Snap-on Rubber Coated Case for Apple® iPhone® 4 4S 4GS 4G AT&T / Verizon, Hot Pink / Black
Added By: bulowkent
About 1 year ago
(0)

Review categories

Latest CWEB Reviews

Awesome!!
Posted in Super Mario 3D Land (3DS)
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.
Posted in Maquillage Full Vision Gloss Coat Mascara
Very nice and thick.
Written By: shriti
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
Posted in Maquillage Full Vision Gloss Coat Mascara
Very Nice product
Written By: BrookLeff
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
Posted in Kinect Disneyland Adventures
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
Posted in Kinect Disneyland Adventures
Disneyland XBOX Game
Written By: caseylee
Great game. Really like it. Very good price.

Was this review helpful?
Read Full Comments (0)   Written By: caseylee
(default) 84 queries took 103 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 1001
2DESCRIBE `content_scopes`772
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 11113
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 (2841, 2810, 1627, 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` = (1627) 110
8SELECT `EavValuesInt`.`id`, `EavValuesInt`.`field`, `EavValuesInt`.`value`, `EavValuesInt`.`eav_record_id` FROM `eav_values_int` AS `EavValuesInt` WHERE `EavValuesInt`.`eav_record_id` = (2101) 000
9SELECT `EavValuesString`.`id`, `EavValuesString`.`field`, `EavValuesString`.`value`, `EavValuesString`.`eav_record_id` FROM `eav_values_string` AS `EavValuesString` WHERE `EavValuesString`.`eav_record_id` = (2101) 220
10SELECT `EavValuesDatetime`.`id`, `EavValuesDatetime`.`field`, `EavValuesDatetime`.`value`, `EavValuesDatetime`.`eav_record_id` FROM `eav_values_datetime` AS `EavValuesDatetime` WHERE `EavValuesDatetime`.`eav_record_id` = (2101) 000
11SELECT `EavValuesArray`.`id`, `EavValuesArray`.`field`, `EavValuesArray`.`eav_record_id` FROM `eav_values_array` AS `EavValuesArray` WHERE `EavValuesArray`.`eav_record_id` = (2101) 000
12SELECT `EavValuesBoolean`.`id`, `EavValuesBoolean`.`field`, `EavValuesBoolean`.`value`, `EavValuesBoolean`.`eav_record_id` FROM `eav_values_boolean` AS `EavValuesBoolean` WHERE `EavValuesBoolean`.`eav_record_id` = (2101) 000
13SELECT `EavValuesText`.`id`, `EavValuesText`.`field`, `EavValuesText`.`value`, `EavValuesText`.`eav_record_id` FROM `eav_values_text` AS `EavValuesText` WHERE `EavValuesText`.`eav_record_id` = (2101) 000
14SELECT `EavValuesFloat`.`id`, `EavValuesFloat`.`field`, `EavValuesFloat`.`value`, `EavValuesFloat`.`eav_record_id` FROM `eav_values_float` AS `EavValuesFloat` WHERE `EavValuesFloat`.`eav_record_id` = (2101) 110
15SELECT `EavValuesDate`.`id`, `EavValuesDate`.`field`, `EavValuesDate`.`value`, `EavValuesDate`.`eav_record_id` FROM `eav_values_date` AS `EavValuesDate` WHERE `EavValuesDate`.`eav_record_id` = (2101) 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 1112
18SELECT COUNT(*) AS `count` FROM `listings` AS `Listing` WHERE `Listing`.`list_category_id` IN (130, 131, 135, 138, 139) AND `Listing`.`status` = 1 112
19SELECT `Listing`.`id` FROM `listings` AS `Listing` WHERE `Listing`.`list_category_id` IN (130, 131, 135, 138, 139) ORDER BY `Listing`.`created` DESC LIMIT 2242242242
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 (3352, 564, 472, 392) 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` = (3352) 110
22SELECT `EavValuesInt`.`id`, `EavValuesInt`.`field`, `EavValuesInt`.`value`, `EavValuesInt`.`eav_record_id` FROM `eav_values_int` AS `EavValuesInt` WHERE `EavValuesInt`.`eav_record_id` = (3834) 000
23SELECT `EavValuesString`.`id`, `EavValuesString`.`field`, `EavValuesString`.`value`, `EavValuesString`.`eav_record_id` FROM `eav_values_string` AS `EavValuesString` WHERE `EavValuesString`.`eav_record_id` = (3834) 220
24SELECT `EavValuesDatetime`.`id`, `EavValuesDatetime`.`field`, `EavValuesDatetime`.`value`, `EavValuesDatetime`.`eav_record_id` FROM `eav_values_datetime` AS `EavValuesDatetime` WHERE `EavValuesDatetime`.`eav_record_id` = (3834) 000
25SELECT `EavValuesArray`.`id`, `EavValuesArray`.`field`, `EavValuesArray`.`eav_record_id` FROM `eav_values_array` AS `EavValuesArray` WHERE `EavValuesArray`.`eav_record_id` = (3834) 001
26SELECT `EavValuesBoolean`.`id`, `EavValuesBoolean`.`field`, `EavValuesBoolean`.`value`, `EavValuesBoolean`.`eav_record_id` FROM `eav_values_boolean` AS `EavValuesBoolean` WHERE `EavValuesBoolean`.`eav_record_id` = (3834) 000
27SELECT `EavValuesText`.`id`, `EavValuesText`.`field`, `EavValuesText`.`value`, `EavValuesText`.`eav_record_id` FROM `eav_values_text` AS `EavValuesText` WHERE `EavValuesText`.`eav_record_id` = (3834) 000
28SELECT `EavValuesFloat`.`id`, `EavValuesFloat`.`field`, `EavValuesFloat`.`value`, `EavValuesFloat`.`eav_record_id` FROM `eav_values_float` AS `EavValuesFloat` WHERE `EavValuesFloat`.`eav_record_id` = (3834) 110
29SELECT `EavValuesDate`.`id`, `EavValuesDate`.`field`, `EavValuesDate`.`value`, `EavValuesDate`.`eav_record_id` FROM `eav_values_date` AS `EavValuesDate` WHERE `EavValuesDate`.`eav_record_id` = (3834) 000
30SELECT `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
31SELECT `ListCategory`.`listing_type_id` FROM `list_categories` AS `ListCategory` WHERE `ListCategory`.`id` = 138 ORDER BY `ListCategory`.`order` asc, `ListCategory`.`name` asc LIMIT 1110
32SELECT `ListingTypeFieldset`.`id`, `ListingTypeFieldset`.`fieldset_id` FROM `listing_type_fieldsets` AS `ListingTypeFieldset` WHERE `listing_type_id` = 29 ORDER BY `field_order` ASC 550
33SELECT `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
34SELECT `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
35SELECT `CustomField`.`name`, `CustomField`.`id` FROM `custom_fields` AS `CustomField` WHERE `fieldset_id` = 35 330
36SELECT `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
37SELECT `CustomField`.`name`, `CustomField`.`id` FROM `custom_fields` AS `CustomField` WHERE `fieldset_id` = 36 660
38SELECT `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
39SELECT `CustomField`.`name`, `CustomField`.`id` FROM `custom_fields` AS `CustomField` WHERE `fieldset_id` = 51 220
40SELECT `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
41SELECT `CustomField`.`name`, `CustomField`.`id` FROM `custom_fields` AS `CustomField` WHERE `fieldset_id` = 34 110
42SELECT `ListCategory`.`listing_type_id` FROM `list_categories` AS `ListCategory` WHERE `ListCategory`.`id` = 138 ORDER BY `ListCategory`.`order` asc, `ListCategory`.`name` asc LIMIT 1110
43SELECT `ListingTypeFieldset`.`id`, `ListingTypeFieldset`.`fieldset_id` FROM `listing_type_fieldsets` AS `ListingTypeFieldset` WHERE `listing_type_id` = 29 ORDER BY `field_order` ASC 550
44SELECT `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
45SELECT `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
46SELECT `CustomField`.`name`, `CustomField`.`id` FROM `custom_fields` AS `CustomField` WHERE `fieldset_id` = 25 220
47SELECT `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 111
48SELECT `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
49SELECT COUNT(*) AS `count` FROM `listings` AS `Listing` WHERE `Listing`.`list_category_id` IN (13, 124, 126, 129) AND `Listing`.`status` = 1 111
50SELECT `Listing`.`id` FROM `listings` AS `Listing` WHERE `Listing`.`list_category_id` IN (13, 124, 126, 129) ORDER BY `Listing`.`created` DESC LIMIT 1061061061
51SELECT `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 (2484, 648, 642, 286) AND `Listing`.`status` = 1 ORDER BY `Listing`.`created` DESC LIMIT 4441
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` = 6 LIMIT 1110
53SELECT COUNT(*) AS `count` FROM `listings` AS `Listing` WHERE `Listing`.`list_category_id` IN (143, 156, 147) AND `Listing`.`status` = 1 111
54SELECT `Listing`.`id` FROM `listings` AS `Listing` WHERE `Listing`.`list_category_id` IN (143, 156, 147) ORDER BY `Listing`.`created` DESC LIMIT 2152152151
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 (3295, 3045, 3042, 1290) AND `Listing`.`status` = 1 ORDER BY `Listing`.`created` DESC LIMIT 4441
56SELECT `EavRecord`.`id`, `EavRecord`.`entity_id` FROM `eav_records` AS `EavRecord` WHERE `EavRecord`.`entity` = 'Listing' AND `EavRecord`.`entity_id` IN (3295, 3045, 3042, 1290) 441
57SELECT `EavValuesInt`.`id`, `EavValuesInt`.`field`, `EavValuesInt`.`value`, `EavValuesInt`.`eav_record_id` FROM `eav_values_int` AS `EavValuesInt` WHERE `EavValuesInt`.`eav_record_id` IN (1764, 3523, 3526, 3777) 12120
58SELECT `EavValuesString`.`id`, `EavValuesString`.`field`, `EavValuesString`.`value`, `EavValuesString`.`eav_record_id` FROM `eav_values_string` AS `EavValuesString` WHERE `EavValuesString`.`eav_record_id` IN (1764, 3523, 3526, 3777) 262662
59SELECT `EavValuesDatetime`.`id`, `EavValuesDatetime`.`field`, `EavValuesDatetime`.`value`, `EavValuesDatetime`.`eav_record_id` FROM `eav_values_datetime` AS `EavValuesDatetime` WHERE `EavValuesDatetime`.`eav_record_id` IN (1764, 3523, 3526, 3777) 000
60SELECT `EavValuesArray`.`id`, `EavValuesArray`.`field`, `EavValuesArray`.`eav_record_id` FROM `eav_values_array` AS `EavValuesArray` WHERE `EavValuesArray`.`eav_record_id` IN (1764, 3523, 3526, 3777) 000
61SELECT `EavValuesBoolean`.`id`, `EavValuesBoolean`.`field`, `EavValuesBoolean`.`value`, `EavValuesBoolean`.`eav_record_id` FROM `eav_values_boolean` AS `EavValuesBoolean` WHERE `EavValuesBoolean`.`eav_record_id` IN (1764, 3523, 3526, 3777) 000
62SELECT `EavValuesText`.`id`, `EavValuesText`.`field`, `EavValuesText`.`value`, `EavValuesText`.`eav_record_id` FROM `eav_values_text` AS `EavValuesText` WHERE `EavValuesText`.`eav_record_id` IN (1764, 3523, 3526, 3777) 000
63SELECT `EavValuesFloat`.`id`, `EavValuesFloat`.`field`, `EavValuesFloat`.`value`, `EavValuesFloat`.`eav_record_id` FROM `eav_values_float` AS `EavValuesFloat` WHERE `EavValuesFloat`.`eav_record_id` IN (1764, 3523, 3526, 3777) 770
64SELECT `EavValuesDate`.`id`, `EavValuesDate`.`field`, `EavValuesDate`.`value`, `EavValuesDate`.`eav_record_id` FROM `eav_values_date` AS `EavValuesDate` WHERE `EavValuesDate`.`eav_record_id` IN (1764, 3523, 3526, 3777) 000
65SELECT COUNT(*) AS `count` FROM `reviews` AS `Review` LEFT JOIN `listings` AS `Listing` ON (`Review`.`listing_id` = `Listing`.`id`) WHERE `Review`.`status` = 1 111
66SELECT `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
67SELECT `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
68SELECT `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
69SELECT `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 1111
70SELECT COUNT(*) AS `count` FROM `listing_assets` AS `ListingAsset` WHERE `user_id` = 36 AND `listing_id` = 2673 AND `status` = 1 110
71SELECT COUNT(*) AS `count` FROM `reviews` AS `Review` WHERE `Review`.`id` = 476 110
72UPDATE `reviews` SET `listing_asset_count` = 0 WHERE `reviews`.`id` = 47600
73SELECT `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
74SELECT 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
75UPDATE `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
76SELECT `Guest`.`id`, `Guest`.`name`, `Guest`.`email` FROM `guests` AS `Guest` WHERE `Guest`.`id` = 16 LIMIT 1110
77SELECT `Listing`.`image` FROM `listings` AS `Listing` WHERE `Listing`.`id` = 1770 LIMIT 1111
78SELECT `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 1111
79SELECT COUNT(*) AS `count` FROM `listing_assets` AS `ListingAsset` WHERE `user_id` = 28 AND `listing_id` = 1770 AND `status` = 1 111
80SELECT COUNT(*) AS `count` FROM `reviews` AS `Review` WHERE `Review`.`id` = 451 110
81UPDATE `reviews` SET `listing_asset_count` = 0 WHERE `reviews`.`id` = 45100
82SELECT `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
83SELECT 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
84UPDATE `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