Email: gunpla@gunpla.es

Surily

There are no more items in your cart

Custom Block

You can create unlimited CMS Blocks with any HTML content and put them on side columns or the main center content in any position on any page

Tags results

What is GUNPLA

Gundam models (or Gunpla (ガンプラ, Ganpura)) are model kits depicting the vehicles and characters of the fictional Gundam multiverse by Bandai.

9 2806 160

SELECT p.viewed ,p.created , p.id_smart_blog_post,pl.meta_title,pl.link_rewrite FROM ps_smart_blog_post p INNER JOIN ps_smart_blog_post_lang pl ON p.id_smart_blog_post=pl.id_smart_blog_post INNER JOIN ps_smart_blog_post_shop ps ON pl.id_smart_blog_post = ps.id_smart_blog_post AND ps.id_shop = 1 WHERE pl.id_lang=2 AND p.active = 1 ORDER BY p.viewed DESC LIMIT 0,5