/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(31337,31339,31345,31348,1406,2456,2457,2458,2459,2460,2461,2867,6088,12313,12314,12315,12316,12317,12318,12319,12320,12321,12322,12323,12324,12325,12326,12327,12328,12329,12330,12331,12332,12333,12334,12335,12336,12337,12338,12339,12340,12341,12342,12343,12344,12382,12383,12384,12385,12386,12387,12388,12389,12390,12391,12392,12393,12394,12395,12396,12397,12398,12399,12400,12401,12402,12403,12404,12405,12406,12407,12408,12409,12410,12411,12412,12413,12414,12415,12416,12417,12418,12419,12420,12421,12422,12423,12424,12425,12426,12427,12428,12429,12430,12431,12432,12433,12434,12435,12436,12437,12438,12439,29407,29408,29409,29410,29532,31312,31335,31336,31338,31340,31341,31342,31343,31344,31346,31347,31825,31827,1010,1011,1012,1013,1405,1407,1802,2848,2849,2850,2851,2852,2853,2854,2855,2856,2857,2858,2859,2860,2861,2862,2863,2864,2865,2866,2868,6372,6373,6374,14387,27973,27979,27992,27993,27995,27996,28348,28589,28805,29009,29319,29320,29321,29322,29323,29324,29325,29326,29327,29328,29329,29403,29404,29405,29406,29411,29412,29413,29414,29415,29416,29417,29418,29419,29420,29421,29422,29423,29424,29425,29426,29433,29434,29444,29445,29446,29447,29448,29455,29456,29457,29458,29459,29460,29461,29462,29463,29464,29465,29466,29467,29468,29469,29470,29471,29472,29473,29474,29475,29476,29477,29478,29479,29480,29513,29514,29515,29516,29517,29518,29519,29520,29596,29597,29598,29599,29600,29601,29602,29603,29604,29605,29606,29607,29608,29609,29610,29611,29619,29650,29691,29692,29913,29914,29915,29916,29917,29918,29919,29920,29921,29922,29923,29924,29925,29926,29927,29928,29929,29930,29931,29932,29933,29934,29935,29936,29937,29938,29939,29940,29941,29942,29943,29944,29945,29946,29998,30089,30097,30185,30186,30187,30188,30234,30297,30298,30322,30323,30324,30325,30326,30327,30328,30329,30330,30331,30332,30333,30334,30335,30336,30337,30338,30339,30340,30341,30342,30343,30344,30345,30346,30347,30348,30349,30350,30351,30352,30353,30521,30698,30718,30837,30838,30843,31046,31049,31050,31061,31062,31063,31067,31187,31188,31189,31213,31230,31231,31248,31256,31257,31258,31318,31319,31320,31321,31351,31372,31435,31436,31437,31438,31439,31440,31441,31442,31443,31444,31445,31446,31447,31448,31449,31450,31451,31452,31453,31454,31455,31456,31457,31458,31788,31981))
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(SELECT DISTINCT set_id FROM prints_set_vector WHERE vector_id IN(31337,31339,31345,31348,1406,2456,2457,2458,2459,2460,2461,2867,6088,12313,12314,12315,12316,12317,12318,12319,12320,12321,12322,12323,12324,12325,12326,12327,12328,12329,12330,12331,12332,12333,12334,12335,12336,12337,12338,12339,12340,12341,12342,12343,12344,12382,12383,12384,12385,12386,12387,12388,12389,12390,12391,12392,12393,12394,12395,12396,12397,12398,12399,12400,12401,12402,12403,12404,12405,12406,12407,12408,12409,12410,12411,12412,12413,12414,12415,12416,12417,12418,12419,12420,12421,12422,12423,12424,12425,12426,12427,12428,12429,12430,12431,12432,12433,12434,12435,12436,12437,12438,12439,29407,29408,29409,29410,29532,31312,31335,31336,31338,31340,31341,31342,31343,31344,31346,31347,31825,31827,1010,1011,1012,1013,1405,1407,1802,2848,2849,2850,2851,2852,2853,2854,2855,2856,2857,2858,2859,2860,2861,2862,2863,2864,2865,2866,2868,6372,6373,6374,14387,27973,27979,27992,27993,27995,27996,28348,28589,28805,29009,29319,29320,29321,29322,29323,29324,29325,29326,29327,29328,29329,29403,29404,29405,29406,29411,29412,29413,29414,29415,29416,29417,29418,29419,29420,29421,29422,29423,29424,29425,29426,29433,29434,29444,29445,29446,29447,29448,29455,29456,29457,29458,29459,29460,29461,29462,29463,29464,29465,29466,29467,29468,29469,29470,29471,29472,29473,29474,29475,29476,29477,29478,29479,29480,29513,29514,29515,29516,29517,29518,29519,29520,29596,29597,29598,29599,29600,29601,29602,29603,29604,29605,29606,29607,29608,29609,29610,29611,29619,29650,29691,29692,29913,29914,29915,29916,29917,29918,29919,29920,29921,29922,29923,29924,29925,29926,29927,29928,29929,29930,29931,29932,29933,29934,29935,29936,29937,29938,29939,29940,29941,29942,29943,29944,29945,29946,29998,30089,30097,30185,30186,30187,30188,30234,30297,30298,30322,30323,30324,30325,30326,30327,30328,30329,30330,30331,30332,30333,30334,30335,30336,30337,30338,30339,30340,30341,30342,30343,30344,30345,30346,30347,30348,30349,30350,30351,30352,30353,30521,30698,30718,30837,30838,30843,31046,31049,31050,31061,31062,31063,31067,31187,31188,31189,31213,31230,31231,31248,31256,31257,31258,31318,31319,31320,31321,31351,31372,31435,31436,31437,31438,31439,31440,31441,31442,31443,31444,31445,31446,31447,31448,31449,31450,31451,31452,31453,31454,31455,31456,31457,31458,31788,31981)) AND EXISTS(SELECT 1 FROM `prints_set_vector` psv2 INNER JOIN `prints_vector` pv2 ON pv2.`id` = psv2.`vector_id` WHERE psv2.`set_id` = `prints_set`.`id` AND psv2.`vector_id` IN(31337,31339,31345,31348,1406,2456,2457,2458,2459,2460,2461,2867,6088,12313,12314,12315,12316,12317,12318,12319,12320,12321,12322,12323,12324,12325,12326,12327,12328,12329,12330,12331,12332,12333,12334,12335,12336,12337,12338,12339,12340,12341,12342,12343,12344,12382,12383,12384,12385,12386,12387,12388,12389,12390,12391,12392,12393,12394,12395,12396,12397,12398,12399,12400,12401,12402,12403,12404,12405,12406,12407,12408,12409,12410,12411,12412,12413,12414,12415,12416,12417,12418,12419,12420,12421,12422,12423,12424,12425,12426,12427,12428,12429,12430,12431,12432,12433,12434,12435,12436,12437,12438,12439,29407,29408,29409,29410,29532,31312,31335,31336,31338,31340,31341,31342,31343,31344,31346,31347,31825,31827,1010,1011,1012,1013,1405,1407,1802,2848,2849,2850,2851,2852,2853,2854,2855,2856,2857,2858,2859,2860,2861,2862,2863,2864,2865,2866,2868,6372,6373,6374,14387,27973,27979,27992,27993,27995,27996,28348,28589,28805,29009,29319,29320,29321,29322,29323,29324,29325,29326,29327,29328,29329,29403,29404,29405,29406,29411,29412,29413,29414,29415,29416,29417,29418,29419,29420,29421,29422,29423,29424,29425,29426,29433,29434,29444,29445,29446,29447,29448,29455,29456,29457,29458,29459,29460,29461,29462,29463,29464,29465,29466,29467,29468,29469,29470,29471,29472,29473,29474,29475,29476,29477,29478,29479,29480,29513,29514,29515,29516,29517,29518,29519,29520,29596,29597,29598,29599,29600,29601,29602,29603,29604,29605,29606,29607,29608,29609,29610,29611,29619,29650,29691,29692,29913,29914,29915,29916,29917,29918,29919,29920,29921,29922,29923,29924,29925,29926,29927,29928,29929,29930,29931,29932,29933,29934,29935,29936,29937,29938,29939,29940,29941,29942,29943,29944,29945,29946,29998,30089,30097,30185,30186,30187,30188,30234,30297,30298,30322,30323,30324,30325,30326,30327,30328,30329,30330,30331,30332,30333,30334,30335,30336,30337,30338,30339,30340,30341,30342,30343,30344,30345,30346,30347,30348,30349,30350,30351,30352,30353,30521,30698,30718,30837,30838,30843,31046,31049,31050,31061,31062,31063,31067,31187,31188,31189,31213,31230,31231,31248,31256,31257,31258,31318,31319,31320,31321,31351,31372,31435,31436,31437,31438,31439,31440,31441,31442,31443,31444,31445,31446,31447,31448,31449,31450,31451,31452,31453,31454,31455,31456,31457,31458,31788,31981) AND pv2.`bundle` = 0) GROUP BY `prints_set`.`id` ORDER BY 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, 0, 1), `prints_set`.`name_full` LIMIT 30
SELECT `prints_vector`.* FROM `prints_vector` LEFT JOIN `prints_set_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `id` IN(31337,31339,31345,31348,1406,2456,2457,2458,2459,2460,2461,2867,6088,12313,12314,12315,12316,12317,12318,12319,12320,12321,12322,12323,12324,12325,12326,12327,12328,12329,12330,12331,12332,12333,12334,12335,12336,12337,12338,12339,12340,12341,12342,12343,12344,12382,12383,12384,12385,12386,12387,12388,12389,12390,12391,12392,12393,12394,12395,12396,12397,12398,12399,12400,12401,12402,12403,12404,12405,12406,12407,12408,12409,12410,12411,12412,12413,12414,12415,12416,12417,12418,12419,12420,12421,12422,12423,12424,12425,12426,12427,12428,12429,12430,12431,12432,12433,12434,12435,12436,12437,12438,12439,29407,29408,29409,29410,29532,31312,31335,31336,31338,31340,31341,31342,31343,31344,31346,31347,31825,31827,1010,1011,1012,1013,1405,1407,1802,2848,2849,2850,2851,2852,2853,2854,2855,2856,2857,2858,2859,2860,2861,2862,2863,2864,2865,2866,2868,6372,6373,6374,14387,27973,27979,27992,27993,27995,27996,28348,28589,28805,29009,29319,29320,29321,29322,29323,29324,29325,29326,29327,29328,29329,29403,29404,29405,29406,29411,29412,29413,29414,29415,29416,29417,29418,29419,29420,29421,29422,29423,29424,29425,29426,29433,29434,29444,29445,29446,29447,29448,29455,29456,29457,29458,29459,29460,29461,29462,29463,29464,29465,29466,29467,29468,29469,29470,29471,29472,29473,29474,29475,29476,29477,29478,29479,29480,29513,29514,29515,29516,29517,29518,29519,29520,29596,29597,29598,29599,29600,29601,29602,29603,29604,29605,29606,29607,29608,29609,29610,29611,29619,29650,29691,29692,29913,29914,29915,29916,29917,29918,29919,29920,29921,29922,29923,29924,29925,29926,29927,29928,29929,29930,29931,29932,29933,29934,29935,29936,29937,29938,29939,29940,29941,29942,29943,29944,29945,29946,29998,30089,30097,30185,30186,30187,30188,30234,30297,30298,30322,30323,30324,30325,30326,30327,30328,30329,30330,30331,30332,30333,30334,30335,30336,30337,30338,30339,30340,30341,30342,30343,30344,30345,30346,30347,30348,30349,30350,30351,30352,30353,30521,30698,30718,30837,30838,30843,31046,31049,31050,31061,31062,31063,31067,31187,31188,31189,31213,31230,31231,31248,31256,31257,31258,31318,31319,31320,31321,31351,31372,31435,31436,31437,31438,31439,31440,31441,31442,31443,31444,31445,31446,31447,31448,31449,31450,31451,31452,31453,31454,31455,31456,31457,31458,31788,31981) 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 13
?q=Ram&page=###page###
509
SELECT `id`, `name`, `type` FROM nox_group

Search Results for "Ram"

 

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: 17 sets of blueprints - 385 vector blueprints - 38 free blueprints (view free blueprints).

Ram 700 blueprint Ram 700 blueprint
Set of items
Ram 700
Collection of 3 blueprints
Starting at $24

 

1981 Dodge Ram D250 Club Cab 8' ∙ D/W Pickup Truck blueprint
1981 - 1990
Dodge Ram D250
$24

 

2012 Ram C/V Tradesman Cargo Van blueprint
2012 - 2015
Ram C/V Tradesman
$24

 

2012 Ram Cargo Van Tradesman Van blueprint
2012 - 2015
Ram Cargo Van
$24

 

2018 Ram H100 2 Gen Facelift2 Wagon ∙ mx Wagon blueprint
2018 - 2026
Ram H100
2 Gen Facelift2
$24

 

2001 Chrysler Ram Panel Van blueprint 2001 Chrysler Ram Panel Van blueprint
2001 - 2004
Chrysler Ram
Panel
$24

 

All search results - 509 items

This list includes all items: free bitmap blueprints, requested items, pre-order and ready vector blueprints.
  Model Views
1999 Dodge Ram SUV  F T R S
1996 Dodge Ram VTS Pick-up Pickup Truck  F T R S
1996 Dodge Ram VTS Pick-up Pickup Truck  F T R S
2010 Dodge Ram-1500 Pickup Truck  F T R S
2010 Dodge Ram-1500 Pickup Truck  F T R S
1968 Pontiac Firebird 400 Ram Air Coupe  F T R S
1998 Pontiac Firebird Ram Air Coupe  F T R S
1998 Pontiac Firebird Ram-Air Coupe  F T R S
2027 Ram ProMaster City All-New Generation Van  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.