Radios - Table Top - Separates

Name	Description	Lifetime
CART	The association with your shopping cart.	1 Year
CATEGORY_INFO	Allows pages to be displayed more quickly.	1 Year
COMPARE	The items that you have in the Compare Products list.	1 Year
CUSTOMER	An encrypted version of your customer id.	1 Year
CUSTOMER_AUTH	An indicator if you are signed into the store.	1 Year
CUSTOMER_INFO	An encrypted version of the customer group you belong to.	1 Year

Name	Description	Lifetime
CUSTOMER_SEGMENT_IDS	Stores your Customer Segment ID	1 Year
EXTERNAL_NO_CACHE	A flag that, indicates whether caching is on or off.	1 Year
FRONTEND	Your session ID on the server.	1 Year
GUEST-VIEW	Allows guests to edit their orders.	1 Year
LAST_CATEGORY	The last category you visited.	1 Year
LAST_PRODUCT	The last product you looked at.	1 Year
NEWMESSAGE	Indicates whether a new message has been received.	1 Year
NO_CACHE	Indicates whether it is allowed to use cache.	1 Year
PERSISTENT_SHOPPING_CART	A link to information about your cart and viewing history if you have asked the site.	1 Year

Name	Description	Lifetime
RECENTLYCOMPARED	The items you recently compared.	1 Year
STF	Information on products you emailed to friends.	1 Year
STORE	The store view or language you have selected.	1 Year
USER_ALLOWED_SAVE_COOKIE	Indicates whether a customer authorized cookies.	1 Year
VIEWED_PRODUCT_IDS	The products that you recently looked at.	1 Year
WISHLIST	An encrypted list of products added to your wish list.	1 Year
WISHLIST_CNT	The number of items in your wish list.	1 Year

SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_varchar` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (42037, 42038)) AND (t_d.attribute_id IN (85, 71, 86, 87, 97, 112, 113, 114, 119, 173, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 243, 266, 621, 664, 668, 748, 755, 811)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_text` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (42037, 42038)) AND (t_d.attribute_id IN (73, 237, 257, 724, 770)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_decimal` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (42037, 42038)) AND (t_d.attribute_id IN (75, 76, 120, 166, 814, 80)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_datetime` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (42037, 42038)) AND (t_d.attribute_id IN (77, 78, 93, 94, 568)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_int` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (42037, 42038)) AND (t_d.attribute_id IN (81, 96, 121, 123, 125, 126, 127, 128, 131, 186, 236, 248, 525, 564, 567, 570, 669, 720, 722, 736, 753, 816, 102, 168)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))