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

Asset Type:

Language: N/A

Date Added: 3-31-2015

ScreenShot122735PM.png

S000007710

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

CrossSell_RET_HC_CAFR_112554.png

S000007709country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

ScreenShotat85810AM.png

S000007708

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

ScreenShotat121336PM.png

S000007707

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

BC_D1_BizSol_CAFR_115666_M-Copy.jpg

S000007706country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

BC_D1_BizSol_CAFR_115666-Copy.jpg

S000007705country

images/creating_preview.png

Htmlpng

Asset Type: Voucher

Language: U.S. English

Date Added: 3-31-2015

trio_voucher.png

S000007698country

images/creating_preview.png

Htmlpng

Asset Type:

Language: U.S. English

Date Added: 3-31-2015

recommendedtile.png

S000007689country

images/creating_preview.png

Htmlpng

Asset Type: Banner Promo

Language: U.S. English

Date Added: 3-31-2015

promobanner_white.png

S000007687country

images/creating_preview.png

Htmlpng

Asset Type: Banner Promo

Language: U.S. English

Date Added: 3-31-2015

promobanner_grey.png

S000007686country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

eblocksCSS.png

S000007684

images/creating_preview.png

Htmlpng

Asset Type:

Language: U.S. English

Date Added: 3-31-2015

browsedtile.png

S000007683country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

black_search.png

S000007681

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

WebsitesBottomBanner_GLOBAL_US_CAFR_117605_M.jpg

S000007618country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

WebsitesBottomBanner_GLOBAL_US_CAFR_117605.jpg

S000007617country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

VPC_TopBanner_RET_117652_M.png

S000007584

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

VPC_TopBanner_RET_117652.png

S000007583

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

StageProdDropOff_BC_WordOfMouth_RET_CA_107669_M_FINAL.jpg

S000007505country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

StageProdDropOff_BC_WordOfMouth_RET_CA_107669_FINAL.jpg

S000007504country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

Semi_Annual_Sale_BB_US_CA_DP2_RET_108251_M.png

S000007420country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

Semi_Annual_Sale_BB_US_CA_DP2_RET_108251.png

S000007419country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

Semi_Annual_Sale_BB_US_CA_DP1_RET_108251_M.gif

S000007418country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

Semi_Annual_Sale_BB_US_CA_DP1_RET_108251.gif

S000007417country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

PC_DropOff_Trigger_US_101861_M.jpg

S000007187

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

PC_DropOff_Trigger_US_101861.jpg

S000007186

images/creating_preview.png

Htmlpng

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