/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`='porsche' 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`='4'
SELECT id, url, sort_name, full_name, views FROM prints_blueprint WHERE `item_id` IN('5','6','1850','1851','1852','1853','1854','1855','1856','1857','1858','1859','1860','1861','1862','1863','1864','1865','1866','1867','1868','1869','1870','1871','1872','1873','1874','1875','1876','1877','1878','1879','1880','1881','1882','1883','1884','1885','1886','1887','1888','1889','1890','1891','1892','1893','1894','1895','1896','1897','1898','1899','1900','1901','1902','1903','1904','1905','1906','1907','1908','1909','1911','1912','1914','1915','1916','1917','1918','1920','1921','1922','1923','1924','1925','1926','1927','1928','1929','1930','1931','9186','9187','9188','9189','9190','9191','9192','9193','9194','9195','9196','9197','9198','9199','9200','9201','9202','9203','9204','9205','9206','9207','9208','9209','9210','9211','9212','9213','9214','9215','9216','9217','9218','9219','9220','9221','9222','9223','9224','9225','9226','9227','9228','9229','9230','9231','9232','9233','9234','9235','9236','9237','9238','9239','9240','9241','9242','9243','9244','9245','9246','9247','9248','9249','9250','9251','9252','9253','9254','9255','9256','9257','9258','9259','9260','9261','9262','9263','9264','9265','9266','9267','9268','9269','9270','9271','9272','9273','9274','9275','9276','9277','9278','9279','9280','9281','9282','9283','9284','9285','9286','9287','9589','9590','9591','9592','9593','9594','9595','9596','9597','9598','9599','9600','9601','9602','9603','9604','9605','9606','9607','9608','9609','9610','9611','9612','9613','9614','9615','9616','9617','9618','10995','11157','11158','11159','11160','11161','11162','11163','11164','11631','13094','13095','13149','13150','13151','13152','13153','14061','14062','15354','15355','15356','15431','16323','16324','16325','16326','16327','16328','16329','16330','16331','17697','17698','17699','17700','17701','17702','17703','17704','17705','20630','20631','20632','20633','20634','20635','20636','20637','20638','20639','20640','20641','20642','20643','20644','20645','20646','20647','22042','27366','27367','27368','27369','27370','27371','27372','27373','27374','27375','27376','27377','27378','27379','27380','27381','27382','27383','27384','27385','27386','27387','45756','45775','45777','45917','46019','46124','46156','46176','46240','46821','46957','46958','47182','47183','47184','47185','47289','47475','47485','48232','48500','49217','49218','53569','60102','60103','60104','60105','60106','60107','60108','60109','60110','60111','60112','60113','60114','60115','60116','60117','60118','60119','60120','60121','60122','60123','60124','60125','60126','60127','60128','60129','60130','60131','60132','60133','60134','60135','60136','60137','60138','60139','60140','60141','60142','60143','60144','60145','60146','60147','60148','60149','60150','60151','60152','60153','60154','60155','60156','60157','60158','60159','60160','60161','60162','60163','60164','60165','60166','60167','60168','60169','60170','60171','60172','60173','60174','60175','60176','60177','60178','60179','60180','60181','60182','60183','60184','60185','60186','60187','60188','60189','60190','60191','60192','60193','60194','60195','60196','60197','60198','60199','60200','60201','60202','60203','60204','60205','60206','60207','60208','60209','60210','60211','60212','60213','60214','60215','60216','60217','60218','60219','60220','60221','60222','60223','60224','60225','60226','60227','60228','60229','60230','60231','60232','60233','60234','60235','60236','60237','60238','60239','60240','60241','60242','60243','60244','60245','60246','60247','60248','60249','60250','60251','60252','60253','60254','60255','60256','60257','60258','60259','60260','60261','60262','60263','60264','60265','60266','60267','60268','60269','60270','60271','60272','60273','60274','60275','60276','60277','60278','60279','60280','60281','60282','60283','60284','60285','60286','60287','60288','60289','60290','60291','60292','60293','60294','60295','60296','60297','60298','60299','60300','60301','60302','60303','60304','60305','60306','60307','60308','60309','60310','60311','60312','60313','60314','60315','60316','60317','60318','60319','60320','60321','60322','60323','60324','60325','60326','60327','60328','60329','60330','60331','60332','60333','60334','60335','60336','60337','60338','60339','60340','60341','60342','60343','60344','60345','60346','61966','62122','62133','62135') AND `class_id`='1'
SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `item_id` IN('5','6','1850','1851','1852','1853','1854','1855','1856','1857','1858','1859','1860','1861','1862','1863','1864','1865','1866','1867','1868','1869','1870','1871','1872','1873','1874','1875','1876','1877','1878','1879','1880','1881','1882','1883','1884','1885','1886','1887','1888','1889','1890','1891','1892','1893','1894','1895','1896','1897','1898','1899','1900','1901','1902','1903','1904','1905','1906','1907','1908','1909','1911','1912','1914','1915','1916','1917','1918','1920','1921','1922','1923','1924','1925','1926','1927','1928','1929','1930','1931','9186','9187','9188','9189','9190','9191','9192','9193','9194','9195','9196','9197','9198','9199','9200','9201','9202','9203','9204','9205','9206','9207','9208','9209','9210','9211','9212','9213','9214','9215','9216','9217','9218','9219','9220','9221','9222','9223','9224','9225','9226','9227','9228','9229','9230','9231','9232','9233','9234','9235','9236','9237','9238','9239','9240','9241','9242','9243','9244','9245','9246','9247','9248','9249','9250','9251','9252','9253','9254','9255','9256','9257','9258','9259','9260','9261','9262','9263','9264','9265','9266','9267','9268','9269','9270','9271','9272','9273','9274','9275','9276','9277','9278','9279','9280','9281','9282','9283','9284','9285','9286','9287','9589','9590','9591','9592','9593','9594','9595','9596','9597','9598','9599','9600','9601','9602','9603','9604','9605','9606','9607','9608','9609','9610','9611','9612','9613','9614','9615','9616','9617','9618','10995','11157','11158','11159','11160','11161','11162','11163','11164','11631','13094','13095','13149','13150','13151','13152','13153','14061','14062','15354','15355','15356','15431','16323','16324','16325','16326','16327','16328','16329','16330','16331','17697','17698','17699','17700','17701','17702','17703','17704','17705','20630','20631','20632','20633','20634','20635','20636','20637','20638','20639','20640','20641','20642','20643','20644','20645','20646','20647','22042','27366','27367','27368','27369','27370','27371','27372','27373','27374','27375','27376','27377','27378','27379','27380','27381','27382','27383','27384','27385','27386','27387','45756','45775','45777','45917','46019','46124','46156','46176','46240','46821','46957','46958','47182','47183','47184','47185','47289','47475','47485','48232','48500','49217','49218','53569','60102','60103','60104','60105','60106','60107','60108','60109','60110','60111','60112','60113','60114','60115','60116','60117','60118','60119','60120','60121','60122','60123','60124','60125','60126','60127','60128','60129','60130','60131','60132','60133','60134','60135','60136','60137','60138','60139','60140','60141','60142','60143','60144','60145','60146','60147','60148','60149','60150','60151','60152','60153','60154','60155','60156','60157','60158','60159','60160','60161','60162','60163','60164','60165','60166','60167','60168','60169','60170','60171','60172','60173','60174','60175','60176','60177','60178','60179','60180','60181','60182','60183','60184','60185','60186','60187','60188','60189','60190','60191','60192','60193','60194','60195','60196','60197','60198','60199','60200','60201','60202','60203','60204','60205','60206','60207','60208','60209','60210','60211','60212','60213','60214','60215','60216','60217','60218','60219','60220','60221','60222','60223','60224','60225','60226','60227','60228','60229','60230','60231','60232','60233','60234','60235','60236','60237','60238','60239','60240','60241','60242','60243','60244','60245','60246','60247','60248','60249','60250','60251','60252','60253','60254','60255','60256','60257','60258','60259','60260','60261','60262','60263','60264','60265','60266','60267','60268','60269','60270','60271','60272','60273','60274','60275','60276','60277','60278','60279','60280','60281','60282','60283','60284','60285','60286','60287','60288','60289','60290','60291','60292','60293','60294','60295','60296','60297','60298','60299','60300','60301','60302','60303','60304','60305','60306','60307','60308','60309','60310','60311','60312','60313','60314','60315','60316','60317','60318','60319','60320','60321','60322','60323','60324','60325','60326','60327','60328','60329','60330','60331','60332','60333','60334','60335','60336','60337','60338','60339','60340','60341','60342','60343','60344','60345','60346','61966','62122','62133','62135') AND `class_id`='1'
SELECT name FROM prints_make WHERE `id`='4'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE `name_full` LIKE "Porsche%" ORDER BY name_title
?page=###page###
SELECT COUNT(*) as `count` FROM brv_summary_cache WHERE `make_id`='4'
794
SELECT `id`, `name`, `full_name`, `sort_name`, `make_id`, `url`, `views`, `type` FROM brv_summary_cache WHERE `make_id`='4' ORDER BY `sort_name`, `type` LIMIT 100, 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`='4'
SELECT `id`, `tag` FROM tag WHERE `id` IN('171','172','173','518','599','600','908')
SELECT DISTINCT `purchase_id` FROM payment WHERE `status`='approved' AND `purchase_id` IN('2662','2663','2664','2665','2666','2667','2668','2669','2670','2671','2672','2673','2674','2675','2676','2677','2678','2679','4099','9438','9439','9440','9441','9442','9443','9444','9445','9446','9447','9448','9449','9450','9451','9452','9453','9454','9455','9456','9457','9459','27837','27857','27859','28011','28113','28223','28253','28273','28331','28904','29038','29039','29250','29251','29252','29253','29357','29543','29553','30261','30529','31228','31229','31801','31959','31970','31972')
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 = 2671) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 34300) 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`='34300'
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('2662','2663','2664','2665','2666','2667','2668','2669','2670','2671','2672','2673','2674','2675','2676','2677','2678','28223','28253','28331','28904','29038','29039','29357','29543','29553','30529','31970','31972') 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 = 2664) 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 = 9446) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 29681) 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`='29681'
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('9444','9445','9446','9450','9452','28113') 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 = 2662) 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 = 9444) 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 = 9448) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 9685) 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 = 28253) 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 = 2663) 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 = 28331) 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('2665','2666','2667','2668','2669','2670','2672','2673','2674','2675','2676','2677','2678','2679','4099','9438','9439','9440','9441','9442','9443','9445','9447','9449','9450','9451','9452','9453','9454','9455','9456','9457','9459','27837','27857','27859','28011','28113','28223','28273','28904','29038','29039','29250','29251','29252','29253','29357','29543','29553','30261','30529','31228','31229','31801','31959','31970','31972')
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 = 28011) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 35554) 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`='35554'
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('28011','31228','31229') 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 = 29543) 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`=1 AND `id` IN('2665','2666','2667','2668','2669','2670','2672','2673','2674','2675','2676','2677','2678','2679','4099','9438','9439','9440','9441','9442','9443','9445','9447','9449','9450','9451','9452','9453','9454','9455','9456','9457','9459','27837','27857','27859','28113','28223','28273','28904','29038','29039','29250','29251','29252','29253','29357','29553','30261','30529','31228','31229','31801','31959','31970','31972')
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 = 27857) 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`='27857'
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 = 4099) 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`='4099'
SELECT `id`, `name`, `type` FROM nox_group