SELECT `al`.*, `u`.username
FROM `tbl_auction_listing` AS `al`
JOIN `tbl_user` AS `u` ON `al`.`user_id` = `u`.`user_id`
WHERE 1 = 1
AND `al`.`status` = 1
AND `al`.`start_date` < NOW()
AND `al`.`end_date` > NOW()
AND MATCH(artist_full_name) AGAINST('koinash' IN BOOLEAN MODE) AND MATCH(artist_full_name) AGAINST('zoya' IN BOOLEAN MODE)