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

Asset Type: Banner Bottom

Language: French

Date Added: 9-14-2021

EM123_grahambtopmulti_hero_FR.jpg

S000503662country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: Canadian Eng.

Date Added: 9-14-2021

EM123_grahambtopmulti_hero_CA_M.jpg

S000503661country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: Canadian Eng.

Date Added: 9-14-2021

EM123_grahambtopmulti_hero_CA.jpg

S000503660country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: German

Date Added: 9-14-2021

EM123_grahambtopmulti_hero_DE_M.jpg

S000503659country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: German

Date Added: 9-14-2021

EM123_grahambtopmulti_hero_DE.jpg

S000503658country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: U.K. English

Date Added: 9-14-2021

EM123_grahambtopmulti_hero_UK_M.jpg

S000503657country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: U.K. English

Date Added: 9-14-2021

EM123_grahambtopmulti_hero_UK.jpg

S000503656country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: U.S. English

Date Added: 9-14-2021

EM123_grahambtopmulti_hero_US_M.jpg

S000503655country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: U.S. English

Date Added: 9-14-2021

EM123_grahambtopmulti_hero_US.jpg

S000503654country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: Danish

Date Added: 9-14-2021

EM123_grahambtopmulti_hero_DK_M.jpg

S000503653country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: Danish

Date Added: 9-14-2021

EM123_grahambtopmulti_hero_DK.jpg

S000503652country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: Norwegian

Date Added: 9-14-2021

EM123_grahambtopmulti_hero_NO_M.jpg

S000503651country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: Norwegian

Date Added: 9-14-2021

EM123_grahambtopmulti_hero_NO.jpg

S000503650country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: Switzerland French

Date Added: 9-14-2021

EM123_grahambtopmulti_hero_CHFR_M.jpg

S000503649country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: Switzerland French

Date Added: 9-14-2021

EM123_grahambtopmulti_hero_CHFR.jpg

S000503648country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: Switzerland German

Date Added: 9-14-2021

EM123_grahambtopmulti_hero_CHDE_M.jpg

S000503647country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: Switzerland German

Date Added: 9-14-2021

EM123_grahambtopmulti_hero_CHDE.jpg

S000503646country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: Belgium Dutch

Date Added: 9-14-2021

EM123_grahambtopmulti_hero_BENL_M.jpg

S000503645country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: Belgium Dutch

Date Added: 9-14-2021

EM123_grahambtopmulti_hero_BENL.jpg

S000503644country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: Belgium French

Date Added: 9-14-2021

EM123_grahambtopmulti_hero_BEFR_M.jpg

S000503643country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: Belgium French

Date Added: 9-14-2021

EM123_grahambtopmulti_hero_BEFR.jpg

S000503642country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: French Canadian

Date Added: 9-14-2021

EM123_grahambtopmulti_hero_CAFR_M.jpg

S000503641country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: French Canadian

Date Added: 9-14-2021

EM123_grahambtopmulti_hero_CAFR.jpg

S000503640country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: Dutch

Date Added: 9-14-2021

EM123_grahambtopmulti_hero_NL_M.jpg

S000503639country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: Dutch

Date Added: 9-14-2021

EM123_grahambtopmulti_hero_NL.jpg

S000503638country

images/creating_preview.png

Htmlpng

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