SELECT A.*, B.name as cat_name, (SELECT name from b_images WHERE  tid = A.id LIMIT 1) as image_name from b_computers A, b_cats B WHERE A.cid = B.id and  CONCAT(A.brand,' ',A.name, ' ', A.characteristic, ' ', A.description)  LIKE '%19'%inch.%'<br/> No database