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

Asset Type:

Language: N/A

Date Added: 3-31-2015

6DollarSale_Drop2_RET_US_111200_M_FINAL.png

S000006183

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

6DollarSale_Drop2_RET_US_111200_FINAL.png

S000006182

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

640x400-Qty-50-PC-Email-Banner-MOBILE-RET-101800.jpg

S000006171

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

4thJulyCADay_Week27Email_DROP1_CA_RET_106553_M.png

S000006170country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

4thJulyCADay_Week27Email_DROP1_CA_RET_106553.png

S000006169country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

29003-Week6-Email2-MOBILE.png

S000006101

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

29003-Week6-Email2-DESKTOP.png

S000006100

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

29003-Promo-Week6-Expanded-Product-Mix-Email2-MOBILE.png

S000006098

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

29003-Promo-Week6-Expanded-Product-Mix-Email2-MOBILE-CAFR.png

S000006097country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

29003-Promo-Week6-Expanded-Product-Mix-Email2-DESKTOP.png

S000006096

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

29003-Promo-Week6-Expanded-Product-Mix-Email2-CAFR.png

S000006095country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

29003-Promo-Week6-Expanded-Product-Mix-Email1.jpg

S000006094

images/creating_preview.png

Htmlpng

Asset Type: Hero

Language: Canadian Eng.

Date Added: 3-31-2015

29003-Promo-Week6-Expanded-Product-Mix-Email1-CA.jpg

S000006093country

images/creating_preview.png

Htmlpng

Asset Type: Banner Bottom

Language: N/A

Date Added: 3-31-2015

1280x400-Qty-50-PC-Email-Banner-DESKTOP-RET-101800.jpg

S000006049

images/creating_preview.png

Htmlpng

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