Login or Create an Account!
[
Select a different cellar
]
Viewing: All Have Been Sold!'s cellar
You are browsing All Have Been Sold!'s cellar.
[
Cellared Tins
] or [
Open Tins
] or [
Finished Tins
]
or [
Blend Detail
] or [
Cabinet
] or [
Statistics
]
The cellar at-a-glance:
The cellar contains
947 tins
and has
259 blends
represented.
We will find
171 lbs. 3 oz.
of tobacco in the collection.
This quantity of tobacco is estimated to fill approximately
27,390
of the owner's pipes.
The cellar should endure
114 yrs, 1 mo
at the defined smoking pace.
Could not successfully run query (SELECT container_id, blends.blend_id, brands.brand_id, blend_name, brand_name, brand_link, trlink, image_name, weight, source, date_tinned, date_bought, price, notes, ctype_name AS container_type, condition_name AS `condition`, status_name AS status, ratings.rating, ratings.nicotine, ratings.flavour, ratings.room_note, brands.brand_abbrev, brands.brand_nationality, baccy_types.type_name, baccy_cuts.cut_name, FLOOR((TO_DAYS(CURDATE()) - TO_DAYS( IFNULL(date_tinned, date_bought) )) / 30) AS container_age, users.name AS username, containers.user_id FROM containers INNER JOIN blends ON containers.blend_id = blends.blend_id INNER JOIN brands ON blends.brand_id = brands.brand_id INNER JOIN baccy_types ON blends.baccy_type_id = baccy_types.type_id INNER JOIN baccy_cuts ON blends.baccy_cut_id = baccy_cuts.cut_id LEFT OUTER JOIN container_types ON containers.container_type = container_types.ctype_id LEFT OUTER JOIN container_conditions ON containers.`condition` = container_conditions.condition_id INNER JOIN container_status ON containers.status = container_status.status_id LEFT OUTER JOIN ratings ON containers.blend_id = ratings.blend_id AND containers.user_id = ratings.user_id INNER JOIN users ON containers.user_id = users.user_id WHERE containers.user_id = '60' AND container_status.disposed = '0' ORDER BY condition desc, blend_name, container_id ) from DB: DB Error: syntax error
