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

Latest Products

The Well-Trained Mind - A Guide to Classical Education at Home
The Well-Trained Mind - A Guide to Classical Education at Home
Added By: Lancekobel
About 2 years ago
(0)
O, The Oprah Magazin
O, The Oprah Magazin
Added By: Lancekobel
About 2 years ago
(0)
InStyle
InStyle
Added By: Lancekobel
About 2 years ago
(0)
Fierce Dawn (ParaRealm Book One) 
Fierce Dawn (ParaRealm Book One) 
Added By: Lenoresit
About 2 years ago
(0)
Gumdrop Cases Drop Tech Series Case for Apple iPad 2, Red-Black, (DS-IPAD2-RED-BLK)
Gumdrop Cases Drop Tech Series Case for Apple iPad 2, Red-Black, (DS-IPAD2-RED-BLK)
Added By: Halleya
About 2 years ago
(0)
Toshiba Satellite L655-S5161
Toshiba Satellite L655-S5161
Added By: Donellala
About 2 years ago
(0)
Lenovo ThinkPad Edge E220s
Lenovo ThinkPad Edge E220s
Added By: Donellala
About 2 years ago
(0)
HP Envy 14
HP Envy 14
Added By: earlenesigg
About 2 years ago
(0)
Enslaved: Odyssey To The West
Enslaved: Odyssey To The West
Added By: bulowkent
About 2 years ago
(0)
Disney Princess: Magical Jewels
Disney Princess: Magical Jewels
Added By: bulowkent
About 2 years ago
(0)
Nintendo DSi Matte - Black
Nintendo DSi Matte - Black
Added By: Donellala
About 2 years ago
(0)
Dragon Ball Z Infinite World
Dragon Ball Z Infinite World
Added By: earlenesigg
About 2 years ago
(0)
LG Micro USB Data Cable for all LG Micro USB Phones - Black
LG Micro USB Data Cable for all LG Micro USB Phones - Black
Added By: Lancekobel
About 2 years ago
(0)
Clear - Durable Glossy Hard Shield with TPU Rubberized Gel Silicone Skin Cover Case for HTC Thunderbolt 4G / Droid Incredible HD 6400 Cell Phone
Clear - Durable Glossy Hard Shield with TPU Rubberized Gel Silicone Skin Cover Case for HTC Thunderbolt 4G / Droid Incredible HD 6400 Cell Phone
Added By: Lancekobel
About 2 years ago
(0)
Toshiba 46SL417U
Toshiba 46SL417U
Added By: Lenoresit
About 2 years ago
(0)
LG Infinia 47LV5500
LG Infinia 47LV5500
Added By: altheabrown
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) 113 queries took 102 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `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
2SELECT COUNT(*) AS `count` FROM `listings` AS `Listing` WHERE `Listing`.`list_category_id` IN (25, 20, 22, 23, 24, 19) AND `Listing`.`status` = 1 111
3SELECT `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
4SELECT `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 (2887, 2882, 2869, 740) AND `Listing`.`status` = 1 ORDER BY `Listing`.`created` DESC LIMIT 4441
5SELECT `EavRecord`.`id`, `EavRecord`.`entity_id` FROM `eav_records` AS `EavRecord` WHERE `EavRecord`.`entity` = 'Listing' AND `EavRecord`.`entity_id` IN (2887, 2869, 740) 331
6DESCRIBE `eav_values_int`441
7SELECT `EavValuesInt`.`id`, `EavValuesInt`.`field`, `EavValuesInt`.`value`, `EavValuesInt`.`eav_record_id` FROM `eav_values_int` AS `EavValuesInt` WHERE `EavValuesInt`.`eav_record_id` IN (1214, 3348, 3366) 000
8DESCRIBE `eav_values_string`441
9SELECT `EavValuesString`.`id`, `EavValuesString`.`field`, `EavValuesString`.`value`, `EavValuesString`.`eav_record_id` FROM `eav_values_string` AS `EavValuesString` WHERE `EavValuesString`.`eav_record_id` IN (1214, 3348, 3366) 6614
10DESCRIBE `eav_values_datetime`441
11SELECT `EavValuesDatetime`.`id`, `EavValuesDatetime`.`field`, `EavValuesDatetime`.`value`, `EavValuesDatetime`.`eav_record_id` FROM `eav_values_datetime` AS `EavValuesDatetime` WHERE `EavValuesDatetime`.`eav_record_id` IN (1214, 3348, 3366) 000
12DESCRIBE `eav_values_array`331
13DESCRIBE `eav_values_array_elements`331
14SELECT `EavValuesArray`.`id`, `EavValuesArray`.`field`, `EavValuesArray`.`eav_record_id` FROM `eav_values_array` AS `EavValuesArray` WHERE `EavValuesArray`.`eav_record_id` IN (1214, 3348, 3366) 000
15DESCRIBE `eav_values_boolean`441
16SELECT `EavValuesBoolean`.`id`, `EavValuesBoolean`.`field`, `EavValuesBoolean`.`value`, `EavValuesBoolean`.`eav_record_id` FROM `eav_values_boolean` AS `EavValuesBoolean` WHERE `EavValuesBoolean`.`eav_record_id` IN (1214, 3348, 3366) 000
17DESCRIBE `eav_values_text`441
18SELECT `EavValuesText`.`id`, `EavValuesText`.`field`, `EavValuesText`.`value`, `EavValuesText`.`eav_record_id` FROM `eav_values_text` AS `EavValuesText` WHERE `EavValuesText`.`eav_record_id` IN (1214, 3348, 3366) 000
19DESCRIBE `eav_values_float`441
20SELECT `EavValuesFloat`.`id`, `EavValuesFloat`.`field`, `EavValuesFloat`.`value`, `EavValuesFloat`.`eav_record_id` FROM `eav_values_float` AS `EavValuesFloat` WHERE `EavValuesFloat`.`eav_record_id` IN (1214, 3348, 3366) 330
21DESCRIBE `eav_values_date`441
22SELECT `EavValuesDate`.`id`, `EavValuesDate`.`field`, `EavValuesDate`.`value`, `EavValuesDate`.`eav_record_id` FROM `eav_values_date` AS `EavValuesDate` WHERE `EavValuesDate`.`eav_record_id` IN (1214, 3348, 3366) 000
23SELECT `ListCategory`.`listing_type_id` FROM `list_categories` AS `ListCategory` WHERE `ListCategory`.`id` = 25 ORDER BY `ListCategory`.`order` asc, `ListCategory`.`name` asc LIMIT 1110
24SELECT `ListingTypeFieldset`.`id`, `ListingTypeFieldset`.`fieldset_id` FROM `listing_type_fieldsets` AS `ListingTypeFieldset` WHERE `listing_type_id` = 37 ORDER BY `field_order` ASC 220
25SELECT `Fieldset`.`id`, `Fieldset`.`name`, `Fieldset`.`label`, `Fieldset`.`show_label`, `Fieldset`.`entity`, `Fieldset`.`status`, `Fieldset`.`created` FROM `fieldsets` AS `Fieldset` WHERE `id` IN (34, 51) AND `entity` = 'Listing' ORDER BY FIELD(id,34,51) ASC 220
26SELECT `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
27SELECT `CustomField`.`name`, `CustomField`.`id` FROM `custom_fields` AS `CustomField` WHERE `fieldset_id` = 34 110
28SELECT `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
29SELECT `CustomField`.`name`, `CustomField`.`id` FROM `custom_fields` AS `CustomField` WHERE `fieldset_id` = 51 220
30SELECT `ListCategory`.`listing_type_id` FROM `list_categories` AS `ListCategory` WHERE `ListCategory`.`id` = 25 ORDER BY `ListCategory`.`order` asc, `ListCategory`.`name` asc LIMIT 1110
31SELECT `ListingTypeFieldset`.`id`, `ListingTypeFieldset`.`fieldset_id` FROM `listing_type_fieldsets` AS `ListingTypeFieldset` WHERE `listing_type_id` = 37 ORDER BY `field_order` ASC 220
32SELECT `Fieldset`.`id`, `Fieldset`.`name`, `Fieldset`.`label`, `Fieldset`.`show_label`, `Fieldset`.`entity`, `Fieldset`.`status`, `Fieldset`.`created` FROM `fieldsets` AS `Fieldset` WHERE `id` IN (34, 51) AND `entity` = 'Review' ORDER BY FIELD(id,34,51) ASC 000
33SELECT `RateableField`.`id`, `RateableField`.`name`, `RateableField`.`is_required`, `RateableField`.`weight`, `RateableField`.`tooltip`, `RateableField`.`listing_type_id` FROM `rateable_fields` AS `RateableField` WHERE `listing_type_id` = 37 110
34SELECT `ListCategory`.`listing_type_id` FROM `list_categories` AS `ListCategory` WHERE `ListCategory`.`id` = 24 ORDER BY `ListCategory`.`order` asc, `ListCategory`.`name` asc LIMIT 1110
35SELECT `ListingTypeFieldset`.`id`, `ListingTypeFieldset`.`fieldset_id` FROM `listing_type_fieldsets` AS `ListingTypeFieldset` WHERE `listing_type_id` = 37 ORDER BY `field_order` ASC 220
36SELECT `Fieldset`.`id`, `Fieldset`.`name`, `Fieldset`.`label`, `Fieldset`.`show_label`, `Fieldset`.`entity`, `Fieldset`.`status`, `Fieldset`.`created` FROM `fieldsets` AS `Fieldset` WHERE `id` IN (34, 51) AND `entity` = 'Listing' ORDER BY FIELD(id,34,51) ASC 220
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` = 34 ORDER BY `CustomField`.`order` ASC 110
38SELECT `CustomField`.`name`, `CustomField`.`id` FROM `custom_fields` AS `CustomField` WHERE `fieldset_id` = 34 110
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 `ListCategory`.`listing_type_id` FROM `list_categories` AS `ListCategory` WHERE `ListCategory`.`id` = 24 ORDER BY `ListCategory`.`order` asc, `ListCategory`.`name` asc LIMIT 1110
42SELECT `ListingTypeFieldset`.`id`, `ListingTypeFieldset`.`fieldset_id` FROM `listing_type_fieldsets` AS `ListingTypeFieldset` WHERE `listing_type_id` = 37 ORDER BY `field_order` ASC 220
43SELECT `Fieldset`.`id`, `Fieldset`.`name`, `Fieldset`.`label`, `Fieldset`.`show_label`, `Fieldset`.`entity`, `Fieldset`.`status`, `Fieldset`.`created` FROM `fieldsets` AS `Fieldset` WHERE `id` IN (34, 51) AND `entity` = 'Review' ORDER BY FIELD(id,34,51) ASC 000
44SELECT `RateableField`.`id`, `RateableField`.`name`, `RateableField`.`is_required`, `RateableField`.`weight`, `RateableField`.`tooltip`, `RateableField`.`listing_type_id` FROM `rateable_fields` AS `RateableField` WHERE `listing_type_id` = 37 110
45SELECT `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
46SELECT COUNT(*) AS `count` FROM `listings` AS `Listing` WHERE `Listing`.`list_category_id` IN (130, 131, 135, 138, 139) AND `Listing`.`status` = 1 111
47SELECT `Listing`.`id` FROM `listings` AS `Listing` WHERE `Listing`.`list_category_id` IN (130, 131, 135, 138, 139) ORDER BY `Listing`.`created` DESC LIMIT 2242242241
48SELECT `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 (1620, 573, 564, 481) AND `Listing`.`status` = 1 ORDER BY `Listing`.`created` DESC LIMIT 4440
49SELECT `EavRecord`.`id`, `EavRecord`.`entity_id` FROM `eav_records` AS `EavRecord` WHERE `EavRecord`.`entity` = 'Listing' AND `EavRecord`.`entity_id` IN (1620, 573, 481) 331
50SELECT `EavValuesInt`.`id`, `EavValuesInt`.`field`, `EavValuesInt`.`value`, `EavValuesInt`.`eav_record_id` FROM `eav_values_int` AS `EavValuesInt` WHERE `EavValuesInt`.`eav_record_id` IN (569, 687, 2094) 774
51SELECT `EavValuesString`.`id`, `EavValuesString`.`field`, `EavValuesString`.`value`, `EavValuesString`.`eav_record_id` FROM `eav_values_string` AS `EavValuesString` WHERE `EavValuesString`.`eav_record_id` IN (569, 687, 2094) 181826
52SELECT `EavValuesDatetime`.`id`, `EavValuesDatetime`.`field`, `EavValuesDatetime`.`value`, `EavValuesDatetime`.`eav_record_id` FROM `eav_values_datetime` AS `EavValuesDatetime` WHERE `EavValuesDatetime`.`eav_record_id` IN (569, 687, 2094) 000
53SELECT `EavValuesArray`.`id`, `EavValuesArray`.`field`, `EavValuesArray`.`eav_record_id` FROM `eav_values_array` AS `EavValuesArray` WHERE `EavValuesArray`.`eav_record_id` IN (569, 687, 2094) 220
54SELECT `EavValuesArrayElement`.`id`, `EavValuesArrayElement`.`value`, `EavValuesArrayElement`.`eav_values_array_id` FROM `eav_values_array_elements` AS `EavValuesArrayElement` WHERE `EavValuesArrayElement`.`eav_values_array_id` IN (882, 973) 3313
55SELECT `EavValuesBoolean`.`id`, `EavValuesBoolean`.`field`, `EavValuesBoolean`.`value`, `EavValuesBoolean`.`eav_record_id` FROM `eav_values_boolean` AS `EavValuesBoolean` WHERE `EavValuesBoolean`.`eav_record_id` IN (569, 687, 2094) 000
56SELECT `EavValuesText`.`id`, `EavValuesText`.`field`, `EavValuesText`.`value`, `EavValuesText`.`eav_record_id` FROM `eav_values_text` AS `EavValuesText` WHERE `EavValuesText`.`eav_record_id` IN (569, 687, 2094) 000
57SELECT `EavValuesFloat`.`id`, `EavValuesFloat`.`field`, `EavValuesFloat`.`value`, `EavValuesFloat`.`eav_record_id` FROM `eav_values_float` AS `EavValuesFloat` WHERE `EavValuesFloat`.`eav_record_id` IN (569, 687, 2094) 660
58SELECT `EavValuesDate`.`id`, `EavValuesDate`.`field`, `EavValuesDate`.`value`, `EavValuesDate`.`eav_record_id` FROM `eav_values_date` AS `EavValuesDate` WHERE `EavValuesDate`.`eav_record_id` IN (569, 687, 2094) 000
59SELECT `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
60SELECT COUNT(*) AS `count` FROM `listings` AS `Listing` WHERE `Listing`.`list_category_id` IN (13, 124, 126, 129) AND `Listing`.`status` = 1 111
61SELECT `Listing`.`id` FROM `listings` AS `Listing` WHERE `Listing`.`list_category_id` IN (13, 124, 126, 129) ORDER BY `Listing`.`created` DESC LIMIT 1061061061
62SELECT `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 (2516, 1457, 779, 536) AND `Listing`.`status` = 1 ORDER BY `Listing`.`created` DESC LIMIT 4441
63SELECT `EavRecord`.`id`, `EavRecord`.`entity_id` FROM `eav_records` AS `EavRecord` WHERE `EavRecord`.`entity` = 'Listing' AND `EavRecord`.`entity_id` IN (1457, 779) 220
64SELECT `EavValuesInt`.`id`, `EavValuesInt`.`field`, `EavValuesInt`.`value`, `EavValuesInt`.`eav_record_id` FROM `eav_values_int` AS `EavValuesInt` WHERE `EavValuesInt`.`eav_record_id` IN (1253, 1931) 000
65SELECT `EavValuesString`.`id`, `EavValuesString`.`field`, `EavValuesString`.`value`, `EavValuesString`.`eav_record_id` FROM `eav_values_string` AS `EavValuesString` WHERE `EavValuesString`.`eav_record_id` IN (1253, 1931) 445
66SELECT `EavValuesDatetime`.`id`, `EavValuesDatetime`.`field`, `EavValuesDatetime`.`value`, `EavValuesDatetime`.`eav_record_id` FROM `eav_values_datetime` AS `EavValuesDatetime` WHERE `EavValuesDatetime`.`eav_record_id` IN (1253, 1931) 000
67SELECT `EavValuesArray`.`id`, `EavValuesArray`.`field`, `EavValuesArray`.`eav_record_id` FROM `eav_values_array` AS `EavValuesArray` WHERE `EavValuesArray`.`eav_record_id` IN (1253, 1931) 000
68SELECT `EavValuesBoolean`.`id`, `EavValuesBoolean`.`field`, `EavValuesBoolean`.`value`, `EavValuesBoolean`.`eav_record_id` FROM `eav_values_boolean` AS `EavValuesBoolean` WHERE `EavValuesBoolean`.`eav_record_id` IN (1253, 1931) 000
69SELECT `EavValuesText`.`id`, `EavValuesText`.`field`, `EavValuesText`.`value`, `EavValuesText`.`eav_record_id` FROM `eav_values_text` AS `EavValuesText` WHERE `EavValuesText`.`eav_record_id` IN (1253, 1931) 000
70SELECT `EavValuesFloat`.`id`, `EavValuesFloat`.`field`, `EavValuesFloat`.`value`, `EavValuesFloat`.`eav_record_id` FROM `eav_values_float` AS `EavValuesFloat` WHERE `EavValuesFloat`.`eav_record_id` IN (1253, 1931) 2213
71SELECT `EavValuesDate`.`id`, `EavValuesDate`.`field`, `EavValuesDate`.`value`, `EavValuesDate`.`eav_record_id` FROM `eav_values_date` AS `EavValuesDate` WHERE `EavValuesDate`.`eav_record_id` IN (1253, 1931) 000
72SELECT `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
73SELECT COUNT(*) AS `count` FROM `listings` AS `Listing` WHERE `Listing`.`list_category_id` IN (143, 156, 147) AND `Listing`.`status` = 1 111
74SELECT `Listing`.`id` FROM `listings` AS `Listing` WHERE `Listing`.`list_category_id` IN (143, 156, 147) ORDER BY `Listing`.`created` DESC LIMIT 2152152151
75SELECT `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 (3049, 3038, 401, 260) AND `Listing`.`status` = 1 ORDER BY `Listing`.`created` DESC LIMIT 4441
76SELECT `EavRecord`.`id`, `EavRecord`.`entity_id` FROM `eav_records` AS `EavRecord` WHERE `EavRecord`.`entity` = 'Listing' AND `EavRecord`.`entity_id` IN (3049, 3038, 260) 330
77SELECT `EavValuesInt`.`id`, `EavValuesInt`.`field`, `EavValuesInt`.`value`, `EavValuesInt`.`eav_record_id` FROM `eav_values_int` AS `EavValuesInt` WHERE `EavValuesInt`.`eav_record_id` IN (347, 3519, 3530) 990
78SELECT `EavValuesString`.`id`, `EavValuesString`.`field`, `EavValuesString`.`value`, `EavValuesString`.`eav_record_id` FROM `eav_values_string` AS `EavValuesString` WHERE `EavValuesString`.`eav_record_id` IN (347, 3519, 3530) 22221
79SELECT `EavValuesDatetime`.`id`, `EavValuesDatetime`.`field`, `EavValuesDatetime`.`value`, `EavValuesDatetime`.`eav_record_id` FROM `eav_values_datetime` AS `EavValuesDatetime` WHERE `EavValuesDatetime`.`eav_record_id` IN (347, 3519, 3530) 000
80SELECT `EavValuesArray`.`id`, `EavValuesArray`.`field`, `EavValuesArray`.`eav_record_id` FROM `eav_values_array` AS `EavValuesArray` WHERE `EavValuesArray`.`eav_record_id` IN (347, 3519, 3530) 110
81SELECT `EavValuesArrayElement`.`id`, `EavValuesArrayElement`.`value`, `EavValuesArrayElement`.`eav_values_array_id` FROM `eav_values_array_elements` AS `EavValuesArrayElement` WHERE `EavValuesArrayElement`.`eav_values_array_id` = (691) 220
82SELECT `EavValuesBoolean`.`id`, `EavValuesBoolean`.`field`, `EavValuesBoolean`.`value`, `EavValuesBoolean`.`eav_record_id` FROM `eav_values_boolean` AS `EavValuesBoolean` WHERE `EavValuesBoolean`.`eav_record_id` IN (347, 3519, 3530) 000
83SELECT `EavValuesText`.`id`, `EavValuesText`.`field`, `EavValuesText`.`value`, `EavValuesText`.`eav_record_id` FROM `eav_values_text` AS `EavValuesText` WHERE `EavValuesText`.`eav_record_id` IN (347, 3519, 3530) 000
84SELECT `EavValuesFloat`.`id`, `EavValuesFloat`.`field`, `EavValuesFloat`.`value`, `EavValuesFloat`.`eav_record_id` FROM `eav_values_float` AS `EavValuesFloat` WHERE `EavValuesFloat`.`eav_record_id` IN (347, 3519, 3530) 550
85SELECT `EavValuesDate`.`id`, `EavValuesDate`.`field`, `EavValuesDate`.`value`, `EavValuesDate`.`eav_record_id` FROM `eav_values_date` AS `EavValuesDate` WHERE `EavValuesDate`.`eav_record_id` IN (347, 3519, 3530) 000
86SELECT `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
87SELECT COUNT(*) AS `count` FROM `reviews` AS `Review` LEFT JOIN `listings` AS `Listing` ON (`Review`.`listing_id` = `Listing`.`id`) WHERE `Review`.`status` = 1 111
88SELECT `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
89SELECT COUNT(*) AS `count` FROM `listing_assets` AS `ListingAsset` WHERE `user_id` = 32 AND `listing_id` = 273 AND `status` = 1 111
90SELECT COUNT(*) AS `count` FROM `reviews` AS `Review` WHERE `Review`.`id` = 490 110
91UPDATE `reviews` SET `listing_asset_count` = 0 WHERE `reviews`.`id` = 49000
92SELECT `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
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` = 273 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` = 1 WHERE `Listing`.`id` = 27300
95SELECT COUNT(*) AS `count` FROM `listing_assets` AS `ListingAsset` WHERE `user_id` = 36 AND `listing_id` = 2673 AND `status` = 1 110
96SELECT COUNT(*) AS `count` FROM `reviews` AS `Review` WHERE `Review`.`id` = 476 110
97UPDATE `reviews` SET `listing_asset_count` = 0 WHERE `reviews`.`id` = 47600
98SELECT `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
99SELECT 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
100UPDATE `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
101SELECT COUNT(*) AS `count` FROM `listing_assets` AS `ListingAsset` WHERE `user_id` = 1 AND `listing_id` = 2673 AND `status` = 1 111
102SELECT COUNT(*) AS `count` FROM `reviews` AS `Review` WHERE `Review`.`id` = 453 110
103UPDATE `reviews` SET `listing_asset_count` = 0 WHERE `reviews`.`id` = 45300
104SELECT `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
105SELECT 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
106UPDATE `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
107SELECT `Listing`.`image` FROM `listings` AS `Listing` WHERE `Listing`.`id` = 1770 LIMIT 1110
108SELECT COUNT(*) AS `count` FROM `listing_assets` AS `ListingAsset` WHERE `user_id` = 28 AND `listing_id` = 1770 AND `status` = 1 110
109SELECT COUNT(*) AS `count` FROM `reviews` AS `Review` WHERE `Review`.`id` = 451 110
110UPDATE `reviews` SET `listing_asset_count` = 0 WHERE `reviews`.`id` = 45100
111SELECT `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
112SELECT 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
113UPDATE `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