ERROR:
select p.products_id,pd.products_name,p.products_production_time, p.products_date_added ,
match(pd.products_name) against ('>"pen" >"pens" pen pens' IN BOOLEAN MODE) as rel_products_name,
match(p.products_search_keywords) against ('>"pen" >"pens" pen pens' IN BOOLEAN MODE) as rel_products_search_keywords,
match(p.categories_search_keywords) against ('>"pen" >"pens" pen pens' IN BOOLEAN MODE) as rel_categories_search_keywords,
match(pd.products_description) against ('>"pen" >"pens" pen pens' IN BOOLEAN MODE) as rel_products_description,
match(p.products_model) against ('>"pen" >"pens" pen pens' 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 ('>"pen" >"pens" pen pens' IN BOOLEAN MODE) OR
match(p.products_model,p.products_search_keywords, p.categories_search_keywords) against ('>"pen" >"pens" pen pens' 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
limit 1368, 24