SELECT DISTINCT post.id,post.code,post.created,post.updated,post.slug,post.title,post.content,post.image,post.properties,post.active,(SELECT image FROM post_image WHERE post_image.post_id = post.id LIMIT 0,1) AS image,product.price,product.stock FROM post JOIN product ON product.post_id = post.id WHERE MATCH (post.title, post.content, post.keyword) AGAINST ('Amp Search Amp Search Amp Search Amp Search Amp Search Amp Search Amp Search Amp Search Amp Search Amp Search Amp Search Amp Search Amp Search Amp Search Amp Search Amp Search Amp Katalog Ferihana Paket Skincare Basic 4 4 3 ') AND post.active = 1 LIMIT 48,16
Location: App\Controller\Product->search()