/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`='daihatsu' 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`='35'
SELECT id, url, sort_name, full_name, views FROM prints_blueprint WHERE `item_id` IN('1284','1285','1286','1287','1288','1289','1290','1291','1292','1293','1294','1295','1296','1297','1298','1299','1300','1301','1302','1303','1304','1305','1306','1307','1308','1309','1310','1311','1312','10767','10768','10769','10770','10771','10772','10773','10774','10775','10776','10777','10778','10779','10780','10781','10782','10783','10784','10785','10786','10787','10788','10789','10790','10791','10952','15762','15763','17410','17411','17412','18960','18961','19916','19917','19918','22870','22897','22900','24023','24024','24025','24026','24027','24028','24029','24030','24031','24032','24033','24034','24037','24038','24039','24040','24041','24043','24044','24045','24046','24047','24048','24049','24050','24051','24052','24053','24054','24055','24056','24057','24058','24059','24060','24062','24063','24065','24067','24068','24069','24070','24071','24072','24073','24074','24075','24076','24077','24078','24079','24080','24081','24082','24083','24084','24085','24086','24087','24088','24089','24090','24091','24092','24093','24094','24095','24096','24097','24098','24099','24100','24101','24102','24103','24104','24105','24106','24107','24108','24109','24110','24111','24112','24113','24114','24115','24116','24117','24118','24119','24120','24121','24122','24123','24124','24125','24126','24127','24128','24129','24130','24131','24132','24133','24134','24135','24136','24137','24138','24139','24140','24141','24142','24143','24144','24145','24146','24147','24148','24149','24150','24151','24152','24153','24154','24155','24156','24157','24158','24159','24160','24163','24164','24165','24166','24167','24168','24169','27814','28464','28465','28466','28467','28473','28640','28641','28642','29020','29021','29028','29053','29054','29055','29056','29081','29082','29083','29084','29089','29090','29111','29112','29119','29120','29121','29122','29123','29124','29125','29126','29127','29128','29129','29130','29131','29132','29133','29134','29135','29136','29137','29138','29139','29140','29141','29142','29143','29144','29145','29146','29147','29148','29149','29150','29151','29152','29153','29154','29155','29156','29157','29158','29159','29160','29161','29162','29163','29164','29165','29166','29167','29168','29169','29170','29171','29172','29173','29174','29175','29176','29177','29178','29179','29180','29181','29182','29183','29184','29185','29186','29187','29188','29189','29190','29191','29192','29193','29194','29195','29196','29197','29198','29199','29200','29201','29202','29203','29204','29208','29209','29210','29211','29212','29213','29214','29215','29216','29217','29218','29219','29284','47941','48372','48451','48452','48453','49943','49944','50813','51180','51181','52523','52524','52525','52526','52527','56017','56018','56019','56020','56021','56022','56023','56024','56025','56026','56027','56028','56029','56030','56031','56032','56033','56034','56035','56036','56037','56038','56039','56040','56041','56042','56043','56044','56045','56046','56047','56048','56049','56050','56051') AND `class_id`='1'
SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `item_id` IN('1284','1285','1286','1287','1288','1289','1290','1291','1292','1293','1294','1295','1296','1297','1298','1299','1300','1301','1302','1303','1304','1305','1306','1307','1308','1309','1310','1311','1312','10767','10768','10769','10770','10771','10772','10773','10774','10775','10776','10777','10778','10779','10780','10781','10782','10783','10784','10785','10786','10787','10788','10789','10790','10791','10952','15762','15763','17410','17411','17412','18960','18961','19916','19917','19918','22870','22897','22900','24023','24024','24025','24026','24027','24028','24029','24030','24031','24032','24033','24034','24037','24038','24039','24040','24041','24043','24044','24045','24046','24047','24048','24049','24050','24051','24052','24053','24054','24055','24056','24057','24058','24059','24060','24062','24063','24065','24067','24068','24069','24070','24071','24072','24073','24074','24075','24076','24077','24078','24079','24080','24081','24082','24083','24084','24085','24086','24087','24088','24089','24090','24091','24092','24093','24094','24095','24096','24097','24098','24099','24100','24101','24102','24103','24104','24105','24106','24107','24108','24109','24110','24111','24112','24113','24114','24115','24116','24117','24118','24119','24120','24121','24122','24123','24124','24125','24126','24127','24128','24129','24130','24131','24132','24133','24134','24135','24136','24137','24138','24139','24140','24141','24142','24143','24144','24145','24146','24147','24148','24149','24150','24151','24152','24153','24154','24155','24156','24157','24158','24159','24160','24163','24164','24165','24166','24167','24168','24169','27814','28464','28465','28466','28467','28473','28640','28641','28642','29020','29021','29028','29053','29054','29055','29056','29081','29082','29083','29084','29089','29090','29111','29112','29119','29120','29121','29122','29123','29124','29125','29126','29127','29128','29129','29130','29131','29132','29133','29134','29135','29136','29137','29138','29139','29140','29141','29142','29143','29144','29145','29146','29147','29148','29149','29150','29151','29152','29153','29154','29155','29156','29157','29158','29159','29160','29161','29162','29163','29164','29165','29166','29167','29168','29169','29170','29171','29172','29173','29174','29175','29176','29177','29178','29179','29180','29181','29182','29183','29184','29185','29186','29187','29188','29189','29190','29191','29192','29193','29194','29195','29196','29197','29198','29199','29200','29201','29202','29203','29204','29208','29209','29210','29211','29212','29213','29214','29215','29216','29217','29218','29219','29284','47941','48372','48451','48452','48453','49943','49944','50813','51180','51181','52523','52524','52525','52526','52527','56017','56018','56019','56020','56021','56022','56023','56024','56025','56026','56027','56028','56029','56030','56031','56032','56033','56034','56035','56036','56037','56038','56039','56040','56041','56042','56043','56044','56045','56046','56047','56048','56049','56050','56051') AND `class_id`='1'
SELECT name FROM prints_make WHERE `id`='35'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE `name_full` LIKE "Daihatsu%" ORDER BY name_title
?page=###page###
SELECT COUNT(*) as `count` FROM brv_summary_cache WHERE `make_id`='35'
447
SELECT `id`, `name`, `full_name`, `sort_name`, `make_id`, `url`, `views`, `type` FROM brv_summary_cache WHERE `make_id`='35' 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`='35'
SELECT `id`, `tag` FROM tag WHERE `id` IN('518','731','732','878')
SELECT DISTINCT `purchase_id` FROM payment WHERE `status`='approved' AND `purchase_id` IN('1047','1048','1963','1964','1965','4939','4966','4969','6095','6096','6097','6098','6099','6100','6101','6102','6103','6104','6105','6106','6109','6110','6111','6112','6113','6115','6116','6117','6118','6119','6120','6121','6122','6123','6124','6125','6126','6127','6128','6129','6130','6131','6132','6134','6135','6137','6139','6140','6141','6142','6143','6144','6145','6146','6147','6148','6149','6150','6151','6152','6153','6154','6155','6156','6157','6158','6159','6160','6161','6162','6163','6164','6165','6166','6167','6168','6169','6170','6171','6172','6173','6174','6175','6176','6177','6178','6179','6180','6181','6182','6183','6184','6185','6186','6187','6188','6189','6190','6191','6192','6193','6194','6195','6196','6197','6198','6199','6200','6201','6202','6203','6204','6205','6206','6207','6208','6209','6210','6211','6212','6213','6214','6215','6216','6217','6218','6219','6220','6221','6222','6223','6224','6225','6226','6227','6228','6229','6230','6231','6232','6235','6236','6237','6238','6239','6240','6241','9886','10536','10537','10538','10539','10545','10712','10713','10714','11092','11093','11100','11125','11126','11127','11128','11153','11154','11155','11156','11161','11162','11183','11184','11191','11192','11193','11194','11195','11196','11197','11198','11199','11200','11201','11202','11203','11204','11205','11206','11207','11208','11209','11210','11211','11212','11213','11214','11215','11216','11217','11218','11219','11220','11221','11222','11223','11224','11225','11226','11227','11228','11229','11230','11231','11232','11233','11234','11235','11236','11237','11238','11239','11240','11241','11242','11243','11244','11245','11246','11247','11248','11249','11250','11251','11252','11253','11254','11255','11256','11257','11258','11259','11260','11261','11262','11263','11264','11265','11266','11267','11268','11269','11270','11271','11272','11273','11274','11275','11276','11280','11281','11282','11283','11284','11285','11286','11287','11288','11289','11290','11291','11356','29990','30401','30480','30481','30482','31370')
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 = 11272) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 36046) 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`='36046'
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('11191','11192','11195','11196','11198','11199','11200','11201','11202','11203','11204','11205','11206','11207','11208','11215','11216','11217','11218','11235','11236','11237','11238','11239','11240','11259','11260','11261','11262','11263','11264','11271','11272','11273','11280','11281','11282','30480') 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 = 11280) ORDER BY name_title
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 = 6194) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 6794) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 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 = 11282) 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 `prepay`=0 AND `id` IN('1047','1048','1963','1964','1965','4939','4966','4969','6095','6096','6097','6098','6099','6100','6101','6102','6103','6104','6105','6106','6109','6110','6111','6112','6113','6115','6116','6117','6118','6119','6120','6121','6122','6123','6124','6125','6126','6127','6128','6129','6130','6131','6132','6134','6135','6137','6139','6140','6141','6142','6143','6144','6145','6146','6147','6148','6149','6150','6151','6152','6153','6154','6155','6156','6157','6158','6159','6160','6161','6162','6163','6164','6165','6166','6167','6168','6169','6170','6171','6172','6173','6174','6175','6176','6177','6178','6179','6180','6181','6182','6183','6184','6185','6186','6187','6188','6189','6190','6191','6192','6193','6195','6196','6197','6198','6199','6200','6201','6202','6203','6204','6205','6206','6207','6208','6209','6210','6211','6212','6213','6214','6215','6216','6217','6218','6219','6220','6221','6222','6223','6224','6225','6226','6227','6228','6229','6230','6231','6232','6235','6236','6237','6238','6239','6240','6241','9886','10536','10537','10538','10539','10545','10712','10713','10714','11092','11093','11100','11125','11126','11127','11128','11153','11154','11155','11156','11161','11162','11183','11184','11191','11192','11193','11194','11195','11196','11197','11198','11199','11200','11201','11202','11203','11204','11205','11206','11207','11208','11209','11210','11211','11212','11213','11214','11215','11216','11217','11218','11219','11220','11221','11222','11223','11224','11225','11226','11227','11228','11229','11230','11231','11232','11233','11234','11235','11236','11237','11238','11239','11240','11241','11242','11243','11244','11245','11246','11247','11248','11249','11250','11251','11252','11253','11254','11255','11256','11257','11258','11259','11260','11261','11262','11263','11264','11265','11266','11267','11268','11269','11270','11271','11273','11274','11275','11276','11281','11283','11284','11285','11286','11287','11288','11289','11290','11291','11356','29990','30401','30480','30481','30482','31370')
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 = 1048) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 6710) 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`='6710'
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('1047','1048','1963','1964','1965','6116','6117','6118','6119','6121','6122','6123','6124','6127','6128','6129') 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 = 30481) 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`='30481' 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 = 30482) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 35880) 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`='35880'
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('11227','11228','11229','11230','11241','11242','11243','11244','11245','11246','11265','11266','11267','11268','11269','11270','11274','11275','11276','11283','11284','11285','30482','31370') 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 = 29990) 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`='29990' ORDER BY price LIMIT 0, 1
SELECT `id`, `name`, `type` FROM nox_group