Search through FranchiseBuy.com's Dental Repair Franchises. FranchiseBuy.com is the perfect starting point for entrepreneurs looking to open their own Dental Repair Franchises. Search through Dental Repair Franchises by brand, location, or investment required.
"... a step-by-step guide to help you make the transition from
the employee culture to that of the entrepreneurial world. This book is a complete toolkit and user's guide
for success for everyone who dreams of starting his or her own business."
SELECT
F.franchiseID,
F.logo,
F.link,
F.name,
F.title,
F.invMin,
F.invMax,
F.liquidCapital,
F.membershipID,
F.VideoWidth,
F.VideoHeight,
F.vid,
F.pic1,
F.sweepstakes,
F.OrderNumber,
FSI.FranchiseType,
IF(FR.SearchPagePosition != 0 AND FR.SearchPagePosition IS NOT NULL, FR.SearchPagePosition, 9999999) AS TempOrdering,
IF(
FSI.FranchiseType = 'pay',
4,
IF(
FSI.FranchiseType = 'tbppc',
5,
IF(
FSI.FranchiseType = 'tb',
6,
7
)
)
) AS TempOrdering2
FROM
franchise F
LEFT JOIN franchise_Sites FSI USING (franchiseID)
LEFT JOIN franchise_cats FC ON (FC.franchiseID = F.franchiseID)
LEFT JOIN franchise_ranking FR ON (FR.franchiseID = F.franchiseID)
WHERE
1
AND FSI.SiteID = '5'
AND F.Deleted = 'n'
AND
(
FSI.FranchiseType = 'pay'
)
AND FC.subcatID = '632'
AND F.franchiseID NOT IN (1243,361,9,107,1059,1269)
GROUP BY
F.franchiseID
ORDER BY
TempOrdering ASC,
TempOrdering2 ASC,
-- F.OrderNumber ASC,
F.name
