/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`='kia' 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`='74'
SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `item_id` IN('2150','2151','2152','2153','2154','2155','2156','2157','2158','2159','2160','2161','2162','2163','2164','2165','2166','2167','2168','2169','2170','2171','2172','2173','2174','2175','2176','2177','8764','8765','8766','8767','8768','8769','8770','8771','8772','8773','8774','8775','8776','8777','8778','10938','13085','13086','13087','13088','13089','13090','13091','13092','13093','13391','13792','15317','16231','16232','16233','16234','16235','16236','16237','16238','16239','16240','16241','16242','16243','16244','16245','16246','16247','16248','16249','16440','17544','17545','17546','17547','17548','18743','18744','18745','18746','18747','18748','18752','18753','18754','18755','18756','18757','18758','18759','18760','18761','18762','18763','19243','19377','20081','20082','20083','20084','20085','20086','21964','21977','21995','21996','21997','22013','22049','22278','22279','22280','22281','22282','22283','22284','22285','22286','22287','22288','22289','22290','22291','22292','22293','22294','22295','22296','22297','22298','22299','22300','22301','22303','22304','22305','22306','22307','22308','22309','22310','22311','22312','22313','22314','22315','22316','22317','22318','22319','22320','22321','22322','22323','22324','22325','22326','22327','22328','22329','22330','22331','22332','22333','22334','22335','22336','22337','22338','22339','22340','22341','22342','22343','22344','22345','22346','22347','22348','22349','22350','22351','22352','22353','22354','22355','22356','22357','22358','22359','22360','22361','22362','22363','22364','22365','22366','22367','22368','22369','22370','22371','22372','22373','22374','22380','22381','22382','22383','22384','22385','22386','22387','22388','22389','22390','22391','22392','22393','22394','22395','22396','23542','23681','23682','23683','23684','23685','23686','23687','23688','23689','23690','23691','23692','23693','23694','23695','23696','23697','23698','23699','23700','23701','23702','23703','23704','23705','23706','23707','23708','23709','23710','23711','23712','23713','23714','23715','23716','23717','23718','23719','23720','23721','23722','23723','23724','23725','23726','23727','23728','23729','23730','23731','23732','23733','23734','23735','23736','23737','23738','23739','23740','23741','33810','33811','33812','33813','45904','45907','45982','46008','46186','46704','47063','47283','47419','47479','47480','47481','47486','47487','48721','48722','48723','48724','48840','49084','50177','50178','50747','50812','51483','51484','51485','51486','51487','51488','51489','51490','51491','51492','51493','51494','58225','58226','58227','58228','58229','58230','58231','58232','58233','58234','58235','58236','58237','58238','58239','58240','58241','58242','58243','58244','58245','58246','58247','58248','58249','58250','58251','58252','58253','58254','58255','58256','58257','58258','58259','58260','58261','58262','58263','58264','58265','58266','58267','62107') AND `class_id`='1'
?page=###page###
SELECT COUNT(*) as `count` FROM brv_summary_cache WHERE `make_id`='74' AND `type` IN('0','1','2')
322
SELECT `id`, `name`, `full_name`, `sort_name`, `make_id`, `url`, `views`, `type` FROM brv_summary_cache WHERE `make_id`='74' 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('830','831','832','833','834','835','839','840','841','842','843','844','845','846','847','848','849','850','1332','1466','2113','2114','2115','2116','2117','2118','4004','4044','4045','4046','4062','4107','4347','4348','4349','4350','4351','4352','4353','4354','4355','4356','4357','4358','4359','4360','4361','4362','4363','4364','4365','4366','4367','4368','4369','4370','4372','4373','4374','4375','4376','4377','4378','4379','4380','4381','4382','4383','4384','4385','4386','4387','4388','4389','4390','4391','4392','4393','4394','4395','4396','4397','4398','4399','4400','4401','4402','4403','4404','4405','4406','4407','4408','4409','4411','4412','4413','4414','4415','4416','4417','4418','4420','4421','4422','4423','4424','4425','4426','4427','4428','4429','4430','4431','4432','4433','4434','4435','4436','4437','4438','4439','4440','4441','4442','4443','4449','4450','4451','4452','4453','4454','4455','4456','4457','4458','4459','4460','4461','4462','4463','4464','4465','5614','5753','5754','5755','5756','5757','5758','5759','5760','5761','5762','5763','5764','5765','5766','5767','5768','5769','5770','5771','5772','5773','5774','5775','5776','5777','5778','5779','5780','5781','5782','5783','5784','5785','5786','5787','5788','5789','5790','5791','5792','5793','5794','5795','5796','5797','5798','5799','5800','5801','5802','5803','5804','5805','5806','5807','5808','5809','5810','5811','5812','5813','15888','15889','15890','15891','27997','28000','28076','28102','28283','28787','29140','29351','29487','29547','29548','29554','29555','30741','30742','30743','30744','30859','31100','31311','31369','31943')
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 = 848)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 2341) 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`='2341'
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('845','846','847','848','849','850') 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 = 4455)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 32340) 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`='32340'
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('4449','4450','4451','4452','4453','4454','4455','29487') 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 = 4363)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 31120) 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`='31120'
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('4354','4355','4356','4357','4358','4359','4360','4361','4362','4363','4364','27997') 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 = 832)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 2335) 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`='2335'
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('830','831','832','833','834','835') 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 = 28000)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 29194) 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`='29194'
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('4004','4456','4457','4458','4459','28000') ORDER BY price LIMIT 0, 1
SELECT `id`, `name`, `type` FROM nox_group