SELECT *
FROM dbo.Tbl_Dba
WHERE (company_id = #Variables.company_id#) and (dba = '#Request.dba#')
#HTMLEditFormat(rs_contentdetails.pagetitle)##HTMLEditFormat(Rs_content.pagetitle)##HTMLEditFormat(application.defaulttitle)##rs_dba.googlewebmaster##rs_dba.metatags#
SELECT Contenttitle, Content_id
FROM Tbl_Content
WHERE dba='#request.dba#' and ContentType = 'Services' and active = 1
SELECT Contenttitle, ContentDetails_id
FROM Tbl_ContentDetails
WHERE Content_id = '#rs_services.Content_id#' and active = 1
SELECT TOP (3) Tbl_ContentDetails.ContentDetails_id, Tbl_ContentDetails.ContentTitle
FROM Tbl_ContentDetails INNER JOIN
Tbl_Content ON Tbl_ContentDetails.Content_id = Tbl_Content.Content_id
WHERE (Tbl_Content.Content_id = 10308) AND (Tbl_ContentDetails.active = 1)
ORDER BY Tbl_ContentDetails.Dsp_order, Tbl_ContentDetails.ContentDetails_id
SELECT TOP (3) Tbl_ContentDetails.ContentDetails_id, Tbl_ContentDetails.ContentTitle
FROM Tbl_ContentDetails INNER JOIN
Tbl_Content ON Tbl_ContentDetails.Content_id = Tbl_Content.Content_id
WHERE (Tbl_Content.Content_id = 10309) AND (Tbl_ContentDetails.active = 1)
ORDER BY Tbl_ContentDetails.Dsp_order, Tbl_ContentDetails.ContentDetails_id
SELECT TOP (3) Tbl_ContentDetails.ContentDetails_id, Tbl_ContentDetails.ContentTitle
FROM Tbl_ContentDetails INNER JOIN
Tbl_Content ON Tbl_ContentDetails.Content_id = Tbl_Content.Content_id
WHERE (Tbl_Content.Content_id = 10310) AND (Tbl_ContentDetails.active = 1)
ORDER BY Tbl_ContentDetails.Dsp_order, Tbl_ContentDetails.ContentDetails_id
SELECT TOP (3) Tbl_ContentDetails.ContentDetails_id, Tbl_ContentDetails.ContentTitle
FROM Tbl_ContentDetails INNER JOIN
Tbl_Content ON Tbl_ContentDetails.Content_id = Tbl_Content.Content_id
WHERE (Tbl_Content.Content_id = 10311) AND (Tbl_ContentDetails.active = 1)
ORDER BY Tbl_ContentDetails.Dsp_order, Tbl_ContentDetails.ContentDetails_id
A 3% convenience fee will be added to your invoice.
SELECT ContentTitle, [Content], pagedescription
FROM Tbl_Content
WHERE (dba = '#request.dba#') AND (ContentType = 'Testimonials') AND (active = 1)
ORDER BY Dsp_order