/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`='subaru' 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`='130'
SELECT id, url, sort_name, full_name, views FROM prints_blueprint WHERE `item_id` IN('2762','2763','2764','2765','2766','2767','2768','2769','2770','2771','2772','2773','2774','2775','2776','2777','2778','2779','2780','2781','2782','2783','2784','2785','2786','2787','2788','2789','2790','2791','2792','2793','2794','2795','2796','2797','2798','2799','2800','2801','2802','2803','2804','2805','2806','2807','2808','2809','2810','2811','2812','2813','2814','2815','2816','2817','2818','2819','2820','2821','2822','2823','2824','2825','2826','2827','2828','2829','2830','2831','2832','2833','2834','2835','2836','2837','2838','2839','2840','2841','2842','2843','2844','2845','2846','10399','10400','10401','10402','10403','10404','10405','10406','10407','10408','10409','10410','10411','10412','10413','10414','10415','10416','10417','10418','10419','10420','11369','11370','11371','11372','11373','11374','11375','11376','11377','11378','11379','11380','11381','11382','11383','11384','11385','11386','11387','11388','11389','11390','11391','11392','11393','11394','12735','13370','13371','13785','14114','14115','16349','16350','17792','17793','17794','19077','19078','19079','19080','19081','19082','19231','19970','20280','20281','20282','20283','20284','20285','20286','20287','20288','20289','20290','20291','20292','20293','20294','20295','20296','20297','20298','20299','20300','20301','20302','20303','20304','20305','20306','20307','20308','20309','20995','20996','20997','20998','20999','21000','22047','22048','22859','22860','22926','24568','24569','24582','24583','26075','26076','27683','27684','27685','27686','27687','27688','27689','27690','27691','27692','27693','27694','27695','27696','27697','27698','27699','27700','27701','27702','27703','27704','27705','27706','27709','27710','27711','27712','27713','27714','27715','27716','27717','27718','27719','27720','27721','27722','27723','27724','27725','27726','27727','27728','27729','27730','27731','27732','27733','27734','27735','27736','27737','27738','27739','27740','27741','27742','27743','27744','27745','27746','27747','27748','27749','27750','27751','27752','27753','27754','27755','27756','27757','27758','27759','27760','27761','27762','27763','27764','27765','27766','27767','27768','27769','27770','27771','27772','27773','27774','27775','27776','27777','27778','27779','27780','27781','27782','27783','27784','27785','27786','27787','27788','27789','27790','27791','27792','27793','27794','27798','27799','27800','27801','27802','27803','27804','27805','27806','27807','27808','27809','27810','27811','27812','27813','27815','27816','27817','27818','27819','27820','27821','27822','27823','27824','27825','27826','27827','27828','27833','27834','27835','27836','27837','27838','27839','45906','45909','46016','46101','46428','46429','46430','46431','46432','46433','46434','46435','46436','46437','46438','46439','46998','47180','47181','48455','48456','48457','50299','50300','50301','50302','50303','50304','50305','50306','50307','50308','50309','50310','50311','50312','50313','50688','60844','60845','60846','60847','60848','60849','60850','60851','60852','60853','60854','60855','60856','60857','60858','60859','60860','60861','60862','60863','60864','60865','60866','60867','60868','60869','60870','60871','60872','60873','60874','60875','60876','60877','60878','60879','60880','60881','60882','60883','60884','60885','60886','60887','60888','60889','60890','60891','60892','60893','60894','60895','60896','60897','60898','60899','60900','60901','60902','61884','61885','62111','62112','62120') AND `class_id`='1'
SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `item_id` IN('2762','2763','2764','2765','2766','2767','2768','2769','2770','2771','2772','2773','2774','2775','2776','2777','2778','2779','2780','2781','2782','2783','2784','2785','2786','2787','2788','2789','2790','2791','2792','2793','2794','2795','2796','2797','2798','2799','2800','2801','2802','2803','2804','2805','2806','2807','2808','2809','2810','2811','2812','2813','2814','2815','2816','2817','2818','2819','2820','2821','2822','2823','2824','2825','2826','2827','2828','2829','2830','2831','2832','2833','2834','2835','2836','2837','2838','2839','2840','2841','2842','2843','2844','2845','2846','10399','10400','10401','10402','10403','10404','10405','10406','10407','10408','10409','10410','10411','10412','10413','10414','10415','10416','10417','10418','10419','10420','11369','11370','11371','11372','11373','11374','11375','11376','11377','11378','11379','11380','11381','11382','11383','11384','11385','11386','11387','11388','11389','11390','11391','11392','11393','11394','12735','13370','13371','13785','14114','14115','16349','16350','17792','17793','17794','19077','19078','19079','19080','19081','19082','19231','19970','20280','20281','20282','20283','20284','20285','20286','20287','20288','20289','20290','20291','20292','20293','20294','20295','20296','20297','20298','20299','20300','20301','20302','20303','20304','20305','20306','20307','20308','20309','20995','20996','20997','20998','20999','21000','22047','22048','22859','22860','22926','24568','24569','24582','24583','26075','26076','27683','27684','27685','27686','27687','27688','27689','27690','27691','27692','27693','27694','27695','27696','27697','27698','27699','27700','27701','27702','27703','27704','27705','27706','27709','27710','27711','27712','27713','27714','27715','27716','27717','27718','27719','27720','27721','27722','27723','27724','27725','27726','27727','27728','27729','27730','27731','27732','27733','27734','27735','27736','27737','27738','27739','27740','27741','27742','27743','27744','27745','27746','27747','27748','27749','27750','27751','27752','27753','27754','27755','27756','27757','27758','27759','27760','27761','27762','27763','27764','27765','27766','27767','27768','27769','27770','27771','27772','27773','27774','27775','27776','27777','27778','27779','27780','27781','27782','27783','27784','27785','27786','27787','27788','27789','27790','27791','27792','27793','27794','27798','27799','27800','27801','27802','27803','27804','27805','27806','27807','27808','27809','27810','27811','27812','27813','27815','27816','27817','27818','27819','27820','27821','27822','27823','27824','27825','27826','27827','27828','27833','27834','27835','27836','27837','27838','27839','45906','45909','46016','46101','46428','46429','46430','46431','46432','46433','46434','46435','46436','46437','46438','46439','46998','47180','47181','48455','48456','48457','50299','50300','50301','50302','50303','50304','50305','50306','50307','50308','50309','50310','50311','50312','50313','50688','60844','60845','60846','60847','60848','60849','60850','60851','60852','60853','60854','60855','60856','60857','60858','60859','60860','60861','60862','60863','60864','60865','60866','60867','60868','60869','60870','60871','60872','60873','60874','60875','60876','60877','60878','60879','60880','60881','60882','60883','60884','60885','60886','60887','60888','60889','60890','60891','60892','60893','60894','60895','60896','60897','60898','60899','60900','60901','60902','61884','61885','62111','62112','62120') AND `class_id`='1'
SELECT name FROM prints_make WHERE `id`='130'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE `name_full` LIKE "Subaru%" ORDER BY name_title
?page=###page###
SELECT COUNT(*) as `count` FROM brv_summary_cache WHERE `make_id`='130'
582
SELECT `id`, `name`, `full_name`, `sort_name`, `make_id`, `url`, `views`, `type` FROM brv_summary_cache WHERE `make_id`='130' ORDER BY `sort_name`, `type` LIMIT 400, 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`='130'
SELECT `id`, `tag` FROM tag WHERE `id` IN('177','518')
SELECT DISTINCT `purchase_id` FROM payment WHERE `status`='approved' AND `purchase_id` IN('1165','1166','1167','1168','1169','1170','1320','2002','2312','2313','2314','2315','2316','2317','2318','2319','2320','2321','2322','2323','2324','2325','2326','2327','2328','2329','2330','2331','2332','2333','2334','2335','2336','2337','2338','2339','2340','2341','3028','4105','4106','4928','4929','4995','6640','6641','6654','6655','8147','8148','9755','9756','9757','9758','9759','9760','9761','9762','9763','9764','9765','9766','9767','9768','9769','9770','9771','9772','9773','9774','9775','9776','9777','9778','9781','9782','9783','9784','9785','9786','9787','9788','9789','9790','9791','9792','9793','9794','9795','9796','9797','9798','9799','9800','9801','9802','9803','9804','9805','9806','9807','9808','9809','9810','9811','9812','9813','9814','9815','9816','9817','9818','9819','9820','9821','9822','9823','9824','9825','9826','9827','9828','9829','9830','9831','9832','9833','9834','9835','9836','9837','9838','9839','9840','9841','9842','9843','9844','9845','9846','9847','9848','9849','9850','9851','9852','9853','9854','9855','9856','9857','9858','9859','9860','9861','9862','9863','9864','9865','9866','9870','9871','9872','9873','9874','9875','9876','9877','9878','9879','9880','9881','9882','9883','9884','9885','9887','9888','9889','9890','9891','9892','9893','9894','9895','9896','9897','9898','9899','9900','9905','9906','9907','9908','9909','9910','9911','27999','28002','28110','28200','28513','28514','28515','28516','28517','28518','28519','28520','28521','28522','28523','28524','29076','29248','29249','30484','30485','30486','31252','31718','31719','31947','31948','31957')
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 = 1167) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 33944) 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`='33944'
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('1167','1169','1320','2339','2340','2341','3028') 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 = 2332) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 33998) 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`='33998'
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('1170','2312','2313','2314','2315','2316','2317','2318','2319','2320','2321','2322','2323','2324','2325','2326','2327','2328','2332','28514','31957') 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 = 29248) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 32020) 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`='32020'
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('8147','8148','9819','9820','9821','9822','9823','9824','9825','9826','9827','9828','9829','9830','9831','9832','9833','9834','9835','9836','9837','9838','9839','9840','9841','9842','29248','29249') 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 = 9796) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 31635) 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`='31635'
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('4105','4106','9784','9785','9786','9791','9792','9793','9794','9795','9796','9797','9806','9807','9808','9809','9814','29076') 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 = 9835) 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 = 9791) 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 = 9785) 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 = 9873) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 10047) 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 = 1165) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 36330) 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`='36330'
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('1165','1166','1168','2329','2330','2331','2333','2334','2335','2336','2337','2338','31252') ORDER BY price LIMIT 0, 1
SELECT `id`, `name`, `type` FROM nox_group