/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`='gmc' 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`='50'

SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `item_id` IN('4928','4929','4930','4931','4932','10792','10793','10794','10795','10796','10797','10798','10799','10800','10801','10802','10803','10804','10805','10806','10807','10808','10809','10810','10811','13282','13600','13601','13602','13603','13604','13605','13606','13607','13608','13609','13610','13611','13612','13613','13614','13615','13616','13617','13928','13929','13930','13931','13932','13933','13934','13935','16207','16478','16479','16480','16924','16926','18178','18606','18723','18781','18953','19049','19106','19107','19195','19196','19197','19198','19199','19219','19220','19221','19445','19987','19988','19989','19990','19991','19992','19993','19994','19995','19996','19997','21682','21683','21684','21685','21686','21687','21688','21689','21690','21691','21692','21693','21694','21695','21696','21697','21698','21699','21700','21701','21702','21703','21704','21705','21706','21707','21708','21709','21710','21711','21712','21713','21714','21715','21716','21717','21718','21719','21720','21721','21722','21723','21724','21725','21726','21727','21728','21729','21730','21731','21732','21733','21734','21735','21736','21737','21738','21739','21740','21741','21742','21743','21744','21745','21746','21747','21748','21749','21750','21751','21752','21753','21754','21755','21756','21757','21758','21759','21760','21761','21762','21763','21764','21765','21766','21767','21768','21769','21770','21771','21772','21773','21774','21775','21776','21777','21778','21779','21780','21781','21782','21783','21784','21785','21786','21787','21788','21789','21790','21791','21792','21793','21794','21795','21796','21797','21798','21799','21800','21801','21802','21803','21804','21805','21806','21807','21808','21809','23930','24411','24412','24413','24414','24415','24416','24417','24418','24419','24420','24421','24422','24423','24424','24425','24426','24427','24428','24429','24430','24431','24433','24434','24435','24436','24437','28008','28009','28010','28011','28012','31218','31219','31220','31221','31222','31223','31224','31225','31230','31231','31232','31233','31335','31336','31341','31342','31343','31348','31349','31350','31357','31358','31359','31360','31505','31506','31507','31508','31509','31510','31511','31512','31541','31542','31543','31544','31545','31546','31547','31548','31549','31550','31551','31552','31553','31554','31555','31556','31557','31558','31559','31560','31561','31562','31563','31564','31565','31566','31567','31736','31737','31738','31739','31740','31741','31742','31743','31744','31745','31746','31749','31750','31751','31752','31753','31754','31755','31756','31757','31758','31759','31760','31761','31762','31763','31764','31765','31766','31767','31768','31769','31770','31771','31772','31773','31774','31775','31776','31777','31778','31779','31780','31781','31782','31783','31784','31785','31786','31787','31788','31789','31790','31791','31792','31793','31794','31795','31796','31797','31798','31799','31800','31801','31802','31803','31804','31805','31806','31807','31808','31815','31816','31817','31818','31819','31820','31896','31897','31898','31901','31902','31909','31910','31911','31920','31921','31922','31925','31926','31927','31934','31935','31936','31937','31938','31939','31965','31967','31969','31979','31980','31981','31982','31991','31992','31993','31994','31995','31996','31997','31998','32029','32030','32031','32032','32033','32034','32065','32066','32067','32068','32069','32070','32101','32102','32103','32104','32105','32106','32137','32138','32139','32140','32141','32142','32173','32174','32175','32176','32177','32178','45747','46844','46845','47043','47044','47045','47046','47047','47048','47049','47050','47051','47053','47054','47055','47056','47057','47123','47124','47125','47126','47127','47128','47129','47235','47242','47243','47244','47245','47246','47247','47248','47249','47373','47374','47375','47498','47499','47500','47507','47590','47603','47604','47605','47606','47607','47608','47609','47610','47611','47612','47613','47776','47777','47778','47779','47780','47781','47782','47783','47784','47785','47786','47787','47788','47789','47790','47791','47792','47793','47794','47795','47796','47797','47798','47799','47800','47801','47802','47803','47804','47805','47806','47807','47808','47809','47810','47811','47812','47813','47814','47815','47816','47817','47818','47819','48089','48090','48091','48092','48093','48094','48095','48096','48097','48098','48099','48100','48128','48129','48130','48131','48132','48133','48134','48135','48136','48137','48138','48139','48140','48141','48142','48143','48144','48145','48146','48147','48148','48149','48150','48151','48152','48153','48154','48188','48236','48415','48438','48439','48440','48484','48485','48486','48529','48530','48531','48532','48738','48909','48910','48911','48912','48913','48914','48932','48951','48952','48953','48954','48955','48956','48957','48958','48959','48960','48961','48962','48963','48964','48965','48966','48967','48968','48969','48970','48971','48972','48973','48976','48977','48978','48979','48982','48983','48984','49013','49114','49115','49116','49117','49118','49120','49121','49122','49123','49124','49153','49157','49158','49159','49160','49161','49583','49584','49585','49586','49587','49588','49589','49590','49591','49592','49593','49594','49595','49596','49597','49598','49599','49600','49601','49602','49603','49604','49605','49606','49607','49608','49609','49610','49611','49612','49613','49614','49615','49616','49617','49618','49619','49620','49621','50071','50072','50073','50074','50075','50076','50077','50078','50079','50685','50703','50704','50705','50709','50710','50711','50739','50764','50765','50766','50767','50768','50803','50921','50922','50923','50924','50925','50926','50927','51263','51264','51265','51266','51267','51268','51269','51270','51271','51272','51273','51274','51275','52847','52848','52849','52850','52851','52852','52853','52854','52855','52856','52857','52858','52859','52860','52861','52862','52863','57693','57694') AND `class_id`='1'

?page=###page###

SELECT COUNT(*) as `count` FROM brv_summary_cache WHERE `make_id`='50' AND `type` IN('0','1','2')

734

SELECT `id`, `name`, `full_name`, `sort_name`, `make_id`, `url`, `views`, `type` FROM brv_summary_cache WHERE `make_id`='50' AND `type` IN('0','1','2') ORDER BY `sort_name`, `type` LIMIT 500, 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('265','693','810','868','1040','1137','1194','1195','1284','1285','1286','1287','1288','1308','1309','1310','1534','2019','2020','2021','2022','2023','2024','2025','2026','2027','2028','2029','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','3786','3787','3788','3789','3790','3791','3792','3793','3794','3795','3796','3797','3798','3799','3800','3801','3802','3803','3804','3805','3806','3807','3808','3809','3810','3811','3812','3813','3814','3815','3816','3817','3818','3819','3820','3821','3822','3823','3824','3825','3826','3827','3828','3829','3830','3831','3832','3833','3834','3835','3836','3837','3838','3839','3840','3841','6002','6483','6484','6485','6486','6487','6488','6489','6490','6491','6492','6493','6494','6495','6496','6497','6498','6499','6500','6501','6502','6503','6505','6506','6507','6508','6509','10080','10081','10082','10083','10084','13294','13295','13296','13297','13298','13299','13300','13301','13306','13307','13308','13309','13411','13412','13417','13418','13419','13424','13425','13426','13433','13434','13435','13436','13581','13582','13583','13584','13585','13586','13587','13588','13617','13618','13619','13620','13621','13622','13623','13624','13625','13626','13627','13628','13629','13630','13631','13632','13633','13634','13635','13636','13637','13638','13639','13640','13641','13642','13643','13812','13813','13814','13815','13816','13817','13818','13819','13820','13821','13822','13825','13826','13827','13828','13829','13830','13831','13832','13833','13834','13835','13836','13837','13838','13839','13840','13841','13842','13843','13844','13845','13846','13847','13848','13849','13850','13851','13852','13853','13854','13855','13856','13857','13858','13859','13860','13861','13862','13863','13864','13865','13866','13867','13868','13869','13870','13871','13872','13873','13874','13875','13876','13877','13878','13879','13880','13881','13882','13883','13884','13891','13892','13893','13894','13895','13896','13972','13973','13974','13977','13978','13985','13986','13987','13996','13997','13998','14001','14002','14003','14010','14011','14012','14013','14014','14015','14041','14043','14045','14055','14056','14057','14058','14067','14068','14069','14070','14071','14072','14073','14074','14105','14106','14107','14108','14109','14110','14141','14142','14143','14144','14145','14146','14177','14178','14179','14180','14181','14182','14213','14214','14215','14216','14217','14218','14249','14250','14251','14252','14253','14254','27827','28927','28928','29120','29121','29122','29123','29124','29125','29126','29127','29128','29130','29132','29133','29134','29195','29196','29197','29198','29199','29200','29201','29303','29310','29311','29312','29313','29314','29315','29316','29317','29441','29442','29443','29566','29567','29568','29575','29658','29671','29672','29673','29674','29675','29676','29677','29678','29679','29680','29681','29833','29834','29835','29836','29837','29838','29839','29840','29841','29842','29843','29844','29845','29846','29847','29848','29849','29850','29851','29852','29853','29854','29855','29856','29857','29858','29859','29860','29861','29862','29863','29864','29865','29866','29867','29868','29869','29870','29871','29872','29873','29874','30129','30130','30131','30132','30133','30134','30135','30136','30137','30138','30139','30140','30160','30161','30162','30163','30164','30165','30166','30167','30168','30169','30170','30171','30172','30173','30174','30175','30176','30177','30178','30179','30180','30181','30182','30183','30184','30218','30265','30444','30467','30468','30469','30513','30514','30515','30561','30758','30928','30929','30930','30931','30932','30933','30951','30970','30971','30972','30973','30974','30975','30976','30977','30978','30979','30980','30981','30982','30983','30984','30985','30986','30987','30988','30989','30990','30991','30992','30995','30996','30997','30998','31001','31002','31003','31032','31130','31131','31132','31133','31134','31136','31137','31138','31139','31140','31166','31170','31171','31172','31173','31174','31249','31267','31268','31269','31273','31274','31275','31303','31327','31328','31329','31330','31331','31360','31478','31479','31480','31481','31482','31483','31484')

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 = 29126)

SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 34576) 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`='34576'

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('28927','29125','29126','29127','29128','29201') 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 = 14254)

SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 35321) 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`='35321'

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('14105','14106','14107','14108','14109','14110','14141','14142','14143','14144','14145','14146','14177','14178','14179','14180','14181','14182','14213','14214','14215','14216','14217','14218','14249','14250','14251','14252','14253','14254') 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 = 868)

SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 28847) 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`='28847'

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('868','13581','13582','13583','13584','13585','13586','13587','13588','13617','13618','13619','13620','13621','13622','13623','13624','13625','13626','13627','13628','13629','13630','13631','13632','13633','13634','13635','13636','13637','13638','13639','13640','13641','13642','13643') 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 = 1137)

SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 35040) 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`='35040'

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('810','1137','1284','1285','1286','1287','1288','1534','2022','2023','2024','2025','2026','2027','2028','2029','3732','3733','3734','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','3786','3787','3788','3789','3790','3791','3792','3793','3794','3795','3796','3797','3798','3799','3800','3801','3802','3803','3804','3805','3806','3807','3808','3809','3810','3811','3812','3813','3814','3815','3816','3817','3818','3819','3820','3821','3822','3823','3824','3825','3826','3827','3828','3829','3830','3831','3832','3833','3834','3835','3836','3837','3838','3839','3840','3841','13812','13813','13814','13815','13816','13817','13818','13819','13820','13821','13822','13825','13826','13827','13828','13829','13830','13831','13832','13833','13834','13835','13836','13837','13838','13839','13840','13841','13842','13843','13844','13845','13846','13847','13848','13849','13850','13851','13852','13853','13854','13855','13856','13857','13858','13859','13860','13861','13862','13863','13864','13865','13866','13867','13868','13869','13870','13871','13872','13873','13874','13875','13876','13877','13878','13879','13880','13881','13882','13883','13884','13891','13892','13893','13894','13895','13896','30265','30928') 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 = 1284)

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 = 29128)

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 = 265)

SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 2188) 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`='2188'

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('265','2019','2020') ORDER BY price LIMIT 0, 1

SELECT `id`, `name`, `type` FROM nox_group