errorNo such file or directoryselect 					
											count(a.fldLeadUniqueId) 	as totalrows	from			
											tblUserMaster b,
											tblCategoryMaster d,
							tblLeadMaster  a
							
							where			(a.fldUserUniqeId=b.fldUserUniqueId)
							and				a.fldCategoryId =d.fldCategoryId
							and				d.fldCategoryActive='Y'					
							and				a.fldLeadStatus ='A'  and (TO_DAYS(DATE_ADD(a.fldDateofSubmit,INTERVAL a.fldExpiryDays DAY))-TO_DAYS(CURRENT_DATE))>=0 and ( (MATCH (
					a.fldForSearch 
					)
					AGAINST (
					'Furniture'
					)  and MATCH (
					a.fldForSearch 
					)
					AGAINST (
					'Stock'
					) ) or (
 
					MATCH (
					a.fldForSearch 
					)
					AGAINST (
					'Stocks'
					) 
					  and 
	 
						MATCH (
						a.fldForSearch 
						)
						AGAINST (
						'Furniture'
						) ) or (
 
					MATCH (
					a.fldForSearch 
					)
					AGAINST (
					'Furniture'
					) 
					  and 
	 
						MATCH (
						a.fldForSearch 
						)
						AGAINST (
						'Stock'
						) ) )
							and				a.fldLeadActive='Y'
							
							and				(b.fldMembership='IP' or b.fldMembership='IS' or (b.fldCountry='0' and b.fldCountryId<>''))
							and 			b.fldMemberActive='Y' 
							and				b.fldMemberIdle='N'