Atlantic Signworks often provides logo and sign designs for our clients. First, we gain a clear understanding of the client's image, message, target market, and the environment where the sign will be installed. Our team will then recommend a style of signage to meet the client's needs while staying within the budget.
Next, our designers work on the details - the sizes, shapes, colors, fonts and materials - to create the impact and image our customers desire. The design process is a give-and-take between the customer and designer, and we welcome the customers participation every step of the way.
Other times, we work with marketing firms or wholesalers to "fine-tune" a design so that it can be manufactured at a reasonable cost. We also look at the installation requirements and make suggestions based on our experience in the field.
1
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='0'2
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='61' LIMIT 13
DELETE FROM mos_session
WHERE (time < 1283623320)4
SELECT * FROM mos_session WHERE session_id='e8a6c226ccd050e47edf4d591114ba59'5
SELECT session_id FROM mos_session WHERE session_id=MD5('f77a6c912da25dad78ccfb13795ead2a')6
INSERT INTO mos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '3b80998b9389edf9e38b401e3927e5e8','1283624220','','0','1' )7
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='editors'
ORDER BY ordering8
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='editors-xtd'
ORDER BY ordering9
SELECT access FROM mos_menu WHERE id='61'10
SELECT a.*, ROUND(v.rating_sum/v.rating_count) AS rating, v.rating_count, u.name AS author, u.usertype, cc.name AS category, s.name AS section, g.name AS groups
FROM mos_content AS a
LEFT JOIN mos_categories AS cc ON cc.id = a.catid
LEFT JOIN mos_sections AS s ON s.id = cc.section AND s.scope='content'
LEFT JOIN mos_users AS u ON u.id = a.created_by
LEFT JOIN mos_content_rating AS v ON a.id = v.content_id
LEFT JOIN mos_groups AS g ON a.access = g.id
WHERE a.id='18' AND (a.state = '1' OR a.state = '-1')
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2010-09-04 13:17:00')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2010-09-04 13:17:00')
AND a.access <= 011
UPDATE mos_content SET hits=(hits+1) WHERE id='18'12
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='content'
ORDER BY ordering13
SELECT id FROM mos_mambots WHERE element = 'mosemailcloak' AND folder = 'content'14
SELECT * FROM mos_mambots WHERE id='16'15
SELECT a.id
FROM mos_components AS a
WHERE a.name = 'Syndicate'16
SELECT * FROM mos_menu WHERE menutype = 'mainmenu' AND published ='1' AND parent = '0' ORDER BY ordering17
SELECT * FROM mos_menu WHERE menutype = 'mainmenu' AND published ='1' AND parent = '0' ORDER BY ordering18
SELECT id, title, module, position, content, showtitle, params
FROM mos_modules AS m, mos_modules_menu AS mm
WHERE m.published='1' AND m.access <= '0' AND m.client_id='0'
AND mm.moduleid=m.id
AND (mm.menuid = '61' OR mm.menuid = '0')
ORDER BY ordering19
SELECT m.* FROM mos_menu AS m
WHERE menutype='mainmenu' AND published='1' AND access <= '0'
ORDER BY parent,ordering20
SELECT id
FROM mos_menu
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=18'21
SELECT id
FROM mos_menu
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=18'22
SELECT id
FROM mos_menu
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=1'23
SELECT id
FROM mos_menu
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=1'24
SELECT id
FROM mos_menu
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=24'25
SELECT id
FROM mos_menu
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=24'26
SELECT id
FROM mos_menu
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=22'27
SELECT id
FROM mos_menu
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=22'28
SELECT id
FROM mos_menu
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=23'29
SELECT id
FROM mos_menu
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=23'