/var/www/html/nox-modules/prints
/lib/action/frontend
/printsBlueprintsSubcategoryAction.action.php
SELECT `id`, `db_table`, `enabled`, `url`, `name`, `name_singular`, `category_image` FROM prints_class WHERE `enabled`='1' AND `url`='weapon'
SELECT UPPER(SUBSTRING( name, 1, 1 )) AS "letter" FROM `prints_blueprint` WHERE class_id = 21 GROUP BY `letter`
SELECT UPPER(SUBSTRING( name, 1, 1 )) AS "letter" FROM `prints_vector` WHERE class_id = 21 GROUP BY `letter`
SELECT UPPER(SUBSTRING( name, 1, 1 )) AS "letter" FROM `prints_request_vector` WHERE category_id = 21 GROUP BY `letter`
SELECT `id`, `class_id`, `item_id`, `name`, `full_name`, `sort_name`, `url`, `ver`, `filename`, `views`, `resolution_width`, `resolution_height`, `ext`, `copyright_type`, `copyright_url`, `copyright_text`, `added_date`, `update_date`, `views_count`, `downloads_count`, `set_name`, `set_id`, `preview`, `make_source` FROM prints_blueprint WHERE `class_id` = "21" AND name LIKE "B%"
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`, `market`, `segment`, `tier`, `make_source` FROM prints_vector WHERE `class_id` = "21" AND name LIKE "B%"
SELECT `id`, `vector_id`, `url`, `name`, `name_details`, `full_name`, `sort_name`, `category_id`, `make_id`, `body`, `blueprint_id`, `year`, `request_date`, `update_date`, `user_id`, `views_count`, `status`, `utm_value`, `description`, `set_name`, `set_id`, `raster_source`, `preview` FROM prints_request_vector WHERE `category_id` = "21" AND name LIKE "B%" AND vector_id IS NULL
SELECT `tag_id`, `category_id` FROM tag_categoryitem WHERE `category_id`='21'
SELECT `tag_id`, `category_id` FROM tag_category WHERE `category_id`='21'
SELECT `id`, `tag` FROM tag WHERE `id` IN('285','286','287','288')
SELECT id FROM prints_vector WHERE `class_id`='21' AND `prepay`=0
SELECT id FROM prints_vector WHERE `prepay`=0
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`, `market`, `segment`, `tier`, `make_source` FROM prints_vector WHERE `id`='3711'
SELECT `id`, `name`, `type` FROM nox_group
