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

Warning: Deleting assets may cause problems with production. Please be certain you are deleting the correct assets.

Asset Type: Banner Bottom

Language: U.K. English

Date Added: 9-17-2021

EM123_grahamtestHTMLISSUE_bannertop_en-gb_M.jpg

S000504093 country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: U.K. English

Date Added: 9-17-2021

EM123_grahamtestHTMLISSUE_bannertop_en-gb.jpg

S000504092 country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: U.S. English

Date Added: 9-17-2021

EM123_grahamtestHTMLISSUE_bannertop_en-us_M.jpg

S000504091 country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: U.S. English

Date Added: 9-17-2021

EM123_grahamtestHTMLISSUE_bannertop_en-us.jpg

S000504090 country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: U.K. English

Date Added: 9-16-2021

EM123_grahamtestbtopmultiC_bannertop_en-gb_M.jpg

S000504081 country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: U.K. English

Date Added: 9-16-2021

EM123_grahamtestbtopmultiC_bannertop_en-gb.jpg

S000504080 country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: U.S. English

Date Added: 9-16-2021

EM123_grahamtestbtopmultiC_bannertop_en-us_M.jpg

S000504079 country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: U.S. English

Date Added: 9-16-2021

EM123_grahamtestbtopmultiC_bannertop_en-us.jpg

S000504078 country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: Danish

Date Added: 9-16-2021

EM123_grahamtesthromultiC_hero_da-dk_M.jpg

S000504077 country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: Danish

Date Added: 9-16-2021

EM123_grahamtesthromultiC_hero_da-dk.jpg

S000504076 country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: Norwegian

Date Added: 9-16-2021

EM123_grahamtesthromultiC_hero_nb-no_M.jpg

S000504075 country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: Norwegian

Date Added: 9-16-2021

EM123_grahamtesthromultiC_hero_nb-no.jpg

S000504074 country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: Switzerland French

Date Added: 9-16-2021

EM123_grahamtesthromultiC_hero_fr-ch_M.jpg

S000504073 country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: Switzerland French

Date Added: 9-16-2021

EM123_grahamtesthromultiC_hero_fr-ch.jpg

S000504072 country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: Switzerland German

Date Added: 9-16-2021

EM123_grahamtesthromultiC_hero_de-ch_M.jpg

S000504071 country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: Switzerland German

Date Added: 9-16-2021

EM123_grahamtesthromultiC_hero_de-ch.jpg

S000504070 country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: Belgium Dutch

Date Added: 9-16-2021

EM123_grahamtesthromultiC_hero_nl-be_M.jpg

S000504069 country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: Belgium Dutch

Date Added: 9-16-2021

EM123_grahamtesthromultiC_hero_nl-be.jpg

S000504068 country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: Belgium French

Date Added: 9-16-2021

EM123_grahamtesthromultiC_hero_fr-be_M.jpg

S000504067 country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: Belgium French

Date Added: 9-16-2021

EM123_grahamtesthromultiC_hero_fr-be.jpg

S000504066 country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: Dutch

Date Added: 9-16-2021

EM123_grahamtesthromultiC_hero_nl-nl_M.jpg

S000504065 country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: Dutch

Date Added: 9-16-2021

EM123_grahamtesthromultiC_hero_nl-nl.jpg

S000504064 country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: Swedish

Date Added: 9-16-2021

EM123_grahamtesthromultiC_hero_sv-se_M.jpg

S000504063 country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: Swedish

Date Added: 9-16-2021

EM123_grahamtesthromultiC_hero_sv-se.jpg

S000504062 country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: French

Date Added: 9-16-2021

EM123_grahamtesthromultiC_hero_fr-fr_M.jpg

S000504061 country

images/creating_preview.png

Htmlpng

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