Communications Specialties (CSI) | Search Results

SELECT a.model, a.id, a.sub_cat, a.prod_line, a.descript, a.basePic, a.part_number, a.is_parent, b.fileField FROM csi_products a INNER JOIN csi_productphotos b ON ( a.basePic = b.id ) WHERE a.is_discontinued = 0 AND is_parent = 1 AND is_active = 1 AND ( a.prod_line != 'Cables' AND (part_number LIKE '%scan_do_select-spec.html%' OR prod_line LIKE '%scan_do_select-spec.html%' OR merged_name LIKE '%scan_do_select-spec.html%' OR CONVERT(sub_cat USING latin1) COLLATE latin1_swedish_ci LIKE '%scan_do_select-spec.html%' OR model LIKE '%scan_do_select-spec.html%' OR descript LIKE '%scan_do_select-spec.html%' OR keywords LIKE '%scan_do_select-spec.html%' Communications Specialties (CSI) | Search Results