Just a small SQL syntax error:
SQL, wildcard characters (such as %, _ , [a-c]) are used with the SQL LIKE operator.
So it should be:
cpc_class_symbol
LIKE 'F03B 13/12%'
or
cpc_class_symbol = 'F03B 13/12'
But in this case, the results will be identical because there are no other CPC classifications starting with 'F03B 13/12'
Be careful with SQL wild card approach !
Looking in detail at this classification itself:
http://worldwide.espacenet.com/classifi ... =F03B13/00 Observe that if you want to have all patents that include wave and tidal energy, you will need to adapt your query to include the specific classification codes such as F03B 13/26.
In this case the hierarchical CPC structure does not follow the numerical structure that can be covered with a simple SQL wild card use. To include tidal and wave energy you could use something like:
where (cpc_class_symbol = 'F03B13/12' or cpc_class_symbol like 'F03B 13/14%' or cpc_class_symbol like 'F03B 13/16%' or cpc_class_symbol like 'F03B 13/18%' or cpc_class_symbol like 'F03B 13/2%')