/var/www/html/nox-modules/prints
/lib/action/frontend
/printsVectorSubcategoryAction.action.php
SELECT `id`, `db_table`, `enabled`, `url`, `name`, `name_singular`, `category_image` FROM prints_class WHERE `enabled`='1' AND `url`='car'
SELECT `id`, `class_id`, `country_id`, `url`, `name`, `logo`, `top`, `blueprints_count`, `vectors_count`, `downloads_count`, `purchases_count` FROM prints_make WHERE `url`='utilimaster' AND `class_id`='1' ORDER BY name
SELECT `id`, `class_id`, `country_id`, `url`, `name`, `logo`, `top`, `blueprints_count`, `vectors_count`, `downloads_count`, `purchases_count` FROM prints_make WHERE class_id = 1 AND ((vectors_count > 0 OR (id IN (SELECT make_id FROM `prints_request_vector`)))) ORDER BY name
SELECT `id`, `make_id`, `year`, `end`, `class`, `body` FROM prints_class_car WHERE `make_id`='491'
SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `item_id` IN('46838','47906','47907','47908','47909','47910','47911','47912','47913','47914','47915','47916','48032','48553','48915','48916','49144','50964','50965','50966','50967','50968','50969','50970','50971','50972','50973','50974','50975','52269') AND `class_id`='1'
?page=###page###
SELECT COUNT(*) as `count` FROM brv_summary_cache WHERE `make_id`='491' AND `type` IN('0','1','2')
29
SELECT `id`, `name`, `full_name`, `sort_name`, `make_id`, `url`, `views`, `type` FROM brv_summary_cache WHERE `make_id`='491' AND `type` IN('0','1','2') ORDER BY `sort_name`, `type` LIMIT 0, 100
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`='1'
SELECT `id`, `tag` FROM tag WHERE `id` IN('91')
SELECT DISTINCT `purchase_id` FROM payment WHERE `status`='approved' AND `purchase_id` IN('28921','29955','29956','29957','29958','29959','29960','29961','29962','29963','29964','30072','30582','30934','30935','31157','31521','31522','31523','31524','31525','31526','31527','31528','31529','31530','31531','31532','31596')
SELECT set_id FROM prints_set_vector WHERE `vector_id`='29957'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 36245) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT vector_id FROM prints_set_vector WHERE `set_id`='36245'
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`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `id` IN('29955','29956','29957','29958','29959','29960','29961','29962','29963','29964','30934','30935','31157','31521','31522','31523','31524','31525','31526','31527','31528','31529','31530','31531','31532','31596') ORDER BY price LIMIT 0, 1
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`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `prepay`=0 AND `id` IN('28921','29955','29956','29958','29959','29960','29961','29962','29963','29964','30072','30582','30934','30935','31157','31521','31522','31523','31524','31525','31526','31527','31528','31529','31530','31531','31532','31596')
SELECT set_id FROM prints_set_vector WHERE `vector_id`='30934'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='30582'
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`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `id`='30582'
SELECT `id`, `name_full` FROM `prints_set` WHERE "2004 - 2026 utilimaster w custom round step van ∙ freightliner mt45/mt55 truck-style ∙ ft-style van" LIKE CONCAT(LOWER(`name_full`), "%") ORDER BY CHAR_LENGTH(`name_full`) DESC, `id` ASC LIMIT 1
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`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `id`='30582'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='29960'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='29955'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='31529'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='29959'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='31527'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='29963'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='31531'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='31522'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='30935'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='29956'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='28921'
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`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `id`='28921'
SELECT `id`, `name_full` FROM `prints_set` WHERE "2011 - 2019 utilimaster reach step van 14\' ∙ p700 ∙ (isuzu npr chassis) van" LIKE CONCAT(LOWER(`name_full`), "%") ORDER BY CHAR_LENGTH(`name_full`) DESC, `id` ASC LIMIT 1
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`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `id`='28921'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='29961'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='31157'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='29964'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='29958'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='31528'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='31526'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='31524'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='31596'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='31525'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='31530'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='31532'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='31523'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='29962'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='31521'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='30934'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='29960'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='29955'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='31529'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='29959'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='31527'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='29963'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='31531'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='31522'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='30935'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='29956'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='29961'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='31157'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='29964'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='29958'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='31528'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='31526'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='31524'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='31596'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='31525'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='31530'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='31532'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='31523'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='29962'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='31521'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='36245'
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`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `prepay`=1 AND `id` IN('30072')
SELECT set_id FROM prints_set_vector WHERE `vector_id`='30072'
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`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `id`='30072'
SELECT `id`, `name_full` FROM `prints_set` WHERE "1999 - 2001 utilimaster ffv usps ∙ ford flexible fuel vehicle ∙ mail truck van" LIKE CONCAT(LOWER(`name_full`), "%") ORDER BY CHAR_LENGTH(`name_full`) DESC, `id` ASC LIMIT 1
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`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `id`='30072'
SELECT `id`, `name`, `type` FROM nox_group