SELECT * FROM `PCXCOPart` WHERE MATCH (TertiaryCategory) AGAINST ('"lamps"' IN BOOLEAN MODE) ORDER BY Manufacturer ASC, SEOPartNumber ASC LIMIT 0,10
LAMPSOBSOLETE / LONG LEAD TIME ELECTRONIC COMPONENTS | Pacific Component Xchange, Inc\n\n
Toll Free 800-993-9047| International 714-374-3070
