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

Warning: Deleting assets may cause problems with production. Please be certain you are deleting the correct assets.

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1199954-CA.jpg

S000007910 country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1198472-US.jpg

S000007909 country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1198472-CAFR.jpg

S000007908 country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1198472-CA.jpg

S000007907 country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1197140_US.png

S000007906 country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1197140_US.jpg

S000007905 country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1197140_CAFR.png

S000007904 country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1197140_CAFR.jpg

S000007903 country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1197140_CA.png

S000007902 country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1197140_CA.jpg

S000007901 country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1196881-US.jpg

S000007900 country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1196881-CAFR.jpg

S000007899 country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1196881-CA.jpg

S000007898 country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1194109-US.jpg

S000007897 country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1194109-CAFR.jpg

S000007896 country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1194109-CA.jpg

S000007895 country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1193850_US.png

S000007894 country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1193850_CAFR.png

S000007893 country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1193850_CA.png

S000007892 country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

118_Oversized-Postcards-BMS-1100397.jpg

S000007891 country

images/creating_preview.png

Htmlpng

Asset Type:

Language: U.S. English

Date Added: 3-31-2015

1182837_MUG_US.png

S000007890 country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1182837_MUG_CAFR.png

S000007889 country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: Canadian Eng.

Date Added: 3-31-2015

1182837_MUG_CA.png

S000007888 country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

117_Oversized-Postcards-Auto-114297.jpg

S000007887 country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1178183-US.jpg

S000007886 country

images/creating_preview.png

Htmlpng

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