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

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

133_Postcards-Standard-Auto-712871copy.jpg

S000008060country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1338864-US.jpg

S000008059country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1338864-CAFR.jpg

S000008058country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1338864-CA.jpg

S000008057country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1335398_US.png

S000008056country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1335398_CAFR.png

S000008055country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1335398_CA.png

S000008054country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1335388_US.png

S000008053country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1335388_US.jpg

S000008052country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1335388_CAFR.png

S000008051country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1335388_CAFR.jpg

S000008050country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1335388_CA.png

S000008049country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1335388_CA.jpg

S000008048country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1331858_US.png

S000008047country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1331858_CAFR.png

S000008046country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1331858_CA.png

S000008045country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1330773_BROCHURE_US.png

S000008044country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1330773_BROCHURE_CAFR.png

S000008043country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1330773_BROCHURE_CA.png

S000008042country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

132_polo_mens_white.jpg

S000008041country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1329162-US.jpg

S000008040country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1329162-CAFR.jpg

S000008039country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1329162-CA.jpg

S000008038country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1328037-PBC-FrCa.jpg

S000008037country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1328037-PBC-CA.jpg

S000008036country

images/creating_preview.png

Htmlpng

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