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

Asset Type:

Language: N/A

Date Added: 3-31-2015

Drop3_BBanner_RET_CA_109457.png

S000006638country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

Drop2_BBanner_RET_CA_109457_M.png

S000006633country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

Drop2_BBanner_RET_CA_109457.png

S000006632country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

DP3-MOBILE-CAFR.png

S000006627country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

Capture.PNG

S000006555

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

CW_HC_Bbanner_RET_CA_113162.jpg

S000006541country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

CASL_topBanner_RET_US_109456_M.jpg

S000006512

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

CASL_topBanner_RET_US_109456.jpg

S000006511

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

CARE_bbanner_overview_SHV_RET_US_103587_M.png

S000006500

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

CARE_bbanner_overview_SHV_RET_US_103587.png

S000006499

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

CARE_bbanner_overview_NONSHV_RET_US_103587_M.png

S000006498

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

CARE_bbanner_overview_NONSHV_RET_US_103587.png

S000006497

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

CARE_bbanner_indv_postclient_RET_US_103587_UPLOAD_M.png

S000006496

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

B_CA_M_111907.jpg

S000006484country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

B_CA_111907.jpg

S000006483country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

BFCM_drop_1_intro_RET_US_CA_113162_FINAL.psd

S000006359country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

BENEFITS_ProAdv_Tbanner_US_118102_M.png

S000006336

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

BENEFITS_ProAdv_Tbanner_US_118102.png

S000006335

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

BENEFITS_ProAdv_TRENDS_US_118102_M.jpg

S000006334

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

BENEFITS_ProAdv_TRENDS_US_118102.jpg

S000006333

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

BENEFITS_ProAdv_Bbanner_US_118102_M.png

S000006332

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

BENEFITS_ProAdv_Bbanner_US_118102.png

S000006331

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

BBMSM_Tbanner_RET_US_104252_M.png

S000006264

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

AprilMiniSale-Drop1-US-CAFR-MOBILE-103303.png

S000006251country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

AprilMiniSale-Drop1-US-CAFR-DESKTOP-103303.png

S000006250country

images/creating_preview.png

Htmlpng

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