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

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1621404_DCHC_CA-50off.png

S000008135country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1620994-CAFR.jpg

S000008134country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

161_Rack-Cards-Pets-117376-CAFR.jpg

S000008133country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

160_Rack-Cards-Food-793045.jpg

S000008132country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

15_DAM323Save-the-Date-Magnets-907423.jpg

S000008131country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

159_Rack-Cards-CT-1076623.jpg

S000008130country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

158_Rack-Cards-CT-1076623-CAFR.jpg

S000008129country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

158872-US.png

S000008128country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

158872-CAFR.png

S000008127country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

158872-CA.png

S000008126country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1584414_HC_US.png

S000008125country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1584414_HC_US-50off_14.jpg

S000008124country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1584414_HC_US-50off.png

S000008123country

images/creating_preview.png

Htmlpng

Asset Type:

Language: N/A

Date Added: 3-31-2015

1584414_HC_CA.png

S000008122country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1584414_HC_CA-60off_14.jpg

S000008121country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1584414_HC_CA-60off.png

S000008120country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1584414_HC_CA-50off_14.jpg

S000008119country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

1584414_HC_CA-50off.png

S000008118country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

157_Rack-Cards-BMS-431679-EDIT.jpg

S000008117country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

156_Rack-Cards-Auto-711771.jpg

S000008116country

images/creating_preview.png

Htmlpng

Asset Type:

Language: U.S. English

Date Added: 3-31-2015

156652_MUG_US.png

S000008115country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: French Canadian

Date Added: 3-31-2015

156652_MUG_CAFR.png

S000008114country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: Canadian Eng.

Date Added: 3-31-2015

156652_MUG_CA.png

S000008113country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

155_Rack-Cards-Auto-711771-CAFR.jpg

S000008112country

images/creating_preview.png

Htmlpng

Asset Type: Tile 7030

Language: N/A

Date Added: 3-31-2015

154_Promo-Products-USB-617116.jpg

S000008111country

images/creating_preview.png

Htmlpng

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