/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`='acura' 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`='2'
SELECT id, url, sort_name, full_name, views FROM prints_blueprint WHERE `item_id` IN('17','18','19','20','21','22','23','24','25','26','27','28','29','5222','5223','5224','5783','5784','5785','5786','5787','5788','8899','9018','12583','12584','12885','12886','12887','12888','12889','12890','15260','15261','15262','15263','15264','15265','17935','17936','17937','17938','17939','17940','17941','18955','19489','19495','19496','19498','19499','19500','19502','19504','19505','19511','19512','19777','19778','19779','19780','19781','19782','19783','19784','19785','19786','19787','19788','19789','19790','19791','19792','19830','19831','19962','19968','21939','22021','23476','23477','23478','23481','23482','23486','23487','23488','23490','23492','23512','23743','23744','23745','23746','23747','23748','23749','23750','23751','23752','23753','23754','24576','24577','33774','33775','33776','33777','33778','33779','33780','33781','33782','33783','33784','46205','46281','46289','46507','49219','51029','51030','51031','51032','51033','51034','51035','51036','51037','51039','51040','51041','51042','51043','51044','51045','51046','51047','51049','51050','51051','51052','51053','51054','51055','51056','51057','51058','51059','51060','51061','51062','51063','51064','51065','51066','51067','51068','51069','53956','53957','53958','53959','53960','53961','53962','53963','53964','53965','61919','61920','62118') AND `class_id`='1'
SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `item_id` IN('17','18','19','20','21','22','23','24','25','26','27','28','29','5222','5223','5224','5783','5784','5785','5786','5787','5788','8899','9018','12583','12584','12885','12886','12887','12888','12889','12890','15260','15261','15262','15263','15264','15265','17935','17936','17937','17938','17939','17940','17941','18955','19489','19495','19496','19498','19499','19500','19502','19504','19505','19511','19512','19777','19778','19779','19780','19781','19782','19783','19784','19785','19786','19787','19788','19789','19790','19791','19792','19830','19831','19962','19968','21939','22021','23476','23477','23478','23481','23482','23486','23487','23488','23490','23492','23512','23743','23744','23745','23746','23747','23748','23749','23750','23751','23752','23753','23754','24576','24577','33774','33775','33776','33777','33778','33779','33780','33781','33782','33783','33784','46205','46281','46289','46507','49219','51029','51030','51031','51032','51033','51034','51035','51036','51037','51039','51040','51041','51042','51043','51044','51045','51046','51047','51049','51050','51051','51052','51053','51054','51055','51056','51057','51058','51059','51060','51061','51062','51063','51064','51065','51066','51067','51068','51069','53956','53957','53958','53959','53960','53961','53962','53963','53964','53965','61919','61920','62118') AND `class_id`='1'
SELECT name FROM prints_make WHERE `id`='2'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE `name_full` LIKE "Acura%" ORDER BY name_title
?page=###page###
SELECT COUNT(*) as `count` FROM brv_summary_cache WHERE `make_id`='2'
171
SELECT `id`, `name`, `full_name`, `sort_name`, `make_id`, `url`, `views`, `type` FROM brv_summary_cache WHERE `make_id`='2' 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`='2'
SELECT `id`, `tag` FROM tag WHERE `id` IN('92','518','866')
SELECT DISTINCT `purchase_id` FROM payment WHERE `status`='approved' AND `purchase_id` IN('23','24','25','26','27','28','1042','1829','1830','1831','1832','1833','1834','1835','1836','1837','1838','1839','1840','1841','1842','1843','1844','5548','5549','5550','5553','5554','5558','5559','5560','5562','5564','5584','5815','5816','5817','5818','5819','5820','5821','5822','5823','5824','5825','5826','6648','6649','15852','15853','15854','15855','15856','15857','15858','15859','15860','15861','15862','28302')
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 = 1042) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 2139) 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`='2139'
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('1042') 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 = 25) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 34680) 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`='34680'
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('25','1836','1837','15856','15857','15860') 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 = 23) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 34965) 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`='34965'
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('23','1831','1832','1833','1834','1835','5584') 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 = 5821) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 6499) 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 = 24) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 2135) 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`='2135'
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('24','1829','1830') 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 = 27) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 4908) 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`='4908'
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('27','1843','1844') ORDER BY price LIMIT 0, 1
SELECT `id`, `name`, `type` FROM nox_group