type iiipSQL = SELECT * FROM product JOIN productcontent ON product.id=productcontent.productID WHERE productcontent.title LIKE '%type iii%' OR productcontent.text LIKE '%type iii%' OR productcontent.productCode LIKE '%type iii%' ORDER BY product.sortnr