/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`='lotus' 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`='83'
SELECT id, url, sort_name, full_name, views FROM prints_blueprint WHERE `item_id` IN('2976','2983','2986','3002','3006','3009','3012','3014','3016','3020','3023','3025','3028','3031','3036','3037','3039','3041','3044','3046','3048','3050','3054','3057','3059','3060','3061','3064','3066','3069','3071','3072','3073','3074','3075','3078','3079','3081','3082','3084','3086','3088','3092','3094','3097','3100','3102','3104','3107','3109','3110','10847','10848','10849','10850','10851','10852','10853','10854','10855','10856','10857','10858','10859','10860','10861','10862','10864','10865','10866','10867','10868','10869','10870','10871','10872','10873','10874','10875','10876','10877','10878','10879','10880','10881','10882','10883','10884','10885','10886','10887','10888','10889','10890','10891','10892','10893','10894','10895','10896','10897','10898','10899','10900','10901','10902','10903','10904','10905','10906','10907','10908','10909','10910','10911','10912','10913','10914','10915','10916','10917','10918','11012','11013','11014','11016','12008','12130','12131','12132','12133','12134','12135','12136','12137','12138','12139','12140','12141','12142','12143','12144','12145','12146','12147','12148','12149','12150','12151','12152','12153','12154','12155','12156','12157','12158','12159','12160','12161','12162','12713','13312','13313','13971','13972','13973','13974','13975','15328','16264','16265','16266','16267','16268','16269','17168','17169','17170','17171','17172','17173','17443','17444','17578','17579','17580','17581','17582','17583','17584','17585','17586','17587','17588','17589','17590','17908','18536','22028','22107','24854','24855','24856','24857','24858','24859','24860','24861','24862','26938','26939','30814','45711','46040','46082','46203','46211','46813','48703','48704','50933','50934','50935','50937','50938','50939','58484','58485','58486','58487','58488','58489','58492','58493','58494','58495','58496','58497','58498','58499','58500','58501','58502','58503','58504','58505','58506','58507','58508','58509','58510','58511','58512','58513','58514','58515','58516','58517','58518','58519','58520','58521','58522','58523','58524','58525','58526','58527','58528','58529','58530','58531','58532','58533','58534','58535','58536','58537','58538','58539','58540','58541','58542','58543','58544','58545','58546','58547','58548','58549','58550','58551','58552','58553','58554','58555','58556','58557','58558','58559','58560','58561') AND `class_id`='1'
SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `item_id` IN('2976','2983','2986','3002','3006','3009','3012','3014','3016','3020','3023','3025','3028','3031','3036','3037','3039','3041','3044','3046','3048','3050','3054','3057','3059','3060','3061','3064','3066','3069','3071','3072','3073','3074','3075','3078','3079','3081','3082','3084','3086','3088','3092','3094','3097','3100','3102','3104','3107','3109','3110','10847','10848','10849','10850','10851','10852','10853','10854','10855','10856','10857','10858','10859','10860','10861','10862','10864','10865','10866','10867','10868','10869','10870','10871','10872','10873','10874','10875','10876','10877','10878','10879','10880','10881','10882','10883','10884','10885','10886','10887','10888','10889','10890','10891','10892','10893','10894','10895','10896','10897','10898','10899','10900','10901','10902','10903','10904','10905','10906','10907','10908','10909','10910','10911','10912','10913','10914','10915','10916','10917','10918','11012','11013','11014','11016','12008','12130','12131','12132','12133','12134','12135','12136','12137','12138','12139','12140','12141','12142','12143','12144','12145','12146','12147','12148','12149','12150','12151','12152','12153','12154','12155','12156','12157','12158','12159','12160','12161','12162','12713','13312','13313','13971','13972','13973','13974','13975','15328','16264','16265','16266','16267','16268','16269','17168','17169','17170','17171','17172','17173','17443','17444','17578','17579','17580','17581','17582','17583','17584','17585','17586','17587','17588','17589','17590','17908','18536','22028','22107','24854','24855','24856','24857','24858','24859','24860','24861','24862','26938','26939','30814','45711','46040','46082','46203','46211','46813','48703','48704','50933','50934','50935','50937','50938','50939','58484','58485','58486','58487','58488','58489','58492','58493','58494','58495','58496','58497','58498','58499','58500','58501','58502','58503','58504','58505','58506','58507','58508','58509','58510','58511','58512','58513','58514','58515','58516','58517','58518','58519','58520','58521','58522','58523','58524','58525','58526','58527','58528','58529','58530','58531','58532','58533','58534','58535','58536','58537','58538','58539','58540','58541','58542','58543','58544','58545','58546','58547','58548','58549','58550','58551','58552','58553','58554','58555','58556','58557','58558','58559','58560','58561') AND `class_id`='1'
SELECT name FROM prints_make WHERE `id`='83'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE `name_full` LIKE "Lotus%" ORDER BY name_title
?page=###page###
SELECT COUNT(*) as `count` FROM brv_summary_cache WHERE `make_id`='83'
456
SELECT `id`, `name`, `full_name`, `sort_name`, `make_id`, `url`, `views`, `type` FROM brv_summary_cache WHERE `make_id`='83' 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`='83'
SELECT DISTINCT `purchase_id` FROM payment WHERE `status`='approved' AND `purchase_id` IN('623','4083','4168','6926','6927','6928','6929','6930','6931','6932','6933','6934','9010','9011','12890','27789','28135','28181','28300','28308','28896','30723','30724','31490','31491','31492','31494','31495','31496')
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 = 623) 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`='623'
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 = 28300) 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`='28300'
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('4083','4168','6926','6927','6928','6929','6930','6931','6932','6933','6934','9010','9011','12890','27789','28135','28181','28308','28896','30723','30724','31490','31491','31492','31494','31495','31496')
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('4083','4168','6926','6927','6928','6929','6930','6931','6932','6933','6934','9010','9011','12890','27789','28135','28181','28308','28896','30723','30724','31490','31491','31492','31494','31495','31496')
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 = 6929) 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`='6929'
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 = 4083) 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`='4083'
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 = 28135) 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`='28135'
SELECT `id`, `name`, `type` FROM nox_group