/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`='buick' 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`='22'
SELECT id, url, sort_name, full_name, views FROM prints_blueprint WHERE `item_id` IN('544','545','546','547','548','549','550','551','552','553','554','555','556','557','558','559','560','561','562','563','564','565','566','567','568','569','570','571','572','573','574','575','576','577','578','579','580','581','582','583','584','585','586','587','588','589','590','591','592','593','594','595','596','597','598','599','600','601','602','603','604','605','606','607','608','609','610','611','612','613','614','615','616','617','618','619','620','621','622','623','624','625','626','627','628','629','630','631','632','633','634','635','636','637','638','639','640','641','642','643','644','645','646','647','648','649','650','651','652','653','654','655','656','657','658','659','660','661','662','663','664','665','666','667','668','669','670','671','672','10715','10716','10717','10718','10719','10720','10721','10722','10723','10724','10725','10726','10727','10728','10729','10730','10731','10732','10733','10734','10735','10736','10737','10738','10739','10740','10741','10742','10743','10744','10745','10746','10747','10748','10749','10750','10751','10752','10753','10754','10755','10756','10757','10758','10759','10760','10761','10762','10763','10764','10765','10766','12610','12611','12928','13237','13841','13842','16101','16102','16103','16104','17202','17209','17328','17329','17967','17968','17969','17970','17971','18228','19663','19664','19878','19879','19880','19881','19882','19883','19884','21653','23838','23839','23840','23841','23842','23843','23844','23845','23846','23847','23848','23849','23850','23851','23852','23853','23854','23855','23856','23857','23858','23859','23860','23861','23862','23863','23864','23865','23867','23868','23869','23870','23871','23872','23873','23874','23875','23876','23878','23879','23880','25976','25977','25978','25979','26913','26918','26919','26927','29961','29963','29964','29978','29979','29980','30087','30088','30089','30090','30091','30092','30912','30913','30914','30915','30916','30917','30918','30919','30920','30921','30922','30923','30924','30925','30926','30927','30928','30929','30930','30931','30932','30933','30934','30935','30936','30937','30938','30939','30940','30941','30942','30943','30944','30945','30946','30947','30948','30949','30950','30951','30952','30953','30954','30955','30956','30957','30958','30959','30960','30961','30962','30963','30964','30965','30966','30967','30968','30969','30970','30971','30972','30973','30975','30976','30977','30978','30979','30980','30981','30982','30983','30984','30985','30986','30987','30988','30989','30990','30991','30992','30993','30994','30995','30996','30997','30998','30999','31000','31001','31002','31003','31004','31005','31006','31007','31008','31009','31010','31011','31012','31013','31014','31015','31016','31017','31018','31019','31020','31021','31022','31023','31024','31025','31026','31027','31028','31029','31030','31031','31032','31033','31034','31035','31036','31037','31038','31039','31040','31041','31042','31043','31044','31045','31046','31047','31048','31049','31050','31051','31052','31053','31054','31055','31056','31057','31058','31059','31060','31061','31062','31063','31064','31065','31066','31067','31068','31069','31070','31071','31072','31073','31074','31075','31076','31077','31078','31079','31080','31081','31082','31083','31084','31085','31086','31087','31088','31089','31090','31091','31092','31093','31094','31095','31096','31097','31098','31099','31100','31101','31102','31103','31574','31575','47937','50737','54901','54902','54903','54904','54905','54906','54907','54908','54909','54910','54911','54912','54913','54914','54915','54916','54917','54918','54919','54920','54921','54922','54923','54924','54925','54926','54927','54928','54929','54930','54931','54932','54933','54934','54935','54936','54937','54938','54939','54940','54941','54942','54943','54944','54945','54946','54947','54948','54949','54950','54951','54952','54953','54954','54955','54956','54957','54958','54959','54960','54961','54962','54963','54964','54965','54966','54967','54968','54969','54970','54971','54972','54973','54974','54975','54976','54977','54978','54979','54980','62093','62096') AND `class_id`='1'
SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `item_id` IN('544','545','546','547','548','549','550','551','552','553','554','555','556','557','558','559','560','561','562','563','564','565','566','567','568','569','570','571','572','573','574','575','576','577','578','579','580','581','582','583','584','585','586','587','588','589','590','591','592','593','594','595','596','597','598','599','600','601','602','603','604','605','606','607','608','609','610','611','612','613','614','615','616','617','618','619','620','621','622','623','624','625','626','627','628','629','630','631','632','633','634','635','636','637','638','639','640','641','642','643','644','645','646','647','648','649','650','651','652','653','654','655','656','657','658','659','660','661','662','663','664','665','666','667','668','669','670','671','672','10715','10716','10717','10718','10719','10720','10721','10722','10723','10724','10725','10726','10727','10728','10729','10730','10731','10732','10733','10734','10735','10736','10737','10738','10739','10740','10741','10742','10743','10744','10745','10746','10747','10748','10749','10750','10751','10752','10753','10754','10755','10756','10757','10758','10759','10760','10761','10762','10763','10764','10765','10766','12610','12611','12928','13237','13841','13842','16101','16102','16103','16104','17202','17209','17328','17329','17967','17968','17969','17970','17971','18228','19663','19664','19878','19879','19880','19881','19882','19883','19884','21653','23838','23839','23840','23841','23842','23843','23844','23845','23846','23847','23848','23849','23850','23851','23852','23853','23854','23855','23856','23857','23858','23859','23860','23861','23862','23863','23864','23865','23867','23868','23869','23870','23871','23872','23873','23874','23875','23876','23878','23879','23880','25976','25977','25978','25979','26913','26918','26919','26927','29961','29963','29964','29978','29979','29980','30087','30088','30089','30090','30091','30092','30912','30913','30914','30915','30916','30917','30918','30919','30920','30921','30922','30923','30924','30925','30926','30927','30928','30929','30930','30931','30932','30933','30934','30935','30936','30937','30938','30939','30940','30941','30942','30943','30944','30945','30946','30947','30948','30949','30950','30951','30952','30953','30954','30955','30956','30957','30958','30959','30960','30961','30962','30963','30964','30965','30966','30967','30968','30969','30970','30971','30972','30973','30975','30976','30977','30978','30979','30980','30981','30982','30983','30984','30985','30986','30987','30988','30989','30990','30991','30992','30993','30994','30995','30996','30997','30998','30999','31000','31001','31002','31003','31004','31005','31006','31007','31008','31009','31010','31011','31012','31013','31014','31015','31016','31017','31018','31019','31020','31021','31022','31023','31024','31025','31026','31027','31028','31029','31030','31031','31032','31033','31034','31035','31036','31037','31038','31039','31040','31041','31042','31043','31044','31045','31046','31047','31048','31049','31050','31051','31052','31053','31054','31055','31056','31057','31058','31059','31060','31061','31062','31063','31064','31065','31066','31067','31068','31069','31070','31071','31072','31073','31074','31075','31076','31077','31078','31079','31080','31081','31082','31083','31084','31085','31086','31087','31088','31089','31090','31091','31092','31093','31094','31095','31096','31097','31098','31099','31100','31101','31102','31103','31574','31575','47937','50737','54901','54902','54903','54904','54905','54906','54907','54908','54909','54910','54911','54912','54913','54914','54915','54916','54917','54918','54919','54920','54921','54922','54923','54924','54925','54926','54927','54928','54929','54930','54931','54932','54933','54934','54935','54936','54937','54938','54939','54940','54941','54942','54943','54944','54945','54946','54947','54948','54949','54950','54951','54952','54953','54954','54955','54956','54957','54958','54959','54960','54961','54962','54963','54964','54965','54966','54967','54968','54969','54970','54971','54972','54973','54974','54975','54976','54977','54978','54979','54980','62093','62096') AND `class_id`='1'
SELECT name FROM prints_make WHERE `id`='22'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE `name_full` LIKE "Buick%" ORDER BY name_title
?page=###page###
SELECT COUNT(*) as `count` FROM brv_summary_cache WHERE `make_id`='22'
730
SELECT `id`, `name`, `full_name`, `sort_name`, `make_id`, `url`, `views`, `type` FROM brv_summary_cache WHERE `make_id`='22' ORDER BY `sort_name`, `type` LIMIT 600, 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`='22'
SELECT DISTINCT `purchase_id` FROM payment WHERE `status`='approved' AND `purchase_id` IN('54','55','56','57','58','315','1715','1716','1929','1930','1931','1932','1933','1934','1935','3685','5910','5911','5912','5913','5914','5915','5916','5917','5918','5919','5920','5921','5922','5923','5924','5925','5926','5927','5928','5929','5930','5931','5932','5933','5934','5935','5936','5937','5939','5940','5941','5942','5943','5944','5945','5946','5947','5948','5950','5951','5952','8048','8049','8050','8051','8985','8990','8991','8999','12034','12036','12037','12051','12052','12053','12160','12161','12162','12163','12164','12165','12988','12989','12990','12991','12992','12993','12994','12995','12996','12997','12998','12999','13000','13001','13002','13003','13004','13005','13006','13007','13008','13009','13010','13011','13012','13013','13014','13015','13016','13017','13018','13019','13020','13021','13022','13023','13024','13025','13026','13027','13028','13029','13030','13031','13032','13033','13034','13035','13036','13037','13038','13039','13040','13041','13042','13043','13044','13045','13046','13047','13048','13049','13051','13052','13053','13054','13055','13056','13057','13058','13059','13060','13061','13062','13063','13064','13065','13066','13067','13068','13069','13070','13071','13072','13073','13074','13075','13076','13077','13078','13079','13080','13081','13082','13083','13084','13085','13086','13087','13088','13089','13090','13091','13092','13093','13094','13095','13096','13097','13098','13099','13100','13101','13102','13103','13104','13105','13106','13107','13108','13109','13110','13111','13112','13113','13114','13115','13116','13117','13118','13119','13120','13121','13122','13123','13124','13125','13126','13127','13128','13129','13130','13131','13132','13133','13134','13135','13136','13137','13138','13139','13140','13141','13142','13143','13144','13145','13146','13147','13148','13149','13150','13151','13152','13153','13154','13155','13156','13157','13158','13159','13160','13161','13162','13163','13164','13165','13166','13167','13168','13169','13170','13171','13172','13173','13174','13175','13176','13177','13178','13179','13650','13651','29986','31301','31929','31932')
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 = 54) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 29552) 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`='29552'
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('54','1929','5917','31932') 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 = 315) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 13306) 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`='13306'
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('315','1715','1716','13001','13002','13003','13004','13005','13006','13007','13008','13009','13010','13011','13012','13013','13014','13015','13016','13017','13018','13019','13020','13021','13022','13023','13024','13025','13026','13027','13028','13029','13030','13031','13032','13033','13034','13035','13036','13037','13038','13039','13040','13041','13042','13043','13044','13045','13046','13047','13048') 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 = 56) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 13313) 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`='13313'
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('56','1930','1931','1932','1933','13049') ORDER BY price LIMIT 0, 1
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('55','57','58','1715','1716','1929','1930','1931','1932','1933','1934','1935','3685','5910','5911','5912','5913','5914','5915','5916','5917','5918','5919','5920','5921','5922','5923','5924','5925','5926','5927','5928','5929','5930','5931','5932','5933','5934','5935','5936','5937','5939','5940','5941','5942','5943','5944','5945','5946','5947','5948','5950','5951','5952','8048','8049','8050','8051','8985','8990','8991','8999','12034','12036','12037','12051','12052','12053','12160','12161','12162','12163','12164','12165','12988','12989','12990','12991','12992','12993','12994','12995','12996','12997','12998','12999','13000','13001','13002','13003','13004','13005','13006','13007','13008','13009','13010','13011','13012','13013','13014','13015','13016','13017','13018','13019','13020','13021','13022','13023','13024','13025','13026','13027','13028','13029','13030','13031','13032','13033','13034','13035','13036','13037','13038','13039','13040','13041','13042','13043','13044','13045','13046','13047','13048','13049','13051','13052','13053','13054','13055','13056','13057','13058','13059','13060','13061','13062','13063','13064','13065','13066','13067','13068','13069','13070','13071','13072','13073','13074','13075','13076','13077','13078','13079','13080','13081','13082','13083','13084','13085','13086','13087','13088','13089','13090','13091','13092','13093','13094','13095','13096','13097','13098','13099','13100','13101','13102','13103','13104','13105','13106','13107','13108','13109','13110','13111','13112','13113','13114','13115','13116','13117','13118','13119','13120','13121','13122','13123','13124','13125','13126','13127','13128','13129','13130','13131','13132','13133','13134','13135','13136','13137','13138','13139','13140','13141','13142','13143','13144','13145','13146','13147','13148','13149','13150','13151','13152','13153','13154','13155','13156','13157','13158','13159','13160','13161','13162','13163','13164','13165','13166','13167','13168','13169','13170','13171','13172','13173','13174','13175','13176','13177','13178','13179','13650','13651','29986','31301','31929','31932')
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 = 5952) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 29099) 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`='29099'
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('5918','5919','5920','5952') 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 = 31929) 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`='31929' ORDER BY price LIMIT 0, 1
SELECT `id`, `name`, `type` FROM nox_group