categories_products. Both plural. In lexical order.
Quote:
Unless the name of the join table is explicitly specified by using the
:join_table option, Active Record creates the name by using the
lexical order of the class names. So a join between customer and order
models will give the default join table name of “customers_orders”
because “c” outranks “o” in lexical ordering.