ERROR:  
      select p.products_id,pd.products_name,p.products_production_time, p.products_date_added ,
        match(pd.products_name) against ('>"pocket planner" >"pocket planners" pocket pockets planner planners' IN BOOLEAN MODE) as rel_products_name,
        match(p.products_search_keywords) against ('>"pocket planner" >"pocket planners" pocket pockets planner planners' IN BOOLEAN MODE) as rel_products_search_keywords,
        match(p.categories_search_keywords) against ('>"pocket planner" >"pocket planners" pocket pockets planner planners' IN BOOLEAN MODE) as rel_categories_search_keywords,
        match(pd.products_description) against ('>"pocket planner" >"pocket planners" pocket pockets planner planners' IN BOOLEAN MODE) as rel_products_description,
        match(p.products_model) against ('>"pocket planner" >"pocket planners" pocket pockets planner planners' IN BOOLEAN MODE) as rel_products_model
      from products_description pd left join products p on pd.products_id=p.products_id 
      where p.`products_status` = 1 and p.discontinued=0 and
	      (
		      match(pd.products_name,pd.products_description) against ('>"pocket planner" >"pocket planners" pocket pockets planner planners' IN BOOLEAN MODE) OR
		      match(p.products_model,p.products_search_keywords, p.categories_search_keywords) against ('>"pocket planner" >"pocket planners" pocket pockets planner planners' IN BOOLEAN MODE)
	      )
	       
      group by p.products_id
       order by ((rel_products_name*4) + (rel_products_search_keywords*3) + (rel_categories_search_keywords*2) + (rel_products_description*1) + (rel_products_model*1)) DESC