```const magicFeedData = await models.sequelize.qu...
# orm-help
n
Copy code
const magicFeedData = await models.sequelize.query(`
        select p.*,
            ${ user ? `exists(select 1 from SavedProduct sp where sp.productId = p.id and sp.userId = ${user.id} and sp.status = '1' limit 1) as "isBookmarked",`: ''}
            (select json_object(
              'id', s.id,
              'name', s.name,
              'picture', s.picture,
              'avatar', s.avatar,
              'website', s.website,
              'contact', s.contact,
              'isVerified', s.isVerified,
              'createdAt', s.createdAt,
              'updatedAt', s.updatedAt)
              from Shop s
            where s.id = p.shopId) as shop
        from Product p
        where p.stock >= 1
        order by p.id DESC ${limit_sql}
      `);