-----
(mysql): SELECT * FROM products WHERE prod_id=197
-----
-----
(mysql): SELECT DISTINCT a.prod_subtype_id, a.type_name FROM prod_subtypes AS a, products AS b WHERE b.prod_subtype_id=a.prod_subtype_id AND b.prod_id = 197
-----
-----
(mysql): SELECT wheel_mat_name FROM wheel_materials WHERE wheel_mat_id=0
-----
-----
(mysql): SELECT wheel_bearing_name FROM wheel_bearings WHERE wheel_bearing_id=0
-----
-----
(mysql): SELECT * FROM prod_pics WHERE prod_id=197 ORDER BY picid DESC LIMIT 1
-----
-----
(mysql): SELECT DISTINCT prod_subtype_id, type_name FROM prod_subtypes WHERE master_cat=2 AND prod_type_id !=7 ORDER BY prod_type_id ASC, prod_subtype_id ASC
-----
-----
(mysql): SELECT * FROM prod_prices WHERE prod_id=197
-----
Fits into tubing to allow mounting of threaded stem glides. Limited weight rating. Not for use with casters.
Thread
1⁄4"-20
Tubing Dimension/ Diameter
1"
Pricing
Qty
Price/ Unit
-----
(mysql): SELECT * FROM prod_prices WHERE prod_id=197
-----
1
$1.15
100
$1.07
200
$0.98
-----
(mysql): SELECT * FROM prod_brake_lu WHERE prod_id=197 ORDER BY prod_brake_id
-----
-----
(mysql): SELECT * FROM prod_mount_lu WHERE prod_id=197 ORDER BY prod_mount_id
-----
-----
(mysql): SELECT * FROM prod_finish_lu WHERE prod_id=197 ORDER BY prod_finish_id
-----