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

Asset Type: Banner Bottom

Language: Czech

Date Added: 10-12-2022

NewHelp_Here_bottombanner_CZ.png

S000505164country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: Portuguese

Date Added: 10-12-2022

NewHelp_Here_bottombanner_PT.png

S000505163country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: French Canadian

Date Added: 7-7-2022

CRMAG122_Dynamic_w_design_services_1_UNENGAGED_promobanner_CAFR.jpg

S000505162country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: Belgium Dutch

Date Added: 7-7-2022

TESTxxxGEM4125_SAS_EndsThursday_topbanner_BENL.jpg

S000505161country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: Canadian Eng.

Date Added: 7-7-2022

TESTGEM4125_SAS_EndsThursday_topbanner_CA.jpg

S000505160country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: Japanese

Date Added: 7-7-2022

TESTeeee_2nd_Buy_Promo_hero_ja-jp.png

S000505159country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: German

Date Added: 7-7-2022

TESTGEM4125_SAS_EndsThursday_topbanner_DE.jpg

S000505158country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: U.S. English

Date Added: 7-7-2022

TESTGEM4125_SAS_EndsThursday_topbanner_US.jpg

S000505157country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: French

Date Added: 7-6-2022

test021_slimos_hero_FR.png

S000505156country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: French Canadian

Date Added: 7-6-2022

test01_slimos_slices_hero_CAFR_03.png

S000505155country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: Italian

Date Added: 7-6-2022

test01_slimos_slices_hero_IT_03.png

S000505154country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: French

Date Added: 7-6-2022

test01_slimos_slices_hero_FR_03.png

S000505153country

images/creating_preview.png

Htmlpng

Asset Type: Banner Promo

Language: French Canadian

Date Added: 7-6-2022

test01_slimos_promobanner_CAFR.png

S000505152country

images/creating_preview.png

Htmlpng

Asset Type: Banner Promo

Language: Italian

Date Added: 7-6-2022

test01_slimos_promobanner_IT.png

S000505151country

images/creating_preview.png

Htmlpng

Asset Type: Banner Promo

Language: French

Date Added: 7-6-2022

test01_slimos_promobanner_FR.png

S000505150country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: French Canadian

Date Added: 7-6-2022

test01_slimos_bottombanner_CAFR.png

S000505149country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: Italian

Date Added: 7-6-2022

test01_slimos_bottombanner_IT.png

S000505148country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: French

Date Added: 7-6-2022

test01_slimos_bottombanner_FR.png

S000505147country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: French Canadian

Date Added: 7-6-2022

test01_slimos_topbanner_CAFR.png

S000505146country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: Italian

Date Added: 7-6-2022

test01_slimos_topbanner_IT.png

S000505145country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: French

Date Added: 7-6-2022

test01_slimos_topbanner_FR.png

S000505144country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: French Canadian

Date Added: 7-6-2022

test01_slimos_hero_CAFR.png

S000505143country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: Italian

Date Added: 7-6-2022

test01_slimos_hero_IT.png

S000505142country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: French

Date Added: 7-6-2022

test01_slimos_hero_FR.png

S000505141country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: Japanese

Date Added: 7-7-2022

TESTeeee_2nd_Buy_Promo_hero_ja-jp.png

S000505140country

images/creating_preview.png

Htmlpng

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