SELECT  *  FROM manufacturer  WHERE replace(replace(manufacturer,'-',''),'/','') = 'chevrolet'SELECT  *  FROM model  WHERE replace(replace(model,'-',''),'/','') = 'captiva 4x4'There was an error inserting pageimp:insert into pageimp (make,model,buspri,contracttype,modeltype,pricerange,num_ads,ip_address,last_page_url,created) values ('5','1147','0','','C','allprices','0','38.103.63.62','/car_leasing-chevrolet-captiva_4x4.php','2008-12-04 06:10:54')