-----
(mysql): SELECT DISTINCT a.prod_subtype_id, b.type_name FROM products AS a, prod_subtypes AS b WHERE a.prod_type_id = 5 AND a.prod_subtype_id=b.prod_subtype_id
-----
Non-Swivel Solid Base Glides |
Click for details | Thread | Stud Length | Base Diameter | Base Material |
-----
(mysql): SELECT * FROM products WHERE prod_subtype_id=4 AND master_cat=1 AND prod_type_id=5 ORDER BY glide_thread ASC, glide_thread_count ASC
-----
-----
(mysql): SELECT glide_mat_name FROM glide_materials WHERE glide_mat_id=8
-----
-----
(mysql): SELECT * FROM prod_pics WHERE prod_id='44' ORDER BY date_added DESC LIMIT 1
-----
View item info | 5⁄16"-18 | 1-1⁄2" | 1-7⁄16" | Phenolic |
-----
(mysql): SELECT glide_mat_name FROM glide_materials WHERE glide_mat_id=8
-----
-----
(mysql): SELECT * FROM prod_pics WHERE prod_id='45' ORDER BY date_added DESC LIMIT 1
-----
View item info | 3⁄8"-16 | 1-7⁄8" | 1-7⁄8" | Phenolic |
|
Non-Swivel Friction Base Glides |
Click for details | Thread | Stud Length | Base Diameter | Base Material |
-----
(mysql): SELECT * FROM products WHERE prod_subtype_id=5 AND master_cat=1 AND prod_type_id=5 ORDER BY glide_thread ASC, glide_thread_count ASC
-----
-----
(mysql): SELECT glide_mat_name FROM glide_materials WHERE glide_mat_id=9
-----
-----
(mysql): SELECT * FROM prod_pics WHERE prod_id='46' ORDER BY date_added DESC LIMIT 1
-----
View item info | 1⁄4"-20 | 1⁄2" | 1-1⁄8" | White Plastic - Nickel Plated Hood |
-----
(mysql): SELECT glide_mat_name FROM glide_materials WHERE glide_mat_id=9
-----
-----
(mysql): SELECT * FROM prod_pics WHERE prod_id='48' ORDER BY date_added DESC LIMIT 1
-----
View item info | 1⁄4"-20 | 1" | 1-3⁄4" | White Plastic - Nickel Plated Hood |
-----
(mysql): SELECT glide_mat_name FROM glide_materials WHERE glide_mat_id=9
-----
-----
(mysql): SELECT * FROM prod_pics WHERE prod_id='49' ORDER BY date_added DESC LIMIT 1
-----
View item info | 5⁄16"-18 | 1-1⁄2" | 1-3⁄8" | White Plastic - Nickel Plated Hood |
-----
(mysql): SELECT glide_mat_name FROM glide_materials WHERE glide_mat_id=9
-----
-----
(mysql): SELECT * FROM prod_pics WHERE prod_id='51' ORDER BY date_added DESC LIMIT 1
-----
View item info | 5⁄16"-18 | 2" | 1-3⁄8" | White Plastic - Nickel Plated Hood |
-----
(mysql): SELECT glide_mat_name FROM glide_materials WHERE glide_mat_id=5
-----
-----
(mysql): SELECT * FROM prod_pics WHERE prod_id='52' ORDER BY date_added DESC LIMIT 1
-----
View item info | 3⁄8"-16 | 1-1⁄2" | 1-3⁄8" | Gray non-skid |
-----
(mysql): SELECT glide_mat_name FROM glide_materials WHERE glide_mat_id=9
-----
-----
(mysql): SELECT * FROM prod_pics WHERE prod_id='53' ORDER BY date_added DESC LIMIT 1
-----
View item info | 3⁄8"-16 | 1-1⁄2" | 1-11⁄16" | White Plastic - Nickel Plated Hood |
-----
(mysql): SELECT glide_mat_name FROM glide_materials WHERE glide_mat_id=9
-----
-----
(mysql): SELECT * FROM prod_pics WHERE prod_id='54' ORDER BY date_added DESC LIMIT 1
-----
View item info | 3⁄8"-16 | 5" | 1-3⁄4" | White Plastic - Nickel Plated Hood |
-----
(mysql): SELECT glide_mat_name FROM glide_materials WHERE glide_mat_id=5
-----
-----
(mysql): SELECT * FROM prod_pics WHERE prod_id='55' ORDER BY date_added DESC LIMIT 1
-----
View item info | 1⁄2"-13 | 2-1⁄2" | 2-5⁄8" | Gray non-skid |
|
Non-Swivel Cushion Base Glides |
Click for details | Thread | Stud Length | Base Diameter | Base Material |
-----
(mysql): SELECT * FROM products WHERE prod_subtype_id=11 AND master_cat=1 AND prod_type_id=5 ORDER BY glide_thread ASC, glide_thread_count ASC
-----
-----
(mysql): SELECT glide_mat_name FROM glide_materials WHERE glide_mat_id=4
-----
-----
(mysql): SELECT * FROM prod_pics WHERE prod_id='59' ORDER BY date_added DESC LIMIT 1
-----
View item info | 1⁄4"-20 | 1" | 1-7⁄8" | Cushion - Nickel Plate |
-----
(mysql): SELECT glide_mat_name FROM glide_materials WHERE glide_mat_id=4
-----
-----
(mysql): SELECT * FROM prod_pics WHERE prod_id='60' ORDER BY date_added DESC LIMIT 1
-----
View item info | 1⁄4"-20 | 1" | 1⁄16" | Cushion - Nickel Plate |
-----
(mysql): SELECT glide_mat_name FROM glide_materials WHERE glide_mat_id=4
-----
-----
(mysql): SELECT * FROM prod_pics WHERE prod_id='61' ORDER BY date_added DESC LIMIT 1
-----
View item info | 1⁄4"-20 | 15⁄16" | 1⁄4" | Cushion - Nickel Plate |
-----
(mysql): SELECT glide_mat_name FROM glide_materials WHERE glide_mat_id=4
-----
-----
(mysql): SELECT * FROM prod_pics WHERE prod_id='64' ORDER BY date_added DESC LIMIT 1
-----
View item info | 5⁄16"-18 | 15⁄16" | 1⁄16" | Cushion - Nickel Plate |
-----
(mysql): SELECT glide_mat_name FROM glide_materials WHERE glide_mat_id=4
-----
-----
(mysql): SELECT * FROM prod_pics WHERE prod_id='66' ORDER BY date_added DESC LIMIT 1
-----
View item info | 5⁄16"-18 | 1-3⁄8" | 1-5⁄8" | Cushion - Nickel Plate |
-----
(mysql): SELECT glide_mat_name FROM glide_materials WHERE glide_mat_id=4
-----
-----
(mysql): SELECT * FROM prod_pics WHERE prod_id='56' ORDER BY date_added DESC LIMIT 1
-----
View item info | 3⁄8"-18 | 15⁄16" | 1⁄4" | Cushion - Nickel Plate |
|
Swivel Base Glides |
Click for details | Thread | Stud Length | Base Diameter | Base Material |
-----
(mysql): SELECT * FROM products WHERE prod_subtype_id=9 AND master_cat=1 AND prod_type_id=5 ORDER BY glide_thread ASC, glide_thread_count ASC
-----
-----
(mysql): SELECT glide_mat_name FROM glide_materials WHERE glide_mat_id=2
-----
-----
(mysql): SELECT * FROM prod_pics WHERE prod_id='72' ORDER BY date_added DESC LIMIT 1
-----
View item info | 1⁄4"-20 | 1" | 1-1⁄8" | White Plastic |
-----
(mysql): SELECT glide_mat_name FROM glide_materials WHERE glide_mat_id=1
-----
-----
(mysql): SELECT * FROM prod_pics WHERE prod_id='73' ORDER BY date_added DESC LIMIT 1
-----
View item info | 1⁄4"-20 | 1" | 1-3⁄16" | Nickel Plated Steel |
-----
(mysql): SELECT glide_mat_name FROM glide_materials WHERE glide_mat_id=9
-----
-----
(mysql): SELECT * FROM prod_pics WHERE prod_id='74' ORDER BY date_added DESC LIMIT 1
-----
View item info | 1⁄4"-20 | 1" | 1-1⁄4" | White Plastic - Nickel Plated Hood |
-----
(mysql): SELECT glide_mat_name FROM glide_materials WHERE glide_mat_id=9
-----
-----
(mysql): SELECT * FROM prod_pics WHERE prod_id='75' ORDER BY date_added DESC LIMIT 1
-----
View item info | 5⁄16"-18 | 1" | 1-1⁄8" | White Plastic - Nickel Plated Hood |
|