/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`='car'
SELECT `id`, `class_id`, `country_id`, `url`, `name`, `logo`, `top`, `blueprints_count`, `vectors_count`, `downloads_count`, `purchases_count` FROM prints_make WHERE `url`='western-star' 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 (blueprints_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`='279'
SELECT id, url, sort_name, full_name, views FROM prints_blueprint WHERE `item_id` IN('15838','15839','15840','48822','48881','48882','48883','48884','48885','48893','50577','50578','50579','50580','50581','50582','50583','50584','50585','50586','50587','50588','50589','50590','50591','50592','50593','50594','50595','50596','50597','50598','50599','50600','50601','50602','50603','50604','50605','50606','50607','50608','50609','50610','50611','50612','50613','50614','50615','50616','50617','50618','50619','50620','50621','50622','50623','50624','50625','50626','50627','50628','50629','50630','50631','50632','50633','50634','50635','50636','50637','50638','50639','50640','50641','50642','50643','50644','50645','50646','50647','50648','50649','50650','50651','50652','50653','50654','50655','50656','50657','50658','50659','50660','50661','50662','50663','50664','50665','50666','50667','50668','50669') AND `class_id`='1'
SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `item_id` IN('15838','15839','15840','48822','48881','48882','48883','48884','48885','48893','50577','50578','50579','50580','50581','50582','50583','50584','50585','50586','50587','50588','50589','50590','50591','50592','50593','50594','50595','50596','50597','50598','50599','50600','50601','50602','50603','50604','50605','50606','50607','50608','50609','50610','50611','50612','50613','50614','50615','50616','50617','50618','50619','50620','50621','50622','50623','50624','50625','50626','50627','50628','50629','50630','50631','50632','50633','50634','50635','50636','50637','50638','50639','50640','50641','50642','50643','50644','50645','50646','50647','50648','50649','50650','50651','50652','50653','50654','50655','50656','50657','50658','50659','50660','50661','50662','50663','50664','50665','50666','50667','50668','50669') AND `class_id`='1'
SELECT name FROM prints_make WHERE `id`='279'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE `name_full` LIKE "Western Star%" ORDER BY name_title
?page=###page###
SELECT COUNT(*) as `count` FROM brv_summary_cache WHERE `make_id`='279'
112
SELECT `id`, `name`, `full_name`, `sort_name`, `make_id`, `url`, `views`, `type` FROM brv_summary_cache WHERE `make_id`='279' ORDER BY `sort_name`, `type` LIMIT 100, 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`='279'
SELECT DISTINCT `purchase_id` FROM payment WHERE `status`='approved' AND `purchase_id` IN('30841','30900','30901','30902','30903','30904')
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 `prepay`=0 AND `id` IN('30841','30900','30901','30902','30903','30904')
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 30841) ORDER BY name_title
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`='30841'
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 `prepay`=1 AND `id` IN('30900','30901','30902','30903','30904')
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 30904) ORDER BY name_title
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`='30904'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 30903) ORDER BY name_title
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`='30903'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 30900) ORDER BY name_title
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`='30900'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 30901) ORDER BY name_title
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`='30901'
SELECT `id`, `name`, `type` FROM nox_group