if(isset($_GET['keywords'])) {
$queryx=str_replace("+"," ",$_GET['keywords']);

 {
 $data=$database->query("
 SELECT
COUNT(*) AS counted,
listing_property.ad_title,
listing_autos.ad_title,
listing_classified.ad_title,
listing_deals.ad_title,
listing_jobs.ad_title,
listing_services.ad_title,
listing_leads.ad_title,
subpages.shortname,
pages.shortname
FROM
(listing_autos, listing_property, listing_classified, listing_deals,    listing_jobs, listing_services, listing_leads)
    INNER JOIN
subpages ON (listing_autos.formsubid = subpages.id
    AND listing_property.formsubid = subpages.id
    AND listing_deals.formsubid = subpages.id
    AND listing_classified.formsubid = subpages.id
    AND listing_deals.formsubid = subpages.id
    AND listing_jobs.formsubid = subpages.id
    AND listing_services.formsubid = subpages.id)
    INNER JOIN
  pages ON (subpages.hd_id = pages.id)
 WHERE
  LOWER(listing_autos.ad_title) LIKE '%$queryx%'
    OR LOWER(listing_property.ad_title) LIKE '%$queryx%'
    OR LOWER(listing_classified.ad_title) LIKE '%$queryx%'
    OR LOWER(listing_deals.ad_title) LIKE '%$queryx%'
    OR LOWER(listing_jobs.ad_title) LIKE '%$queryx%'
  GROUP BY listing_property.ad_title, listing_autos.ad_title, listing_classified.ad_title, listing_jobs.ad_title, listing_services.ad_title, listing_deals.ad_title, listing_leads.ad_title, subpages.shortname, pages.shortname
   ");
  if($rs=mysqli_num_rows($data)!=0){
  while($tag=mysqli_fetch_array($data))
  {
  $maintag=$tag['shortname'];
  $subtag=$tag['subsname'];
  ?>