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

Running on local dev DB:ams_dev user:theams.developer@vistaprint.com [-]

128,669 assets

Refine: Clear

Asset Type: Hero

Language: U.K. English

Date Added: 5-26-2022

TESTMULTIheroAWS21_welcome_hero_UK.jpg

S000505001 country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: U.S. English

Date Added: 5-26-2022

TESTMULTIheroAWS21_welcome_hero_US.jpg

S000505000 country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: U.K. English

Date Added: 5-26-2022

TESTMULTIheroAWS21_welcome_hero_UK.jpg

S000504999 country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: U.S. English

Date Added: 5-26-2022

TESTMULTIheroAWS21_welcome_hero_US.jpg

S000504998 country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: U.S. English

Date Added: 5-26-2022

TESTSINGLE_TEST0099_welcome_hero_US.jpg

S000504997 country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: U.S. English

Date Added: 5-26-2022

TESTSINGLE_TEST0099_welcome_hero_US.jpg

S000504996 country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: U.S. English

Date Added: 5-26-2022

TESTSINGLE_TEST0099_welcome_hero_US.jpg

S000504995 country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: U.S. English

Date Added: 5-26-2022

TESTSINGLE_TEST0099_welcome_hero_US.jpg

S000504994 country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: U.K. English

Date Added: 5-26-2022

TESTSINGLE_TEST0099_welcome_hero_US.jpg

S000504991 country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: U.S. English

Date Added: 5-26-2022

TESTSINGLE_TEST0099_welcome_hero_US.jpg

S000504990 country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: U.K. English

Date Added: 5-26-2022

TESTSINGLE_TEST0099_welcome_hero_US.jpg

S000504989 country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: U.S. English

Date Added: 5-26-2022

TESTSINGLE_TEST0099_welcome_hero_US.jpg

S000504988 country

images/creating_preview.png

Htmlpng

Asset Type: Banner Promo

Language: U.S. English

Date Added: 5-19-2022

TESTMULTIpromobannerAWS20_welcome_promobanner_US.jpg

S000504987 country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: U.S. English

Date Added: 5-19-2022

TESTMULTIbottombannerAWS20_welcome_bottombanner_US.jpg

S000504984 country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: U.S. English

Date Added: 5-19-2022

TESTMULTItopbannerAWS20_welcome_topbanner_US.jpg

S000504982 country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: French Canadian

Date Added: 5-17-2022

TESTMULTIheroAWS05_welcome_hero_CAFR.jpg

S000504980 country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: U.K. English

Date Added: 5-17-2022

TESTMULTIheroAWS05_welcome_hero_UK.jpg

S000504979 country

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: U.S. English

Date Added: 5-17-2022

TESTMULTIheroAWS05_welcome_hero_US.jpg

S000504978 country

images/creating_preview.png

Htmlpng

Asset Type: Banner Promo

Language: U.S. English

Date Added: 5-17-2022

TESTSINGLEprobanAWS01_welcome_promobanner_US.jpg

S000504977 country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: French Canadian

Date Added: 4-22-2022

TESTSINGLEbotbanAWS12_welcome_bottombanner_CAFR.jpg

S000504973 country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: U.K. English

Date Added: 4-22-2022

TESTSINGLEbotbanAWS12_welcome_bottombanner_UK.jpg

S000504972 country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: U.S. English

Date Added: 4-22-2022

TESTSINGLEbotbanAWS12_welcome_bottombanner_US.jpg

S000504971 country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: French Canadian

Date Added: 4-22-2022

TESTSINGLEbotbanAWS11_welcome_bottombanner_CAFR.jpg

S000504970 country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: U.K. English

Date Added: 4-22-2022

TESTSINGLEbotbanAWS11_welcome_bottombanner_UK.jpg

S000504969 country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: U.S. English

Date Added: 4-22-2022

TESTSINGLEbotbanAWS11_welcome_bottombanner_US.jpg

S000504968 country

images/creating_preview.png

Htmlpng

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