Grocery scratch

gistfile1.txt

select prod_barcode, prod_brand, prod_name, prod_size, quantity, lloc_name, items_date_added 
from products 
inner join items on products._id = items.io_id
left outer join lloc on lloc._id = items.location
order by prod_name

810979005254  True Citrus	- True Orange Crystallized Orange 32 x .8g Packets - 0.91 oz.		1.0	Sunroom Cabinet	2013-06-06
037000847366	Puffs	180 Count Assorted Boxes Basic Facial Tissue 84736 - 24 Pack		9.0	Sunroom Cabinet	2013-06-06
048121277079	Thomas'	Bagels Plain Pre-Sliced 6 Ct	22 oz	3.0	Sunroom Freezer	
013409351505	Sweet Baby Ray's	Barbecue Sauce Hickory & Brown Sugar	18 oz	1.0	Sunroom Cabinet	2013-06-06
051000076236	Pepperidge Farm	Cake 3-Layer Chocolate Fudge	19.6 oz	1.0	Sunroom Freezer	2013-06-07
046100000922	Sargento(R) Classic	Cheese Mexican 4 Cheese Shredded	8 oz	1.0	Sunroom Freezer	2013-06-07
075901332116	Fast Fixin'	Chicken Breast Nuggets	36 oz	1.0	Sunroom Freezer	2013-06-07
099555151138	Barista Prima	Colombia Coffee K-Cups (Case of 6)		1.0	Sunroom Cabinet	2013-06-06
013120014611	Ore-Ida	Country Style French Fries Seasoned Potatoes w/Skins	30 oz	1.0	Sunroom Freezer	2013-06-07
099555155778	Donut House Collection	Donut House K-Cups - 80 Count		1.0	Sunroom Cabinet	2013-06-06
028400156363		Doritos nacho cheese	11 oz	2.0	Sunroom Cabinet	2013-06-08
082368007020		Easy quick almond bark		1.0	Sunroom Freezer	2013-06-07
027815001503		Eckridge beef smoked sausage		1.0	Sunroom Freezer	2013-06-07
099555088021	Tully's	Extra Bold House Blend Coffee K-Cups (Case of 6)	12 ct	1.0	Sunroom Cabinet	2013-06-06
013120012600	Ore-Ida	Extra Crispy French Fried Pota Golden Crinkles	26 oz	1.0	Sunroom Freezer	2013-06-07
05278008		Fannie Mae Pixies		1.0	Sunroom Freezer	2013-06-07
013700824258	Hefty OneZip	Freezer Bags  Value Pack Gal Size	25 ct	1.0	Sunroom Cabinet	2013-06-06
025700003816	Ziploc	Freezer Bags Quart 7 In X 8 In	40 ct	1.0	Sunroom Cabinet	2013-06-06
046704063309	T.g.I.	Friday's cheddar cheese jalapenos	8oz	1.0	Sunroom Freezer	2013-06-07
078742370477	Great value	Great value cream cheese		2.0	Sunroom Freezer	2013-06-07
013700812224	Pactiv	Hefty One Zip Fd Storag Bg Quart - 12 Pack		1.0	Sunroom Cabinet	2013-06-06
028400082938	Lay's	Homestyle Kettle Chips Mesquite	8.5 OZ BAG	1.0	Sunroom Cabinet	2013-06-08
028400082945	Lay's	Kettle Potato Chips	8.5 OZ BAG	1.0	Sunroom Cabinet	2013-06-08
048001213487	Hellmann's	Mayonnaise Real	30 fl oz	1.0	Sunroom Cabinet	2013-06-06
028000217303	Nestle Toll House	Morsels Butterscotch	11 oz	1.0	Sunroom Freezer	
041483029188	Kemps	Mouse tracks frozen yogurt	1.5	1.0	Sunroom Freezer	2013-06-07
725439104869	my essentials	My essentials cream cheese		2.0	Sunroom Freezer	
073310454559	Mardi Gras	Napkins Soft & Absorbent	500 ct	1.0	Sunroom Cabinet	2013-06-06
072554111525	Nestle	Nestle drumstick little drums		1.0	Sunroom Freezer	2013-06-07
010900005104	Reynolds Oven Bags	Oven Bags Turkey Size	2 ct	2.0	Sunroom Cabinet	
051000129116	Prego	Pasta Sauce Italian Sausage & Garlic	27 oz	1.0	Sunroom Cabinet	2013-06-06
041565000067	Pace	Picante Sauce Medium	16 oz	1.0	Sunroom Cabinet	2013-06-06
071921003371	DiGiorno	Pizza Rising Crust Supreme	32.7 ct	1.0	Sunroom Freezer	2013-06-07
029000016552	Kraft	Planters Crunchy Peanut Butter	16.3	1.0	Sunroom Cabinet	2013-06-06
012587000205	Glad	Plastic Wrap Crystal Clear Polyethylene	66.667 yd	1.0	Sunroom Cabinet	2013-06-06
296040307272		Publix lean ground beef		1.0	Sunroom Freezer	2013-06-07
071429010727	Zatarains	Red Beans And Rice		1.0	Sunroom Cabinet	2013-06-06
029200002171	Mueller's	Rotini Twists	16 oz	1.0	Sunroom Cabinet	2013-06-06
725439104920	My essential s	Salted butter	1lb	1.0	Sunroom Freezer	2013-06-07
025700002406	S.C. Johnson & Son, Inc.	Saran Cling Plus, 200 sq ft		1.0	Sunroom Cabinet	2013-06-06
073410135471	Arnold	Select Sandwich Thins Multigrain Pre-Sliced	8 Ct 12 OZ PKG	1.0	Sunroom Freezer	2013-06-07
041196914160	Progresso	Soup Chicken Corn Chowder	18.5 oz	1.0	Sunroom Cabinet	2013-06-06
041196010886	Progresso	Soup Chicken Noodle W/Only White Meat	19 oz	1.0	Sunroom Cabinet	2013-06-06
051000005687	Campbell's	Soup Steak 'N' Potato Chunky	18 oz	1.0	Sunroom Cabinet	2013-06-06
021140204257	Winn Dixie	Tomato Sauce		1.0	Sunroom Cabinet	2013-06-06
810979001263		True lemon crystallized lemon		1.0	Sunroom Cabinet	2013-06-06
023700062321	Tyson	Tyson all natural boneless skinless chicken breast		1.0	Sunroom Freezer	2013-06-07
043000009505	Kraft Cool Whip	Whipped Topping Lite	8 oz	1.0	Sunroom Freezer	2013-06-07
021140610829	Pace	Winn Dixie butter flavor Syrup		1.0	Sunroom Cabinet	2013-06-06
021140279149		Winn Dixie garlic breadsticks		1.0	Sunroom Freezer	2013-06-07