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

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

113_Notecards-RE-651010.jpg

S000007735country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: U.S. English

Date Added: 3-31-2015

113106_mugs_US.jpg

S000007734country

images/creating_preview.png

Htmlpng

Asset Type: Tile Square

Language: Canadian Eng.

Date Added: 3-31-2015

113106_mugs_CA.jpg

S000007733country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

113106_holidaycards_US.jpg

S000007732country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

113106_holidaycards_CA.jpg

S000007731country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

113106_calendars_US.jpg

S000007730country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

113106_calendars_CA.jpg

S000007729country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

112_Notecards-Food-741473.jpg

S000007728country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1126796_US.png

S000007727country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1126796_CAFR.png

S000007726country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1126796_CA.png

S000007725country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

111_Notecards-AME-755691.jpg

S000007724country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

110_Notecards-758810.jpg

S000007723country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

110663_US.png

S000007722country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

110663_CAFR.png

S000007721country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

110663_CA.png

S000007720country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

10_42-24053443Premium-Business-Cards-Food-307692.jpg

S000007719country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

109_Notecards-758810-Chris.jpg

S000007718country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

108_Notecards-755149.jpg

S000007717country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1089390_US.png

S000007716country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

ScreenShot85433AM.png

S000007715

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

ScreenShot80440AM.png

S000007714

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

ScreenShot80434AM.png

S000007713

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

ScreenShot122929PM.png

S000007712

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

ScreenShot122750PM.png

S000007711

images/creating_preview.png

Htmlpng

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