$resultlast = dbquery(
"SELECT f.figure_id,
f.figure_cat,
f.figure_title,
f.figure_submitter,
f.figure_freigabe,
f.figure_pubdate,
f.figure_scale,
f.figure_manufacturer,
f.figure_brand,
f.figure_datestamp,
fc.figure_cat_id,
fc.figure_cat_name,
fm.figure_manufacturer_id,
fm.figure_manufacturer_name,
fb.figure_brand_id,
fb.figure_brand_name,
fy.figure_year_id,
fy.figure_year,
fs.figure_scale_id,
fs.figure_scale_name,
fuf.figure_userfigures_figure_id,
fuf.figure_userfigures_user_id
FROM ".DB_FIGURE_ITEMS." f
INNER JOIN ".DB_FIGURE_USERFIGURES." fuf ON fuf.figure_userfigures_figure_id=f.figure_id
INNER JOIN ".DB_FIGURE_CATS." fc ON fc.figure_cat_id=f.figure_cat
INNER JOIN ".DB_FIGURE_MANUFACTURERS." fm ON fm.figure_manufacturer_id=f.figure_manufacturer
INNER JOIN ".DB_FIGURE_BRANDS." fb ON fb.figure_brand_id=f.figure_brand
INNER JOIN ".DB_FIGURE_SCALES." fs ON fs.figure_scale_id=f.figure_scale
INNER JOIN ".DB_FIGURE_YEARS." fy ON fy.figure_year_id=f.figure_pubdate
".(multilang_table("FI") ? "WHERE figure_language='".LANGUAGE."' AND" : "WHERE")." figure_userfigures_user_id=".$userdata['user_id']."
ORDER BY figure_datestamp DESC LIMIT 1
");