/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`='isuzu' 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`='66'
SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `item_id` IN('5124','5125','5126','5127','5128','5129','5130','5131','5132','5133','5134','5135','5136','5137','5138','5139','5140','10827','10828','10829','10830','10831','10832','10833','10834','10835','10836','10837','10838','10839','11326','11327','11997','11998','13686','13687','13688','13689','13690','13691','13692','13693','13694','13695','13696','13697','13698','13699','16216','16943','16945','16946','16947','17534','17535','17740','19048','19072','19097','19098','19099','19100','19101','19102','19472','19543','19544','19545','19546','19547','19548','19549','19550','19551','20515','20516','20517','20518','20519','20520','21677','23448','23449','24529','24530','24531','24532','24533','24534','24535','24536','24537','24538','24539','24540','24541','24542','24543','24544','24545','24546','24547','24548','24549','24554','24555','24556','24557','24559','24560','24561','24562','24563','24570','24571','24572','24573','24574','24575','24586','24587','24588','24589','24590','24591','24598','24599','24600','24601','24602','24603','24604','24605','24606','24607','24608','24609','24610','24611','24612','24613','24622','24623','24624','24625','24626','24627','24628','24629','24630','24631','24632','24633','24634','24635','24636','24637','24638','24639','24640','24641','24642','24643','24644','24645','24646','24647','24648','24649','24650','24651','24652','24653','24654','24655','24656','24657','24658','24659','24660','24679','24680','24681','24682','25887','25962','25963','25964','25965','25966','25967','25968','25969','25970','25971','25984','25985','25986','25987','25988','25989','25990','25991','26004','26005','26006','26007','26008','26009','26010','26011','26041','26152','26153','26154','26155','26156','26157','26158','26159','26160','26161','26162','26163','26180','26181','26190','26191','26192','26193','26206','26207','26208','26209','26283','26284','27795','27796','27797','27918','27919','29760','29761','29762','29763','29764','29765','29766','29767','29768','29769','29770','29771','31571','31572','31573','31952','31953','31954','33611','33612','33613','45786','46105','46197','46503','46637','46700','46701','46702','46703','46800','46801','46802','46803','46804','46805','46806','46837','46944','47001','47591','47627','48021','48281','48282','48283','48284','48285','48286','48287','48288','48289','48290','48291','48292','48388','48389','48390','48391','48392','48405','48408','48409','48417','48418','48513','48514','48515','48516','48517','48518','48519','48520','48521','48522','48523','48524','48525','48585','48586','48587','48588','48669','48670','48671','49103','49670','49671','49672','49673','49674','49675','49676','49677','49678','49679','49680','49681','49682','49683','49684','49685','49686','49687','49688','49689','50134','50135','50136','50137','50138','50139','50140','50141','50142','50143','50144','50145','50146','50147','50902','50903','50904','50905','50906','50907','50908','50909','50954','50955','50956','50957','51432','51433','51434','51435','51436','51437','51438','51439','51440','51441','51442','51443','51444','51445','51446','51447','51448','51449','51450','51451','51452','51453','51454','51455','51456','51457','51458','51459','51460','51461','51462','51463','51464','51465','51466','51467','51468','51469','51470','51471','51472','51473','51474','51475','51476','51477','51478','51479','51480','51481','51482','58123','58124','58125','62064','62075','62076') AND `class_id`='1'
?page=###page###
SELECT COUNT(*) as `count` FROM brv_summary_cache WHERE `make_id`='66' AND `type` IN('0','1','2')
353
SELECT `id`, `name`, `full_name`, `sort_name`, `make_id`, `url`, `views`, `type` FROM brv_summary_cache WHERE `make_id`='66' 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('1136','1160','1185','1186','1187','1188','1189','1190','1554','1595','1596','1597','1598','1599','1600','1601','1602','1603','2547','2548','2549','2550','2551','2552','3709','5520','5521','6601','6602','6603','6604','6605','6606','6607','6608','6609','6610','6611','6612','6613','6614','6615','6616','6617','6618','6619','6620','6621','6626','6627','6628','6629','6631','6632','6633','6634','6635','6642','6643','6644','6645','6646','6647','6658','6659','6660','6661','6662','6663','6670','6671','6672','6673','6674','6675','6676','6677','6678','6679','6680','6681','6682','6683','6684','6685','6694','6695','6696','6697','6698','6699','6700','6701','6702','6703','6704','6705','6706','6707','6708','6709','6710','6711','6712','6713','6714','6715','6716','6717','6718','6719','6720','6721','6722','6723','6724','6725','6726','6727','6728','6729','6730','6731','6732','6751','6752','6753','6754','8034','8035','8036','8037','8038','8039','8040','8041','8042','8043','8056','8057','8058','8059','8060','8061','8062','8063','8076','8077','8078','8079','8080','8081','8082','8083','8113','8224','8225','8226','8227','8228','8229','8230','8231','8232','8233','8234','8235','8252','8253','8262','8263','8264','8265','8278','8279','8280','8281','8355','8356','9867','9868','9869','9990','9991','11833','11834','11835','11836','11837','11838','11839','11840','11841','11842','11843','11844','13647','13648','13649','14028','14029','14030','15687','15688','15689','27870','28204','28294','28588','28720','28783','28784','28785','28786','28883','28884','28885','28886','28887','28888','28889','28920','29025','29079','29659','29695','30061','30310','30311','30312','30313','30314','30315','30316','30317','30318','30319','30320','30321','30417','30418','30419','30420','30421','30434','30437','30438','30446','30447','30542','30543','30544','30545','30546','30547','30548','30549','30550','30551','30553','30554','30611','30612','30613','30614','30695','30696','30697','31119','31459','31460','31461','31462','31463','31464','31465','31466','31511','31512','31513','31514','31900','31911','31912')
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 = 1136)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 36007) 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`='36007'
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('1136','1160','28785','30310','30311','30312','30313','31459') 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 = 28786)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 36008) 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`='36008'
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('27870','28786','30611','30612','30613','30614','31460') 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 = 1189)
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`='1189' 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 = 28588)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 36058) 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`='36058'
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('1554','1595','1596','1597','1598','1599','1600','1601','1602','1603','3709','28588','28720','29659') 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 = 29659)
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 = 1187)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 36014) 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`='36014'
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('1187','1188','30434','31465') ORDER BY price LIMIT 0, 1
SELECT `id`, `name`, `type` FROM nox_group