/var/www/html/nox-modules/prints
/lib/action/frontend
/printsSearchDefaultAction.action.php
main
SELECT COUNT(*) as `count` FROM prints_set WHERE id IN(SELECT DISTINCT set_id FROM prints_set_vector WHERE vector_id IN(8334,8335,8336,8337,8339,8341))
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(8334,8335,8336,8337,8339,8341)) LIMIT 0, 30
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(8694) 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` = 8694 AND `prints_set_vector`.`vector_id` IN(8334,8335,8336,8337,8339,8341) AND `prints_vector`.`bundle` = 0
SELECT `prints_vector`.* FROM `prints_vector` LEFT JOIN `prints_set_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `id` IN(8334,8335,8336,8337,8339,8341) AND `set_id` IS NULL ORDER BY IF(`prints_vector`.`preview` IS NOT NULL AND `prints_vector`.`preview` != '', 0, 1), `prepay`, `prints_vector`.`full_name` LIMIT 29
?q=Cima&page=###page###
23
SELECT `id`, `name`, `type` FROM nox_group

Search Results for "Cima"

 

VECTOR

Ready-made editable vector blueprints available for instant download.


CUSTOM ORDER

Order a custom vector blueprint with a fixed price. Production and delivery within 3-7 work days.


REQUEST

This blueprint is not available as a ready-made item. You can request a custom order for this vehicle.

 

Search Results

We found: 1 sets of blueprints - 6 vector blueprints - 10 free blueprints (view free blueprints).

Nissan Cima blueprint Nissan Cima blueprint
Set of items
Nissan Cima
Collection of 6 blueprints
Starting at $24

 

All search results - 23 items

This list includes all items: free bitmap blueprints, requested items, pre-order and ready vector blueprints.

  Model Views
2001 - 2010 Nissan Cima F50 Sedan CUSTOM ORDER F T R S
1988 - 1991 Nissan Cima Y31 Hardtop Sedan CUSTOM ORDER F T R S
1993 - 1996 Nissan Cima Y32 Facelift Sedan CUSTOM ORDER F T R S
1991 - 1993 Nissan Cima Y32 Sedan CUSTOM ORDER F T R S
1996 - 2001 Nissan Cima Y33 Sedan CUSTOM ORDER F T R S
2012 Nissan Cima Y51 Sedan CUSTOM ORDER F T R S
2004 Nissan Cima REQUEST F T R S
2001 Nissan Cima 450XV REQUEST F T R S
2004 Nissan Cima F50 REQUEST F T R S
2001 Nissan Cima F55 REQUEST F T R S
2003 Nissan Cima VG30 REQUEST F T R S
1988 Nissan Cima Y31 REQUEST F T R S
1985 Other Foxtrot Cima REQUEST F T R S
2001 Nissan Cima 450XV Sedan  F T R S
2001 Nissan Cima 450XV Sedan  F T R S
2004 Nissan Cima F50 Sedan  F T R S
2001 Nissan Cima F55 Sedan  F T R S
2004 Nissan Cima Sedan  F T R S
2003 Nissan Cima VG30 Sedan  F T R S
1988 Nissan Cima Y31 Coupe  F T R S
1988 Nissan Cima Y31 Sedan  F T R S
Nissan Cima Y31 Sedan  F T R S
1985 Other Foxtrot Cima Sedan  F T R S


Search Tips

Please write a vehicle make or brand name (e.g., Ford) or just a model name (e.g., Transit) or both make and model name (e.g., Volkswagen Golf). For better search results, please follow these simple rules:

  • ● Check if the brand or model name is written correctly
  • ● Do not specify your search with version (such as GT or Mk.2)
  • ● Do not specify a year (such as 68 Mustang) - just write Mustang
  • ● Please do not enter words such as blueprints, drawings, templates, PDF, etc.
eng
English
arrow
OK
Log in or Create account
For quick login use:
 
or
Create account or Log in
Gmail / Google+
By pressing this button you accept our terms and conditions
or
Use Email
Facebook
Register with FB or go back
Enter your email address to receive personal notifications.
Register with Email or go back
Create your account with an email.
I forgot password or go back
Enter your email address to reset your password.
Enter new password
Enter your new password.