Welcome To LA Tactical Supplies

We have been in the retail firearms/sporting goods business since 1992 with a storefront location on the world famous Sunset Strip. Unlike many fly-by-night Internet operations popping up everywhere we are an actual brick and mortar store and are stocking dealers for the items we list. We are distributors for many hard to find products like Surefire, Emerson Knives, Galco and more, and have access to thousands of products not currently listed on our site. If you don’t see it, contact us, we can probably get it fast. Of course this website will be updated regularly so check back often for new products and specials.


Featured Products

SELECT c.Id, c.rootId, c.propsetId, c.functiongroup, c.rootId, c.OwnerId, c.ParentId, c.propsetId, c.Title, c.NavName, c.SortName, REPLACE(c.TextAlternative,' ', '
') AS TextAlternative, c.Short, c.Short AS Short1 , c.Short2, c.Short3, c.Short4, c.Short5, c.Url, c.ParagraphBreaks, IF (c.ParagraphBreaks <> 'html', REPLACE(c.Content,' ', '
'), c.Content) AS Content, IF (c.ParagraphBreaks <> 'html', REPLACE(c.Content,' ', '
'), c.Content) AS Content1, 'javascript:alert(\'FileLink is deprecated in version 3, use GetFile instead\');' AS FileLink, IF ( c.FileName = '', 'javascript:alert(\'Sorry, file not available\');', CONCAT('./tools/local/secureupload/content/FileName/', SUBSTRING_INDEX(c.FileName, ':::', -1)) ) AS FileDirect, IF ( c.FileName = '', '[none]', SUBSTRING_INDEX(c.FileName, ':::', 1) ) AS FileDisplay, IF ( c.FileName = '', 'javascript:alert(\'Sorry, file not available\');', CONCAT('./tools/software/3.0/go.php?toolscontext.publicstep=FileDownload&toolscontext.stepinput.entity=content&toolscontext.stepinput.property=FileName&toolscontext.stepinput.id=', c.Id) ) AS GetFile , c.Thumbnail, CONCAT(c.Id, 't_', c.Thumbnail) AS Thumb, CONCAT( './tools/local/imageupload/', IF ( c.Thumbnail = '', 'spacer.gif', CONCAT('content/Thumbnail/size1/', SUBSTRING_INDEX(c.Thumbnail, ':::', -1)) ) ) AS AutoThumb, CONCAT( './tools/local/imageupload/', IF ( c.MainImage = '', 'spacer.gif', CONCAT('content/MainImage/size1/', SUBSTRING_INDEX(c.MainImage, ':::', -1)) ) ) AS AutoImage, IF ( c.MainImage = '', '../../../spacer.gif', SUBSTRING_INDEX(c.MainImage, ':::', -1) ) AS AutoImageFile, IF ( c.MainImage = '', '[none]', SUBSTRING_INDEX(c.MainImage, ':::', 1) ) AS AutoImageDisplay , c.MainImage, CONCAT(c.Id, '_', c.FileName) AS Src, IF (c.FileName <> '', CONCAT('./tools/local/imageupload/', c.Id, '_', c.FileName), 'images/spacer.gif') AS AutoSrc, IF (c.Url <> '', c.Url, CONCAT('./pages/', IF (c.NavName <> '', c.NavName, c.Id), '/', REPLACE(c.Title,' ', '_'), '.htm')) AS AutoLink, c.Heading, c.Summary, IF (c.DisplayDate = '0000-00-00 00:00:00', '', DATE_FORMAT(c.DisplayDate, '%c/%e/%Y')) AS DisplayDate , UNIX_TIMESTAMP(c.DisplayDate) AS DisplayDateRaw , IF (c.DisplayDate = '0000-00-00 00:00:00', '', DATE_FORMAT(c.DisplayEnd, '%c/%e/%Y')) AS DisplayEnd, UNIX_TIMESTAMP(c.DisplayEnd) AS DisplayEndRaw , IF (c.DateCreated = '0000-00-00 00:00:00', '', DATE_FORMAT(c.DateCreated, '%c/%e/%Y')) AS DateCreated , UNIX_TIMESTAMP(c.DateCreated) AS DateCreatedRaw , IF (c.DateModified = '0000-00-00 00:00:00', '', DATE_FORMAT(c.DateModified, '%c/%e/%Y')) AS DateModified , UNIX_TIMESTAMP(c.DateModified) AS DateModifiedRaw , UNIX_TIMESTAMP(c.StartLive) AS StartLive, UNIX_TIMESTAMP(c.EndLive) AS EndLive, IF (c.ParagraphBreaks <> 'html', REPLACE(c.Content2,' ', '
'), c.Content2) AS Content2, IF (c.ParagraphBreaks <> 'html', REPLACE(c.Content3,' ', '
'), c.Content3) AS Content3, IF (c.ParagraphBreaks <> 'html', REPLACE(c.Content4,' ', '
'), c.Content4) AS Content4, IF (c.ParagraphBreaks <> 'html', REPLACE(c.Content5,' ', '
'), c.Content5) AS Content5, c.Short6, c.Short7, c.Short8, pr.Id AS ProductId, pr.ItemId, pr.Price, pr.PriceNote, pr.Weight, pr.Taxable, pr.Shipping, pr.Availability, pr.QuantityAvailable, pr.ProductType, pr.DiscountedPrice, pr.DiscountQuantity, pr.NonTaxableAmount, pr.Options, pr.RecurringPrice, pr.RecurringPeriod FROM (content c, propset ps , product pr, crossreference cr) WHERE (c.propsetId = ps.id AND ( 1 = 0 OR ( ( ( cr.ParentId IN (100) AND cr.ChildId = c.Id ) OR ( cr.ChildId IN (100) AND cr.ParentId = c.Id AND cr.Reversible = 'yes' ) ) ) ) AND c.ProductId = pr.Id AND c.controlAccess IN ('', 'no') AND ( c.LiveOverride = 'always' OR (c.LiveOverride = 'by date' AND (c.StartLive <= NOW() AND (c.EndLive >= NOW() OR c.EndLive = '0000-00-00 00:00:00') ) ) )) GROUP BY c.Id ORDER BY c.SortName, c.Title

Can't create/write to file '/tmp/#sql_7784_0.MYI' (Errcode: 122)

array ( 1 => array ( 'file' => '/var/www/vhosts/latacticalsupplies.com/httpdocs/tools/software/3.0/include/cms/api.inc.php', 'line' => 444, 'function' => 'rawquery', 'class' => 'toolscontext_storage_sql', 'type' => '->', 'args' => ', SELECT c.Id, c.rootId, c.propsetId, c.functiongroup, c.rootId, c.OwnerId, c.ParentId, c.propsetId, c.Title, c.NavName, c.SortName, REPLACE(c.TextAlternative,\' \', \'
\') AS TextAlternative, c.Short, c.Short AS Short1 , c.Short2, c.Short3, c.Short4, c.Short5, c.Url, c.ParagraphBreaks, IF (c.ParagraphBreaks <> \'html\', REPLACE(c.Content,\' \', \'
\'), c.Content) AS Content, IF (c.ParagraphBreaks <> \'html\', REPLACE(c.Content,\' \', \'
\'), c.Content) AS Content1, \'javascript:alert(\\\'FileLink is deprecated in version 3, use GetFile instead\\\');\' AS FileLink, IF ( c.FileName = \'\', \'javascript:alert(\\\'Sorry, file not available\\\');\', CONCAT(\'./tools/local/secureupload/content/FileName/\', SUBSTRING_INDEX(c.FileName, \':::\', -1)) ) AS FileDirect, IF ( c.FileName = \'\', \'[none]\', SUBSTRING_INDEX(c.FileName, \':::\', 1) ) AS FileDisplay, IF ( c.FileName = \'\', \'javascript:alert(\\\'Sorry, file not available\\\');\', CONCAT(\'./tools/software/3.0/go.php?toolscontext.publicstep=FileDownload&toolscontext.stepinput.entity=content&toolscontext.stepinput.property=FileName&toolscontext.stepinput.id=\', c.Id) ) AS GetFile , c.Thumbnail, CONCAT(c.Id, \'t_\', c.Thumbnail) AS Thumb, CONCAT( \'./tools/local/imageupload/\', IF ( c.Thumbnail = \'\', \'spacer.gif\', CONCAT(\'content/Thumbnail/size1/\', SUBSTRING_INDEX(c.Thumbnail, \':::\', -1)) ) ) AS AutoThumb, CONCAT( \'./tools/local/imageupload/\', IF ( c.MainImage = \'\', \'spacer.gif\', CONCAT(\'content/MainImage/size1/\', SUBSTRING_INDEX(c.MainImage, \':::\', -1)) ) ) AS AutoImage, IF ( c.MainImage = \'\', \'../../../spacer.gif\', SUBSTRING_INDEX(c.MainImage, \':::\', -1) ) AS AutoImageFile, IF ( c.MainImage = \'\', \'[none]\', SUBSTRING_INDEX(c.MainImage, \':::\', 1) ) AS AutoImageDisplay , c.MainImage, CONCAT(c.Id, \'_\', c.FileName) AS Src, IF (c.FileName <> \'\', CONCAT(\'./tools/local/imageupload/\', c.Id, \'_\', c.FileName), \'images/spacer.gif\') AS AutoSrc, IF (c.Url <> \'\', c.Url, CONCAT(\'./pages/\', IF (c.NavName <> \'\', c.NavName, c.Id), \'/\', REPLACE(c.Title,\' \', \'_\'), \'.htm\')) AS AutoLink, c.Heading, c.Summary, IF (c.DisplayDate = \'0000-00-00 00:00:00\', \'\', DATE_FORMAT(c.DisplayDate, \'%c/%e/%Y\')) AS DisplayDate , UNIX_TIMESTAMP(c.DisplayDate) AS DisplayDateRaw , IF (c.DisplayDate = \'0000-00-00 00:00:00\', \'\', DATE_FORMAT(c.DisplayEnd, \'%c/%e/%Y\')) AS DisplayEnd, UNIX_TIMESTAMP(c.DisplayEnd) AS DisplayEndRaw , IF (c.DateCreated = \'0000-00-00 00:00:00\', \'\', DATE_FORMAT(c.DateCreated, \'%c/%e/%Y\')) AS DateCreated , UNIX_TIMESTAMP(c.DateCreated) AS DateCreatedRaw , IF (c.DateModified = \'0000-00-00 00:00:00\', \'\', DATE_FORMAT(c.DateModified, \'%c/%e/%Y\')) AS DateModified , UNIX_TIMESTAMP(c.DateModified) AS DateModifiedRaw , UNIX_TIMESTAMP(c.StartLive) AS StartLive, UNIX_TIMESTAMP(c.EndLive) AS EndLive, IF (c.ParagraphBreaks <> \'html\', REPLACE(c.Content2,\' \', \'
\'), c.Content2) AS Content2, IF (c.ParagraphBreaks <> \'html\', REPLACE(c.Content3,\' \', \'
\'), c.Content3) AS Content3, IF (c.ParagraphBreaks <> \'html\', REPLACE(c.Content4,\' \', \'
\'), c.Content4) AS Content4, IF (c.ParagraphBreaks <> \'html\', REPLACE(c.Content5,\' \', \'
\'), c.Content5) AS Content5, c.Short6, c.Short7, c.Short8, pr.Id AS ProductId, pr.ItemId, pr.Price, pr.PriceNote, pr.Weight, pr.Taxable, pr.Shipping, pr.Availability, pr.QuantityAvailable, pr.ProductType, pr.DiscountedPrice, pr.DiscountQuantity, pr.NonTaxableAmount, pr.Options, pr.RecurringPrice, pr.RecurringPeriod FROM (content c, propset ps , product pr, crossreference cr) WHERE (c.propsetId = ps.id AND ( 1 = 0 OR ( ( ( cr.ParentId IN (100) AND cr.ChildId = c.Id ) OR ( cr.ChildId IN (100) AND cr.ParentId = c.Id AND cr.Reversible = \'yes\' ) ) ) ) AND c.ProductId = pr.Id AND c.controlAccess IN (\'\', \'no\') AND ( c.LiveOverride = \'always\' OR (c.LiveOverride = \'by date\' AND (c.StartLive <= NOW() AND (c.EndLive >= NOW() OR c.EndLive = \'0000-00-00 00:00:00\') ) ) )) GROUP BY c.Id ORDER BY c.SortName, c.Title ', ), 2 => array ( 'file' => '/var/www/vhosts/latacticalsupplies.com/httpdocs/tools/software/3.0/include/cms/api.inc.php', 'line' => 490, 'function' => 'getlist', 'class' => 'toolscontext_cms_api', 'type' => '->', 'args' => ', 100, Array', ), 3 => array ( 'file' => '/var/www/vhosts/latacticalsupplies.com/httpdocs/tools/compile/3/index.html', 'line' => 16, 'function' => 'beginlist', 'class' => 'toolscontext_cms_api', 'type' => '->', 'args' => ', default, Array', ), 4 => array ( 'file' => '/var/www/vhosts/latacticalsupplies.com/httpdocs/tools/software/3.0/include/cms/page.inc.php', 'line' => 55, 'args' => ', /var/www/vhosts/latacticalsupplies.com/httpdocs/tools/compile/3/index.html', 'function' => 'require', ), 5 => array ( 'file' => '/var/www/vhosts/latacticalsupplies.com/httpdocs/tools/software/3.0/include/master.inc.php', 'line' => 332, 'function' => 'getdisplay', 'class' => 'toolscontext_cms_page', 'type' => '->', 'args' => '', ), 6 => array ( 'file' => '/var/www/vhosts/latacticalsupplies.com/httpdocs/index.php', 'line' => 9, 'function' => 'getcmsdisplay', 'class' => 'toolscontext_master', 'type' => '->', 'args' => ', 100, Array', ), )