/var/www/html/nox-modules/prints
/lib/action/frontend
/printsBlueprintsCategoryAction.action.php
SELECT `id`, `db_table`, `enabled`, `url`, `name`, `name_singular`, `category_image` FROM prints_class WHERE `enabled`='1' AND `url`='train'
SELECT `tag_id`, `category_id` FROM tag_categoryitem WHERE `category_id`='16'
SELECT `tag_id`, `category_id` FROM tag_category WHERE `category_id`='16'
SELECT `id`, `tag` FROM tag WHERE `id` IN('266','267','268','269','270','271','272','273','274','275','276')
SELECT UPPER(SUBSTRING( name, 1, 1 )) AS "letter" FROM `prints_blueprint` WHERE class_id = 16 GROUP BY `letter`
SELECT UPPER(SUBSTRING( name, 1, 1 )) AS "letter" FROM `prints_vector` WHERE class_id = 16 GROUP BY `letter`
SELECT UPPER(SUBSTRING( name, 1, 1 )) AS "letter" FROM `prints_request_vector` WHERE category_id = 16 GROUP BY `letter`
SELECT `id`, `db_table`, `enabled`, `url`, `name`, `name_singular`, `category_image` FROM prints_class WHERE `enabled`='1'
SELECT id FROM prints_vector WHERE `class_id`='16' 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`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `id`='30349'
SELECT `id`, `name`, `type` FROM nox_group
