/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`='mack' 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`='264'

SELECT id, url, sort_name, full_name, views FROM prints_blueprint WHERE `item_id` IN('14779','14780','14781','14782','14783','14784','14785','14786','14787','14788','14789','14790','14791','14792','14793','14794','14795','14796','14797','14798','14799','14800','14801','14802','14803','14804','14805','14806','14807','14808','14809','14810','14811','14812','14813','14814','14815','14816','14817','14818','14819','14820','14821','14822','14823','14824','14825','14826','14827','14828','14875','14877','15821','16485','16486','22029','37692','37693','37694','37695','37696','37697','39103','39104','39105','39106','39107','39108','39109','39110','39111','39112','39113','39114','39115','39116','39117','39118','39119','39120','39560','39561','39562','39563','39564','39565','39566','39567','39568','39569','39570','39571','39572','39573','39574','39575','39576','39577','39578','39579','39580','39581','39582','39583','39584','39585','39586','39587','39588','39589','39590','39591','39592','39593','39594','39595','39596','39597','39598','39599','39600','39601','39602','39603','39604','39605','39606','39607','39608','39609','39610','39611','39612','39613','39614','39615','45830','45986','46768','47619','48816','49746','49747','49748','49749','49750','49751','49752','49753','49754','49755','49756','49757','49758','49759','49760','49761','49762','49763','49764','49765','49766','49767','49768','49769','49770','49771','49772','49773','49774','49775','49776','49777','49778','49779','49780','49781','49782','49783','49784','49785','49786','49787','49788','49789','49790','49791','49792','49793','49794','49795','50182','50183','50184','50185','50186','50187','50188','50189','50190','50191','50192','50193','50194','50195','50196','50197','50198','50199','50200','50201','50202','50203','50989','51506','51507','53132','53133','53134','53135','53136','53137','53138','53139','53140','53141','62116') AND `class_id`='1'

SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `item_id` IN('14779','14780','14781','14782','14783','14784','14785','14786','14787','14788','14789','14790','14791','14792','14793','14794','14795','14796','14797','14798','14799','14800','14801','14802','14803','14804','14805','14806','14807','14808','14809','14810','14811','14812','14813','14814','14815','14816','14817','14818','14819','14820','14821','14822','14823','14824','14825','14826','14827','14828','14875','14877','15821','16485','16486','22029','37692','37693','37694','37695','37696','37697','39103','39104','39105','39106','39107','39108','39109','39110','39111','39112','39113','39114','39115','39116','39117','39118','39119','39120','39560','39561','39562','39563','39564','39565','39566','39567','39568','39569','39570','39571','39572','39573','39574','39575','39576','39577','39578','39579','39580','39581','39582','39583','39584','39585','39586','39587','39588','39589','39590','39591','39592','39593','39594','39595','39596','39597','39598','39599','39600','39601','39602','39603','39604','39605','39606','39607','39608','39609','39610','39611','39612','39613','39614','39615','45830','45986','46768','47619','48816','49746','49747','49748','49749','49750','49751','49752','49753','49754','49755','49756','49757','49758','49759','49760','49761','49762','49763','49764','49765','49766','49767','49768','49769','49770','49771','49772','49773','49774','49775','49776','49777','49778','49779','49780','49781','49782','49783','49784','49785','49786','49787','49788','49789','49790','49791','49792','49793','49794','49795','50182','50183','50184','50185','50186','50187','50188','50189','50190','50191','50192','50193','50194','50195','50196','50197','50198','50199','50200','50201','50202','50203','50989','51506','51507','53132','53133','53134','53135','53136','53137','53138','53139','53140','53141','62116') AND `class_id`='1'

SELECT name FROM prints_make WHERE `id`='264'

SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE `name_full` LIKE "Mack%" ORDER BY name_title

?page=###page###

SELECT COUNT(*) as `count` FROM brv_summary_cache WHERE `make_id`='264'

282

SELECT `id`, `name`, `full_name`, `sort_name`, `make_id`, `url`, `views`, `type` FROM brv_summary_cache WHERE `make_id`='264' 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`='264'

SELECT DISTINCT `purchase_id` FROM payment WHERE `status`='approved' AND `purchase_id` IN('4084','19770','19771','19772','19773','19774','19775','21181','21182','21183','21184','21185','21186','21187','21188','21189','21190','21191','21192','21193','21194','21195','21196','21197','21198','21638','21639','21640','21641','21642','21643','21644','21645','21646','21647','21648','21649','21650','21651','21652','21653','21654','21655','21656','21657','21658','21659','21660','21661','21662','21663','21664','21665','21666','21667','21668','21669','21670','21671','21672','21673','21674','21675','21676','21677','21678','21679','21680','21681','21682','21683','21684','21685','21686','21687','21688','21689','21690','21691','21692','21693','27918','28080','28851','29687','30835','31538','31952')

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 = 28080) 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`='28080'

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('4084','19770','19771','19772','19773','19774','19775','21181','21182','21183','21184','21185','21186','21187','21188','21189','21190','21191','21192','21193','21194','21195','21196','21197','21198','21638','21639','21640','21641','21642','21643','21644','21645','21646','21647','21648','21649','21650','21651','21652','21653','21654','21655','21656','21657','21658','21659','21660','21661','21662','21663','21664','21665','21666','21667','21668','21669','21670','21671','21672','21673','21674','21675','21676','21677','21678','21679','21680','21681','21682','21683','21684','21685','21686','21687','21688','21689','21690','21691','21692','21693','27918','28851','29687','30835','31538','31952')

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 = 30835) ORDER BY name_title

SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 34923) 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`='34923'

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('29687','30835') 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 = 28851) ORDER BY name_title

SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 31316) 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`='31316'

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('19770','19771','19772','19773','19774','19775','28851') 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 = 29687) 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 = 31952) ORDER BY name_title

SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 36360) 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`='36360'

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('31538','31952') 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 = 31538) 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('4084','19770','19771','19772','19773','19774','19775','21181','21182','21183','21184','21185','21186','21187','21188','21189','21190','21191','21192','21193','21194','21195','21196','21197','21198','21638','21639','21640','21641','21642','21643','21644','21645','21646','21647','21648','21649','21650','21651','21652','21653','21654','21655','21656','21657','21658','21659','21660','21661','21662','21663','21664','21665','21666','21667','21668','21669','21670','21671','21672','21673','21674','21675','21676','21677','21678','21679','21680','21681','21682','21683','21684','21685','21686','21687','21688','21689','21690','21691','21692','21693','27918')

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 = 21674) ORDER BY name_title

SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 22664) 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 = 21196) ORDER BY name_title

SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 22192) 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 = 21648) ORDER BY name_title

SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 22664) 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 = 27918) 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`='27918'

SELECT `id`, `name`, `type` FROM nox_group