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

Asset Type:

Language: N/A

Date Added: 3-31-2015

1325516_US.png

S000008035country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1325516_US.jpg

S000008034country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1325516_CAFR.png

S000008033country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1325516_CAFR.jpg

S000008032country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1325516_CA.png

S000008031country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1325516_CA.jpg

S000008030country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1321256_BROCHURE_US.png

S000008029country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1321256_BROCHURE_CAFR.png

S000008028country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1321256_BROCHURE_CA.png

S000008027country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1321150-flyers-US.jpg

S000008026country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1321150-flyers-CA.jpg

S000008025country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

131_Polo-446592.jpg

S000008024country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1318433_US.png

S000008023country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1318433_CAFR.png

S000008022country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1318433_CA.png

S000008021country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1317869_BROCHURE_US.png

S000008020country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1317869_BROCHURE_CAFR.png

S000008019country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1317869_BROCHURE_CA.png

S000008018country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1312267-US.jpg

S000008017country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1312267-CAFR.jpg

S000008016country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1312267-CA.jpg

S000008015country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1310139_BROCHURE_US.png

S000008014country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1310139_BROCHURE_CAFR.png

S000008013country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1310139_BROCHURE_CA.png

S000008012country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

130_Pens-1019832.jpg

S000008011country

images/creating_preview.png

Htmlpng

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