/var/www/html/nox-modules/prints
/lib/action/frontend
/printsVectorSubcategoryAction.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`='ferrari' 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 (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`='45'
SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `item_id` IN('4320','4321','4322','4323','4324','4325','4326','4327','4328','4329','4330','4331','4332','4333','4334','4335','4336','4337','4338','4339','4340','4341','4342','4343','4344','4345','4346','4347','4348','4349','4350','4351','4352','4353','4354','4355','4356','4357','4358','4359','4360','4361','4362','4363','4364','4365','4366','4367','4368','4369','4370','4371','4372','4373','4374','4375','4376','4377','4378','4379','4380','4381','4382','4383','4384','4385','4386','4387','4388','4389','4390','4391','4392','4393','4394','4395','4396','4397','4398','4399','4400','4401','4402','4403','4404','4405','4406','4407','4408','4409','4410','4411','4412','4413','4414','4415','4591','5409','5410','5411','5412','5413','5414','5415','5416','5417','5418','5419','5420','5421','5422','5423','5424','5425','5426','5427','5428','5429','5430','5431','5432','5433','5434','5435','5436','5437','5438','5439','5440','5441','5442','5443','5444','5445','5446','5447','5448','5449','5450','5451','5452','5453','5454','5455','5456','5457','5458','5459','5460','5461','5462','5463','5464','5465','5466','5467','5468','5469','5470','5471','5472','5473','5474','5475','5476','5477','5478','5479','5480','5481','5482','5483','5484','5485','5486','5487','5490','5491','5492','5493','5494','5495','5496','5497','5498','5499','5500','5501','5502','5503','5504','5505','5506','5507','5508','5509','5510','5511','5512','5513','5514','5515','5516','5517','5518','5519','5520','5521','5522','5523','5524','5525','5526','5527','5528','5529','5530','5531','5532','5533','5534','5535','5536','5537','5538','5539','5540','5541','5542','5543','5544','5545','5546','5547','5548','5549','5550','5551','5552','5553','5554','5555','5556','5557','5558','5559','5560','5561','5562','5563','5564','5565','5566','5567','5568','5569','5570','5571','5572','5573','5574','5575','5576','5577','5578','5579','5580','5581','5582','5583','5584','5585','5586','5587','5588','5589','5590','5591','5592','5593','5594','5595','5596','5597','5598','5599','5600','5601','5602','5603','5604','5605','5606','5607','5608','5609','5610','5611','5612','5613','5614','5615','5616','5617','5618','5619','5620','5621','5622','5623','5624','5625','5626','5627','5628','5629','5630','5631','5632','5633','5634','5635','5636','5637','5638','5639','5640','5641','5642','5643','5644','5645','5646','5647','5648','5649','5650','5651','5652','5653','5654','5655','5656','5657','5658','5659','5660','5661','5662','5663','5664','5665','5666','5667','5668','5669','5670','5671','5672','5673','5674','5675','5676','5677','5678','5679','5680','5681','5682','5683','5684','5685','5686','5687','5688','5689','5690','5691','5692','5693','5694','5695','5696','5697','5698','5699','5700','5701','5702','5703','5704','5705','5706','5707','5708','5709','5710','5711','5712','5713','5714','5715','5716','5717','5718','5719','5720','5721','5722','5723','5724','5725','5726','5727','5728','5729','5730','5731','5732','5733','5734','5735','5736','5737','5738','5739','5740','5741','5742','5743','5744','5745','5746','5747','5748','5749','5750','5751','5752','5753','5754','5755','5756','5757','5758','5759','5760','5761','5762','5763','5764','6983','6984','6985','6986','6987','6988','6989','6990','6991','6992','6993','6994','8079','8080','8081','8082','8083','8084','8085','8086','8087','8088','8089','8090','8091','8093','8094','8095','8096','8097','8098','8911','9064','9065','9066','9067','10996','10997','10998','11118','11119','12005','12076','12077','12078','12079','12080','12081','12082','12083','12084','12085','12086','12087','12088','12089','12090','12091','12092','12093','12094','12095','12096','12097','12098','12099','12100','12101','12102','12103','12104','12105','12106','12107','12108','12109','12110','12111','12112','12113','12114','12115','12116','12117','12118','12119','12120','12121','12122','12123','12124','12682','12683','12684','12967','12968','12969','12970','12971','12972','12973','12974','12975','12976','12977','12978','12979','12980','12981','12982','13877','13878','13879','14219','15308','15309','15310','15393','15394','15395','15396','15397','15398','15399','15400','15401','15402','15403','15404','15405','15406','15407','15408','15409','15410','15411','15412','15413','15414','15415','15417','15418','16153','16154','16155','16423','17153','17154','17155','17156','17157','17158','17159','17160','17161','17162','17163','17164','17165','17166','17445','17446','17447','17448','17449','17450','17451','17979','17980','17981','17982','17983','17984','18334','18459','18510','19764','19765','19766','19919','19920','19921','19922','19974','22062','22063','22092','22110','22111','24236','24237','24238','24239','24240','24241','24242','24243','24244','29680','29682','30119','37219','45761','45776','45792','45978','45984','45985','46011','46172','46175','46199','46524','46935','46936','46955','46956','47465','47483','47695','48197','50736','50745','52623','56362','56363','56364','56365','56366','56367','56368','56369','56370','56371','56372','56373','56374','56375','56376','56377','56378','56379','56380','56381','56382','56383','56384','56385','56386','56387','56388','56389','56390','56391','56392','56393','56394','56395','56396','56397','56398','56399','56400','56401','56402','56403','56404','56405','56406','56407','56408','56409','56410','56411','56412','56413','56414','56415','56416','56417','56418','56419','56420','56421','56422','56423','56424','56425','56426','56427','56428','56429','56430','56431','56432','56433','56434','56435','56436','56437','56438','56439','56440','56441','56442','56443','56444','56445','56446','56447','56448','56449','56450','56451','56452','56453','56454','56455','56456','56457','56458','56459','56460','56461','56462','56463','56464','56465','56466','56467','56468','56469','56470','56471','56472','56473','56474','56475','56476','56477','56478','56479','56480','56481','56482','56483','56484','56485','56486','56487','56488','56489','56490','56491','56492','56493','56494','56495','56496','56497','56498','56499','56500','56501','56502','56503','56504','56505','56506','56507','56508','56509','56510','56511','56512','56513','56514','56515','56516','56517','56518','56519','56520','56521','56522','56523','56524','56525','56526','56527','56528','56529','56530','56531','56532','56533','56534','56535','56536','56537','56538','56539','56540','56541','56542','56543','56544','56545','56546','56547','56548','56549','56550','56551','56552','56553','56554','56555','56556','56557','56558','56559','56560','56561','56562','56563','56564','56565','56566','56567','56568','56569','56570','56571','56572','56573','56574','56575','56576','56577','56578','56579','56580','56581','56582','56583','56584','56585','56586','56587','56588','56589','56590','56591','56592','56593','56594','56595','56596','56597','56598','56599','56600','56601','56602','56603','56604','56605','56606','56607','56608','56609','56610','56611','61969') AND `class_id`='1'
?page=###page###
SELECT COUNT(*) as `count` FROM brv_summary_cache WHERE `make_id`='45' AND `type` IN('0','1','2')
519
SELECT `id`, `name`, `full_name`, `sort_name`, `make_id`, `url`, `views`, `type` FROM brv_summary_cache WHERE `make_id`='45' AND `type` IN('0','1','2') 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`='1'
SELECT `id`, `tag` FROM tag WHERE `id` IN('91')
SELECT DISTINCT `purchase_id` FROM payment WHERE `status`='approved' AND `purchase_id` IN('66','67','68','69','70','71','421','546','597','1816','1817','1818','1966','1967','1968','1969','2006','4120','4121','4150','4171','4172','6308','6309','6310','6311','6312','6313','6314','6315','6316','11753','11755','12193','19297','27843','27858','27876','28072','28078','28079','28105','28269','28272','28296','28608','29016','29017','29036','29037','29533','29551','29760','30227','31300','31309','31804')
SELECT set_id FROM prints_set_vector WHERE `vector_id`='4120'
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`='4120'
SELECT `id`, `name_full` FROM `prints_set` WHERE "1948 - 1950 ferrari 125 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`='4120'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='1966'
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 `id`='30596'
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 30596) 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`='30596'
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` IN('546','1966') ORDER BY price LIMIT 0, 1
SELECT set_id FROM prints_set_vector WHERE `vector_id`='69'
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`='69'
SELECT `id`, `name_full` FROM `prints_set` WHERE "2006 - 2016 ferrari 599 gto coupe" 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`='69' ORDER BY price LIMIT 0, 1
SELECT set_id FROM prints_set_vector WHERE `vector_id`='70'
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 `id`='32771'
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 32771) 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`='32771'
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` IN('70','29760') ORDER BY price LIMIT 0, 1
SELECT set_id FROM prints_set_vector WHERE `vector_id`='28272'
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`='28272'
SELECT `id`, `name_full` FROM `prints_set` WHERE "1950 - 1952 ferrari 375 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`='28272' ORDER BY price LIMIT 0, 1
SELECT `id`, `name`, `type` FROM nox_group
