/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`='bentley' 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`='16'
SELECT id, url, sort_name, full_name, views FROM prints_blueprint WHERE `item_id` IN('332','333','334','335','336','337','338','339','340','341','342','343','344','345','346','2273','8012','8013','10190','10645','10646','10647','10648','10649','10650','10651','10652','10653','10654','10655','10656','10657','10658','10659','10660','10661','10662','10663','10664','10665','10666','10667','10668','10669','10670','10671','10672','10673','10674','10675','10676','10677','10678','12918','12919','12920','13224','15301','15302','15605','17291','17292','17293','17294','17295','17323','17959','17960','17961','17962','19497','19501','19843','19844','19845','19846','19847','19848','22001','22057','23800','23801','23802','23803','23804','23805','23806','23807','23808','23809','46079','48890','50976','54562','54563','54564','54565','54566','54567','54568','54569','54570','54571','54572','54573','54574','54575','54576','54577','54578','54579','54580','54581','54582','54583','54584','54585','54586','54587','54588','54589','54590','54591','54592','54593','54594','54595','54596','54597','54598','54599','54600','54601','54602','55462') AND `class_id`='1'
SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `item_id` IN('332','333','334','335','336','337','338','339','340','341','342','343','344','345','346','2273','8012','8013','10190','10645','10646','10647','10648','10649','10650','10651','10652','10653','10654','10655','10656','10657','10658','10659','10660','10661','10662','10663','10664','10665','10666','10667','10668','10669','10670','10671','10672','10673','10674','10675','10676','10677','10678','12918','12919','12920','13224','15301','15302','15605','17291','17292','17293','17294','17295','17323','17959','17960','17961','17962','19497','19501','19843','19844','19845','19846','19847','19848','22001','22057','23800','23801','23802','23803','23804','23805','23806','23807','23808','23809','46079','48890','50976','54562','54563','54564','54565','54566','54567','54568','54569','54570','54571','54572','54573','54574','54575','54576','54577','54578','54579','54580','54581','54582','54583','54584','54585','54586','54587','54588','54589','54590','54591','54592','54593','54594','54595','54596','54597','54598','54599','54600','54601','54602','55462') AND `class_id`='1'
SELECT name FROM prints_make WHERE `id`='16'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE `name_full` LIKE "Bentley%" ORDER BY name_title
?page=###page###
SELECT COUNT(*) as `count` FROM brv_summary_cache WHERE `make_id`='16'
192
SELECT `id`, `name`, `full_name`, `sort_name`, `make_id`, `url`, `views`, `type` FROM brv_summary_cache WHERE `make_id`='16' 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`='16'
SELECT `id`, `tag` FROM tag WHERE `id` IN('518','917')
SELECT DISTINCT `purchase_id` FROM payment WHERE `status`='approved' AND `purchase_id` IN('46','47','48','49','1894','1895','1896','1897','1898','1899','4115','5872','5873','5874','5875','5876','5877','5878','5879','5880','5881','28178','30909','31533','31612')
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 = 49) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 6537) 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`='6537'
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('49','1898','1899','5876') 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 = 47) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 36286) 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`='36286'
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('47','48','1894','1895','1896','1897','31533','31612') 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 = 48) 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 = 46) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 6534) 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`='6534'
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('46','5872') 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`=0 AND `id` IN('1894','1895','1896','1897','1898','1899','4115','5872','5873','5874','5875','5876','5877','5878','5879','5880','5881','28178','30909','31533','31612')
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 = 30909) 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`='30909'
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 = 31612) 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('1894','1895','1896','1897','1898','1899','4115','5872','5873','5874','5875','5876','5877','5878','5879','5880','5881','28178','31533')
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 = 5879) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 6539) 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 = 5878) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 6539) 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 = 5874) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 6535) 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 = 1895) 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 = 5875) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 6535) 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 = 1897) 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 = 1894) 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 = 1898) 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 = 5881) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 6540) 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 = 5873) 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`='5873'
SELECT `id`, `name`, `type` FROM nox_group