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

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1216022-PBC.jpg

S000007935country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1216013_US.png

S000007934country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1216013_CAFR.png

S000007933country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1216013_CA.png

S000007932country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

120_Oversized-Postcards-Food-1115832-CAFR.jpg

S000007931country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1209269_TSHIRT_US.png

S000007930country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1209269_TSHIRT_CAFR.png

S000007929country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1209269_TSHIRT_CA.png

S000007928country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1206395-PBC.jpg

S000007927country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1206353_US.png

S000007926country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1206353_US.jpg

S000007925country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1206353_CAFR.png

S000007924country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1206353_CAFR.jpg

S000007923country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1206353_CA.png

S000007922country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1206353_CA.jpg

S000007921country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1205994_US.png

S000007920country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1205994_CAFR.png

S000007919country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1205994_CA.png

S000007918country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1200903_US.png

S000007917country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1200903_CAFR.png

S000007916country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1200903_CA.png

S000007915country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

11_DAM15481Rack-Cards-AME-448731.jpg

S000007914country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

119_Oversized-Postcards-CT-1098207.jpg

S000007913country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1199954-US.jpg

S000007912country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1199954-CAFR.jpg

S000007911country

images/creating_preview.png

Htmlpng

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