SELECT `products`.`id`, `products`.`name`, `products`.`sku`, `products`.`seo_url`, `products`.`tags`, `products`.`master_img`, `category_product_position`.`id` AS `position_id`, `position`, `price`, `compare_at_price`, `products`.`sale_count`, `option1_values` FROM `products` LEFT JOIN `category_product_position` ON category_product_position.product=products.id and category_product_position.category=456 WHERE ((`name` LIKE '%Bag%') OR (`name` LIKE '%Hat%') OR (`name` LIKE '%Towel%') OR (`name` LIKE '%Sandal%')) AND (products.status=1) GROUP BY `id` ORDER BY `category_product_position`.`position` DESC, `id` DESC LIMIT 8