/var/www/html/nox-modules/prints
/lib/action/frontend
/printsVectorSubcategoryAction.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`='mitsubishi' 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 (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`='95'
SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `item_id` IN('3646','3647','3648','3650','3651','3652','3654','3656','3657','3658','3659','3662','3664','3665','3667','3669','3670','3671','3673','3675','3676','3677','3678','3679','3680','3681','3683','3684','3687','3689','3690','3692','3694','3695','3697','3699','3701','3702','3703','3705','3708','3710','3711','3712','3713','3714','3715','3716','3717','3718','3719','3720','3721','3722','3723','3724','3725','3726','3727','3728','3729','3730','3731','3732','3733','3734','3735','3736','3737','3738','3739','3740','3741','3742','3743','3744','3745','3746','3747','3748','3749','3750','3751','3752','3753','3754','3755','3756','3757','3758','3759','3760','3761','3762','3763','3764','3765','3766','3767','3768','3769','3770','3771','3772','3773','3774','3775','3776','3777','3778','3779','3780','3781','3782','3783','3784','3785','7614','7615','7616','7617','7618','7619','7620','7621','7622','7623','7624','7625','7626','7627','7628','7629','7630','7631','7632','7633','7634','7635','7636','7637','7638','7639','7640','7641','7642','7643','7644','7645','7646','7647','7648','7649','7650','7651','7652','7653','7654','7655','7656','7657','7658','7659','7660','7661','7662','7663','7664','7665','7666','7667','7668','7669','7670','7671','7672','7673','7674','7675','7676','7677','7678','7679','7680','7681','7682','7683','7684','7685','7686','7687','7688','7689','7690','7691','7692','7693','7694','7695','7696','7697','7698','7699','7700','7701','7702','7703','7704','7705','7706','7707','7708','7709','7710','7711','7712','7713','7714','7716','7717','7718','7719','7720','7721','7722','7723','7724','7725','7726','7727','7728','7729','7730','7731','7732','7733','7734','7735','11132','12719','12720','12721','13137','13138','13338','13774','14014','14015','14016','14017','14018','14019','14020','14021','14022','14023','15338','15339','15340','15494','15495','15496','15497','15498','15499','15500','15501','15502','15503','15504','15505','15506','15507','15508','15509','15510','15511','15512','15513','15514','15515','15516','15517','15518','15519','15520','15521','15522','15523','16296','16297','16298','16299','16300','16951','16952','16953','16955','16956','16957','16958','16959','16960','17635','17636','17637','17638','17639','17640','17641','18455','18458','18619','18620','18621','18622','18623','18624','18625','18626','18627','18628','18629','18630','18631','18632','18633','18634','18635','18636','18637','18638','18639','18640','18641','18642','18643','18644','18645','19086','19087','19190','19483','19938','19975','20128','20129','20130','20131','20132','20133','20134','20135','20136','20137','20138','20139','20140','20141','20142','20143','20144','20145','20146','20147','20148','20149','20150','20557','20558','20559','20560','20561','20562','20563','20564','20565','20566','20567','20568','20569','20570','20571','20572','20573','20994','21980','22010','22131','22132','22133','22134','22135','22136','22139','22142','22623','22624','22625','22626','22627','22628','22629','22630','22631','22632','22633','22634','22635','22636','22637','22638','22639','22640','22641','22642','22643','22644','22645','22646','22647','22648','22649','22650','22651','22652','22653','22654','22655','22656','22657','22658','22659','22660','22661','22662','22663','22664','22665','22666','22667','22668','22669','22670','22671','22672','22673','22674','22675','22676','22677','22678','22679','22680','22681','22682','22683','22684','22685','22686','22687','22688','22689','22690','22691','22692','22693','22694','22695','22696','22697','22698','22699','22700','22701','22702','22703','22704','22705','22706','22707','22708','22709','22710','22711','22712','22713','22714','22715','22716','22717','22718','22719','22720','22721','22722','22723','23588','23589','23591','25574','25575','25576','25577','25578','25579','25580','25581','25582','25586','25587','25588','25589','25590','25592','25593','25594','25595','25596','25597','25598','25599','25600','25601','25602','25603','25604','25605','25606','25607','25608','25609','25610','25611','25612','25613','25614','25615','25616','25617','25618','25619','25620','25621','25622','25623','25624','25631','25632','25633','25652','25653','25654','25655','25656','25657','25658','25659','25660','25661','25662','25663','25670','25671','25672','25673','25674','25675','25676','25677','25678','25679','25680','25681','25682','25683','25684','25685','25686','25687','25688','25689','25690','25691','25692','25693','25694','25695','25696','25703','25704','25705','25706','25707','25708','25709','25710','25711','25712','25713','25714','25715','25716','25717','25718','25719','25720','25721','25722','25723','25724','25725','25726','25727','25728','25729','25730','25731','25732','25733','25734','25735','25736','25737','25738','25739','25740','25741','25742','25743','25744','25745','25746','25747','25750','25751','25752','25753','25754','25755','25756','25757','25760','25761','25762','25763','25764','25765','25766','25767','25770','25771','25772','25773','25774','25775','25776','25777','25778','25779','25780','25781','25782','25783','25784','25785','25786','25787','25791','25792','25793','25794','25795','25796','25797','25798','25799','25800','25801','25802','25803','25804','25805','25806','25807','25808','25809','25810','25811','25812','25813','25814','25815','25816','25817','25818','25819','25820','25821','25822','25823','25824','25825','25826','25827','25828','25829','25830','25831','25832','25833','25834','25835','25836','25837','25838','25839','25842','25843','25844','25847','25848','25849','25850','25851','25852','25853','25854','26089','26090','26210','26211','26212','26213','28126','28127','28128','28129','29686','29687','29688','29689','29690','29691','29692','29693','29694','29695','29696','29697','29698','29699','29700','29701','29702','29703','29704','29705','29706','29707','29708','29709','29710','29711','29712','29713','29714','29715','29716','29717','29718','29719','29720','29721','29722','29723','29724','29725','29726','29727','29728','29729','29730','29731','29732','29733','29734','29735','29784','29785','29786','29787','29788','29789','29790','29791','29810','29811','29812','29813','29814','29815','29816','29817','29818','29819','29820','29821','29822','29823','29824','29825','29826','29827','29828','29829','29830','29831','29832','29833','29834','29835','29836','29837','29838','29839','29840','29841','29842','29843','29844','29845','29846','29847','29848','29865','29866','29867','29868','29869','29870','29871','29872','29873','29874','29875','29876','29877','29878','29879','30497','32273','32274','32275','32276','32277','32278','32279','45721','45771','45824','46035','46115','46258','46259','46290','46646','46647','46664','46682','46683','46716','46925','46926','46974','47067','47068','47069','47070','47145','47146','47147','47164','47165','47166','47587','48039','48040','48041','48347','48348','48349','48350','48351','48352','48353','48360','48364','48365','48488','48489','48545','48546','48547','48548','48549','48569','48570','48571','48572','48573','48574','48575','48576','48577','48578','48579','48580','48581','48584','49104','49105','49801','49802','49803','49804','49805','50821','50822','50857','50858','50860','50861','50862','50863','50864','50963','51006','51007','51008','51009','51883','51884','51885','51886','51887','51888','51889','51890','51891','51892','51893','51894','51895','51896','51897','51898','51899','51900','51901','51902','51903','51904','51905','51906','51907','51908','51909','51910','51911','51912','51913','51914','51915','51916','51917','51918','51919','59182','59183','59184','59185','59186','59187','59188','59189','59190','59191','59192','59193','59194','59195','59196','59197','59198','59199','59200','59201','59202','59203','59204','59205','59206','59207','59208','59209','59210','59211','59212','59213','59214','59215','59216','59217','59218','59219','59220','59221','59222','59223','59224','59225','59226','59227','59228','59229','59230','59231','59232','59233','59234','59235','59236','59237','59238','59239','59240','59241','59242') AND `class_id`='1'
?page=###page###
SELECT COUNT(*) as `count` FROM brv_summary_cache WHERE `make_id`='95' AND `type` IN('0','1','2')
921
SELECT `id`, `name`, `full_name`, `sort_name`, `make_id`, `url`, `views`, `type` FROM brv_summary_cache WHERE `make_id`='95' AND `type` IN('0','1','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`='1'
SELECT `id`, `tag` FROM tag WHERE `id` IN('91')
SELECT DISTINCT `purchase_id` FROM payment WHERE `status`='approved' AND `purchase_id` IN('542','545','706','707','708','709','710','711','712','713','714','715','716','717','718','719','720','721','722','723','724','725','726','727','728','729','730','731','732','1174','1175','1279','1562','1986','2007','2160','2161','2162','2163','2164','2165','2166','2167','2168','2169','2170','2171','2172','2173','2174','2175','2176','2177','2178','2179','2180','2181','2182','2589','2590','2591','2592','2593','2594','2595','2596','2597','2598','2599','2600','2601','2602','2603','2604','2605','3026','4028','4059','4195','4196','4197','4198','4199','4200','4208','4692','4693','4694','4695','4696','4697','4698','4699','4700','4701','4702','4703','4704','4705','4706','4707','4708','4709','4710','4711','4712','4713','4714','4715','4716','4717','4718','4719','4720','4721','4722','4723','4724','4725','4726','4727','4728','4729','4730','4731','4732','4733','4734','4735','4736','4737','4738','4739','4740','4741','4742','4743','4745','4746','4747','4748','4749','4750','4751','4752','4753','4754','4755','4756','4757','4758','4759','4760','4761','4762','4763','4764','4765','4766','4767','4768','4769','4770','4771','4772','4773','4774','4775','4776','4777','4778','4779','4780','4781','4782','4783','4784','4785','4786','4787','4788','4789','4790','4791','4792','5660','5661','5663','7646','7647','7648','7649','7650','7651','7652','7653','7654','7658','7659','7660','7661','7662','7664','7665','7666','7667','7668','7669','7670','7671','7672','7673','7674','7675','7676','7677','7678','7679','7680','7681','7682','7683','7684','7685','7686','7687','7688','7689','7690','7691','7692','7693','7694','7695','7696','7703','7704','7705','7724','7725','7726','7727','7728','7729','7730','7731','7732','7733','7734','7735','7742','7743','7744','7745','7746','7747','7748','7749','7750','7751','7752','7753','7754','7755','7756','7757','7758','7759','7760','7761','7762','7763','7764','7765','7766','7767','7768','7775','7776','7777','7778','7779','7780','7781','7782','7783','7784','7785','7786','7787','7788','7789','7790','7791','7792','7793','7794','7795','7796','7797','7798','7799','7800','7801','7802','7803','7804','7805','7806','7807','7808','7809','7810','7811','7812','7813','7814','7815','7816','7817','7818','7819','7822','7823','7824','7825','7826','7827','7828','7829','7832','7833','7834','7835','7836','7837','7838','7839','7842','7843','7844','7845','7846','7847','7848','7849','7850','7851','7852','7853','7854','7855','7856','7857','7858','7859','7863','7864','7865','7866','7867','7868','7869','7870','7871','7872','7873','7874','7875','7876','7877','7878','7879','7880','7881','7882','7883','7884','7885','7886','7887','7888','7889','7890','7891','7892','7893','7894','7895','7896','7897','7898','7899','7900','7901','7902','7903','7904','7905','7906','7907','7908','7909','7910','7911','7914','7915','7916','7919','7920','7921','7922','7923','7924','7925','7926','8161','8162','8282','8283','8284','8285','10198','10199','10200','10201','11759','11760','11761','11762','11763','11764','11765','11766','11767','11768','11769','11770','11771','11772','11773','11774','11775','11776','11777','11778','11779','11780','11781','11782','11783','11784','11785','11786','11787','11788','11789','11790','11791','11792','11793','11794','11795','11796','11797','11798','11799','11800','11801','11802','11803','11804','11805','11806','11807','11808','11857','11858','11859','11860','11861','11862','11863','11864','11883','11884','11885','11886','11887','11888','11889','11890','11891','11892','11893','11894','11895','11896','11897','11898','11899','11900','11901','11902','11903','11904','11905','11906','11907','11908','11909','11910','11911','11912','11913','11914','11915','11916','11917','11918','11919','11920','11921','11938','11939','11940','11941','11942','11943','11944','11945','11946','11947','11948','11949','11950','11951','11952','12572','14349','14350','14351','14352','14353','14354','14355','27799','27853','27911','28129','28214','28349','28350','28375','28729','28730','28747','28765','28766','28799','29007','29008','29055','29144','29145','29146','29147','29216','29217','29218','29235','29236','29237','29655','30079','30080','30081','30376','30377','30378','30379','30380','30381','30382','30389','30393','30394','30517','30518','30574','30575','30576','30577','30578','30595','30596','30597','30598','30599','30600','30601','30602','30603','30604','30605','30606','30607','30610','31120','31121','31378','31379','31414','31415','31417','31418','31419','31420','31421','31520','31555','31556','31557','31558')
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 = 7854)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 28857) 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`='28857'
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('2007','2175','2176','2177','2178','2179','2180','2181','2182','7854','7855','7863','7864','7871') 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 = 2168)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 29765) 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`='29765'
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('2165','2166','2167','2168','2169','3026','12572') 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 = 730)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 33550) 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`='33550'
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('706','707','708','721','722','723','730','28729','28730','29144','29145','29216','29217','29218','29235','29236','29237','30079','30080','30081') 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 = 2178)
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 = 7850)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 34372) 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`='34372'
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('7812','7813','7822','7823','7832','7833','7842','7843','7850','7851','7852','7853','30376','30378','30379','30389','30393','30574','30575') 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 = 4198)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 28911) 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`='28911'
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('542','2160','2161','2162','2163','2164','4198','4199') ORDER BY price LIMIT 0, 1
SELECT `id`, `name`, `type` FROM nox_group