/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`='bmw' 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`='17'
SELECT id, url, sort_name, full_name, views FROM prints_blueprint WHERE `item_id` IN('347','348','349','350','351','352','353','354','355','356','357','358','359','360','361','362','363','364','365','366','367','368','369','370','371','372','373','374','375','376','377','378','379','380','381','382','383','384','385','386','387','388','389','390','391','392','393','394','395','396','397','398','399','400','401','402','403','404','405','406','407','408','409','410','411','412','413','414','415','416','417','418','419','420','421','422','423','424','425','426','427','428','429','430','431','432','433','434','435','436','437','438','439','440','441','442','443','444','445','446','447','448','449','450','451','452','453','454','455','456','457','458','459','460','461','462','463','464','465','466','467','468','469','470','471','472','473','474','475','476','477','478','479','480','481','482','483','484','485','486','487','488','489','490','491','492','493','494','495','496','497','498','499','500','501','502','5842','6675','6676','6677','6678','6679','6680','6681','6682','6683','6684','6685','6686','6687','6688','6689','6690','6691','6692','6693','6694','6695','6696','6697','6698','6699','6700','6701','6702','6703','6704','6705','6706','6707','6708','6709','6710','6711','6712','6713','6714','6715','6716','6717','6718','6719','6720','6721','6722','6723','6724','6725','6726','6727','6728','6729','6730','6731','6732','6733','6734','6735','6736','6737','6738','6739','6740','6741','6742','6743','6744','6745','6746','6747','6748','6749','6750','6751','6752','6753','6754','6755','6756','6757','6758','6759','6760','6761','6762','6763','6764','6765','6766','6767','6768','6769','6770','6771','6772','6773','6774','6775','6776','6777','6778','6779','6780','6781','6782','6783','6784','6785','6786','6787','6788','6789','6790','6791','6792','6793','6794','6795','6796','6797','6798','6799','6800','6801','6802','6803','6804','6805','6806','6807','6808','6809','6810','6811','6812','6813','6814','6818','6982','8014','8015','8016','8017','8018','8904','8905','8906','8907','8908','8909','9040','9041','9042','9043','9044','9045','9046','9047','9048','9049','9050','9051','9052','10942','11117','11172','12594','12595','12596','12597','12598','12599','12600','12601','12602','12603','12604','12605','12606','12607','12608','12765','12921','12922','12923','12924','12925','13225','13226','13227','13228','13229','13230','13231','13232','13233','13760','13761','13802','13830','13831','13832','13833','13834','13835','14210','15303','15656','16086','16087','16088','16089','16090','16091','16092','16093','16094','16095','16096','16097','16098','17296','17297','17298','17299','17300','17301','17302','17303','17304','17305','17306','17307','17308','17324','17924','17925','17926','17927','17928','17929','17930','17931','17932','17933','17963','18225','18226','18821','19030','19031','19591','19592','19593','19594','19595','19596','19597','19598','19599','19600','19601','19602','19603','19604','19605','19606','19607','19608','19609','19610','19611','19612','19613','19614','19615','19616','19617','19618','19619','19620','19621','19622','19623','19624','19625','19626','19627','19628','19629','19630','19631','19632','19633','19634','19635','19636','19637','19638','19639','19640','19641','19642','19643','19644','19645','19646','19647','19648','19649','19650','19651','19652','19653','19654','19655','19656','19657','19658','19659','19660','19661','19849','19850','19851','19852','19853','19854','19855','19856','19857','19858','19859','19860','19861','19862','19863','19864','19865','19866','19867','19868','19869','19870','19871','19872','19873','19874','19875','19876','19877','19966','21001','21002','21003','21004','21005','21006','21669','21670','21671','21975','22051','22125','23078','23079','23080','23081','23082','23083','23084','23085','23086','23087','23088','23089','23090','23091','23092','23093','23094','23095','23096','23097','23098','23099','23100','23101','23102','23103','23104','23105','23106','23107','23108','23109','23110','23111','23112','23113','23114','23115','23116','23117','23118','23119','23120','23121','23122','23123','23124','23125','23126','23127','23128','23129','23130','23131','23132','23133','23134','23135','23136','23137','23138','23139','23140','23141','23142','45738','45821','46026','46193','46823','48035','48238','48239','50678','54603','54604','54605','54606','54607','54608','54609','54610','54611','54612','54613','54614','54615','54616','54617','54618','54619','54620','54621','54622','54623','54624','54625','54626','54627','54628','54629','54630','54631','54632','54633','54634','54635','54636','54637','54638','54639','54640','54641','54642','54643','54644','54645','54646','54647','54648','54649','54650','54651','54652','54653','54654','54655','54656','54657','54658','54659','54660','54661','54662','54663','54664','54665','54666','54667','54668','54669','54670','54671','54672','54673','54674','54675','54676','54677','54678','54679','54680','54681','54682','54683','54684','54685','54686','54687','54688','54689','54690','54691','54692','54693','54694','54695','54696','54697','54698','54699','54700','54701','54702','54703','54704','54705','54706','54707','54708','54709','54710','54711','54712','54713','54714','54715','54716','54717','54718','54719','54720','54721','54722','54723','54724','54725','54726','54727','54728','54729','54730','54731','54732','54733','54734','54735','54736','54737','54738','54739','54740','54741','54742','54743','54744','54745','54746','54747','54748','54749','54750','54751','54752','54753','54754','54755','54756','54757','54758','54759','54760','54761','54762','54763','54764','54765','54766','54767','54768','54769','54770','54771','54772','54773','54774','54775','54776','54777','54778','54779','54780','54781','54782','54783','54784','54785','54786','54787','54788','54789','54790','54791','54792','54793','54794','54795','54796','54797','54798','54799','54800','54801','54802','54803','54804','54805','54806','54807','54808','54809','54810','54811','54812','54813','54814','54815','54816','54817','54818','54819','54820','54821','54822','54823','54824','54825','54826','54827','54828','54829','54830','54831','54832','54833','54834','54835','54836','54837','54838','54839','54840','54841','54842','54843','54844','54845','54846','54847','54848','54849','54850','54851','54852','54853') AND `class_id`='1'
SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `item_id` IN('347','348','349','350','351','352','353','354','355','356','357','358','359','360','361','362','363','364','365','366','367','368','369','370','371','372','373','374','375','376','377','378','379','380','381','382','383','384','385','386','387','388','389','390','391','392','393','394','395','396','397','398','399','400','401','402','403','404','405','406','407','408','409','410','411','412','413','414','415','416','417','418','419','420','421','422','423','424','425','426','427','428','429','430','431','432','433','434','435','436','437','438','439','440','441','442','443','444','445','446','447','448','449','450','451','452','453','454','455','456','457','458','459','460','461','462','463','464','465','466','467','468','469','470','471','472','473','474','475','476','477','478','479','480','481','482','483','484','485','486','487','488','489','490','491','492','493','494','495','496','497','498','499','500','501','502','5842','6675','6676','6677','6678','6679','6680','6681','6682','6683','6684','6685','6686','6687','6688','6689','6690','6691','6692','6693','6694','6695','6696','6697','6698','6699','6700','6701','6702','6703','6704','6705','6706','6707','6708','6709','6710','6711','6712','6713','6714','6715','6716','6717','6718','6719','6720','6721','6722','6723','6724','6725','6726','6727','6728','6729','6730','6731','6732','6733','6734','6735','6736','6737','6738','6739','6740','6741','6742','6743','6744','6745','6746','6747','6748','6749','6750','6751','6752','6753','6754','6755','6756','6757','6758','6759','6760','6761','6762','6763','6764','6765','6766','6767','6768','6769','6770','6771','6772','6773','6774','6775','6776','6777','6778','6779','6780','6781','6782','6783','6784','6785','6786','6787','6788','6789','6790','6791','6792','6793','6794','6795','6796','6797','6798','6799','6800','6801','6802','6803','6804','6805','6806','6807','6808','6809','6810','6811','6812','6813','6814','6818','6982','8014','8015','8016','8017','8018','8904','8905','8906','8907','8908','8909','9040','9041','9042','9043','9044','9045','9046','9047','9048','9049','9050','9051','9052','10942','11117','11172','12594','12595','12596','12597','12598','12599','12600','12601','12602','12603','12604','12605','12606','12607','12608','12765','12921','12922','12923','12924','12925','13225','13226','13227','13228','13229','13230','13231','13232','13233','13760','13761','13802','13830','13831','13832','13833','13834','13835','14210','15303','15656','16086','16087','16088','16089','16090','16091','16092','16093','16094','16095','16096','16097','16098','17296','17297','17298','17299','17300','17301','17302','17303','17304','17305','17306','17307','17308','17324','17924','17925','17926','17927','17928','17929','17930','17931','17932','17933','17963','18225','18226','18821','19030','19031','19591','19592','19593','19594','19595','19596','19597','19598','19599','19600','19601','19602','19603','19604','19605','19606','19607','19608','19609','19610','19611','19612','19613','19614','19615','19616','19617','19618','19619','19620','19621','19622','19623','19624','19625','19626','19627','19628','19629','19630','19631','19632','19633','19634','19635','19636','19637','19638','19639','19640','19641','19642','19643','19644','19645','19646','19647','19648','19649','19650','19651','19652','19653','19654','19655','19656','19657','19658','19659','19660','19661','19849','19850','19851','19852','19853','19854','19855','19856','19857','19858','19859','19860','19861','19862','19863','19864','19865','19866','19867','19868','19869','19870','19871','19872','19873','19874','19875','19876','19877','19966','21001','21002','21003','21004','21005','21006','21669','21670','21671','21975','22051','22125','23078','23079','23080','23081','23082','23083','23084','23085','23086','23087','23088','23089','23090','23091','23092','23093','23094','23095','23096','23097','23098','23099','23100','23101','23102','23103','23104','23105','23106','23107','23108','23109','23110','23111','23112','23113','23114','23115','23116','23117','23118','23119','23120','23121','23122','23123','23124','23125','23126','23127','23128','23129','23130','23131','23132','23133','23134','23135','23136','23137','23138','23139','23140','23141','23142','45738','45821','46026','46193','46823','48035','48238','48239','50678','54603','54604','54605','54606','54607','54608','54609','54610','54611','54612','54613','54614','54615','54616','54617','54618','54619','54620','54621','54622','54623','54624','54625','54626','54627','54628','54629','54630','54631','54632','54633','54634','54635','54636','54637','54638','54639','54640','54641','54642','54643','54644','54645','54646','54647','54648','54649','54650','54651','54652','54653','54654','54655','54656','54657','54658','54659','54660','54661','54662','54663','54664','54665','54666','54667','54668','54669','54670','54671','54672','54673','54674','54675','54676','54677','54678','54679','54680','54681','54682','54683','54684','54685','54686','54687','54688','54689','54690','54691','54692','54693','54694','54695','54696','54697','54698','54699','54700','54701','54702','54703','54704','54705','54706','54707','54708','54709','54710','54711','54712','54713','54714','54715','54716','54717','54718','54719','54720','54721','54722','54723','54724','54725','54726','54727','54728','54729','54730','54731','54732','54733','54734','54735','54736','54737','54738','54739','54740','54741','54742','54743','54744','54745','54746','54747','54748','54749','54750','54751','54752','54753','54754','54755','54756','54757','54758','54759','54760','54761','54762','54763','54764','54765','54766','54767','54768','54769','54770','54771','54772','54773','54774','54775','54776','54777','54778','54779','54780','54781','54782','54783','54784','54785','54786','54787','54788','54789','54790','54791','54792','54793','54794','54795','54796','54797','54798','54799','54800','54801','54802','54803','54804','54805','54806','54807','54808','54809','54810','54811','54812','54813','54814','54815','54816','54817','54818','54819','54820','54821','54822','54823','54824','54825','54826','54827','54828','54829','54830','54831','54832','54833','54834','54835','54836','54837','54838','54839','54840','54841','54842','54843','54844','54845','54846','54847','54848','54849','54850','54851','54852','54853') AND `class_id`='1'
SELECT name FROM prints_make WHERE `id`='17'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE `name_full` LIKE "BMW%" ORDER BY name_title
?page=###page###
SELECT COUNT(*) as `count` FROM brv_summary_cache WHERE `make_id`='17'
1205
SELECT `id`, `name`, `full_name`, `sort_name`, `make_id`, `url`, `views`, `type` FROM brv_summary_cache WHERE `make_id`='17' ORDER BY `sort_name`, `type` LIMIT 1000, 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`='17'
SELECT `id`, `tag` FROM tag WHERE `id` IN('141','142')
SELECT DISTINCT `purchase_id` FROM payment WHERE `status`='approved' AND `purchase_id` IN('12','13','14','15','16','17','18','19','20','21','50','312','908','1118','1119','1643','1644','1645','1646','1647','1648','1649','1650','1651','1652','1653','1654','1655','1656','1657','1658','1659','1660','1661','1662','1663','1664','1665','1666','1667','1668','1669','1670','1671','1672','1673','1674','1675','1676','1677','1678','1679','1680','1681','1682','1683','1684','1685','1686','1687','1688','1689','1690','1691','1692','1693','1694','1695','1696','1697','1698','1699','1700','1701','1702','1703','1704','1705','1706','1707','1708','1709','1710','1711','1712','1713','1900','1901','1902','1903','1904','1905','1906','1907','1908','1909','1910','1911','1912','1913','1914','1915','1916','1917','1918','1919','1920','1921','1922','1923','1924','1925','1926','1927','1928','1999','3033','3034','3035','3036','3037','3038','3701','3702','3703','4023','4109','4188','5147','5148','5149','5150','5151','5152','5153','5154','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','5184','5185','5186','5187','5188','5189','5190','5191','5192','5193','5194','5195','5196','5197','5198','5199','5200','5201','5202','5203','5204','5205','5206','5207','5208','5209','5210','5211','27816','27908','28120','28290','28906','30075','30267','30268','31242')
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 = 27816) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 35373) 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`='35373'
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('1693','1694','1695','1696','1697','1698','1999','3701','3702','3703','5185','27816','30267','30268') 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 = 13) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 6007) 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`='6007'
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('13','908','1118','1119','1643','1644','1647','1648','1649','1650','1652','1653','5183') 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 = 17) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 29211) 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`='29211'
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('17','1699','1700') 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 = 16) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 34302) 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`='34302'
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('16','1668','1681','1682','1683','1684','1685','1686','1687','1688','1689','1690','5176','5177','5178') 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 = 1118) ORDER BY name_title
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 = 1645) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 5921) 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 = 14) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 31349) 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`='31349'
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('14','312','1900','1901','1902','1903','1904','1905','1906','1907','1908','1909','1910','1911','1912','1913','1914','1915','4188','5168','5169','5170','5171','5172','5173') ORDER BY price LIMIT 0, 1
SELECT `id`, `name`, `type` FROM nox_group
-SUV-blueprint-preview208.png)
-Sedan-Long-blueprint-preview208.png)
