SELECT id,caption,deleted,stage,name,amount,discount,content,qty,product_id,category,creator,editor,created_date,updated_date,published,currency,reviews FROM products WHERE category = :category AND stage = :stage AND published = :published AND deleted = :deleted AND creator = :creator  ORDER BY id DESC LIMIT 20