/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`='jaguar' 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`='68'
SELECT id, url, sort_name, full_name, views FROM prints_blueprint WHERE `item_id` IN('5155','5156','5157','5158','5159','5160','5161','5162','5163','5164','5165','5166','5167','5168','5169','5170','5171','5172','5173','5174','5175','5176','5177','5178','5179','5180','5181','5182','5183','9502','9503','9504','9505','9506','9507','9508','9509','9510','9511','9512','9513','9514','9515','9516','9517','9518','9519','9520','9521','9522','9523','9524','9525','9526','9527','9528','9529','9530','9531','12125','12126','12127','12128','12129','12707','13069','13070','13071','13072','13073','13074','13075','13076','13077','13297','13298','13299','13300','13301','13957','16217','16218','16219','16220','16221','16222','16223','16224','16225','16226','17539','17540','17541','17542','17987','18014','24683','24684','24685','24686','24687','24688','24689','24690','24691','24692','24693','24694','24695','24696','24697','24698','24699','24700','24701','24702','24706','24707','24708','24709','24712','24713','24714','24715','24716','24717','24718','24720','24721','24722','24723','24724','24725','24726','24727','24728','24729','24730','24731','24732','24733','24734','29899','29900','29901','29902','29903','29904','29905','29906','29907','29908','30498','30499','30500','45713','45735','45742','45881','45945','46207','46208','46209','46210','46939','46940','46941','47284','50743','58126','58127','58128','58129','58130','58131','58132','58133','58134','58135','58136','58137','58138','58139','58140','58141','58142','58143','58144','58145','58146','58147','58148','58149','58150','58151','58152','58153','58154','58155','58156','58157','58158','58159','58160','58161','58162','58163','58164','58165','58166','58167','58168','58169','58170','58171','58172','58173','58174','58175','58176','58177','58178','58179','58180','58181','58182','58183','58184','58185','58186','58187','58188','58189','58190','58191','58192','58193','58194','58195','58196','58197','58198','58199','58200','61972') AND `class_id`='1'
SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `item_id` IN('5155','5156','5157','5158','5159','5160','5161','5162','5163','5164','5165','5166','5167','5168','5169','5170','5171','5172','5173','5174','5175','5176','5177','5178','5179','5180','5181','5182','5183','9502','9503','9504','9505','9506','9507','9508','9509','9510','9511','9512','9513','9514','9515','9516','9517','9518','9519','9520','9521','9522','9523','9524','9525','9526','9527','9528','9529','9530','9531','12125','12126','12127','12128','12129','12707','13069','13070','13071','13072','13073','13074','13075','13076','13077','13297','13298','13299','13300','13301','13957','16217','16218','16219','16220','16221','16222','16223','16224','16225','16226','17539','17540','17541','17542','17987','18014','24683','24684','24685','24686','24687','24688','24689','24690','24691','24692','24693','24694','24695','24696','24697','24698','24699','24700','24701','24702','24706','24707','24708','24709','24712','24713','24714','24715','24716','24717','24718','24720','24721','24722','24723','24724','24725','24726','24727','24728','24729','24730','24731','24732','24733','24734','29899','29900','29901','29902','29903','29904','29905','29906','29907','29908','30498','30499','30500','45713','45735','45742','45881','45945','46207','46208','46209','46210','46939','46940','46941','47284','50743','58126','58127','58128','58129','58130','58131','58132','58133','58134','58135','58136','58137','58138','58139','58140','58141','58142','58143','58144','58145','58146','58147','58148','58149','58150','58151','58152','58153','58154','58155','58156','58157','58158','58159','58160','58161','58162','58163','58164','58165','58166','58167','58168','58169','58170','58171','58172','58173','58174','58175','58176','58177','58178','58179','58180','58181','58182','58183','58184','58185','58186','58187','58188','58189','58190','58191','58192','58193','58194','58195','58196','58197','58198','58199','58200','61972') AND `class_id`='1'
SELECT name FROM prints_make WHERE `id`='68'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE `name_full` LIKE "Jaguar%" ORDER BY name_title
?page=###page###
SELECT COUNT(*) as `count` FROM brv_summary_cache WHERE `make_id`='68'
329
SELECT `id`, `name`, `full_name`, `sort_name`, `make_id`, `url`, `views`, `type` FROM brv_summary_cache WHERE `make_id`='68' 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`='68'
SELECT DISTINCT `purchase_id` FROM payment WHERE `status`='approved' AND `purchase_id` IN('74','101','6755','6756','6757','6758','6759','6760','6761','6762','6763','6764','6765','6766','6767','6768','6769','6770','6771','6772','6773','6774','6778','6779','6780','6781','6784','6785','6786','6787','6788','6789','6790','6792','6793','6794','6795','6796','6797','6798','6799','6800','6801','6802','6803','6804','6805','6806','11972','11973','11974','11975','11976','11977','11978','11979','11980','11981','12573','12574','12575','27791','27813','27820','27972','28039','28304','28305','28306','28307','29020','29021','29022','29352','31307','31807')
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 = 11980) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 30606) 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`='30606'
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('11972','11973','11974','11975','11976','11977','11978','11979','11980','11981') 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 = 28039) 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`='28039' 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 = 6779) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 7177) 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 = 28307) 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`='28307' 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 = 27820) 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`='27820' 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 = 28306) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 30608) 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`='30608'
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('28304','28305','28306') ORDER BY price LIMIT 0, 1
SELECT `id`, `name`, `type` FROM nox_group