/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`='austin' 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`='12'
SELECT id, url, sort_name, full_name, views FROM prints_blueprint WHERE `item_id` IN('289','290','291','292','293','294','295','296','297','298','299','300','301','302','303','304','305','306','4267','6981','8900','8901','10537','10538','10539','10540','10541','10542','10543','10544','10545','10546','10547','10548','10549','10550','10551','10552','10553','10554','10556','10557','10558','10559','10560','10561','10562','10563','10564','10565','10566','10567','10568','10569','10570','10571','10572','10573','10574','10575','10576','10577','10578','10579','10580','10581','10582','10583','10584','10585','10587','10588','10589','10590','10591','10592','10593','10594','10595','10596','10597','10598','10599','10600','10601','10603','10604','10605','10606','10607','10608','10609','10610','10611','10612','10613','10614','10615','10617','10618','10619','10620','10621','10622','10623','10624','10626','10627','10628','10629','10630','10631','10632','10633','10634','10635','10636','10637','10638','10639','10640','10641','10642','10643','10644','10939','10941','11969','11970','12900','12901','12902','12903','12904','12905','12906','12907','12908','13221','13222','13223','13825','13826','13827','13828','13829','15298','15299','15300','15732','15733','15734','15735','15736','15737','15738','16080','16081','16082','16083','16084','16407','17272','17273','17274','17275','17276','17277','17279','17280','17281','17282','17284','22375','22376','30171','30223','45725','46010','46076','46113','46125','46132','46133','46194','46195','46961','47466','48199','49025','49250','49251','49252','51101','51102','51103','51104','51105','51106','51107','51108','51109','51110','51111','51112','51113','52312','52313','52314','52315','52316','52317','52318','52319','52320','52321','52322','54468','54469','54470','54471','54472','54473','54474','54475','54476','54477','54478','54479','54480','54481','54482','54483','54484','54485','54486','54487','54488','54489','54490','54491','54492','54493','54494','54495','54496','54497','54498','54499','54500','54501','54502','54503','54504','54505','54506','54507','54508','54509','54510','54511','54512','54513','54514','54515','54516','54517','54518','54519','54520','54521','54522','54523','54524','54525','54526','54527','54528','54529','54530','54531','54532','54533','54534','54535','54536','54537','54538','54539','54540','54541','54542','54543','54544','62123') AND `class_id`='1'
SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `item_id` IN('289','290','291','292','293','294','295','296','297','298','299','300','301','302','303','304','305','306','4267','6981','8900','8901','10537','10538','10539','10540','10541','10542','10543','10544','10545','10546','10547','10548','10549','10550','10551','10552','10553','10554','10556','10557','10558','10559','10560','10561','10562','10563','10564','10565','10566','10567','10568','10569','10570','10571','10572','10573','10574','10575','10576','10577','10578','10579','10580','10581','10582','10583','10584','10585','10587','10588','10589','10590','10591','10592','10593','10594','10595','10596','10597','10598','10599','10600','10601','10603','10604','10605','10606','10607','10608','10609','10610','10611','10612','10613','10614','10615','10617','10618','10619','10620','10621','10622','10623','10624','10626','10627','10628','10629','10630','10631','10632','10633','10634','10635','10636','10637','10638','10639','10640','10641','10642','10643','10644','10939','10941','11969','11970','12900','12901','12902','12903','12904','12905','12906','12907','12908','13221','13222','13223','13825','13826','13827','13828','13829','15298','15299','15300','15732','15733','15734','15735','15736','15737','15738','16080','16081','16082','16083','16084','16407','17272','17273','17274','17275','17276','17277','17279','17280','17281','17282','17284','22375','22376','30171','30223','45725','46010','46076','46113','46125','46132','46133','46194','46195','46961','47466','48199','49025','49250','49251','49252','51101','51102','51103','51104','51105','51106','51107','51108','51109','51110','51111','51112','51113','52312','52313','52314','52315','52316','52317','52318','52319','52320','52321','52322','54468','54469','54470','54471','54472','54473','54474','54475','54476','54477','54478','54479','54480','54481','54482','54483','54484','54485','54486','54487','54488','54489','54490','54491','54492','54493','54494','54495','54496','54497','54498','54499','54500','54501','54502','54503','54504','54505','54506','54507','54508','54509','54510','54511','54512','54513','54514','54515','54516','54517','54518','54519','54520','54521','54522','54523','54524','54525','54526','54527','54528','54529','54530','54531','54532','54533','54534','54535','54536','54537','54538','54539','54540','54541','54542','54543','54544','62123') AND `class_id`='1'
SELECT name FROM prints_make WHERE `id`='12'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE `name_full` LIKE "Austin%" ORDER BY name_title
?page=###page###
SELECT COUNT(*) as `count` FROM brv_summary_cache WHERE `make_id`='12'
441
SELECT `id`, `name`, `full_name`, `sort_name`, `make_id`, `url`, `views`, `type` FROM brv_summary_cache WHERE `make_id`='12' ORDER BY `sort_name`, `type` LIMIT 200, 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`='12'
SELECT DISTINCT `purchase_id` FROM payment WHERE `status`='approved' AND `purchase_id` IN('4444','4445','12245','12297','27803','28104','28175','28212','28224','28229','28230','28292','29042','29534','30229','31043','31960')
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 = 28175) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 31581) 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`='31581'
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('28175','28229','28230') 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 = 28229) 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('4444','4445','12245','12297','27803','28104','28212','28224','28230','28292','29042','29534','30229','31043','31960')
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 = 28292) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 29707) 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`='29707'
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('27803','28292','31960') ORDER BY price LIMIT 0, 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`, `market`, `segment`, `tier`, `make_source` FROM prints_vector WHERE `prepay`=1 AND `id` IN('4444','4445','12245','12297','27803','28104','28212','28224','28230','29042','29534','30229','31043','31960')
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 = 31960) 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 = 30229) 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`='30229'
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 = 28224) 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`='28224'
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 = 12297) 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`='12297'
SELECT `id`, `name`, `type` FROM nox_group