Can’t find your vehicle? Request a custom blueprint.

My Downloads | Order Status | Log out

/var/www/html/nox-modules/prints

/lib/action/frontend

/printsBlueprintsPrintAction.action.php

SELECT `id`, `class_id`, `item_id`, `name`, `full_name`, `sort_name`, `url`, `ver`, `filename`, `views`, `resolution_width`, `resolution_height`, `ext`, `copyright_type`, `copyright_url`, `copyright_text`, `added_date`, `update_date`, `views_count`, `downloads_count`, `set_name`, `set_id`, `preview`, `make_source` FROM prints_blueprint WHERE `id`='11305'

UPDATE prints_blueprint SET views_count = views_count+1 WHERE id = 11305

SELECT `id`, `db_table`, `enabled`, `url`, `name`, `name_singular`, `category_image` FROM prints_class WHERE `id`='1'

SELECT `id`, `make_id`, `year`, `end`, `class`, `body` FROM prints_class_car WHERE `id`='11305'

SELECT `id`, `class_id`, `country_id`, `url`, `name`, `logo`, `top`, `blueprints_count`, `vectors_count`, `downloads_count`, `purchases_count` FROM prints_make WHERE `id`='61'

SELECT `tag_id`, `category_id` FROM tag_categoryitem WHERE `category_id`='1'

SELECT `id`, `tag` FROM tag WHERE `id` IN('64','65','66','67','68','69','70','71','72','73','74','75','76','77','78','79','80','81','289','290','291')

SELECT `tag_id`, `make_id` FROM tag_make WHERE `make_id`='61'

SELECT `id`, `db_table`, `enabled`, `url`, `name`, `name_singular`, `category_image` FROM prints_class WHERE `id`='1'

SELECT id FROM prints_vector WHERE prepay=0 AND item_id IN(select id from `prints_class_car` where make_id = 61 AND class = "Offroad" AND body = "SUV")

SELECT id FROM prints_vector WHERE prepay=0 AND item_id IN(select id from `prints_class_car` where make_id = 61 AND class = "Offroad")

SELECT id FROM prints_vector WHERE prepay=0 AND item_id IN(select id from `prints_class_car` where class = "Offroad" AND body = "SUV")

SELECT `id`, `class_id`, `item_id`, `name`, `name_version`, `name_spec`, `full_name`, `sort_name`, `url`, `preview`, `filename`, `large_preview`, `detail`, `vector_dwg`, `wrap_template`, `views`, `scale`, `ext`, `copyright_type`, `copyright_url`, `copyright_text`, `added_date`, `update_date`, `updated_by`, `views_count`, `downloads_count`, `add_user_id`, `price`, `prepay`, `prm`, `flag`, `comment`, `bundle`, `bundle_text`, `market`, `segment`, `tier`, `make_source` FROM prints_vector WHERE `id` IN('871','2555','3402','6257','6645','6827','7854','28740','28862','31364','31515','31938')

SELECT COUNT(*) as `count` FROM prints_set WHERE id IN(SELECT DISTINCT set_id FROM prints_set_vector WHERE vector_id IN(871,2555,3402,6257,6645,6827,7854,28740,28862,31364,31515,31938))

SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT DISTINCT set_id FROM prints_set_vector WHERE vector_id IN(871,2555,3402,6257,6645,6827,7854,28740,28862,31364,31515,31938)) LIMIT 0, 4

SELECT `prints_set`.`id`, `prints_set`.`url`, `prints_set`.`name_full`, COUNT(`vector_id`) c, MIN(`price`) price, IF((SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = `prints_set`.`id`) AND `prepay` = 0 AND `bundle` = 0 AND `preview` != "" ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1) IS NOT NULL, (SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = `prints_set`.`id`) AND `prepay` = 0 AND `bundle` = 0 AND `preview` != "" ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1), (SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = `prints_set`.`id`) AND `bundle` = 0 AND `preview` != "" ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1)) as preview, IF((SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = `prints_set`.`id`) AND `prepay` = 0 AND `bundle` = 0 AND `preview` != "" ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1) IS NOT NULL, 1, 0) as vector FROM `prints_set` LEFT JOIN `prints_set_vector` ON `prints_set`.`id` = `prints_set_vector`.`set_id` LEFT JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set`.`id` IN(28830, 34291, 35519, 36062) GROUP BY `prints_set`.`id` ORDER BY IF(MAX(`prints_vector`.`preview`) IS NOT NULL AND MAX(`prints_vector`.`preview`) != '', 0, 1), `prints_set`.`name_full`

SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 36062 AND `prints_set_vector`.`vector_id` IN(871,2555,3402,6257,6645,6827,7854,28740,28862,31364,31515,31938) AND `prints_vector`.`bundle` = 0

SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 35519 AND `prints_set_vector`.`vector_id` IN(871,2555,3402,6257,6645,6827,7854,28740,28862,31364,31515,31938) AND `prints_vector`.`bundle` = 0

SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 34291 AND `prints_set_vector`.`vector_id` IN(871,2555,3402,6257,6645,6827,7854,28740,28862,31364,31515,31938) AND `prints_vector`.`bundle` = 0

SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 28830 AND `prints_set_vector`.`vector_id` IN(871,2555,3402,6257,6645,6827,7854,28740,28862,31364,31515,31938) AND `prints_vector`.`bundle` = 0

SELECT `tag_id`, `blueprint_id` FROM tag_blueprint WHERE `blueprint_id`='11305'

SELECT `blueprint_id`, `vector_id` FROM prints_relation_vector_blueprint WHERE `blueprint_id`='11305'

SELECT `id`, `name`, `type` FROM nox_group

IKA Jeep 101 Bernadaro SUV blueprints free

All IKA blueprints

Image

RASTER

Get free access:

Get this raster image

Download

Views: Front Top Rear Side

License: Creative Commons

Format: gif

Dimensions: 403 x 188

Downloads: 823

USERS' CHOICE

Request this blueprint as a vector

Request an editable vector blueprint for this exact model:

Request this vector blueprint

View vector example or Request other model.

Raster blueprint of the IKA Jeep 101 Bernadaro SUV. This free downloadable image can be used for graphic projects, digital design, and 3D modeling. The file provides accurate exterior proportions of the vehicle. Body type: SUV.