/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`='holden' 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`='52'
SELECT id, url, sort_name, full_name, views FROM prints_blueprint WHERE `item_id` IN('4937','4938','4939','4940','4941','4942','4943','4944','4945','4946','4947','4948','4949','4950','8029','8030','8031','8047','8048','8049','8050','8051','8052','8053','8054','8055','8056','8057','8058','8059','8060','8061','8062','8063','8064','8065','8066','8067','8068','8069','8070','8071','18585','18595','18596','18779','18780','18919','18920','18989','18990','18991','18992','18993','18994','18995','18996','18997','18998','19998','19999','20000','20001','20002','20003','20004','21610','21611','21612','21613','21614','21615','21616','21617','21618','21619','21620','21621','21622','21623','21624','21625','21626','21627','21628','21629','21630','21631','21632','21633','21634','21635','21636','21637','21638','21639','21640','21641','21642','21643','21644','21645','21646','21647','21648','21649','21650','21651','21652','21654','21655','21656','21657','21658','21659','21660','21661','21662','21663','21664','21665','24432','24472','24473','24474','24475','24476','24477','24478','24479','24480','24481','24482','24483','24484','24485','24486','24487','24488','24489','24490','24491','24492','24493','24494','24495','24496','24497','24498','24499','24500','24501','24502','24503','24504','24505','24506','24507','24508','24509','24510','24511','24512','24513','24514','24515','24516','24517','24518','24519','24520','24521','24522','24523','24524','24525','24526','24527','24528','24552','24553','26012','26013','26014','26015','26016','26017','26018','26019','26020','26021','26022','26023','26024','26025','26026','26027','26028','26176','26177','26178','26179','26517','26527','26528','26912','26914','26970','27912','27913','27937','27938','27939','27940','28122','28123','28124','28125','28281','28282','28283','28284','28285','28286','28287','28288','28289','28290','28419','28420','28678','28679','28680','28681','28682','28683','29951','29952','29953','29954','29955','29956','29957','29958','29959','29960','29981','29982','29986','29987','29988','29989','29990','29991','29992','29993','29994','29995','29996','29997','29998','29999','30000','30001','30002','30003','30004','30005','30006','30009','30010','30011','30012','30013','30014','30015','30018','30019','30020','30021','30022','30023','30024','30029','30030','30031','30032','30033','30034','30035','30040','30041','30042','30043','30044','30045','30046','30047','30048','30049','30050','30051','30052','30053','30054','30055','30056','30057','30058','30059','30060','30061','30062','30063','30064','30065','30066','30067','30068','30069','30070','30071','30072','30073','30074','30075','30076','30080','30081','30082','30083','30084','30085','30086','30224','30225','30226','30227','31494','31495','31923','33598','33599','33614','33615','33616','33617','45750','45991','46121','46650','46651','47138','47139','47140','47141','47142','47143','48019','49633','49634','50953','51326','57722','57723','57724','57725','57726','57727','57728','57729','57730','57731','57732','57733','57734','57735','62015','62016','62092') AND `class_id`='1'
SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `item_id` IN('4937','4938','4939','4940','4941','4942','4943','4944','4945','4946','4947','4948','4949','4950','8029','8030','8031','8047','8048','8049','8050','8051','8052','8053','8054','8055','8056','8057','8058','8059','8060','8061','8062','8063','8064','8065','8066','8067','8068','8069','8070','8071','18585','18595','18596','18779','18780','18919','18920','18989','18990','18991','18992','18993','18994','18995','18996','18997','18998','19998','19999','20000','20001','20002','20003','20004','21610','21611','21612','21613','21614','21615','21616','21617','21618','21619','21620','21621','21622','21623','21624','21625','21626','21627','21628','21629','21630','21631','21632','21633','21634','21635','21636','21637','21638','21639','21640','21641','21642','21643','21644','21645','21646','21647','21648','21649','21650','21651','21652','21654','21655','21656','21657','21658','21659','21660','21661','21662','21663','21664','21665','24432','24472','24473','24474','24475','24476','24477','24478','24479','24480','24481','24482','24483','24484','24485','24486','24487','24488','24489','24490','24491','24492','24493','24494','24495','24496','24497','24498','24499','24500','24501','24502','24503','24504','24505','24506','24507','24508','24509','24510','24511','24512','24513','24514','24515','24516','24517','24518','24519','24520','24521','24522','24523','24524','24525','24526','24527','24528','24552','24553','26012','26013','26014','26015','26016','26017','26018','26019','26020','26021','26022','26023','26024','26025','26026','26027','26028','26176','26177','26178','26179','26517','26527','26528','26912','26914','26970','27912','27913','27937','27938','27939','27940','28122','28123','28124','28125','28281','28282','28283','28284','28285','28286','28287','28288','28289','28290','28419','28420','28678','28679','28680','28681','28682','28683','29951','29952','29953','29954','29955','29956','29957','29958','29959','29960','29981','29982','29986','29987','29988','29989','29990','29991','29992','29993','29994','29995','29996','29997','29998','29999','30000','30001','30002','30003','30004','30005','30006','30009','30010','30011','30012','30013','30014','30015','30018','30019','30020','30021','30022','30023','30024','30029','30030','30031','30032','30033','30034','30035','30040','30041','30042','30043','30044','30045','30046','30047','30048','30049','30050','30051','30052','30053','30054','30055','30056','30057','30058','30059','30060','30061','30062','30063','30064','30065','30066','30067','30068','30069','30070','30071','30072','30073','30074','30075','30076','30080','30081','30082','30083','30084','30085','30086','30224','30225','30226','30227','31494','31495','31923','33598','33599','33614','33615','33616','33617','45750','45991','46121','46650','46651','47138','47139','47140','47141','47142','47143','48019','49633','49634','50953','51326','57722','57723','57724','57725','57726','57727','57728','57729','57730','57731','57732','57733','57734','57735','62015','62016','62092') AND `class_id`='1'
SELECT name FROM prints_make WHERE `id`='52'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE `name_full` LIKE "Holden%" ORDER BY name_title
?page=###page###
SELECT COUNT(*) as `count` FROM brv_summary_cache WHERE `make_id`='52'
469
SELECT `id`, `name`, `full_name`, `sort_name`, `make_id`, `url`, `views`, `type` FROM brv_summary_cache WHERE `make_id`='52' ORDER BY `sort_name`, `type` LIMIT 0, 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`='52'
SELECT DISTINCT `purchase_id` FROM payment WHERE `status`='approved' AND `purchase_id` IN('672','682','866','867','1006','1007','1076','1077','1078','1079','1080','1081','1082','1083','1084','1085','2030','2031','2032','2033','2034','2035','2036','3642','3643','3644','3645','3646','3647','3648','3649','3650','3651','3652','3653','3654','3655','3656','3657','3658','3659','3660','3661','3662','3663','3664','3665','3666','3667','3668','3669','3670','3671','3672','3673','3674','3675','3676','3677','3678','3679','3680','3681','3682','3683','3684','3686','3687','3688','3689','3690','3691','3692','3693','3694','3695','3696','3697','6504','6544','6545','6546','6547','6548','6549','6550','6551','6552','6553','6554','6555','6556','6557','6558','6559','6560','6561','6562','6563','6564','6565','6566','6567','6568','6569','6570','6571','6572','6573','6574','6575','6576','6577','6578','6579','6580','6581','6582','6583','6584','6585','6586','6587','6588','6589','6590','6591','6592','6593','6594','6595','6596','6597','6598','6599','6600','6624','6625','8084','8085','8086','8087','8088','8089','8090','8091','8092','8093','8094','8095','8096','8097','8098','8099','8100','8248','8249','8250','8251','8589','8599','8600','8984','8986','9042','9984','9985','10009','10010','10011','10012','10194','10195','10196','10197','10353','10354','10355','10356','10357','10358','10359','10360','10361','10362','10491','10492','10750','10751','10752','10753','10754','10755','12024','12025','12026','12027','12028','12029','12030','12031','12032','12033','12054','12055','12059','12060','12061','12062','12063','12064','12065','12066','12067','12068','12069','12070','12071','12072','12073','12074','12075','12076','12077','12078','12079','12082','12083','12084','12085','12086','12087','12088','12091','12092','12093','12094','12095','12096','12097','12102','12103','12104','12105','12106','12107','12108','12113','12114','12115','12116','12117','12118','12119','12120','12122','12123','12124','12125','12126','12127','12128','12129','12130','12131','12132','12133','12134','12135','12136','12137','12139','12140','12141','12142','12143','12144','12145','12146','12147','12148','12149','12153','12154','12155','12156','12157','12158','12159','12298','12299','12300','12301','13570','13571','13999','15674','15675','15690','15691','15692','15693','27831','28085','28220','28733','28734','29209','29210','29211','29212','29213','29214','30059','31510','31850','31851','31928')
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 = 8099) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 8459) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
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 = 672) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 29572) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT vector_id FROM prints_set_vector WHERE `set_id`='29572'
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` IN('672','2032','2033','3675','3676','3677','3678','3679','3680','3681','3682','3683','3684','12059','12060','12061','12062','12063','12064','12065','12066','12069','12070','12073','12074','12082','12083','12092','12102','12103','12108','12116','12122','12144','12145','12153','12154','31850','31851') ORDER BY price LIMIT 0, 1
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 = 8099) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 8459) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
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 = 1006) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 798) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT vector_id FROM prints_set_vector WHERE `set_id`='798'
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` IN('866','867','1006','1007') ORDER BY price LIMIT 0, 1
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 = 1082) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 16494) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT vector_id FROM prints_set_vector WHERE `set_id`='16494'
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` IN('1076','1077','1078','1079','1080','1081','1082','1083','1084','1085','2030','2031','3651','3652','9984','9985','10009','10010','10011','10012','15674','15675','15690','15691','15692','15693') ORDER BY price LIMIT 0, 1
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 = 682) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 2220) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT vector_id FROM prints_set_vector WHERE `set_id`='2220'
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` IN('682','2034','2035','2036') ORDER BY price LIMIT 0, 1
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 = 12129) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 12230) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
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 = 6567) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 29316) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT vector_id FROM prints_set_vector WHERE `set_id`='29316'
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` IN('6565','6566','6567','6568','6569','6570','6571','6572','6573') ORDER BY price LIMIT 0, 1
SELECT `id`, `name`, `type` FROM nox_group