SELECT * FROM `assets` 
	LEFT JOIN `asset_class` ON `assets`.`asset_class` = `asset_class`.`asset_class_id`
	LEFT JOIN `asset_status` ON `assets`.`asset_status` = `asset_status`.`asset_status_id`
	LEFT JOIN `country` ON `assets`.`country` = `country`.`country_id`
	LEFT JOIN `asset_type` ON `assets`.`asset_type` = `asset_type`.`asset_type_id`
	LEFT JOIN `industry` ON `assets`.`industry` = `industry`.`industry_id`
	LEFT JOIN `language` ON `assets`.`language` = `language`.`language_id`
	LEFT JOIN `fullserial` ON `assets`.`id` = `fullserial`.`id`
	LEFT JOIN `product` ON `assets`.`pfid` = `product`.`product_pfid`  WHERE `asset_class_active` = 1 AND  `assets`.`asset_status` = 1 AND asset_class = 5 ORDER BY `assets`.`id` DESC LIMIT 100,25

Asset Type: Banner Promo

Language: U.S. English

Date Added: 6-16-2022

1655209262-GEM4125_SAS_EndsThursday_topbanner_US.jpg

S000505079country

images/creating_preview.png

Htmlpng

Asset Type: Banner Promo

Language: Japanese

Date Added: 6-16-2022

2nd_Buy_Promo_hero_ja-jp.png

S000505078country

images/creating_preview.png

Htmlpng

Asset Type: Banner Promo

Language: U.S. English

Date Added: 6-16-2022

1655209262-GEM4125_SAS_EndsThursday_topbanner_US.jpg

S000505077country

images/creating_preview.png

Htmlpng

Asset Type: Banner Promo

Language: Japanese

Date Added: 6-16-2022

2nd_Buy_Promo_hero_ja-jp.png

S000505076country

images/creating_preview.png

Htmlpng

Asset Type: Banner Promo

Language: U.S. English

Date Added: 6-16-2022

1655209262-GEM4125_SAS_EndsThursday_topbanner_US.jpg

S000505075country

images/creating_preview.png

Htmlpng

Asset Type: Banner Promo

Language: N/A

Date Added: 6-16-2022

2nd_Buy_Promo_hero_ja-jp.png

S000505074

images/creating_preview.png

Htmlpng

Asset Type: Banner Promo

Language: U.S. English

Date Added: 6-16-2022

1655209262-GEM4125_SAS_EndsThursday_topbanner_US.jpg

S000505073country

images/creating_preview.png

Htmlpng

Asset Type: Banner Promo

Language: N/A

Date Added: 6-16-2022

2nd_Buy_Promo_hero_ja-jp.png

S000505072

images/creating_preview.png

Htmlpng

Asset Type: Banner Promo

Language: U.S. English

Date Added: 6-16-2022

1655209262-GEM4125_SAS_EndsThursday_topbanner_US.jpg

S000505071country

images/creating_preview.png

Htmlpng

Asset Type: Banner Promo

Language: N/A

Date Added: 6-16-2022

2nd_Buy_Promo_hero_ja-jp.png

S000505070

images/creating_preview.png

Htmlpng

Asset Type: Banner Promo

Language: U.S. English

Date Added: 6-16-2022

1655209262-GEM4125_SAS_EndsThursday_topbanner_US.jpg

S000505069country

images/creating_preview.png

Htmlpng

Asset Type: Banner Promo

Language: N/A

Date Added: 6-16-2022

2nd_Buy_Promo_hero_ja-jp.png

S000505068

images/creating_preview.png

Htmlpng

Asset Type: Banner Promo

Language: U.S. English

Date Added: 6-16-2022

1655209262-GEM4125_SAS_EndsThursday_topbanner_US.jpg

S000505067country

images/creating_preview.png

Htmlpng

Asset Type: Banner Promo

Language: N/A

Date Added: 6-16-2022

2nd_Buy_Promo_hero_JP_M.png

S000505066

images/creating_preview.png

Htmlpng

Asset Type: Banner Promo

Language: N/A

Date Added: 6-16-2022

2nd_Buy_Promo_hero_ja-jp.png

S000505065

images/creating_preview.png

Htmlpng

Asset Type: Banner Promo

Language: U.S. English

Date Added: 6-16-2022

1655209262-GEM4125_SAS_EndsThursday_topbanner_US_M.jpg

S000505064country

images/creating_preview.png

Htmlpng

Asset Type: Banner Promo

Language: U.S. English

Date Added: 6-16-2022

1655209262-GEM4125_SAS_EndsThursday_topbanner_US.jpg

S000505063country

images/creating_preview.png

Htmlpng

Asset Type: Banner Promo

Language: N/A

Date Added: 6-16-2022

2nd_Buy_Promo_hero_JP_M.png

S000505062

images/creating_preview.png

Htmlpng

Asset Type: Banner Promo

Language: N/A

Date Added: 6-16-2022

2nd_Buy_Promo_hero_ja-jp.png

S000505061

images/creating_preview.png

Htmlpng

Asset Type: Banner Promo

Language: U.S. English

Date Added: 6-16-2022

1655209262-GEM4125_SAS_EndsThursday_topbanner_US_M.jpg

S000505060country

images/creating_preview.png

Htmlpng

Asset Type: Banner Promo

Language: U.S. English

Date Added: 6-16-2022

1655209262-GEM4125_SAS_EndsThursday_topbanner_US.jpg

S000505059country

images/creating_preview.png

Htmlpng

Asset Type: Banner Promo

Language: N/A

Date Added: 6-15-2022

2nd_Buy_Promo_hero_ja-jp.png

S000505058

images/creating_preview.png

Htmlpng

Asset Type: Banner Promo

Language: U.S. English

Date Added: 6-15-2022

1655209262-GEM4125_SAS_EndsThursday_topbanner_US.jpg

S000505057country

images/creating_preview.png

Htmlpng

Asset Type: Banner Promo

Language: N/A

Date Added: 6-15-2022

2nd_Buy_Promo_hero_ja-jp.png

S000505056

images/creating_preview.png

Htmlpng

Asset Type: Banner Promo

Language: U.S. English

Date Added: 6-15-2022

1655209262-GEM4125_SAS_EndsThursday_topbanner_US.jpg

S000505055country

images/creating_preview.png

Htmlpng

Sorry, we don't support old versions of Internet Explorer Please use Chrome, Safari or Firefox