/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(3096,3097,3098,3099,3100,3101,3102,3103,3104,3105,3106,3107,3108,3109,3110,3111,3112,3113,3114,3115,3116,3117,3118,3119,3120,3121,3122,3123,3124,3125,3126,3127,3128,3129,3130,3131,3132,3133,3134,3135,3136,3137,3138,3139,3140,3141,3142,3143,3144,3145,3146,3147,3148,3149,3150,3151,3152,3153,3154,3155,3156,3157,3158,3159,3160,3161,3162,3163,3164,3165,3166,3167,3168,3169,3170,3171,3172,3173,3174,3175,3176,3177,3178,3179,3180,3181,3182,3183,3184,3185,3186,3187,3188,3189,3190,3191,3192,3193,3194,3195,3196,3197,3198,3199,3200,3201,3202,3203,3204,3205,3206,3207,3208,3209,3210))
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(3096,3097,3098,3099,3100,3101,3102,3103,3104,3105,3106,3107,3108,3109,3110,3111,3112,3113,3114,3115,3116,3117,3118,3119,3120,3121,3122,3123,3124,3125,3126,3127,3128,3129,3130,3131,3132,3133,3134,3135,3136,3137,3138,3139,3140,3141,3142,3143,3144,3145,3146,3147,3148,3149,3150,3151,3152,3153,3154,3155,3156,3157,3158,3159,3160,3161,3162,3163,3164,3165,3166,3167,3168,3169,3170,3171,3172,3173,3174,3175,3176,3177,3178,3179,3180,3181,3182,3183,3184,3185,3186,3187,3188,3189,3190,3191,3192,3193,3194,3195,3196,3197,3198,3199,3200,3201,3202,3203,3204,3205,3206,3207,3208,3209,3210)) 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(29611) 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` = 29611 AND `prints_set_vector`.`vector_id` IN(3096,3097,3098,3099,3100,3101,3102,3103,3104,3105,3106,3107,3108,3109,3110,3111,3112,3113,3114,3115,3116,3117,3118,3119,3120,3121,3122,3123,3124,3125,3126,3127,3128,3129,3130,3131,3132,3133,3134,3135,3136,3137,3138,3139,3140,3141,3142,3143,3144,3145,3146,3147,3148,3149,3150,3151,3152,3153,3154,3155,3156,3157,3158,3159,3160,3161,3162,3163,3164,3165,3166,3167,3168,3169,3170,3171,3172,3173,3174,3175,3176,3177,3178,3179,3180,3181,3182,3183,3184,3185,3186,3187,3188,3189,3190,3191,3192,3193,3194,3195,3196,3197,3198,3199,3200,3201,3202,3203,3204,3205,3206,3207,3208,3209,3210) 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(3096,3097,3098,3099,3100,3101,3102,3103,3104,3105,3106,3107,3108,3109,3110,3111,3112,3113,3114,3115,3116,3117,3118,3119,3120,3121,3122,3123,3124,3125,3126,3127,3128,3129,3130,3131,3132,3133,3134,3135,3136,3137,3138,3139,3140,3141,3142,3143,3144,3145,3146,3147,3148,3149,3150,3151,3152,3153,3154,3155,3156,3157,3158,3159,3160,3161,3162,3163,3164,3165,3166,3167,3168,3169,3170,3171,3172,3173,3174,3175,3176,3177,3178,3179,3180,3181,3182,3183,3184,3185,3186,3187,3188,3189,3190,3191,3192,3193,3194,3195,3196,3197,3198,3199,3200,3201,3202,3203,3204,3205,3206,3207,3208,3209,3210) 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=P-Series&page=###page###
125
SELECT `id`, `name`, `type` FROM nox_group

Search Results for "P-Series"

 

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 - 115 vector blueprints - 3 free blueprints (view free blueprints).

Scania P-Series blueprint
Set of items
Scania P-Series
Collection of 115 blueprints
Starting at $24

 

All search results - 125 items

This list includes all items: free bitmap blueprints, requested items, pre-order and ready vector blueprints.
12
>
  Model Views
2011 Scania P-Series P410 8×4 Highline Mixer Heavy Truck CUSTOM ORDER F T R S
2011 Scania P-Series P410 8×4 Tipper Heavy Truck CUSTOM ORDER F T R S
2011 Scania P-Series P410 8×4 Tipper Off-Road Package Heavy Truck CUSTOM ORDER F T R S
2004 - 2010 Scania P-Series P420 4x2 Heavy Truck CUSTOM ORDER F T R S
2004 - 2010 Scania P-Series P420 4x4 Tipper Heavy Truck CUSTOM ORDER F T R S
2004 - 2010 Scania P-Series P420 6x2 Heavy Truck CUSTOM ORDER F T R S
2005 - 2010 Scania P-Series P420 6x2 Refrigerator Heavy Truck CUSTOM ORDER F T R S
2004 - 2010 Scania P-Series P420 6x4 Heavy Truck CUSTOM ORDER F T R S
2004 - 2010 Scania P-Series P420 6x4 Tipper Heavy Truck CUSTOM ORDER F T R S
2004 - 2010 Scania P-Series P420 6x6 Timber Truck Heavy Truck CUSTOM ORDER F T R S
2004 - 2010 Scania P-Series P420 6x6 Tipper Heavy Truck CUSTOM ORDER F T R S
2004 - 2010 Scania P-Series P420 8x4 Heavy Truck CUSTOM ORDER F T R S
2004 - 2011 Scania P-Series P420 8x4 rigid Short cab with Rossetti tipper body Heavy Truck CUSTOM ORDER F T R S
2010 - 2011 Scania P-Series P420 8x4 Tipper Heavy Truck CUSTOM ORDER F T R S
2004 - 2010 Scania P-Series P420 8x6 Tipper Heavy Truck CUSTOM ORDER F T R S
2006 Oshkosh P-series 4x4 REQUEST F T R S
2006 Oshkosh P-series 6x6 REQUEST F T R S
2005 Scania P-Series 230 REQUEST F T R S
2015 Scania P-Series 450 REQUEST F T R S
2021 Scania P-Series 8x2 REQUEST F T R S
2004 Scania P-Series LA 4X2 REQUEST F T R S
2011 Scania P-Series P250 REQUEST F T R S
2006 Oshkosh P-series 4x4 Heavy Truck  F T R S
2006 Oshkosh P-series 6x6 Heavy Truck  F T R S
2012 Oshkosh P-Series Snow Chassis Heavy Truck  F T R S
12
>

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.