/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(11001,11002,11003,11004,11005,11006,11007,11008))
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(11001,11002,11003,11004,11005,11006,11007,11008)) 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(11163) 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` = 11163 AND `prints_set_vector`.`vector_id` IN(11001,11002,11003,11004,11005,11006,11007,11008) 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(11001,11002,11003,11004,11005,11006,11007,11008) 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=Cresta&page=###page###
28
SELECT `id`, `name`, `type` FROM nox_group

Search Results for "Cresta"

 

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 - 8 vector blueprints - 16 free blueprints (view free blueprints).

Toyota Cresta blueprint Toyota Cresta blueprint
Set of items
Toyota Cresta
Collection of 8 blueprints
Starting at $24
Set of items
Toyota Cresta
Collection of 8 blueprints
View set of 8 blueprints

 

All search results - 28 items

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

  Model Views
1982 - 1984 Toyota Cresta X-50 Hardtop Facelift Sedan CUSTOM ORDER F T R S
1980 - 1982 Toyota Cresta X-50 Hardtop Sedan CUSTOM ORDER F T R S
1986 - 1988 Toyota Cresta X-70 Hardtop Facelift Sedan CUSTOM ORDER F T R S
1984 - 1986 Toyota Cresta X-70 Hardtop Sedan CUSTOM ORDER F T R S
1990 - 1992 Toyota Cresta X-80 Facelift Sedan CUSTOM ORDER F T R S
1988 - 1990 Toyota Cresta X-80 Sedan CUSTOM ORDER F T R S
1996 - 2001 Toyota Cresta X100 Sedan CUSTOM ORDER F T R S
1992 - 1996 Toyota Cresta X90 Sedan CUSTOM ORDER F T R S
1991 Toyota Cresta 25G REQUEST F T R S
1984 Toyota Cresta GX71 GT Twin Turbo REQUEST F T R S
1991 Toyota Cresta III X80 25G Twin Turbo REQUEST F T R S
1989 Toyota Cresta Super G REQUEST F T R S
1991 Toyota Cresta 25G Sedan  F T R S
1984 Toyota Cresta GX71 GT Twin Turbo Sedan  F T R S
1991 Toyota Cresta III X80 25G Twin Turbo Sedan  F T R S
1989 Toyota Cresta Super G Sedan  F T R S
1966 Vauxhall Cresta Deluxe Tag  F T R S
1959 Vauxhall Cresta PA Tag  F T R S
1963 Vauxhall Cresta PB Estate Wagon  F T R S
1963 Vauxhall Cresta PB Tag  F T R S
1963 Vauxhall Cresta PB Tag  F T R S
1963 Vauxhall Cresta PB Tag  F T R S
1964 Vauxhall Cresta PB Tag  F T R S
1965 Vauxhall Cresta PB Tag  F T R S
1972 Vauxhall Cresta PC DeLuxe Tag  F T R S
1966 Vauxhall Cresta PC Tag  F T R S
1966 Vauxhall Cresta PC Tag  F T R S
1972 Vauxhall Cresta PC Tag  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
de
Deutsch
fr
Français
es
Español
it
Italiano
nl
Nederlands
se
Svenska
jp
日本語
OK
Log in or Create account
For quick login use:
 
or
Forgot password?
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.