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

Asset Type: Hero

Language: U.S. English

Date Added: 4-20-2022

TESTMULTIheroAWS05_welcome_hero_US.jpg

S000504878country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: French Canadian

Date Added: 4-19-2022

TESTSINGLEtopbanAWS04_welcome_topbanner_CAFR_M.jpg

S000504877country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: French Canadian

Date Added: 4-19-2022

TESTSINGLEtopbanAWS04_welcome_topbanner_CAFR.jpg

S000504876country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: U.K. English

Date Added: 4-19-2022

TESTSINGLEtopbanAWS04_welcome_topbanner_UK_M.jpg

S000504875country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: U.K. English

Date Added: 4-19-2022

TESTSINGLEtopbanAWS04_welcome_topbanner_UK.jpg

S000504874country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: U.S. English

Date Added: 4-19-2022

TESTSINGLEtopbanAWS04_welcome_topbanner_US_M.jpg

S000504873country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: U.S. English

Date Added: 4-19-2022

TESTSINGLEtopbanAWS04_welcome_topbanner_US.jpg

S000504872country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: French Canadian

Date Added: 4-19-2022

TESTSINGLEtopbanAWS03_welcome_topbanner_CAFR_M.jpg

S000504871country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: French Canadian

Date Added: 4-19-2022

TESTSINGLEtopbanAWS03_welcome_topbanner_CAFR.jpg

S000504870country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: U.K. English

Date Added: 4-19-2022

TESTSINGLEtopbanAWS03_welcome_topbanner_UK_M.jpg

S000504869country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: U.K. English

Date Added: 4-19-2022

TESTSINGLEtopbanAWS03_welcome_topbanner_UK.jpg

S000504868country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: U.S. English

Date Added: 4-19-2022

TESTSINGLEtopbanAWS03_welcome_topbanner_US_M.jpg

S000504867country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: U.S. English

Date Added: 4-19-2022

TESTSINGLEtopbanAWS03_welcome_topbanner_US.jpg

S000504866country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: French Canadian

Date Added: 4-19-2022

TESTSINGLEtopbanAWS03_welcome_topbanner_CAFR_M.jpg

S000504865country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: French Canadian

Date Added: 4-19-2022

TESTSINGLEtopbanAWS03_welcome_topbanner_CAFR.jpg

S000504864country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: U.K. English

Date Added: 4-19-2022

TESTSINGLEtopbanAWS03_welcome_topbanner_UK_M.jpg

S000504863country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: U.K. English

Date Added: 4-19-2022

TESTSINGLEtopbanAWS03_welcome_topbanner_UK.jpg

S000504862country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: U.S. English

Date Added: 4-19-2022

TESTSINGLEtopbanAWS03_welcome_topbanner_US_M.jpg

S000504861country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: U.S. English

Date Added: 4-19-2022

TESTSINGLEtopbanAWS03_welcome_topbanner_US.jpg

S000504860country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: French Canadian

Date Added: 4-19-2022

TESTSINGLEtopbanAWS03_welcome_topbanner_CAFR_M.jpg

S000504859country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: French Canadian

Date Added: 4-19-2022

TESTSINGLEtopbanAWS03_welcome_topbanner_CAFR.jpg

S000504858country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: U.K. English

Date Added: 4-19-2022

TESTSINGLEtopbanAWS03_welcome_topbanner_UK_M.jpg

S000504857country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: U.K. English

Date Added: 4-19-2022

TESTSINGLEtopbanAWS03_welcome_topbanner_UK.jpg

S000504856country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: U.S. English

Date Added: 4-19-2022

TESTSINGLEtopbanAWS03_welcome_topbanner_US_M.jpg

S000504855country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: U.S. English

Date Added: 4-19-2022

TESTSINGLEtopbanAWS03_welcome_topbanner_US.jpg

S000504854country

images/creating_preview.png

Htmlpng

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