/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`='mclaren' 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`='90'
SELECT id, url, sort_name, full_name, views FROM prints_blueprint WHERE `item_id` IN('3280','3283','3284','3285','3286','3287','3288','9744','9745','9746','9747','9748','9749','9750','9751','9752','9753','9754','9755','9756','9757','9758','9759','9760','9761','9762','9763','9764','9765','9766','9767','9768','9769','9770','9771','9772','9773','9774','9775','9776','9777','9778','9779','9780','9781','9782','9783','9784','9785','9786','9787','9788','9789','9790','9791','9792','9793','9794','9795','9796','9797','11017','11018','11019','11020','11962','11987','12163','12164','12165','12166','12167','12168','12169','12170','12171','12172','12173','12174','12175','12176','12177','12178','12179','12180','12181','12182','12183','12184','12185','12186','12187','12188','12189','12190','12191','12192','12193','13131','13132','13133','13134','13135','13324','14000','14001','14002','16280','16281','16282','16450','16451','17176','17177','17178','17179','17180','17181','17182','17183','17184','17185','17186','17187','17610','17611','17612','17613','17614','17615','17616','17617','17618','22040','25358','25359','25360','25361','25362','25363','25364','25365','25366','25367','45710','45714','45763','45764','45765','45767','45992','46048','46111','46123','46157','46158','46159','46160','46161','46162','46163','46181','46201','46202','48227','58749','58750','58751','58752','58753','58754','58755','58756','58757','58758','58759','58760','58761','58762','58763','58764','58765','58766','58767','58768','58769','58770','58771','58772','58773','58774','58775','58776','58777','58778','58779','58780','58781','58782','58783','58784','58785','58786','58787','58788','58789','58790','58791','58792','58793','58794','61894','62109') AND `class_id`='1'
SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `item_id` IN('3280','3283','3284','3285','3286','3287','3288','9744','9745','9746','9747','9748','9749','9750','9751','9752','9753','9754','9755','9756','9757','9758','9759','9760','9761','9762','9763','9764','9765','9766','9767','9768','9769','9770','9771','9772','9773','9774','9775','9776','9777','9778','9779','9780','9781','9782','9783','9784','9785','9786','9787','9788','9789','9790','9791','9792','9793','9794','9795','9796','9797','11017','11018','11019','11020','11962','11987','12163','12164','12165','12166','12167','12168','12169','12170','12171','12172','12173','12174','12175','12176','12177','12178','12179','12180','12181','12182','12183','12184','12185','12186','12187','12188','12189','12190','12191','12192','12193','13131','13132','13133','13134','13135','13324','14000','14001','14002','16280','16281','16282','16450','16451','17176','17177','17178','17179','17180','17181','17182','17183','17184','17185','17186','17187','17610','17611','17612','17613','17614','17615','17616','17617','17618','22040','25358','25359','25360','25361','25362','25363','25364','25365','25366','25367','45710','45714','45763','45764','45765','45767','45992','46048','46111','46123','46157','46158','46159','46160','46161','46162','46163','46181','46201','46202','48227','58749','58750','58751','58752','58753','58754','58755','58756','58757','58758','58759','58760','58761','58762','58763','58764','58765','58766','58767','58768','58769','58770','58771','58772','58773','58774','58775','58776','58777','58778','58779','58780','58781','58782','58783','58784','58785','58786','58787','58788','58789','58790','58791','58792','58793','58794','61894','62109') AND `class_id`='1'
SELECT name FROM prints_make WHERE `id`='90'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `name_full` LIKE "McLaren%" ORDER BY name_title
?page=###page###
SELECT COUNT(*) as `count` FROM brv_summary_cache WHERE `make_id`='90'
328
SELECT `id`, `name`, `full_name`, `sort_name`, `make_id`, `url`, `views`, `type` FROM brv_summary_cache WHERE `make_id`='90' 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`='90'
SELECT `id`, `tag` FROM tag WHERE `id` IN('518','590')
SELECT DISTINCT `purchase_id` FROM payment WHERE `status`='approved' AND `purchase_id` IN('4097','7430','7431','7432','7433','7434','7435','7436','7437','7438','7439','27788','27792','27845','27846','27847','27849','28086','28144','28210','28222','28254','28255','28256','28257','28258','28259','28260','28278','28298','28299','30256','31729','31945')
SELECT set_id FROM prints_set_vector WHERE `vector_id`='27845'
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`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `id`='27845'
SELECT `id`, `name_full` FROM `prints_set` WHERE "1999 - 1999 mclaren mp4/14 f1 formula" LIKE CONCAT(LOWER(`name_full`), "%") ORDER BY CHAR_LENGTH(`name_full`) DESC, `id` ASC LIMIT 1
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`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `id`='27845'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='27847'
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`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `id`='27847'
SELECT `id`, `name_full` FROM `prints_set` WHERE "2001 - 2001 mclaren mp4/16 f1 formula" LIKE CONCAT(LOWER(`name_full`), "%") ORDER BY CHAR_LENGTH(`name_full`) DESC, `id` ASC LIMIT 1
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`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `id`='27847'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='28086'
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`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `id`='28086'
SELECT `id`, `name_full` FROM `prints_set` WHERE "1982 - 1982 mclaren mp4/1b f1 formula" LIKE CONCAT(LOWER(`name_full`), "%") ORDER BY CHAR_LENGTH(`name_full`) DESC, `id` ASC LIMIT 1
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`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `id`='28086'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='27849'
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`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `id`='27849'
SELECT `id`, `name_full` FROM `prints_set` WHERE "1999 - 2001 mclaren mp4/14 mp4/15 mp4/16 top views 19 x 3 formula" LIKE CONCAT(LOWER(`name_full`), "%") ORDER BY CHAR_LENGTH(`name_full`) DESC, `id` ASC LIMIT 1
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`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `id`='27849'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='27846'
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`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `id`='27846'
SELECT `id`, `name_full` FROM `prints_set` WHERE "2000 - 2000 mclaren mp4/15 f1 formula" LIKE CONCAT(LOWER(`name_full`), "%") ORDER BY CHAR_LENGTH(`name_full`) DESC, `id` ASC LIMIT 1
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`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `id`='27846'
SELECT `id`, `name`, `type` FROM nox_group