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

Asset Type: Banner Bottom

Language: U.S. English

Date Added: 7-5-2022

TESTxxxGEM4125_SAS_EndsThursday_topbanner_US.jpg

S000505138country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: U.S. English

Date Added: 7-7-2022

TESTxxxGEM4125_SAS_EndsThursday_topbanner_US.jpg

S000505137country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: U.S. English

Date Added: 7-5-2022

TESTxxxGEM4125_SAS_EndsThursday_topbanner_US.jpg

S000505136country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: Canadian Eng.

Date Added: 7-5-2022

TESTGEM4125_SAS_EndsThursday_topbanner_CA.jpg

S000505135country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: U.S. English

Date Added: 7-5-2022

TESTGEM4125_SAS_EndsThursday_topbanner_US.jpg

S000505134country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: U.S. English

Date Added: 7-5-2022

TESTGEM4125_SAS_EndsThursday_topbanner_US.jpg

S000505133country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: U.S. English

Date Added: 7-5-2022

TESTGEM4125_SAS_EndsThursday_topbanner_US.jpg

S000505132country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: U.S. English

Date Added: 7-5-2022

TESTGEM4125_SAS_EndsThursday_topbanner_US.jpg

S000505131country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: Canadian Eng.

Date Added: 6-30-2022

TESTLOCAL_TEST0120_welcome_bottombanner_CA.jpg

S000505130country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: U.S. English

Date Added: 6-30-2022

TESTLOCAL_TEST0120_welcome_bottombanner_US.jpg

S000505129country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: Canadian Eng.

Date Added: 6-30-2022

TESTLOCAL_TEST0119_welcome_bottombanner_CA.jpg

S000505128country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: U.S. English

Date Added: 6-30-2022

TESTLOCAL_TEST0119_welcome_bottombanner_US.jpg

S000505127country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: Canadian Eng.

Date Added: 7-1-2022

TESTGEM4125_SAS_EndsThursday_topbanner_CA.jpg

S000505126country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: U.S. English

Date Added: 7-1-2022

TESTGEM4125_SAS_EndsThursday_topbanner_US.jpg

S000505125country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: Canadian Eng.

Date Added: 6-30-2022

TESTLOCAL_TEST0118_welcome_bottombanner_CA.jpg

S000505124country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: U.S. English

Date Added: 6-30-2022

TESTLOCAL_TEST0118_welcome_bottombanner_US.jpg

S000505123country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: Canadian Eng.

Date Added: 6-30-2022

TESTLOCAL_TEST0118_welcome_bottombanner_CA.jpg

S000505121country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: U.S. English

Date Added: 6-30-2022

TESTLOCAL_TEST0118_welcome_bottombanner_US.jpg

S000505120country

images/creating_preview.png

Htmlpng

Asset Type: Banner Promo

Language: U.S. English

Date Added: 6-30-2022

CRMAG122_Dynamic_w_design_services_1_UNENGAGED_promobanner_US.jpg

S000505119country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: Canadian Eng.

Date Added: 6-30-2022

TESTGEM4125_SAS_EndsThursday_topbanner_US.jpg

S000505117country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: Canadian Eng.

Date Added: 6-30-2022

1655324269-1655209262-GEM4125_SAS_EndsThursday_topbanner_US.jpg

S000505116country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: Canadian Eng.

Date Added: 6-30-2022

1655324269-1655209262-GEM4125_SAS_EndsThursday_topbanner_US.jpg

S000505114country

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

S000505113country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: Canadian Eng.

Date Added: 6-30-2022

1655324269-1655209262-GEM4125_SAS_EndsThursday_topbanner_US.jpg

S000505112country

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

S000505111country

images/creating_preview.png

Htmlpng

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