/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`='vauxhall' 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`='141'
SELECT id, url, sort_name, full_name, views FROM prints_blueprint WHERE `item_id` IN('3274','3275','3276','3277','3278','3279','10191','10192','10193','10194','10195','10196','10197','10198','10199','10200','10201','10202','10203','10204','10205','10206','10207','10208','10209','10210','10211','10212','10213','10214','10215','10216','10217','10218','10219','10220','10221','10222','10223','10224','10225','10226','10227','10228','10229','10230','10231','10232','10233','10234','10235','10236','10237','10238','10239','10240','10241','10242','10243','10244','10245','10246','10247','10248','10249','10250','10251','10252','10253','10254','10255','10256','10257','10258','10259','10260','10261','10262','10263','10264','10265','10266','10267','10268','10269','10270','10271','10272','10273','10274','10275','10276','10277','10278','10279','10280','10281','10282','10283','10284','10285','10286','10287','10288','10289','10290','10291','10292','10293','17837','17838','17839','17840','17996','17997','17998','17999','18000','18015','18029','18030','18031','18032','18033','18034','18035','18036','18037','18205','18206','18207','18208','18209','18212','18366','18367','18368','18369','18370','18371','18372','18373','18374','18375','18376','18377','18378','18379','18380','18381','18382','18383','18384','18385','18386','18387','18388','18389','18390','18647','18648','18649','18650','18651','18652','18653','18751','18777','18778','18917','18918','19441','19442','20751','21562','21563','21564','21565','21566','21567','21568','21569','21570','21571','21572','21573','21574','21575','21576','21577','21578','21579','21580','21581','21582','21583','21584','21585','21586','21587','21588','21589','21590','21591','21592','21593','21594','21595','21596','21597','21598','21599','21600','21601','21602','21603','21604','21605','21606','21607','21608','21609','24584','24585','24670','24671','24672','26172','26173','26174','26175','26901','26902','26903','26908','26909','26920','26942','26943','26946','26947','26956','26957','26959','26962','26965','26966','26969','26979','26980','26981','26982','26995','26996','26997','26998','26999','27000','27013','27014','27015','27016','27017','27018','28107','28108','28109','28110','28111','28112','29455','29456','30095','45752','45952','45953','45954','45955','45956','45957','45958','45959','45960','46720','47290','47291','47292','47548','47561','48691','49184','52212','52213','61226','61227','61228','61229','61230','61231','61232','61233','61234','61235','61236','61237','61238','61239','61240','61241','61242','61243','61244','61245','61246','61247','61248','61249','61250','61251','61252','61253','61254','61255','61256','61257','61258','61259','61260','61261','61262','61263','61264','61265','61266','61267','61268','61269','61270','61271','61272','61273','61274','61275','61276','61277','61278','61279','61280','61281','61282','61283','61284','61285','61286','61287','61288','61289','61290','61291','61292','61293','61294','61295','61296','61297','61298','61299','61300','61301','61302','61303','61304','61305','61306','61307','61308','61309','61310','61311','61312','61313','61314','61315','61316','61317','61318','61319','61320','61321','61322','61323','61324','61325','61326','61327','61328','61329','61330','61331','61332','61333','61334','61335','61336','61337','61338','61339','61340','61341','61342','61343','61344','61345','61346','61347','61348','61349','61350','61351','61352','61353','61354','61355','61356','61357','61358','61359','61360','61361','61362','61363','61364','61365','61366','61367','61368','61369','61370','61371','61372','61373','61374','61375','61376','61377','61378','61379','61380','61381','61382','61383','61384','61385','61386','61387','61388','61389','61390','61391','61392','61393','61394','61395','61396','61397','61398','61399','61400','61401','61402','61403','61404','61405','61406','61407','61408','61409','61410','61411','61412','61413','61414','61415','61416','61417','61418','61419','61420','61421','61422','61423','61424','61425','61426','61427','61428','61429','61430','61431','61432','61433','61434','61435','61436','61437','61438','61439','61440','61441','61442','61443','61444','61445','61446','61447','61448','62089','62090','62091','62140') AND `class_id`='1'
SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `item_id` IN('3274','3275','3276','3277','3278','3279','10191','10192','10193','10194','10195','10196','10197','10198','10199','10200','10201','10202','10203','10204','10205','10206','10207','10208','10209','10210','10211','10212','10213','10214','10215','10216','10217','10218','10219','10220','10221','10222','10223','10224','10225','10226','10227','10228','10229','10230','10231','10232','10233','10234','10235','10236','10237','10238','10239','10240','10241','10242','10243','10244','10245','10246','10247','10248','10249','10250','10251','10252','10253','10254','10255','10256','10257','10258','10259','10260','10261','10262','10263','10264','10265','10266','10267','10268','10269','10270','10271','10272','10273','10274','10275','10276','10277','10278','10279','10280','10281','10282','10283','10284','10285','10286','10287','10288','10289','10290','10291','10292','10293','17837','17838','17839','17840','17996','17997','17998','17999','18000','18015','18029','18030','18031','18032','18033','18034','18035','18036','18037','18205','18206','18207','18208','18209','18212','18366','18367','18368','18369','18370','18371','18372','18373','18374','18375','18376','18377','18378','18379','18380','18381','18382','18383','18384','18385','18386','18387','18388','18389','18390','18647','18648','18649','18650','18651','18652','18653','18751','18777','18778','18917','18918','19441','19442','20751','21562','21563','21564','21565','21566','21567','21568','21569','21570','21571','21572','21573','21574','21575','21576','21577','21578','21579','21580','21581','21582','21583','21584','21585','21586','21587','21588','21589','21590','21591','21592','21593','21594','21595','21596','21597','21598','21599','21600','21601','21602','21603','21604','21605','21606','21607','21608','21609','24584','24585','24670','24671','24672','26172','26173','26174','26175','26901','26902','26903','26908','26909','26920','26942','26943','26946','26947','26956','26957','26959','26962','26965','26966','26969','26979','26980','26981','26982','26995','26996','26997','26998','26999','27000','27013','27014','27015','27016','27017','27018','28107','28108','28109','28110','28111','28112','29455','29456','30095','45752','45952','45953','45954','45955','45956','45957','45958','45959','45960','46720','47290','47291','47292','47548','47561','48691','49184','52212','52213','61226','61227','61228','61229','61230','61231','61232','61233','61234','61235','61236','61237','61238','61239','61240','61241','61242','61243','61244','61245','61246','61247','61248','61249','61250','61251','61252','61253','61254','61255','61256','61257','61258','61259','61260','61261','61262','61263','61264','61265','61266','61267','61268','61269','61270','61271','61272','61273','61274','61275','61276','61277','61278','61279','61280','61281','61282','61283','61284','61285','61286','61287','61288','61289','61290','61291','61292','61293','61294','61295','61296','61297','61298','61299','61300','61301','61302','61303','61304','61305','61306','61307','61308','61309','61310','61311','61312','61313','61314','61315','61316','61317','61318','61319','61320','61321','61322','61323','61324','61325','61326','61327','61328','61329','61330','61331','61332','61333','61334','61335','61336','61337','61338','61339','61340','61341','61342','61343','61344','61345','61346','61347','61348','61349','61350','61351','61352','61353','61354','61355','61356','61357','61358','61359','61360','61361','61362','61363','61364','61365','61366','61367','61368','61369','61370','61371','61372','61373','61374','61375','61376','61377','61378','61379','61380','61381','61382','61383','61384','61385','61386','61387','61388','61389','61390','61391','61392','61393','61394','61395','61396','61397','61398','61399','61400','61401','61402','61403','61404','61405','61406','61407','61408','61409','61410','61411','61412','61413','61414','61415','61416','61417','61418','61419','61420','61421','61422','61423','61424','61425','61426','61427','61428','61429','61430','61431','61432','61433','61434','61435','61436','61437','61438','61439','61440','61441','61442','61443','61444','61445','61446','61447','61448','62089','62090','62091','62140') AND `class_id`='1'
SELECT name FROM prints_make WHERE `id`='141'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE `name_full` LIKE "Vauxhall%" ORDER BY name_title
?page=###page###
SELECT COUNT(*) as `count` FROM brv_summary_cache WHERE `make_id`='141'
611
SELECT `id`, `name`, `full_name`, `sort_name`, `make_id`, `url`, `views`, `type` FROM brv_summary_cache WHERE `make_id`='141' ORDER BY `sort_name`, `type` LIMIT 500, 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`='141'
SELECT DISTINCT `purchase_id` FROM payment WHERE `status`='approved' AND `purchase_id` IN('83','84','85','86','87','102','116','117','118','120','122','124','292','293','294','295','296','299','453','454','455','456','457','458','459','460','461','462','463','464','465','466','467','468','469','470','471','472','473','474','475','476','477','734','735','736','737','738','739','740','838','864','865','1004','1005','1530','1531','2783','3594','3595','3596','3597','3598','3599','3600','3602','3603','3604','3605','3606','3607','3608','3609','3610','3611','3612','3613','3614','3615','3616','3617','3618','3619','3620','3621','3622','3623','3624','3625','3626','3627','3628','3629','3630','3631','3632','3633','3634','3635','3636','3637','3638','3639','3640','3641','6656','6657','6742','6743','6744','8244','8245','8246','8247','8973','8974','8975','8980','8981','8992','9014','9015','9018','9019','9028','9029','9031','9034','9037','9038','9041','9051','9052','9053','9054','9067','9068','9069','9070','9071','9072','9085','9086','9087','9088','9089','9090','10179','10180','10181','10182','10183','10184','11527','11528','12168','27833','28046','28047','28048','28049','28050','28051','28052','28053','28054','28803','29358','29359','29360','29616','29629','30711','31195','31925','31926','31927')
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 = 737) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 34665) 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`='34665'
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('734','735','736','737','738','739','740','864','865','1004','1005','29629','30711') 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 = 296) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 32563) 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`='32563'
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('102','116','117','118','120','122','124','292','293','294','295','296','299','29616') 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 = 470) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 35497) 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`='35497'
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('453','454','455','456','457','458','459','460','461','462','463','464','465','466','467','468','469','470','471','472','473','474','475','476','477','1530','1531','28803','31195') 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 = 28046) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 29455) 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`='29455'
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('3609','3610','3611','3612','3613','3614','3615','3616','3617','3618','3619','28046','28047','28048','28049','28050') 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 = 468) 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 = 471) 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 = 29629) 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 = 117) 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 = 292) 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 = 3606) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 29453) 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`='29453'
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('83','84','85','86','3595','3596','3597','3598','3599','3600','3602','3603','3604','3606','3607','28051','28052','28053','28054') ORDER BY price LIMIT 0, 1
SELECT `id`, `name`, `type` FROM nox_group