InfoTech: Dilemma With Similar IDs

Standard

gfdh

Ever since I’ve used SQL, I’ve been really using the GROUP BY clause the WRONG way! Yesterday while coding, I was trying to get distinct log ins on each day. The problem is, I wasn’t getting the right results. Instead of counting multiple values of account_id number 4 as a one, it will count all logs of that id plus the COUNT of all other ids.

I search online I have found DISTINCT, it literally change the way I code… LITERALLY. So I revised my query to this…

$query_trails = “SELECT COUNT(DISTINCT account_id) as counted FROM log_trails WHERE trail_type=’Log in’ and (trail_date<‘”.$range_date.”‘ and trail_date>'”.$check_date.”‘)”; // This works fine…

Then I found this snippet by Adam Matan which gave me an ease with all of my other queries. My new query…

$query_trails = “SELECT COUNT(trail_id) as counted, account_id FROM log_trails WHERE trail_type=’Log in’ and (trail_date<‘”.$range_date.”‘ and trail_date>'”.$check_date.”‘) GROUP BY account_id HAVING COUNT(*) = 1″; // This only returns one row… I’ll check this soon.

I’m really thankful I found these things right now. So bye for now and I going to code here again. じゃあ~

Cute and Not-So-Cute Dogs At The Dog Show in Ormoc City

Standard

Ormoc City was celebrating its fiesta and one of the events scheduled on its week-long celebration is the dog show called “Dog Show Fun Match 2015.” It wasn’t really a day to enjoy because we already planned to work on our thesis that day. We were waiting for someone but she didn’t came. We were apparently bored going around the city so we stayed on an empty kiosk near the city stage. While enjoying the sea breeze on that hot noon, we were eating ripe mangoes. We just don’t have something to do—so we entertained ourselves by eating foods and chatting with each other.

2015-06-21 16.31.31

2015-06-21 16.33.07

Ormoc City was celebrating its fiesta and one of the events scheduled on its week-long celebration is the dog show called “Dog Show Fun Match 2015.” It wasn’t really a day to enjoy because we already planned to work on our thesis that day. We were waiting for someone but she didn’t came. We were apparently bored going around the city so we stayed on an empty kiosk near the city stage. While enjoying the sea breeze on that hot noon, we were eating ripe mangoes. We just don’t have something to do—so we entertained ourselves by eating foods and chatting with each other.

2015-06-21 16.33.20

2015-06-21 16.34.01

I don’t know if it was luck or what, we were looking on people passing by when we see the fiesta schedule on a large tarpaulin. So that time, in a few hours will be the dog show. People started coming with their dogs. A locally famous man brought his trained dogs that were askal or asong kalye—it literally means street dog. He calls his dogs by its names and will return to him after wandering a few meters away. But of certain reasons he went home before the event even started.Before the event started, the dog owners registered their pets on the three categories. There were really a lot of breeds ranging from small ones to large ones. The dogs were paraded in front of the judges. Few minutes later the winner were called, but our bet did not won. We asked of the dog owners and he said that the Great Dane don’t look healthy.

2015-06-21 16.35.09

2015-06-21 16.33.23

2015-06-21 16.31.42

Another Way To Eat Sandwich

Standard

WIN_20150629_163640 (2)

I was making French fries while I was alone in our house. We also have some loaf bread, so I was thinking of making toasted bread out of it. The bread seems bare so I decided to place butter and the French fries on it—then seasoning it with ground black pepper. It’s really good.I was making French fries while I was alone in our house. We also have some loaf bread, so I was thinking of making toasted bread out of it. The bread seems bare so I decided to place butter and the French fries on it—then seasoning it with ground black pepper. It’s really good.

10 Things You’ll Encounter In Raising Broiler Chickens

Standard

While surfing online, I found a lot of articles about raising chicken for home consumption or for business. Although health concerns about commercial chicken is widespread in the internet, most people in our area don’t really care at all. Why? Because commercial chicken is just right in size, cleaner, leaner and is the price is almost the same with the local farms—why opt for chicken if you are unsure of its quality.

I can see that the chicken is a booming industry in Leyte, PH. Several farms are opening within the region. Some offers organic chicken while others are farms of large companies. I was once in an interview of a City Councillor and I found out that our region is still exporting chicken even there’s still a high demand in our region. That only shows that there is not enough chicken to feed the growing demand.

Chicken is choice to most of the locals when fish is scarce especially during rainy season. Although pork is a staple to very home, chicken has always been part of the meals of Filipinos. We enjoy a savoury chicken Adobo, inasal, and specially fried chicken.

I was thinking of raising chicken because it sounds profitable. I have more than a year of studying how-to-raise-chicken but that was about six years ago! Back then we were taught basically about everything and one thing I can’t forget is the Archaeopteryx—that looks like a dinosaur slash bird slash Sci-Fi monster. So I look online on what tips and techniques that I can apply.

While several articles came from people who are living in colder parts of the world, most things still apply when you live in a tropical country with only two season. But one problem is our region does not follow six months of sunny weather and another six months of rainfall unlike several other regions. Leyte has rain distributed throughout the rain, may it be in the early in the morning/afternoon or all throughout the day.

So here are the things I have encountered in raising chickens:

  1. Make a battle plan first

Before you start buying chicks and raising them indecisively, you must first consult someone who is an expert or who has already an experience. You can observe in farms or just search online. Through different ideas you have gathered, choose something relevant to your skills and time—and even to the area you plan to raise. Check if you have enough time to spare because chicken might need much of your time at the beginning. See also if you can carry out basic skills or if you have patience to raise chicken. If you are already decided, see whether you have neighbour—or family—won’t be bothered buy any smell or sound. And lastly, ask yourself how much chicken you could sell or eat so that you’ll know how many will you raise.

  1. Be creative and save money

20150531_134146 20150531_171954

You don’t need to buy or hire someone to make you a housing. Look around your house if you have a hammer, nails etc. If you need to buy lumber, screen, plywood, or galvanized iron, draw a blueprint so you can save on your expenses. But if you can’t really do carpentry, better ask someone before ending up hurting yourself. I was thinking of buying only a few chicks, so I only made a small cage, about 1 x 1.5 x 1m [I know that’s too small for five chickens.]

I used some piece of lumber, some bamboo, and screen to make one. I was just raising chicken for experience so I just started with five chicks. I also bought a feeder and a waterer.

  1. The chicken needs your time

20150601_170831 20150601_170838

When the chicks are still few weeks old, they need heat. You also need to check for temperature or observe some odd behaviours especially if you are raising a lot of chickens. You must also check whether the feeds and water are enough. Also check if there are poop on the feeder or waterer, if there is, replace the feeds or water. As the chicken grows, you can visit the chicken less—in the morning and in the evening.

  1. Safety and health of the chickens

Photo4502

You’ve been raising chicken for a few weeks already and you are keen on the safety and health of the chicken. Your chicken need not to be super healthy, they just need to look fine and without displaying odd behaviours. Make sure that your housing is always locked when you’re not around. If it’s big, check if there are no dogs, cats etc. that might kill or shock the chickens.

  1. Feeds are becoming costly

Photo4487 Photo4496

You can find online on what specific feeds are needed in every stage of the growing chicken. First, decide on how mature the chicken before slaughtering. I have planned of selling dressed chicken on the sixth month after buying the chicks. The chicks are more than a week old. You can search a lot of sources on what and how much you need to feed your chicken. Then you can compute how much feeds you need to buy, I prefer buying wholesale when needed so that you’ll have enough stock and not let your chicken go hungry. I followed the advice of our agriculture teacher of applying an ad libitum feeding. I also placed a light bulb so they can feed for 24 hours. As they grow bigger, the waterer needs to be replaced more often.

Sometime later, you’ll realize that you have spent much and your chicken are still few weeks before they can be sold or eaten. If you ponder if there are other substitutes, you’re lucky because there are many feedstuff you can find or grow which are organic and healthier. Arachis pintoi is locally known as Mani-mani. It resembles the appearance a peanut plant. It is high in protein and can be mixed with rice bran for carbohydrates. You just need to dry and grind/pulverize before it can be utilized as a feedstuff. You can also mixed it in certain amount with commercial feeds to lessen your expenses.

  1. Obligations

While it is fun watching your chicks turn into giant chickens, note that they poop 24-7! If you don’t want pesky flies and some annoying odour, you might as well man-up to maintain cleanliness—and that is to dispose chicken dung before it add up in layers. While you can sell chicken dung or turn it into fertilizer, you can bury it so that no maggots can grow in.

  1. Cut-off the bond

Some people get too emotional with the chickens, with more than a month of interaction there becomes a master-and-pet relationship. I don’t think a lot of people would be like this. But if this ever happen, would you feed them until they die—that’s about six year of restless expenses.

  1. To sell or not

Photo4517

At first, what are your plan? Did you intend to consume the chicken or sell it? Do you want to sell live chicken or you would personally slaughter and dress it before selling? Find a person who can buy your chicken or sell it to your family, friends, or neighbours. When you dress your chicken by yourself, you can sell the feet, neck and entrails in a separate price. If you can’t carry out the tough work of dressing chicken, you should probably sell it alive—that is quicker but is less profitable.

  1. Was it worth it?

When you have sold all or cooked the last piece, was it all worth the money or effort? If you’re into real small-scale business, you might as do some maths to check if you have profit. If you raised chicken for consumption, see if you have saved from your monthly bill or just destroyed your budget. Either way, the first time may not be the best experience for some but you can always learn from it.

  1. Preparing for another batch

You’re planning on making a larger housing and a few more chicken to raise, you must always check everything again and go back to #1. But if you plan to reuse all the equipment, always clean everything and sanitize. Make sure the next batch won’t get diseases from the previous batch.

Few more words…

It’s been about two weeks and I planning to raise another batch of chickens. My mother planned to raise layers too. So if you would plan to raise chickens too, don’t be afraid to start. There will always risks but it will be always worth the risk! See you again soon.

Raising Chickens? Yup.

Standard

I’ll be posting soon about my experience in raising broilers. It’s quite easy being someone who lives in a tropical country–no snow etc. =) BUT. There’s a but. Maintaining a clean setup is a tiresome work. But it was all worth the sweat.

Thanks for reading!

The Nature As I See It Today

Standard

The previous day, we planned to go swimming. The beach had more sands again unlike its rocky appearance in the previous months. The coconut trees became the natural seawall protecting erosion. The rounded bottoms of the coconuts are now visible with its roots pruned naturally. You need to go a one-meter drop from the seawall to have a better view of the sea. The swampy palm area separates the residential area from the beach. The beach became a “No build zone” about two years ago but there are a lot of houses along the beach. A private resort still stands strong even if the sea-level has raised pass to it.

Here are some flashback photos because I don’t have any photographs taken at this moment:

Erosion went meters nearer to the houses.

20140705 – This day, erosion went a few meters nearer to the houses.

No Build Zone

20140817 – This is now painted with yellow and black.

Children swimming in front of the private beach house/ function hall/ resort.

20140907 – Children swimming in front of the private beach house/ function hall/ resort.

The wall that separates the beach.

20140817 – The wall that separates the beach.

The sunset during summer.

20150508 – The sunset during summer.

A long wall separates the beach into two. It can be seen that the two beaches has different looks. The southern part is sandier and gradually become rocky towards the brook. Starting from the wall, the northern part is rockier and gradually becomes sand towards north. Near the resort is a fallen tree [or a stranded trunk] that has grown enough to root down and mature again.

The southern part is quiet with many coconut trees lined far from the shore bearing coconuts ranging from slightly orangey to brownish green. A private residence can be peeked along it’s the backdrop of the coconuts. A pack of dogs—and puppies—guards the area. Sibog-sibog or insects [or arachnids] living on dry and sandy soils creates a depression on the ground that serves as traps to its prey. Farther south are large mangroves. Although the trees are lesser than the finger of the hands, it recalls that the Gabas Beach is a mangrove forest previously.

During low-tide, the locals scratch the shore for seashells and clams. Few molluscs that can be found is kaykay [a clam slightly oblong with zigzag markings on its brownish shell and it needs to be dug on the sand], paypay [an elongated triangular fan-shaped clam that can be found heavily rooted on sands between rocks], and few sea snails. Umang or hermit crab—I think it plagued the young edible molluscs along the shore—is far more plentiful on the shore.

The southern beach continues southwards but are mostly privately owned with vacation houses and resorts. The accessible beach on the northern part previously extends to Barangay Patag but the elongated beach was cut—I don’t know if it was natural or not—and the river now flows directly towards the sea instead of flowing northward parallel to the sea before reaching the sea.

The locals near the sea are fishermen. The northern part is laces with single-color paddle boats. Most fishermen has installed motors on their boats—they fished farther to the sea. Floating Styrofoam in even distance lined the sea from north to south. I don’t know if that is a sanctuary or a large fishing net below. The sunset is beautiful on early summer and becomes less as December comes.

The dark orange sun—sometimes red—peeks as it sets unto the horizon but the clouds are too thick that time. Although the slightly cloudy skies above and southward started to darken with cloud reflecting orange hues.

Today is July, the northern horizon is covered with thick clouds while the south are clearer. The Ormoc Bay can be seen afar. The Leyte Island curves to the west. The Camotes Islands is located on the west side. Few small islands can also be seen on the southern part. The waves are angled depending on the season.

While we were swimming, the sea slowly receded and giving a rockier look to the shore. There are sandy paths underwater between rocks. It is called Monbon or Bonbon—it depends on the speaker though. Different fishes ranging from schools of tiny ones to solitary fishes with length not longer than six inches swims near the shore. The tiny ones are usually translucent to silver while the bigger ones are black or dark in shade with blue or yellow linings.

While going deeper—about 20 to 10 meters away from the seawall—we found two sea urchins. My cousin observed me while I pulled the rock and raise it above water. The sea urchin clings to the rock beautifully.

“If fireflies signifies a thriving environment on land, the SEA URCHINS tells that the sea is blossoming again.”

We later used a piece of translucent plastic to pick them for a better view. The sea urchins resembles the form of mandarin oranges. They are oblong in shape that has shallow depressions on top and below. They have needle-like extensions which becomes lesser towards their bottom that are about a centimetre in length. Tiny flexible hands—like the squids—can be found at its side and becomes numerous towards the bottom. It looks like a flexible straw that has sucking lips on its tips. Below them are dark coloured rings—maybe a mouth or something.

As the water receded more, few more sea urchins can be found by twos or threes. Their shell [the hard covering] colours varies from monochrome to stripes. There are creamy whites, dark brown or violet, green ones, orangey, etc. The colour of their needles also varies from monochrome, stripes or tainted. The colours ranges from white, violet, green, yellow, orange, and red—rainbow, eh? The variants of the colours are numerous.

Another striking—and more potentially dangerous—sea urchins has longer and thicker sets of needles. Although they also have tiny needles like the previous sea urchins, their thicker needles looks like the base of a chicken’s feather—with a length of about two inches. They are more rounded and solitary unlike the other ones. They are also fewer than the other.

As the sun sets and the tide becomes lower, more and more sea urchins can be found. I found about 26 of them in the area but we went back ashore because it’s getting darker and it’s dangerous to step on one. Many people started swimming that night. The silhouette clouds along the northern horizon intensifies remaining light of the skies. The lights of houses along the sea lit up. The lighthouses on the far cities and islands lit up too. Then we went home.

FINAL THOUGHTS

Many people rarely talk about the environment because they haven’t seen nature enough—what they chat about are numbers rising or plummeting that’s why they can’t comprehend. Things has dramatically changed in the past decades—as supported by my parents and grandparents—the scenery of the yester years is far more beautiful than of today. But nature is still beautiful even if only a fraction of what has been left. I don’t know if our great grandchildren will still see these things. But sometimes I think that the efforts of many organizations and people who promote a better environment—or saving the environment—will preserve what we have today if not bringing the beauty of the past again.

Although it’s been a tough month for me, I always give myself a retreat. I wake up early to see the sunrise and visit beaches to see sunsets. I enjoy every day of this crazy fun adventure in a world of treasure hunts called Life. This was my first comeback post so I made it sure that it would be interesting to read—I hope so.

Back Again

Standard

 

Department of Animal Science Tour

It’s been few years since I last posted here at Paper Drafts. The ST Haiyan had destroyed the communication and power lines for about a year. So much has changed but everything is well now.

I became a fish hobbyists together with my friends before I became busy with school-works. I am currently doing my thesis. It is very tiring but I’m good in time management. Even though I have several tasks to do every weekdays, I always give some time for leisure and recreation during weekends and holidays. I began running together with some of my exercise buddies. We usually wake up early and starts at about 4AM. The quiet road and the twilight is so amazing–that motivates me to be active.

I also started raising few chicken for meat. That would be all for now. ^_^

Opportunities in Disguise

Standard

Our research was about chicken fat bio-diesel which aims to discover the potentials of a commercial fried chicken industry byproduct–mainly the chicken fat residue. Though sleepless nights and busy days may lose your creative skills, there are always something around that might be great subjects that you would miss if you don’t open your eyes.

Finding the Saponification values of the samples.

Finding the Saponification numbers of the samples.

Preparation of samples to be placed inside an oven.

Preparation of samples to be placed inside an oven.