Login or Create an Account!
[
Select a different cellar
]
Viewing: scratchybadger's cellar
You are browsing scratchybadger'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
147 tins
and has
98 blends
represented.
We will find
23 lbs. 7 oz.
of tobacco in the collection.
This quantity of tobacco is estimated to fill approximately
3,755
of the owner's pipes.
The cellar should endure
20 yrs, 10 mos
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 = '103' AND container_status.disposed = '0' ORDER BY condition desc, blend_name, container_id ) from DB: DB Error: syntax error
