Fall Schedule
Array
(
[10] => Array
(
[0] => Array
(
[name] => Stretch into Sleek
[bgcolor] => C6D9F1
[font] => Y
[teacher] => Svetlana
[teacher_id] => 11145
[starthour] => 10
[type_id] => 29
[length] => 1
[level] => F
)
[1] => Array
(
[name] => Conditioning for Pole
[bgcolor] => 98FF00
[font] => Y
[teacher] => Svetlana
[teacher_id] => 11145
[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] => F
)
[3] => Array
(
[name] => Corelicious / Bootylicious
[bgcolor] => 00FFFA
[font] => Y
[teacher] => Svetlana
[teacher_id] => 11145
[starthour] => 10
[type_id] => 65
[length] => 1
[level] => F
)
)
[11] => Array
(
[0] => Array
(
[name] => Pole Dance Routine
[bgcolor] => FAA2B2
[font] => Y
[teacher] => Svetlana
[teacher_id] => 11145
[starthour] => 11
[type_id] => 68
[length] => 1
[level] => AL
)
[1] => Array
(
[name] => Level 1&2 Beginner
[bgcolor] => 9933FF
[font] => N
[teacher] => Svetlana
[teacher_id] => 11145
[starthour] => 11
[type_id] => 64
[length] => 1
[level] => B
)
[2] => Array
(
[name] => Intro to Pole
[bgcolor] => FFFFFF
[font] => Y
[teacher] => Yana
[teacher_id] => 7
[starthour] => 11
[type_id] => 39
[length] => 1
[level] => B
)
[3] => Array
(
[name] => Pole Prep
[bgcolor] => 1E11C5
[font] => N
[teacher] => Svetlana
[teacher_id] => 11145
[starthour] => 11
[type_id] => 38
[length] => 1
[level] => B
)
[4] => Array
(
[name] => Basic Pole
[bgcolor] => F8674A
[font] => N
[teacher] => Svetlana
[teacher_id] => 11145
[starthour] => 11
[type_id] => 50
[length] => 1
[level] => B
)
[5] => Array
(
[name] => Pole Class for group of 6-10 people
[bgcolor] => FF0009
[font] => N
[teacher] => Svetlana
[teacher_id] => 11145
[starthour] => 11
[type_id] => 80
[length] => 1
[level] => AL
)
)
[12] => Array
(
[0] => Array
(
[name] => Level 2 Beginner
[bgcolor] => 948A54
[font] => N
[teacher] => Svetlana
[teacher_id] => 11145
[starthour] => 12
[type_id] => 7
[length] => 1
[level] => B
)
[1] => Array
(
[name] => Beginner Tricks & Skills
[bgcolor] => 002060
[font] => N
[teacher] => Svetlana
[teacher_id] => 11145
[starthour] => 12
[type_id] => 48
[length] => 1
[level] => B
)
[2] => Array
(
[name] => Pole Prep
[bgcolor] => 1E11C5
[font] => N
[teacher] => Svetlana
[teacher_id] => 11145
[starthour] => 12
[type_id] => 38
[length] => 1
[level] => B
)
[3] => Array
(
[name] => Intro to Pole
[bgcolor] => FFFFFF
[font] => Y
[teacher] => Svetlana
[teacher_id] => 11145
[starthour] => 12
[type_id] => 39
[length] => 1
[level] => B
)
[4] => Array
(
[name] => Simple Spins and Beginner Pole
[bgcolor] => 262626
[font] => N
[teacher] => Svetlana
[teacher_id] => 11145
[starthour] => 12
[type_id] => 51
[length] => 1
[level] => B
)
)
[17] => Array
(
[5] => Array
(
[name] => Booty Pop
[bgcolor] => 660033
[font] => N
[teacher] => Svetlana
[teacher_id] => 11145
[starthour] => 12
[type_id] => 32
[length] => 1
[level] => A
)
[4] => Array
(
[name] => Open Pole Freestyle
[bgcolor] => BBA901
[font] => N
[teacher] => No Instructor
[teacher_id] => 18086
[starthour] => 13
[type_id] => 77
[length] => 1
[level] => B
)
[1] => Array
(
[name] => Zumba
[bgcolor] => 800080
[font] => N
[teacher] => Alex
[teacher_id] => 1074
[starthour] => 17
[type_id] => 47
[length] => 1
[level] => A
)
[2] => Array
(
[name] => Open Pole Freestyle
[bgcolor] => BBA901
[font] => N
[teacher] => No Instructor
[teacher_id] => 18086
[starthour] => 17
[type_id] => 77
[length] => 1
[level] => B
)
[3] => Array
(
[name] => Open Pole Freestyle
[bgcolor] => BBA901
[font] => N
[teacher] => No Instructor
[teacher_id] => 18086
[starthour] => 17
[type_id] => 77
[length] => 1
[level] => B
)
)
[18] => Array
(
[5] => Array
(
[name] => Exotic Lap Dance
[bgcolor] => FF00FF
[font] => N
[teacher] => Svetlana
[teacher_id] => 11145
[starthour] => 13
[type_id] => 1
[length] => 1
[level] => A
)
[0] => Array
(
[name] => Sultry Chair Vixens
[bgcolor] => E36C0A
[font] => N
[teacher] => Iyana
[teacher_id] => 81
[starthour] => 18
[type_id] => 45
[length] => 1
[level] => A
)
[1] => Array
(
[name] => Level 3&4 Intermediate
[bgcolor] => 548DD4
[font] => N
[teacher] => Rafaela
[teacher_id] => 13724
[starthour] => 18
[type_id] => 52
[length] => 1
[level] => I
)
[2] => Array
(
[name] => Pole Class for group of 6-10 people
[bgcolor] => FF0009
[font] => N
[teacher] => Must register
[teacher_id] => 18958
[starthour] => 18
[type_id] => 80
[length] => 1
[level] => AL
)
[3] => Array
(
[name] => Private Lesson
[bgcolor] =>
[font] => N
[teacher] => Must register
[teacher_id] => 18958
[starthour] => 18
[type_id] => 34
[length] => 1
[level] => AL
)
)
[19] => Array
(
[5] => Array
(
[name] => Simple Spins and Beginner Pole
[bgcolor] => 262626
[font] => N
[teacher] => Svetlana
[teacher_id] => 11145
[starthour] => 14
[type_id] => 51
[length] => 1
[level] => B
)
[0] => Array
(
[name] => Basic Pole
[bgcolor] => F8674A
[font] => N
[teacher] => Iyana
[teacher_id] => 81
[starthour] => 19
[type_id] => 50
[length] => 1
[level] => B
)
[1] => Array
(
[name] => Level 1 Beginner
[bgcolor] => C4BC96
[font] => Y
[teacher] => Rafaela
[teacher_id] => 13724
[starthour] => 19
[type_id] => 6
[length] => 1
[level] => B
)
[2] => Array
(
[name] => Pole Class for group of 6-10 people
[bgcolor] => FF0009
[font] => N
[teacher] => Must register
[teacher_id] => 18958
[starthour] => 19
[type_id] => 80
[length] => 1
[level] => AL
)
[3] => Array
(
[name] => Private Lesson
[bgcolor] =>
[font] => N
[teacher] => Must register
[teacher_id] => 18958
[starthour] => 19
[type_id] => 34
[length] => 1
[level] => AL
)
)
[20] => Array
(
[0] => Array
(
[name] => Transitional Level 2/3
[bgcolor] => FF00A0
[font] => N
[teacher] => Iyana
[teacher_id] => 81
[starthour] => 20
[type_id] => 66
[length] => 1
[level] => I
)
[1] => Array
(
[name] => Level 1&2 Beginner
[bgcolor] => 9933FF
[font] => N
[teacher] => Rafaela
[teacher_id] => 13724
[starthour] => 20
[type_id] => 64
[length] => 1
[level] => B
)
)
)
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>='2015-01-26' AND les.lesson_date<='2015-02-01' 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 with exception to Pole Class for group of 6-10 people, Open Pole, and Living Social/Groupon students. 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. Be advised that the Studio provides NO REFUNDS. Call Studio to register at (305) 532-7171. You may also register online. To register online simply add class/classes to your cart, proceed with the purchase and indicate class name and date you would like to register for under “Customer Notes”. You should always call for availability. 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 your safety we do not allow to a class after 10 min. The 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. Upon registering for a class you will be held financially accountable for that specific class.Availability: Mon-Fri 1:00:00-5:00pm (Last Private Begins at 4:00pm), Sat 11:00am, Sun: closed
For Private Parties: Please call (305) 532-7171 or contact us to check for availability. We recommend reserving your spot at least 3 weeks in advance.
|
