Neo Lambada
07/27/2021, 7:55 PMconst 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}
`);