SELECT 'username','password'  FROM `users`   WHERE `username`  LIKE '%luc%' ;
SELECT 'user'  FROM `users` `u`  INNER JOIN `pages`  ON `p`.`userid`  = 'u.id' ;
Also view the source.