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 75,25

Asset Type: Hero

Language: Canadian Eng.

Date Added: 6-30-2022

1655324269-1655209262-GEM4125_SAS_EndsThursday_topbanner_US.jpg

S000505110country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: U.S. English

Date Added: 6-30-2022

1655324269-1655209262-GEM4125_SAS_EndsThursday_topbanner_US.jpg

S000505109country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: Canadian Eng.

Date Added: 6-30-2022

1655324269-1655209262-GEM4125_SAS_EndsThursday_topbanner_US.jpg

S000505108country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: U.S. English

Date Added: 6-30-2022

1655324269-1655209262-GEM4125_SAS_EndsThursday_topbanner_US.jpg

S000505107country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: Canadian Eng.

Date Added: 6-30-2022

1655324269-1655209262-GEM4125_SAS_EndsThursday_topbanner_US.jpg

S000505106country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: U.S. English

Date Added: 6-30-2022

1655324269-1655209262-GEM4125_SAS_EndsThursday_topbanner_US.jpg

S000505105country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: U.S. English

Date Added: 6-30-2022

S000505104country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: U.S. English

Date Added: 6-27-2022

TESTSINGLE_TEST0099_welcome_hero_US.jpg

S000505103country

images/creating_preview.png

Htmlpng

Asset Type: Banner Promo

Language: French

Date Added: 6-23-2022

TEST003_Newsletter_hero_FR.png

S000505102country

images/creating_preview.png

Htmlpng

Asset Type: Banner Promo

Language: Australian Eng.

Date Added: 6-23-2022

TEST003_Newsletter_hero_AU.png

S000505101country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: Belgium French

Date Added: 6-22-2022

TESTLOCAL_TEST0113_welcome_topbanner_BEFR.jpg

S000505100country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: Dutch

Date Added: 6-22-2022

TESTLOCAL_TEST0113_welcome_topbanner_NL.jpg

S000505099country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: U.S. English

Date Added: 6-22-2022

TESTLOCAL_TEST0113_welcome_topbanner_US.jpg

S000505098country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: U.S. English

Date Added: 6-21-2022

TESTLOCAL_TEST0110_welcome_topbanner_US.jpg

S000505097country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: U.S. English

Date Added: 6-20-2022

TESTLOCAL_TEST0109_welcome_topbanner_US.jpg

S000505096country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: U.S. English

Date Added: 6-20-2022

TESTLOCAL_TEST0108_welcome_topbanner_US.jpg

S000505095country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: U.S. English

Date Added: 6-20-2022

TESTLOCAL_TEST0107_welcome_topbanner_US.jpg

S000505094country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: Canadian Eng.

Date Added: 6-20-2022

S000505093country

images/creating_preview.png

Htmlpng

Asset Type: Banner Promo

Language: Japanese

Date Added: 6-20-2022

2nd_Buy_Promo_hero_ja-jp.png

S000505092country

images/creating_preview.png

Htmlpng

Asset Type: Banner Promo

Language: U.S. English

Date Added: 6-20-2022

1655324269-1655209262-GEM4125_SAS_EndsThursday_topbanner_US.jpg

S000505091country

images/creating_preview.png

Htmlpng

Asset Type: Banner Promo

Language: Japanese

Date Added: 6-16-2022

2nd_Buy_Promo_hero_ja-jp.png

S000505084country

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

S000505083country

images/creating_preview.png

Htmlpng

Asset Type: Banner Promo

Language: Japanese

Date Added: 6-16-2022

2nd_Buy_Promo_hero_ja-jp.png

S000505082country

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

S000505081country

images/creating_preview.png

Htmlpng

Asset Type: Banner Promo

Language: Japanese

Date Added: 6-16-2022

2nd_Buy_Promo_hero_ja-jp.png

S000505080country

images/creating_preview.png

Htmlpng

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