/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`='audi' 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`='11'
SELECT id, url, sort_name, full_name, views FROM prints_blueprint WHERE `item_id` IN('201','202','203','204','205','206','207','208','209','210','211','212','213','214','215','216','217','218','219','220','221','222','223','224','225','226','227','228','229','230','231','232','233','234','235','236','237','238','239','240','241','242','243','244','245','246','247','248','249','250','251','252','253','254','255','256','257','258','259','260','261','262','263','264','265','266','267','268','269','270','271','272','273','274','275','276','277','278','279','280','281','282','283','284','285','286','287','288','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','6601','6602','6603','6604','6605','6606','6607','6608','6609','6610','6611','6612','6613','6614','6615','6616','6617','6618','6619','6620','6621','6622','6623','6624','6625','6626','6627','6628','6629','6630','6631','6632','6633','6634','6635','6636','6637','6638','6639','6640','6641','6642','6643','6644','6645','6646','6647','6648','6649','6650','6651','6652','6653','6654','6655','6656','6657','6658','6659','6660','6661','6662','6663','6664','6665','6666','6668','6669','6670','8009','8010','9038','9039','10482','10483','10484','10485','10486','10487','10488','10489','10490','10491','10492','10493','12787','12788','12789','12791','12897','12898','12899','13219','13220','13819','13820','13821','13822','13823','13824','16077','16078','16079','16393','16394','16395','16396','16397','16399','16400','16401','16402','16403','16404','16405','16406','17261','17262','17263','17264','17265','17266','17267','17268','17269','17270','17271','17322','17944','17945','17946','17947','17948','17949','17950','17951','17952','17953','17954','17955','17956','17957','17958','18813','19044','19552','19553','19554','19555','19556','19557','19558','19559','19560','19561','19562','19563','19564','19565','19566','19567','19568','19569','19570','19571','19572','19573','19574','19575','19576','19577','19578','19579','19580','19581','19582','19583','19584','19585','19586','19587','19588','19589','19590','19794','19795','19796','19797','19798','19799','19800','19801','19802','19803','19804','19805','19806','19807','19808','19809','19810','19811','19812','19813','19814','19815','19816','19817','19818','19819','19820','19821','19822','19823','19824','19825','19826','19827','19828','19829','19832','19833','19834','19835','19836','19837','19838','19839','19840','19841','19842','21007','21008','21009','21010','21011','21012','21013','21014','21015','21016','21017','21018','21019','21020','21021','21022','21023','21024','21025','21026','21027','21028','21029','21030','21031','21032','21033','21034','21035','21036','21037','21038','21039','21040','21041','21042','21043','21044','21045','21046','21047','21048','21049','21050','21051','21052','21053','21054','21055','21056','21057','21969','21972','21981','21982','23021','23022','23023','23024','23025','23026','23027','23028','23029','23030','23031','23032','23033','23034','23035','23036','23037','23038','23039','23040','23041','23042','23043','23044','23045','23046','23047','23048','23049','23050','23051','23052','23053','23054','23055','23056','23057','23058','23059','23060','23061','23062','23063','23064','23065','23066','23067','23068','23069','23070','23071','23072','23073','23074','23075','23076','23077','33645','33646','33647','33648','33649','33650','33651','33652','33653','33654','33655','33656','33657','33658','33659','33660','33661','33662','33663','33664','33665','33666','33667','33668','33669','33670','33671','33672','33673','33674','33675','33676','33677','33678','33679','33680','33681','33682','33683','33684','33685','33686','33687','33688','33689','33690','33691','33692','33693','33694','33695','33696','33697','33698','33699','33700','33701','33702','33703','33704','33705','33706','33707','45946','45983','46280','48259','51093','51094','51095','51096','51097','51098','51099','51100','54257','54258','54259','54260','54261','54262','54263','54264','54265','54266','54267','54268','54269','54270','54271','54272','54273','54274','54275','54276','54277','54278','54279','54280','54281','54282','54283','54284','54285','54286','54287','54288','54289','54290','54291','54292','54293','54294','54295','54296','54297','54298','54299','54300','54301','54302','54303','54304','54305','54306','54307','54308','54309','54310','54311','54312','54313','54314','54315','54316','54317','54318','54319','54320','54321','54322','54323','54324','54325','54326','54327','54328','54329','54330','54331','54332','54333','54334','54335','54336','54337','54338','54339','54340','54341','54342','54343','54344','54345','54346','54347','54348','54349','54350','54351','54352','54353','54354','54355','54356','54357','54358','54359','54360','54361','54362','54363','54364','54365','54366','54367','54368','54369','54370','54371','54372','54373','54374','54375','54376','54377','54378','54379','54380','54381','54382','54383','54384','54385','54386','54387','54388','54389','54390','54391','54392','54393','54394','54395','54396','54397','54398','54399','54400','54401','54402','54403','54404','54405','54406','54407','54408','54409','54410','54411','54412','54413','54414','54415','54416','54417','54418','54419','54420','54421','54422','54423','54424','54425','54426','54427','54428','54429','54430','54431','54432','54433','54434','54435','54436','54437','54438','54439','54440','54441','54442','54443','54444','54445','54446','54447','54448','54449','54450','54451','54452','54453','54454','54455','54456','54457','54458','54459','54460','54461','54462','54463','54464','54465','54466','54467','62106') AND `class_id`='1'
SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `item_id` IN('201','202','203','204','205','206','207','208','209','210','211','212','213','214','215','216','217','218','219','220','221','222','223','224','225','226','227','228','229','230','231','232','233','234','235','236','237','238','239','240','241','242','243','244','245','246','247','248','249','250','251','252','253','254','255','256','257','258','259','260','261','262','263','264','265','266','267','268','269','270','271','272','273','274','275','276','277','278','279','280','281','282','283','284','285','286','287','288','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','6601','6602','6603','6604','6605','6606','6607','6608','6609','6610','6611','6612','6613','6614','6615','6616','6617','6618','6619','6620','6621','6622','6623','6624','6625','6626','6627','6628','6629','6630','6631','6632','6633','6634','6635','6636','6637','6638','6639','6640','6641','6642','6643','6644','6645','6646','6647','6648','6649','6650','6651','6652','6653','6654','6655','6656','6657','6658','6659','6660','6661','6662','6663','6664','6665','6666','6668','6669','6670','8009','8010','9038','9039','10482','10483','10484','10485','10486','10487','10488','10489','10490','10491','10492','10493','12787','12788','12789','12791','12897','12898','12899','13219','13220','13819','13820','13821','13822','13823','13824','16077','16078','16079','16393','16394','16395','16396','16397','16399','16400','16401','16402','16403','16404','16405','16406','17261','17262','17263','17264','17265','17266','17267','17268','17269','17270','17271','17322','17944','17945','17946','17947','17948','17949','17950','17951','17952','17953','17954','17955','17956','17957','17958','18813','19044','19552','19553','19554','19555','19556','19557','19558','19559','19560','19561','19562','19563','19564','19565','19566','19567','19568','19569','19570','19571','19572','19573','19574','19575','19576','19577','19578','19579','19580','19581','19582','19583','19584','19585','19586','19587','19588','19589','19590','19794','19795','19796','19797','19798','19799','19800','19801','19802','19803','19804','19805','19806','19807','19808','19809','19810','19811','19812','19813','19814','19815','19816','19817','19818','19819','19820','19821','19822','19823','19824','19825','19826','19827','19828','19829','19832','19833','19834','19835','19836','19837','19838','19839','19840','19841','19842','21007','21008','21009','21010','21011','21012','21013','21014','21015','21016','21017','21018','21019','21020','21021','21022','21023','21024','21025','21026','21027','21028','21029','21030','21031','21032','21033','21034','21035','21036','21037','21038','21039','21040','21041','21042','21043','21044','21045','21046','21047','21048','21049','21050','21051','21052','21053','21054','21055','21056','21057','21969','21972','21981','21982','23021','23022','23023','23024','23025','23026','23027','23028','23029','23030','23031','23032','23033','23034','23035','23036','23037','23038','23039','23040','23041','23042','23043','23044','23045','23046','23047','23048','23049','23050','23051','23052','23053','23054','23055','23056','23057','23058','23059','23060','23061','23062','23063','23064','23065','23066','23067','23068','23069','23070','23071','23072','23073','23074','23075','23076','23077','33645','33646','33647','33648','33649','33650','33651','33652','33653','33654','33655','33656','33657','33658','33659','33660','33661','33662','33663','33664','33665','33666','33667','33668','33669','33670','33671','33672','33673','33674','33675','33676','33677','33678','33679','33680','33681','33682','33683','33684','33685','33686','33687','33688','33689','33690','33691','33692','33693','33694','33695','33696','33697','33698','33699','33700','33701','33702','33703','33704','33705','33706','33707','45946','45983','46280','48259','51093','51094','51095','51096','51097','51098','51099','51100','54257','54258','54259','54260','54261','54262','54263','54264','54265','54266','54267','54268','54269','54270','54271','54272','54273','54274','54275','54276','54277','54278','54279','54280','54281','54282','54283','54284','54285','54286','54287','54288','54289','54290','54291','54292','54293','54294','54295','54296','54297','54298','54299','54300','54301','54302','54303','54304','54305','54306','54307','54308','54309','54310','54311','54312','54313','54314','54315','54316','54317','54318','54319','54320','54321','54322','54323','54324','54325','54326','54327','54328','54329','54330','54331','54332','54333','54334','54335','54336','54337','54338','54339','54340','54341','54342','54343','54344','54345','54346','54347','54348','54349','54350','54351','54352','54353','54354','54355','54356','54357','54358','54359','54360','54361','54362','54363','54364','54365','54366','54367','54368','54369','54370','54371','54372','54373','54374','54375','54376','54377','54378','54379','54380','54381','54382','54383','54384','54385','54386','54387','54388','54389','54390','54391','54392','54393','54394','54395','54396','54397','54398','54399','54400','54401','54402','54403','54404','54405','54406','54407','54408','54409','54410','54411','54412','54413','54414','54415','54416','54417','54418','54419','54420','54421','54422','54423','54424','54425','54426','54427','54428','54429','54430','54431','54432','54433','54434','54435','54436','54437','54438','54439','54440','54441','54442','54443','54444','54445','54446','54447','54448','54449','54450','54451','54452','54453','54454','54455','54456','54457','54458','54459','54460','54461','54462','54463','54464','54465','54466','54467','62106') AND `class_id`='1'
SELECT name FROM prints_make WHERE `id`='11'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE `name_full` LIKE "Audi%" ORDER BY name_title
?page=###page###
SELECT COUNT(*) as `count` FROM brv_summary_cache WHERE `make_id`='11'
992
SELECT `id`, `name`, `full_name`, `sort_name`, `make_id`, `url`, `views`, `type` FROM brv_summary_cache WHERE `make_id`='11' ORDER BY `sort_name`, `type` LIMIT 200, 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`='11'
SELECT DISTINCT `purchase_id` FROM payment WHERE `status`='approved' AND `purchase_id` IN('31','32','33','34','35','36','37','38','39','40','41','42','43','44','45','900','1132','1604','1605','1606','1607','1608','1609','1610','1611','1612','1613','1614','1615','1616','1617','1618','1619','1620','1621','1622','1623','1624','1625','1626','1627','1628','1629','1630','1631','1632','1633','1634','1635','1636','1637','1638','1639','1640','1641','1642','1846','1847','1848','1849','1850','1851','1852','1853','1854','1855','1856','1857','1858','1859','1860','1861','1862','1863','1864','1865','1866','1867','1868','1869','1870','1871','1872','1873','1874','1875','1876','1877','1878','1879','1880','1883','1884','1885','1886','1887','1888','1889','1890','1891','1892','1893','3039','3040','3041','3042','3043','3044','3045','3046','3047','3048','3049','3050','3051','3052','3053','3054','3055','3056','3057','3058','3059','3060','3061','3062','3063','3064','3065','3066','3067','3068','3069','3070','3071','3072','3073','3074','3075','3076','3077','3078','3079','3080','3081','3082','3083','3084','3085','3086','3087','3088','3089','4017','4020','5090','5091','5093','5094','5095','5096','5097','5098','5099','5100','5101','5102','5103','5104','5105','5106','5107','5108','5109','5110','5112','5113','5114','5115','5116','5117','5118','5119','5120','5121','5122','5123','5124','5125','5126','5127','5128','5129','5130','5131','5132','5133','5134','5135','5136','5137','5138','5139','5140','5141','5142','5143','5144','5145','5146','15721','15722','15723','15724','15725','15726','15727','15728','15729','15730','15731','15732','15733','15734','15735','15736','15737','15738','15739','15740','15741','15742','15743','15744','15745','15746','15747','15748','15749','15750','15751','15752','15753','15754','15755','15756','15757','15758','15759','15760','15761','15762','15763','15764','15765','15766','15767','15768','15769','15770','15771','15772','15773','15774','15775','15776','15777','15778','15779','15780','15781','15782','15783','28040','28077','30288','31942')
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 = 1869) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 33531) 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`='33531'
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('41','1869','1870','1871','1872','1873','1874','1875','1876','1877','1878','1879','5124','5125') 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 = 1132) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 5882) 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`='5882'
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('900','1132','1888','1889','1890','1891','1892','1893') 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 = 3050) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 31569) 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 = 3057) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 31790) 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`='31790'
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('3053','3054','3055','3056','3057','3058','3059','3060','3061') 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 = 3074) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 33962) 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`='33962'
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('3074','3075','3076','3077','3078') 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 = 1885) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 29209) 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`='29209'
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('43','1884','1885') ORDER BY price LIMIT 0, 1
SELECT `id`, `name`, `type` FROM nox_group