CPS to Redfox Query

redfox.sql

SELECT product.id, product.name, product.description, 
       coalesce(product.image, product.affiliate_image, product.thumbnail, product.affiliate_thumbnail) as image, 
       product.gender, product.age, category.name as original_category, 
       '' as label, '' as probability, '' as sublabel, '' as subprobability,
       product.created, product.updated
    FROM product
    LEFT JOIN category on category.id = product.category_id
    --LIMIT 10
;