/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`='airplane'
SELECT `id`, `class_id`, `country_id`, `url`, `name`, `logo`, `top`, `blueprints_count`, `vectors_count`, `downloads_count`, `purchases_count` FROM prints_make WHERE `url`='boeing' AND `class_id`='13' 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 = 13 AND ((vectors_count > 0) OR (blueprints_count > 0) OR (id IN (SELECT make_id FROM `prints_request_vector`))) ORDER BY name
SELECT `id`, `make_id`, `class`, `year` FROM prints_class_airplane WHERE `make_id`='307'
SELECT id, url, sort_name, full_name, views FROM prints_blueprint WHERE `item_id` IN('18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','37','38','39','40','41','42','43','44','108','110','114','116','118','119','121','122','124','128','129','130','133') AND `class_id`='13'
SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `item_id` IN('18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','37','38','39','40','41','42','43','44','108','110','114','116','118','119','121','122','124','128','129','130','133') AND `class_id`='13'
SELECT name FROM prints_make WHERE `id`='307'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE `name_full` LIKE "Boeing%" ORDER BY name_title
SELECT id, url, sort_name, full_name, "15" as views FROM prints_request_vector WHERE `make_id`='307' AND `vector_id` IS NULL
SELECT `tag_id`, `category_id` FROM tag_categoryitem WHERE `category_id`='13'
SELECT `tag_id`, `make_id` FROM tag_make WHERE `make_id`='307'
SELECT id FROM prints_vector WHERE `id` IN('1981','4067','4204','4244','5381','12548','15784','15785','27905','27987','27990','28133','28152') AND `prepay`=0
SELECT id FROM prints_vector WHERE `class_id`='13' AND `prepay`=0
SELECT id FROM prints_vector WHERE `class_id`='13' AND `prepay`=0
