Current Schedule. New Schedule coming up starting February 24th
Array
(
[10] => Array
(
[0] => Array
(
[name] => Stretch into Sleek
[bgcolor] => C6D9F1
[font] => Y
[teacher] => Carinne
[teacher_id] => 11142
[starthour] => 10
[type_id] => 29
[length] => 1
[level] => F
)
[1] => Array
(
[name] => Conditioning for Pole
[bgcolor] => 98FF00
[font] => Y
[teacher] => Carinne
[teacher_id] => 11142
[starthour] => 10
[type_id] => 74
[length] => 1
[level] => F
)
[2] => Array
(
[name] => Flexibility and Foam Rolling
[bgcolor] => 13912F
[font] => N
[teacher] => Yana
[teacher_id] => 7
[starthour] => 10
[type_id] => 78
[length] => 1
[level] => B
)
[3] => Array
(
[name] => Strip Dance
[bgcolor] => FFF00B
[font] => Y
[teacher] => Yana
[teacher_id] => 7
[starthour] => 10
[type_id] => 71
[length] => 1
[level] => A
)
[4] => Array
(
[name] => Body By Pole
[bgcolor] => 7030A0
[font] => N
[teacher] => Yana
[teacher_id] => 7
[starthour] => 10
[type_id] => 36
[length] => 1
[level] => F
)
)
[11] => Array
(
[0] => Array
(
[name] => Pole Dance Routine
[bgcolor] => FAA2B2
[font] => Y
[teacher] => Carinne
[teacher_id] => 11142
[starthour] => 11
[type_id] => 68
[length] => 1
[level] => AL
)
[1] => Array
(
[name] => Level 1&2 Beginner
[bgcolor] => 9933FF
[font] => N
[teacher] => Carinne
[teacher_id] => 11142
[starthour] => 11
[type_id] => 64
[length] => 1
[level] => B
)
[2] => Array
(
[name] => Pole Prep
[bgcolor] => 1E11C5
[font] => N
[teacher] => Yana
[teacher_id] => 7
[starthour] => 11
[type_id] => 38
[length] => 1
[level] => B
)
[3] => Array
(
[name] => Sexy Chair
[bgcolor] => TT30A0
[font] => N
[teacher] => Yana
[teacher_id] => 7
[starthour] => 11
[type_id] => 13
[length] => 1
[level] => A
)
[4] => Array
(
[name] => Intro to Pole
[bgcolor] => FFFFFF
[font] => Y
[teacher] => Yana
[teacher_id] => 7
[starthour] => 11
[type_id] => 39
[length] => 1
[level] => B
)
[5] => Array
(
[name] => Basic Pole
[bgcolor] => F8674A
[font] => N
[teacher] => Eilen
[teacher_id] => 1300
[starthour] => 11
[type_id] => 50
[length] => 1
[level] => B
)
)
[12] => Array
(
[0] => Array
(
[name] => Pole Grooves
[bgcolor] => BBB555
[font] => N
[teacher] => Carinne
[teacher_id] => 11142
[starthour] => 12
[type_id] => 44
[length] => 1
[level] => AL
)
[1] => Array
(
[name] => Beginner Tricks & Skills
[bgcolor] => 002060
[font] => N
[teacher] => Carinne
[teacher_id] => 11142
[starthour] => 12
[type_id] => 48
[length] => 1
[level] => B
)
[2] => Array
(
[name] => Basic Pole
[bgcolor] => F8674A
[font] => N
[teacher] => Yana
[teacher_id] => 7
[starthour] => 12
[type_id] => 50
[length] => 1
[level] => B
)
[3] => Array
(
[name] => Intro to Pole
[bgcolor] => FFFFFF
[font] => Y
[teacher] => Yana
[teacher_id] => 7
[starthour] => 12
[type_id] => 39
[length] => 1
[level] => B
)
[4] => Array
(
[name] => Simple Spins and Beginner Pole
[bgcolor] => 262626
[font] => N
[teacher] => Yana
[teacher_id] => 7
[starthour] => 12
[type_id] => 51
[length] => 1
[level] => B
)
)
[17] => Array
(
[5] => Array
(
[name] => Booty Pop
[bgcolor] => 660033
[font] => N
[teacher] => Eilen
[teacher_id] => 1300
[starthour] => 12
[type_id] => 32
[length] => 1
[level] => A
)
[0] => Array
(
[name] => Basic Pole
[bgcolor] => F8674A
[font] => N
[teacher] => Carinne
[teacher_id] => 11142
[starthour] => 17
[type_id] => 50
[length] => 1
[level] => B
)
[1] => Array
(
[name] => Zumba
[bgcolor] => 800080
[font] => N
[teacher] => Richard
[teacher_id] => 169
[starthour] => 17
[type_id] => 47
[length] => 1
[level] => A
)
[2] => Array
(
[name] => SoBe Hip Hop
[bgcolor] => 00B050
[font] => Y
[teacher] => Iyana
[teacher_id] => 81
[starthour] => 17
[type_id] => 61
[length] => 1
[level] => AL
)
[3] => Array
(
[name] => Level 1&2 Beginner
[bgcolor] => 9933FF
[font] => N
[teacher] => Guensie
[teacher_id] => 26
[starthour] => 17
[type_id] => 64
[length] => 1
[level] => B
)
[4] => Array
(
[name] => Freshman Pole
[bgcolor] => 003300
[font] => N
[teacher] => Eilen
[teacher_id] => 1300
[starthour] => 17
[type_id] => 49
[length] => 1
[level] => B
)
)
[18] => Array
(
[5] => Array
(
[name] => Exotic Lap Dance
[bgcolor] => FF00FF
[font] => N
[teacher] => Eilen
[teacher_id] => 1300
[starthour] => 13
[type_id] => 1
[length] => 1
[level] => A
)
[0] => Array
(
[name] => Beginner Tricks & Skills
[bgcolor] => 002060
[font] => N
[teacher] => Carinne
[teacher_id] => 11142
[starthour] => 18
[type_id] => 48
[length] => 1
[level] => B
)
[1] => Array
(
[name] => Level 1 Beginner
[bgcolor] => C4BC96
[font] => Y
[teacher] => Eilen
[teacher_id] => 1300
[starthour] => 18
[type_id] => 6
[length] => 1
[level] => B
)
[2] => Array
(
[name] => Pole Divas
[bgcolor] => 10FFF9
[font] => Y
[teacher] => Iyana
[teacher_id] => 81
[starthour] => 18
[type_id] => 62
[length] => 1
[level] => B
)
[3] => Array
(
[name] => Zumba
[bgcolor] => 800080
[font] => N
[teacher] => Alex
[teacher_id] => 1074
[starthour] => 18
[type_id] => 47
[length] => 1
[level] => A
)
[4] => Array
(
[name] => Flexibility and Floor Work
[bgcolor] => CC9FA0
[font] => N
[teacher] => Eilen
[teacher_id] => 1300
[starthour] => 18
[type_id] => 75
[length] => 1
[level] => A
)
)
[19] => Array
(
[5] => Array
(
[name] => Simple Spins and Beginner Pole
[bgcolor] => 262626
[font] => N
[teacher] => Eilen
[teacher_id] => 1300
[starthour] => 14
[type_id] => 51
[length] => 1
[level] => B
)
[0] => Array
(
[name] => Open Pole Freestyle
[bgcolor] => BBA901
[font] => N
[teacher] => No Instructor
[teacher_id] => 18086
[starthour] => 19
[type_id] => 77
[length] => 1
[level] => B
)
[1] => Array
(
[name] => Level 2 Beginner
[bgcolor] => 948A54
[font] => N
[teacher] => Eilen
[teacher_id] => 1300
[starthour] => 19
[type_id] => 7
[length] => 1
[level] => B
)
[2] => Array
(
[name] => Level 3&4 Intermediate
[bgcolor] => 548DD4
[font] => N
[teacher] => Iyana
[teacher_id] => 81
[starthour] => 19
[type_id] => 52
[length] => 1
[level] => I
)
[3] => Array
(
[name] => Booty Pop
[bgcolor] => 660033
[font] => N
[teacher] => Guensie
[teacher_id] => 26
[starthour] => 19
[type_id] => 32
[length] => 1
[level] => A
)
[4] => Array
(
[name] => Level 2 and Up
[bgcolor] => DD90F0
[font] => N
[teacher] => Eilen
[teacher_id] => 1300
[starthour] => 19
[type_id] => 76
[length] => 1
[level] => AL
)
)
)
select *, WEEKDAY(lesson_date) as wd from xcart_cm_lessons les
join xcart_cm_lesson_types lt on les.lesson_type_id = lt.type_id
join xcart_customers cust on les.lesson_teacher_id = cust.id
WHERE les.lesson_date>='2014-03-03' AND les.lesson_date<='2014-03-09' AND les.lesson_group_type='G'
order by les.lesson_starthour
B = Beginner F = Fitness A = Alternative (not a pole dance class) I = Intermediate AL = All Levels
CLASS REGISTRATION:
Please be aware that there is limited space in each class (maximum number of students per class is 12), and that REGISTRATION for a class is OPTIONAL. WALK-INS ARE WELCOME but a space cannot be guaranteed. Registering for a class will reserve your position in that class and for that hour and day only. Upon registering for a class you will be held financially accountable for that specific class. Call Studio to register at (305) 532-7171. You may also register online. To register for a specific class online simply indicate name and time of the class under “Instructions from Buyer” when you purchase it on our website. We recommend coming to a class at least 15 minutes prior to class time to ensure your spot. Your cooperation is greatly appreciated. Studio reserves the right to cancel or reschedule classes.
For Private Lessons: Please call or contact us to schedule an appointment with one of our instructors. Availability: Mon-Fri 1:00:00-5:00pm (Last Private Begins at 4:00pm), Sat 4:00-6:00pm (Last Private Begins at 5:00pm), Sun: closed
For your safety we do not allow to a class after 15 min.
|
