SELECT
li.id,
li.asin,
li.sku,
li.order_source_sku_id,
li.source_id,
li.msku,
li.delivery_type,
li.browse_path_by_id,
li.NAME,
li.image,
( CASE WHEN ( prop.`desc` IS NOT NULL AND prop.`desc` != N ) THEN N ELSE N END ) `description`,
( CASE WHEN ( prop.generic_keyword IS NOT NULL AND prop.generic_keyword != N ) THEN N ELSE N END ) `keyword`,
prop.bullet_point,
prop.images,
prop.properties,
ea.brand
FROM
t_amazon_listing_N li
LEFT JOIN t_amazon_listing_properties_N prop ON li.id = prop.id
LEFT JOIN t_amazon_listing_extra_asin_br ea ON li.marketplace_id = ea.marketplace_id
AND li.asin = ea.asin
WHERE
li.is_deleted = N
AND li.delivery_type = N
AND li.source_id = N
LIMIT N OFFSET N;
