/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`='peugeot' 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`='108'
SELECT id, url, sort_name, full_name, views FROM prints_blueprint WHERE `item_id` IN('1571','1572','1573','1574','1575','1576','1577','1578','1579','1580','1581','1582','1583','1584','1585','1586','1587','1588','1589','1590','1591','1592','1593','1594','1595','1596','1597','1598','1599','1600','1601','1602','1603','1604','1605','1606','1607','1608','1609','1610','1611','1612','1613','1614','1615','1616','1617','1618','1619','1620','1621','1622','1623','1624','1625','1626','1627','1628','1629','1630','1631','1632','1633','1634','1635','1636','1637','1638','1639','1640','1641','1642','1643','1644','1645','1646','1647','1648','1649','1650','1651','1652','1653','1654','1655','1656','1657','1658','1659','1660','1661','1662','1663','1664','1665','1666','1667','1668','1669','1670','1671','1672','1673','1674','1675','1676','1677','1678','1679','1680','1681','1682','1683','1684','1685','1686','1687','1688','1689','1690','1691','1692','1693','1694','1695','1696','1697','1698','1699','1700','1701','1702','1703','1704','1705','1706','1707','1708','1709','1710','1711','1712','1713','1714','1715','1716','1717','1718','1719','1720','1721','1722','1723','1724','1725','1726','1727','1728','1729','1730','1731','1732','1733','1734','1735','1736','1737','1738','1739','1740','1741','1742','1743','1744','1745','1746','1747','1748','1749','1750','1751','1752','1753','1754','1755','1756','1757','1758','1759','1760','1761','1762','1763','1764','1765','1766','1767','1768','1769','1770','1771','1772','1773','1774','1775','1776','1777','1778','1779','1780','9104','9105','9106','9107','9108','9109','9110','9111','9112','9113','9114','9115','9116','9117','9118','9119','9120','9121','9122','9123','9124','9125','9126','9127','9128','9129','9130','9131','9132','9133','9134','9135','9136','9137','9138','9139','9140','9141','9142','9143','9144','9145','9146','9147','9148','9149','9150','9151','9152','9153','9154','9155','9156','9157','9158','9159','9160','9161','9162','9163','9164','9165','9166','9167','9168','9169','9170','9171','9172','9173','9174','9175','9176','9177','9178','9179','9180','9181','9182','9183','9184','9185','11152','11153','11154','12053','12726','12727','12728','13349','14054','14055','15346','15347','15828','16317','16318','16319','16320','16321','16463','16464','17245','17531','17532','17533','17673','17674','17675','17676','17677','17678','17679','17680','17681','17682','17683','17684','17685','17686','17687','17688','17689','17690','17691','17692','17693','17694','17695','17696','18116','18117','18118','18119','18120','18121','18122','18123','18223','18224','18249','18250','18251','18252','18253','18254','18255','18256','18257','18258','18259','18260','18261','18262','18263','18264','18265','18266','18267','18268','18438','18439','18440','18441','18442','18443','18444','18445','18446','18447','18480','18481','18482','18483','18484','18485','18486','18487','18488','18489','18490','18491','18492','18493','18494','18495','18496','18497','18498','18499','18500','18501','18502','18646','18706','18707','18708','18713','18714','18769','18770','18771','18973','19063','19064','19123','20190','20191','20192','20193','20194','20195','20196','20197','20198','20199','20629','22103','22750','22751','22752','22753','22754','22755','22756','22757','22758','22759','22760','22761','27023','27024','27025','27026','27027','27028','27029','27030','27031','27032','27033','27034','27035','27036','27037','27038','27039','27040','27041','27042','27043','27044','27045','27046','27047','27048','27049','27050','27051','27052','27053','27054','27055','27056','27057','27058','27059','27060','27061','27062','27063','27064','27065','27066','27067','27068','27069','27070','27071','27072','27073','27074','27075','27076','27077','27078','27079','27080','27081','27082','27083','27084','27085','27086','27087','27088','27089','27090','27091','27092','27093','27094','27095','27096','27097','27098','27099','27100','27101','27102','27103','27104','27105','27106','27107','27108','27109','27110','27111','27112','27113','30096','30097','30098','30099','30100','30101','30469','30470','30471','30472','30473','45730','45731','45800','45801','45802','45825','45826','45868','45869','45921','46200','46709','46724','47368','47546','47559','48051','48257','48376','48377','48378','48379','48380','48381','48382','48383','48384','48385','48386','48387','49182','49186','52111','52112','52113','52114','52115','52116','53561','53562','53563','53564','53565','59736','59737','59738','59739','59740','59741','59742','59743','59744','59745','59746','59747','59748','59749','59750','59751','59752','59753','59754','59755','59756','59757','59758','59759','59760','59761','59762','59763','59764','59765','59766','59767','59768','59769','59770','59771','59772','59773','59774','59775','59776','59777','59778','59779','59780','59781','59782','59783','59784','59785','59786','59787','59788','59789','59790','59791','59792','59793','59794','59795','59796','59797','59798','59799','59800','59801','59802','59803','59804','59805','59806','59807','59808','59809','59810','59811','59812','59813','59814','59815','59816','59817','59818','59819','59820','59821','59822','59823','59824','59825','59826','59827','59828','59829','59830','59831','59832','59833','59834','59835','59836','59837','59838','59839','59840','59841','59842','59843','59844','59845','59846','59847','59848','59849','59850','59851','59852','59853','59854','59855','59856','59857','59858','59859','59860','59861','59862','59863','59864','59865','59866','59867','59868','59869','59870','59871','59872','59873','59874','59875','59876','59877','59878','59879','59880','59881','59882','59883','59884','59885','59886') AND `class_id`='1'
SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `item_id` IN('1571','1572','1573','1574','1575','1576','1577','1578','1579','1580','1581','1582','1583','1584','1585','1586','1587','1588','1589','1590','1591','1592','1593','1594','1595','1596','1597','1598','1599','1600','1601','1602','1603','1604','1605','1606','1607','1608','1609','1610','1611','1612','1613','1614','1615','1616','1617','1618','1619','1620','1621','1622','1623','1624','1625','1626','1627','1628','1629','1630','1631','1632','1633','1634','1635','1636','1637','1638','1639','1640','1641','1642','1643','1644','1645','1646','1647','1648','1649','1650','1651','1652','1653','1654','1655','1656','1657','1658','1659','1660','1661','1662','1663','1664','1665','1666','1667','1668','1669','1670','1671','1672','1673','1674','1675','1676','1677','1678','1679','1680','1681','1682','1683','1684','1685','1686','1687','1688','1689','1690','1691','1692','1693','1694','1695','1696','1697','1698','1699','1700','1701','1702','1703','1704','1705','1706','1707','1708','1709','1710','1711','1712','1713','1714','1715','1716','1717','1718','1719','1720','1721','1722','1723','1724','1725','1726','1727','1728','1729','1730','1731','1732','1733','1734','1735','1736','1737','1738','1739','1740','1741','1742','1743','1744','1745','1746','1747','1748','1749','1750','1751','1752','1753','1754','1755','1756','1757','1758','1759','1760','1761','1762','1763','1764','1765','1766','1767','1768','1769','1770','1771','1772','1773','1774','1775','1776','1777','1778','1779','1780','9104','9105','9106','9107','9108','9109','9110','9111','9112','9113','9114','9115','9116','9117','9118','9119','9120','9121','9122','9123','9124','9125','9126','9127','9128','9129','9130','9131','9132','9133','9134','9135','9136','9137','9138','9139','9140','9141','9142','9143','9144','9145','9146','9147','9148','9149','9150','9151','9152','9153','9154','9155','9156','9157','9158','9159','9160','9161','9162','9163','9164','9165','9166','9167','9168','9169','9170','9171','9172','9173','9174','9175','9176','9177','9178','9179','9180','9181','9182','9183','9184','9185','11152','11153','11154','12053','12726','12727','12728','13349','14054','14055','15346','15347','15828','16317','16318','16319','16320','16321','16463','16464','17245','17531','17532','17533','17673','17674','17675','17676','17677','17678','17679','17680','17681','17682','17683','17684','17685','17686','17687','17688','17689','17690','17691','17692','17693','17694','17695','17696','18116','18117','18118','18119','18120','18121','18122','18123','18223','18224','18249','18250','18251','18252','18253','18254','18255','18256','18257','18258','18259','18260','18261','18262','18263','18264','18265','18266','18267','18268','18438','18439','18440','18441','18442','18443','18444','18445','18446','18447','18480','18481','18482','18483','18484','18485','18486','18487','18488','18489','18490','18491','18492','18493','18494','18495','18496','18497','18498','18499','18500','18501','18502','18646','18706','18707','18708','18713','18714','18769','18770','18771','18973','19063','19064','19123','20190','20191','20192','20193','20194','20195','20196','20197','20198','20199','20629','22103','22750','22751','22752','22753','22754','22755','22756','22757','22758','22759','22760','22761','27023','27024','27025','27026','27027','27028','27029','27030','27031','27032','27033','27034','27035','27036','27037','27038','27039','27040','27041','27042','27043','27044','27045','27046','27047','27048','27049','27050','27051','27052','27053','27054','27055','27056','27057','27058','27059','27060','27061','27062','27063','27064','27065','27066','27067','27068','27069','27070','27071','27072','27073','27074','27075','27076','27077','27078','27079','27080','27081','27082','27083','27084','27085','27086','27087','27088','27089','27090','27091','27092','27093','27094','27095','27096','27097','27098','27099','27100','27101','27102','27103','27104','27105','27106','27107','27108','27109','27110','27111','27112','27113','30096','30097','30098','30099','30100','30101','30469','30470','30471','30472','30473','45730','45731','45800','45801','45802','45825','45826','45868','45869','45921','46200','46709','46724','47368','47546','47559','48051','48257','48376','48377','48378','48379','48380','48381','48382','48383','48384','48385','48386','48387','49182','49186','52111','52112','52113','52114','52115','52116','53561','53562','53563','53564','53565','59736','59737','59738','59739','59740','59741','59742','59743','59744','59745','59746','59747','59748','59749','59750','59751','59752','59753','59754','59755','59756','59757','59758','59759','59760','59761','59762','59763','59764','59765','59766','59767','59768','59769','59770','59771','59772','59773','59774','59775','59776','59777','59778','59779','59780','59781','59782','59783','59784','59785','59786','59787','59788','59789','59790','59791','59792','59793','59794','59795','59796','59797','59798','59799','59800','59801','59802','59803','59804','59805','59806','59807','59808','59809','59810','59811','59812','59813','59814','59815','59816','59817','59818','59819','59820','59821','59822','59823','59824','59825','59826','59827','59828','59829','59830','59831','59832','59833','59834','59835','59836','59837','59838','59839','59840','59841','59842','59843','59844','59845','59846','59847','59848','59849','59850','59851','59852','59853','59854','59855','59856','59857','59858','59859','59860','59861','59862','59863','59864','59865','59866','59867','59868','59869','59870','59871','59872','59873','59874','59875','59876','59877','59878','59879','59880','59881','59882','59883','59884','59885','59886') AND `class_id`='1'
SELECT name FROM prints_make WHERE `id`='108'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE `name_full` LIKE "Peugeot%" ORDER BY name_title
?page=###page###
SELECT COUNT(*) as `count` FROM brv_summary_cache WHERE `make_id`='108'
1037
SELECT `id`, `name`, `full_name`, `sort_name`, `make_id`, `url`, `views`, `type` FROM brv_summary_cache WHERE `make_id`='108' ORDER BY `sort_name`, `type` LIMIT 800, 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`='108'
SELECT DISTINCT `purchase_id` FROM payment WHERE `status`='approved' AND `purchase_id` IN('203','204','205','206','207','208','209','210','310','311','336','337','338','339','340','341','342','343','344','345','346','347','348','349','350','351','352','353','354','355','525','526','527','528','529','530','531','532','533','534','567','568','569','570','571','572','573','574','575','576','577','578','579','580','581','582','583','584','585','586','587','588','589','733','793','794','795','800','801','856','857','858','1060','1151','1152','1212','2222','2223','2224','2225','2226','2227','2228','2229','2230','2231','2661','4164','4819','4820','4821','4822','4823','4824','4825','4826','4827','4828','4829','4830','9095','9096','9097','9098','9099','9100','9101','9102','9103','9104','9105','9106','9107','9108','9109','9110','9111','9112','9113','9114','9115','9116','9117','9118','9119','9120','9121','9122','9123','9124','9125','9126','9127','9128','9129','9130','9131','9132','9133','9134','9135','9136','9137','9138','9139','9140','9141','9142','9143','9144','9145','9146','9147','9148','9149','9150','9151','9152','9153','9154','9155','9156','9157','9158','9159','9160','9161','9162','9163','9164','9165','9166','9167','9168','9169','9170','9171','9172','9173','9174','9175','9176','9177','9178','9179','9180','9181','9182','9183','9184','9185','12170','12171','12172','12173','12174','12175','12543','12544','12545','12546','12547','27808','27809','27884','27885','27886','27913','27914','27959','27960','28015','28297','28792','28807','29436','29614','29627','30091','30286','30405','30406','30407','30408','30410','30411','30412','30413','30414','30415','30416','31193','31197')
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 = 206) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 33581) 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`='33581'
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('203','204','205','206','207','208','209','210','525','526','527','567','568','569','570','571','572','793','794','795','800','801','29627','30091') 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 = 568) 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 = 570) 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 = 569) 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 = 1060) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 4781) 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`='4781'
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('310','311','1060') 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 = 583) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 35499) 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`='35499'
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('336','337','338','339','340','341','342','343','344','345','346','347','348','349','350','351','352','353','354','355','573','574','575','576','577','578','579','580','581','582','583','584','585','586','587','588','589','28792','29436','30405','30406','30407','30408','30410','30411','30412','30413','30414','30415','30416','31193') 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 = 344) 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 = 9123) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 29363) 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`='29363'
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('9121','9122','9123','9124') 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 = 588) 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 = 9130) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 29318) 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`='29318'
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('9129','9130') ORDER BY price LIMIT 0, 1
SELECT `id`, `name`, `type` FROM nox_group