/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`='helicopter'
SELECT `id`, `class_id`, `country_id`, `url`, `name`, `logo`, `top`, `blueprints_count`, `vectors_count`, `downloads_count`, `purchases_count` FROM prints_make WHERE `url`='agusta' AND `class_id`='18' 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 = 18 AND ((vectors_count > 0 OR (id IN (SELECT make_id FROM `prints_request_vector`)))) ORDER BY name
SELECT `id`, `make_id`, `year` FROM prints_class_helicopter WHERE `make_id`='387'
SELECT id, url, sort_name, full_name, "15" as views FROM prints_request_vector WHERE `make_id`='387' AND `vector_id` IS NULL
SELECT `tag_id`, `category_id` FROM tag_categoryitem WHERE `category_id`='18'
SELECT `tag_id`, `make_id` FROM tag_make WHERE `make_id`='18'
SELECT id FROM prints_vector WHERE `id` IN(0) AND `prepay`=0
SELECT id FROM prints_vector WHERE `class_id`='18' AND `prepay`=0
SELECT id FROM prints_vector WHERE `class_id`='18' AND `prepay`=0
