/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`='hyundai' 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`='58'
SELECT id, url, sort_name, full_name, views FROM prints_blueprint WHERE `item_id` IN('5083','5084','5085','5086','5087','5088','5089','5090','5091','5092','5093','5094','5095','5096','5097','8722','8723','8724','8725','8726','8727','8728','8729','8730','8731','8732','8733','8734','8735','8736','8737','8738','8739','8740','8741','8742','8743','8744','8745','8746','8747','8748','8749','8750','8751','8752','8753','8754','8755','8756','8757','8758','8759','8760','8761','8762','8763','12704','13060','13061','13062','13063','13064','13951','13952','13953','13954','13955','13956','15776','15777','15778','15779','15780','15781','15782','16934','16935','16937','16938','16939','17413','17517','17518','17519','17520','17521','17522','17523','17524','17526','17527','17528','17529','17530','18516','18517','18518','18519','18520','18521','18522','18523','18524','18525','18526','19233','19234','19235','19236','19237','19238','19239','19376','19527','19528','19529','19530','19531','19532','19533','19534','19535','19536','19972','20036','20037','20038','20039','20040','20041','20042','20043','20044','20045','20046','20047','20048','20049','20050','20051','20052','20053','20054','20055','20056','20057','20058','20059','20060','20061','20062','20063','20064','20065','20066','20067','20068','20069','20070','20071','20072','20073','20074','20075','20076','20077','20078','20079','20080','20511','20512','20513','20514','20925','20926','20927','20928','20929','20930','21667','21668','22004','22038','22039','22143','22233','22234','22235','22236','22237','22238','22239','22240','22241','22242','22243','22244','22245','22246','22247','22248','22249','22250','22251','22252','22253','22254','22255','22256','22257','22258','22259','22260','22261','22262','22263','22264','22265','22266','22267','22268','22269','22270','22271','22272','22273','22275','22276','22277','23536','23537','23538','23539','23540','23543','23544','23545','23546','23547','23548','23549','23550','23551','23552','23553','23554','23555','23556','23557','23558','23559','23560','23561','23562','23563','23564','23565','23566','23567','23568','23569','23570','23571','23572','23573','23574','23575','23576','23577','23578','23579','23580','23581','23586','23587','23590','23592','23593','23594','23595','23596','23597','23598','23599','23600','23601','23602','23603','23604','23605','23606','23607','23608','23609','23610','23611','23612','23613','23614','23615','23616','23617','23618','23619','23620','23621','23622','23623','23624','23625','23626','23627','23628','23629','23630','23631','23632','23633','23634','23635','23636','23637','23638','23639','23640','23641','23642','23643','23644','23645','23646','23647','23648','23649','23650','23651','25591','25789','25790','29754','29755','29756','29757','29758','29759','29792','29793','29794','29795','29796','29797','29798','29799','29800','29801','29802','29803','29804','29805','29806','29807','29808','29809','29861','29862','29863','29864','29880','29881','29882','29883','29884','29885','29886','29887','29888','29889','29890','29891','29892','29893','29894','29895','29896','29897','33815','45901','45910','45911','46007','46009','46025','46097','46099','46116','46131','46440','46441','46442','46832','46858','46862','46954','47573','47574','47575','47576','47577','47578','47579','47580','47581','47583','47584','48537','48538','48540','48717','49209','49210','49211','49212','49213','49214','49215','49216','50117','50118','50119','50120','50121','50122','50123','50124','50125','50126','50127','50128','50129','50130','50725','50823','50944','51329','51330','51331','51332','51333','51334','51335','51336','51337','51338','51339','51340','52971','52972','57995','57996','57997','57998','57999','58000','58001','58002','58003','58004','58005','58006','58007','58008','58009','58010','58011','58012','58013','58014','58015','58016','58017','58018','58019','58020','58021','58022','58023','58024','58025','58026','58027','58028','58029','58030','58031','58032','58033','58034','58035','58036','58037','58038','58039','58040','58041','58042','58043','58044','58045','58046','58047','58048','58049','58050','58051','58052','58053','58054','58055','58056','58057','58058','58059','58060','58061','58062','58063','58064','58065','58066','58067','58068','58069','58070','58071','58072','58073','58074','58075','58076','58077','58078','58079','58080','58081','58082','58083','58084','58085','58086','58087','62115','62129') AND `class_id`='1'
SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `item_id` IN('5083','5084','5085','5086','5087','5088','5089','5090','5091','5092','5093','5094','5095','5096','5097','8722','8723','8724','8725','8726','8727','8728','8729','8730','8731','8732','8733','8734','8735','8736','8737','8738','8739','8740','8741','8742','8743','8744','8745','8746','8747','8748','8749','8750','8751','8752','8753','8754','8755','8756','8757','8758','8759','8760','8761','8762','8763','12704','13060','13061','13062','13063','13064','13951','13952','13953','13954','13955','13956','15776','15777','15778','15779','15780','15781','15782','16934','16935','16937','16938','16939','17413','17517','17518','17519','17520','17521','17522','17523','17524','17526','17527','17528','17529','17530','18516','18517','18518','18519','18520','18521','18522','18523','18524','18525','18526','19233','19234','19235','19236','19237','19238','19239','19376','19527','19528','19529','19530','19531','19532','19533','19534','19535','19536','19972','20036','20037','20038','20039','20040','20041','20042','20043','20044','20045','20046','20047','20048','20049','20050','20051','20052','20053','20054','20055','20056','20057','20058','20059','20060','20061','20062','20063','20064','20065','20066','20067','20068','20069','20070','20071','20072','20073','20074','20075','20076','20077','20078','20079','20080','20511','20512','20513','20514','20925','20926','20927','20928','20929','20930','21667','21668','22004','22038','22039','22143','22233','22234','22235','22236','22237','22238','22239','22240','22241','22242','22243','22244','22245','22246','22247','22248','22249','22250','22251','22252','22253','22254','22255','22256','22257','22258','22259','22260','22261','22262','22263','22264','22265','22266','22267','22268','22269','22270','22271','22272','22273','22275','22276','22277','23536','23537','23538','23539','23540','23543','23544','23545','23546','23547','23548','23549','23550','23551','23552','23553','23554','23555','23556','23557','23558','23559','23560','23561','23562','23563','23564','23565','23566','23567','23568','23569','23570','23571','23572','23573','23574','23575','23576','23577','23578','23579','23580','23581','23586','23587','23590','23592','23593','23594','23595','23596','23597','23598','23599','23600','23601','23602','23603','23604','23605','23606','23607','23608','23609','23610','23611','23612','23613','23614','23615','23616','23617','23618','23619','23620','23621','23622','23623','23624','23625','23626','23627','23628','23629','23630','23631','23632','23633','23634','23635','23636','23637','23638','23639','23640','23641','23642','23643','23644','23645','23646','23647','23648','23649','23650','23651','25591','25789','25790','29754','29755','29756','29757','29758','29759','29792','29793','29794','29795','29796','29797','29798','29799','29800','29801','29802','29803','29804','29805','29806','29807','29808','29809','29861','29862','29863','29864','29880','29881','29882','29883','29884','29885','29886','29887','29888','29889','29890','29891','29892','29893','29894','29895','29896','29897','33815','45901','45910','45911','46007','46009','46025','46097','46099','46116','46131','46440','46441','46442','46832','46858','46862','46954','47573','47574','47575','47576','47577','47578','47579','47580','47581','47583','47584','48537','48538','48540','48717','49209','49210','49211','49212','49213','49214','49215','49216','50117','50118','50119','50120','50121','50122','50123','50124','50125','50126','50127','50128','50129','50130','50725','50823','50944','51329','51330','51331','51332','51333','51334','51335','51336','51337','51338','51339','51340','52971','52972','57995','57996','57997','57998','57999','58000','58001','58002','58003','58004','58005','58006','58007','58008','58009','58010','58011','58012','58013','58014','58015','58016','58017','58018','58019','58020','58021','58022','58023','58024','58025','58026','58027','58028','58029','58030','58031','58032','58033','58034','58035','58036','58037','58038','58039','58040','58041','58042','58043','58044','58045','58046','58047','58048','58049','58050','58051','58052','58053','58054','58055','58056','58057','58058','58059','58060','58061','58062','58063','58064','58065','58066','58067','58068','58069','58070','58071','58072','58073','58074','58075','58076','58077','58078','58079','58080','58081','58082','58083','58084','58085','58086','58087','62115','62129') AND `class_id`='1'
SELECT name FROM prints_make WHERE `id`='58'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE `name_full` LIKE "Hyundai%" ORDER BY name_title
?page=###page###
SELECT COUNT(*) as `count` FROM brv_summary_cache WHERE `make_id`='58'
681
SELECT `id`, `name`, `full_name`, `sort_name`, `make_id`, `url`, `views`, `type` FROM brv_summary_cache WHERE `make_id`='58' 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`='58'
SELECT `id`, `tag` FROM tag WHERE `id` IN('201')
SELECT DISTINCT `purchase_id` FROM payment WHERE `status`='approved' AND `purchase_id` IN('603','604','605','606','607','608','609','610','611','612','613','1322','1323','1324','1325','1326','1327','1328','1465','1579','1580','1581','1582','1583','1584','1585','1586','1587','1588','2004','2068','2069','2070','2071','2072','2073','2074','2075','2076','2077','2078','2079','2080','2081','2082','2083','2084','2085','2086','2087','2088','2089','2090','2091','2092','2093','2094','2095','2096','2097','2098','2099','2100','2101','2102','2103','2104','2105','2106','2107','2108','2109','2110','2111','2112','2543','2544','2545','2546','2957','2958','2959','2960','2961','2962','4053','4095','4096','4209','4302','4303','4304','4305','4306','4307','4308','4309','4310','4311','4312','4313','4314','4316','4317','4318','4319','4320','4321','4322','4323','4324','4325','4327','4328','4330','4331','4332','4333','4334','4335','4336','4337','4338','4339','4340','4341','4342','4344','4345','4346','5608','5609','5610','5611','5612','5615','5616','5617','5618','5619','5620','5621','5622','5623','5624','5625','5626','5627','5628','5629','5630','5631','5632','5633','5634','5635','5636','5637','5638','5639','5640','5641','5642','5643','5644','5645','5646','5647','5648','5649','5650','5651','5652','5653','5658','5659','5662','5664','5665','5666','5667','5668','5669','5670','5671','5672','5673','5674','5675','5676','5677','5678','5679','5680','5681','5682','5683','5684','5685','5686','5687','5688','5689','5690','5691','5692','5693','5694','5695','5696','5697','5698','5699','5700','5701','5702','5703','5704','5705','5706','5707','5708','5709','5710','5711','5712','5713','5714','5715','5716','5717','5718','5719','5720','5721','5722','5723','7663','7861','7862','11827','11828','11829','11830','11831','11832','11865','11866','11867','11868','11869','11870','11871','11872','11873','11874','11875','11876','11877','11878','11879','11880','11881','11882','11934','11935','11936','11937','11953','11954','11955','11956','11957','11958','11959','11960','11961','11962','11963','11964','11965','11966','11967','11968','11969','11970','15893','27994','28003','28004','28101','28103','28119','28196','28198','28215','28228','28525','28526','28527','28915','28941','28945','29035','29641','29642','29643','29644','29645','29646','29647','29648','29649','29651','29652','30566','30567','30569','31220','31221','31222','31223','31224','31225','31226','31227','31289','31380','31501','31951','31966')
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 = 613) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 32579) 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`='32579'
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('613','29646') 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 = 605) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 32576) 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`='32576'
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('603','604','605','2957','2958','2959','2960','2961','2962','29641') 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 = 4306) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 31437) 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`='31437'
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('4306','4307','4308','4309','28941') 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 = 610) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 32577) 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`='32577'
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('610','611','2106','2107','2108','29644') 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 = 2543) 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`='2543' ORDER BY price LIMIT 0, 1
SELECT `id`, `name`, `type` FROM nox_group